EXCEL FEATURES | BI & AI

💡What If Excel Could Write Formulas For You?
In this video David Fortin shows you what Copilot in Excel can do.
00:15 - Write an Excel formula with Microsoft Copilot
04:43 - Sheetmatcher Sponsor
05:19 - Write Excel Formula without typing with Copilot in Excel
10:45 - Merge two lists with Copilot in Excel
XLOOKUP formula
14:50 - Write complex Excel Functions and Formulas with Copilot
17:03 - Learn more about Microsoft Copilot & Copilot in Excel
Check out this video ⬇️
https://youtu.be/wQY8STgqXy8

🔎 How to compare two sheets and find differences: several methods.
1. To highlight matching text data in two tables in Excel, you can use conditional formatting with a formula. Here's how you can set it up:

Assuming your tables are in columns A and B (left table in column A and right table in column B), starting from row 2, you can apply the following conditional formatting formula to the range in column A where your left table data is:

1. Select the range in column A where you want to apply the formatting.
2. Go to the "Home" tab in Excel.
3. Click on "Conditional Formatting" in the Styles group.
4. Select "New Rule."
5. Choose "Use a formula to determine which cells to format."
6. Enter the following formula:

      =ISNUMBER(MATCH(A2, $B:$B, 0))
   

This formula checks if the value in cell A2 exists in column B as text. If it does, the formula result will be true.

7. Click on the "Format" button, go to the "Fill" tab, and choose a green color.
8. Click "OK" to apply the formatting.
9. Click "OK" again to exit the Conditional Formatting Rules Manager.

This conditional formatting formula will color the cells in the left table that have matching text values in the right table in green.

2. Check out this video ⬇️
https://youtu.be/nrDOQ_VDmQA?si=nt94oulK6YnWOwvJ

✅ 💡Learn Excel’s BEST Automation tool in 15 minutes.

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is a feature in Excel that allows users to import, transform, and consolidate data from different databases, files, and sources in a structured manner.
Watch out this video ⬇️

https://youtu.be/2FSCmkZ9778?si=c5fv78qRkZfmC4xN

✅ 8 Copilot tips in Excel to boost your efficiency ⬇️
https://youtu.be/RB3MvJ7ft_E

💡How to protect your hard work with Excel VBA.
In video below you'll learn how to secure your worksheets, workbooks, and VBA code with ease.

Watch the video today and safeguard all your hard work!

https://youtu.be/LuSsGRWJKNU?si=Vm4JSSE6ElobvMfw

💡Excel for Finance and Accounting full course for beginners.

It is clear, practical and detailed. ⬇️

https://youtu.be/hkybRW7Z3Yk?si=HnobiTojUhyupVhv

🌟 Introducing a collection of 8 CHATGPT Prompts curated by Chandra Kumar! 🚀

Enhance your productivity and streamline your task management with these carefully crafted prompts designed to boost efficiency and help you prioritize your workflow. Explore a range of insightful prompts that will empower you to navigate your daily tasks with ease. Stay tuned for valuable insights and actionable suggestions to supercharge your efficiency! 🌈

💡AI Tool that creates Excel dashboards in minutes for free

The world is speeding into Al taking over a lot of chores.

Big improvement on ChatGPT's capabilities.

Check out this video ⬇️

https://youtu.be/1b4gDSodMwo?si=7qfYcgjYv3o7kZYV

💡Copilot Tutorial for Beginners
Copilot is a conversational chat interface that lets you search for specific information, generate text such as emails and summaries, and create images based on text prompts you write.

https://youtu.be/d-CuF6dlqLg?si=pA445a_L327VC4vM

💡How to customize number formatting in Excel by adding units:

1. Select the cell or range of cells you want to format.
2. Right-click and choose "Format Cells."
3. In the Format Cells dialog box, go to the "Number" tab.
4. Select "Custom" from the Category list.
5. In the "Type" field, enter your desired format, including the unit. For example, "0.00" for numbers with two decimal places and then add the unit like "m" for meters.
6. Click "OK" to apply the custom number format with units to the selected cells.

Watch this video ⬇️

https://youtu.be/RC0wzWOsdlQ?si=bkLFdc5mtS-jP_yQ

📈Overview of Simple Linear Regression Analysis: Years of Experience and Salary 💸

