In this very quick video, I will go over a few details related to the "Main Workbook." This is the workbook you will be using throughout Section 2 and a little beyond. It's important to pay attention to the things I show you in this video; otherwise, you may encounter problems. Let's do this :)

What is the difference between a formula and a function in Excel? In this tutorial, I explain the subtle differences between a formula and a function in Excel.

Learning how to write formulas in Excel can be quite daunting—even before you begin. In this tutorial, I hope to put your mind at ease. Formulas are actually quite easy to understand and write, and of course, they are very useful for working out calculations in Excel.

In this video, I want to share the different methods we can use to create and work with functions, including using the Function Arguments box and writing functions manually in the editor.

One of the most common questions I have received from my students over the years has to be, "What is the IF function and how do I use it in Excel?" That is always a great question! In this tutorial, I hope to shed some light on what might be one of the most important functions in Excel.

Printing in Excel is a tricky business. So, what I hope to achieve over the next few tutorials is to provide you with the basic knowledge needed to print in Excel. We’ll cover topics such as scaling, page break settings, the Print Preview area, and more.

Please note that printer settings in Excel may vary depending on the version you are using. In addition, the printer model connected to your version of Excel may be significantly different. As a result, some of the settings demonstrated in this tutorial may not be available in your version of Excel. You may also see extra settings or options that are not included in the tutorial. I sincerely apologize for any inconvenience this may cause.

You’ve probably asked yourself, “How do I use VLOOKUP in Excel?" Well, over the course of just a few minutes, you’ll learn how to use VLOOKUP to search, match, and retrieve data with ease.

We've already covered how to print in Excel in the previous section. While that information is still fresh in your head, I'd like to go into a little more detail about this area in Excel. Basically, we're going to look at some of the other settings and methods that can be used to achieve your printing goals. Please be aware that some of the printing settings you see me using in this section might not be available in your version of Excel. Though Excel tends to remain the same when it is updated, the printing settings seem to change the most.

You may have come across Macros in Excel or even used them. Well, this section is entirely dedicated to the world of Macros! Macros can be a bit peculiar as they have the potential to either be your greatest ally or your biggest challenge. What I aim to do is provide a thorough explanation and demonstration of Macros to ensure they become your trusted companion.

In this section, you'll find the PMT and IPMT functions to be incredibly useful for calculating monthly mortgage payments. With the PMT, you can figure out the fixed monthly installment, even with a variable interest rate and different loan durations. Meanwhile, the IPMT breaks down the payments, showing you exactly how much goes towards interest and how much towards the principal amount each month. This knowledge will be invaluable to anyone who wants to navigate mortgage calculations. The PMT and IPMT functions can also be used to workout standard loans.

What-if analysis in Excel is used to explore different scenarios and assess the impact of changing input values in your data. In this section, we’ll be covering two areas of what-if analysis. Data tables, and goal seek.

3D maps (Power Maps) in Excel bring data to life, making it easier to see and understand geographic information. They add a cool 3D twist to your data, helping you spot patterns and insights more easily. Please note that this feature is only available on Windows operating systems and within Excel 2011 and later.

I've already covered a number of functions in this course so far. But now we're going to explore some "must-know functions" that any Microsoft Excel warrior should not be without. At the end of this section, we'll also delve into Excel's drawing tools, a set of tools typically not used very often but still adding value to the program. Let's dive right in!

In this tutorial, we explore the Draw tab in Microsoft Excel and how it can enhance your spreadsheets. You’ll learn how to use the digital inking tools to sketch, highlight, and add annotations right on your worksheet. Whether you’re using a mouse, stylus, or touchscreen, the Draw tab offers a simple way to illustrate ideas, emphasize key points, or add personal touches to your data.

In this section, we're going to dive into AI (Artificial Intelligence) in Excel. As you'll soon discover, AI in Excel can enhance productivity, accuracy, and decision-making.

Not many people know that Excel includes a form of AI-assisted functionality within the application. It's called 'Analyze Data'. This feature is AI-driven and understands basic human language inputs and questions. Thus, you can ask questions about your data and, if your question actually makes sense, it should provide you with the information you're looking for.

We've taken a look at Excel's default built-in AI functionality; now let's explore a very useful add-in created by ChatGPT. With this AI feature, you'll be able to take advantage of the several AI functions it provides. This feature has the ability to search online for the information you're looking for and import it straight into an Excel spreadsheet.

In this tutorial, we'll look at the different parameters presented with AI functions. Once you know how to set these parameters, you'll be able to get more information or the right answers from your AI functions.

I suspect many people are now using AI to improve their Microsoft Excel skills, I know I am. In this and the next few tutorials, we'll explore AI's general capabilities in solving Excel-related problems. Enjoy! :)

At this point in AI's development, you may already know that you can upload a screenshot to an AI chatbot (like Copilot) for analysis and then ask questions about the image. In this tutorial, I’ll demonstrate this by uploading a screenshot of an Excel spreadsheet with a problem I need AI to solve.

In this tutorial, you’ll learn how to instruct an AI chatbot like ChatGPT to take on a specific role or profession. This approach is especially useful when you want the chatbot to concentrate on a particular subject or area of expertise. You can ask it to act as a doctor, engineer, accountant, mathematician, plumber, or even a racing coach. Providing a clear role often results in more accurate and targeted responses.