Introduction:
Simple linear regression is a statistical method used to understand the relationship between two variables by fitting a linear equation to the data. In this analysis, we have considered years of experience and salary. The goal is to predict how changes in years of experience impact salary using a simple linear regression model.

Methodology:
We collected data on years of experience and corresponding salaries from a sample of individuals in a specific industry. Using a regression model, we aim to estimate the effect of each additional year of experience on salary.

Results:
The analysis revealed a positive correlation between years of experience and salary, indicating that, on average, an increase in years of experience is associated with a higher salary. The regression model allows us to quantify this relationship and make predictions about salary based on an individual's years of experience.

Conclusion:
Simple linear regression analysis provides valuable insights into the relationship between years of experience and salary. By understanding this relationship, businesses can make informed decisions regarding salary structures, promotions, and hiring practices. While simple linear regression has its limitations, it serves as a foundational tool for analyzing and interpreting data in various fields.

https://youtu.be/M1tVwND8T1o?si=cVU4cuBjEplXU7f6

📈 A sales pipeline spreadsheet in Excel
is a tool used to track and manage sales opportunities from initial contact to closing.
It typically includes stages such as lead generation, qualification, proposals, and closing.
The spreadsheet also incorporate forecasts, tools for analyzing sales data, and performance metrics to help sales teams monitor progress and make informed decisions. The upcoming video will delve into the different stages, forecasting methods, tools, and analysis techniques employed in utilizing a sales pipeline spreadsheet effectively. 🔽

https://youtu.be/Fej-JRTGJvE?si=ZacSajUohEWfFgaf

📍BIG NEWS!
Microsoft Excel just got a huge upgrade with new REGEX functions! 🎉

Think REGEX is just for the pros? Think again! 😲
In the video 👇 Leyla shows how ANYONE can use these powerful new functions.


🔍 Here's what you'll learn:

- Grab email addresses from long text - even multiple ones.
- Get website addresses - even messy ones from long text.
- Extract dates hidden in text.
- Clean up text by removing special characters.
- Format numbers for readability - like phone or credit card numbers.
- Remove those annoying leading zeros.
- Break up words that are stuck together.
- Extract data inside brackets.

Watch the video and get ready for the time when these functions become available in your Office 365 version.
They are currently in the beta version in Excel Insiders.

https://youtu.be/YFnXV2be9eg?si=_6suMsH2veqNa0Eq

📍📈 Macros and VBA for beginners
What are VBA Macros in Excel? VBA Macros use the Visual Basic Application in Excel to create custom user-generated functions and speed up manual tasks by creating automated processes. Additionally, VBA can be used to access the Windows Application Programming Interface (API).

To learn more about, check out the video ⬇️

https://youtu.be/IJQHMFLXk_c?si=d3viozD3QqdXndW6

🚗 🧮 How to calculate Car loan payments

The key question for most people when taking out a car loan is “What will my monthly payment be?” Fortunately, Excel has been around the block a few times with this kind of question, and there is a special function just for this calculation, called PMT. You can watch this video for better understanding ⬇️

https://youtu.be/Ht70lweo3Wo?si=ZewjaGudOLdrR1jg

🧮📚Financial analysis
In this video you will learn how to calculate NPV and IRR in Excel.
Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.
By contrast, the internal rate of return (IRR) is a calculation used to estimate the profitability of potential investments.

https://youtu.be/YDpf00QHY0I?si=BR-J4lXuEhy1iJh3

✅👉Some of useful tips how to use SCAN function in Excel.

The Excel SCAN function progressively applies a LAMBDA to each element in an array and returns an array of all intermediate values. This function is particularly useful for generating running totals, cumulative statistics, or constructing sequences based on the array elements and a specified operation.

Check it out ⬇️

https://youtu.be/7vC5Ot6fu6s?si=3_rkn2IKmexOfVBM

✅ 10 essential Excel formulas in 2024
To be competitive, you have to keep up with the new features that enable you to improve productivity, or you’ll be left behind. In this video you can find 10 must know modern Excel functions that simplify common tasks. These functions will not only make your life easier, they’ll also make you the go-to expert at your workplace.

https://youtu.be/rTHrTfcFSB0?si=wFjFkbnxaWEFXp1f