Learn Microsoft Excel + AI: Go From Beginner to Expert Fast

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Discover what Microsoft Excel is and why it’s one of the most powerful tools for working with numbers and data. This beginner-friendly introduction explains the purpose of spreadsheets, how Excel compares to Microsoft Word, and why it's essential for business, finance, school, and personal productivity. Explore the invention of the modern spreadsheet and how it revolutionized data management. Learn about Dan Bricklin, the father of spreadsheets, and how tools like Microsoft Excel and Google Sheets evolved into today’s must-have business software. Understand the origin and evolution of Excel to appreciate its value in today’s workplace.

• Spreadsheets are powerful tools that allow us to work with numbers, just like customizable calculators. They also help us organize and manage data efficiently, making them essential for businesses, finance, research, and everyday tasks.

  
  

• Just as Microsoft Word is designed for working with words, Microsoft Excel is built specifically for handling numbers and data. Excel enables users to perform calculations, create charts, analyze trends, and automate tasks with ease.

  
  

• The Invention of Spreadsheets

  • The modern spreadsheet was invented in 1979 by Dan Bricklin, revolutionizing the way we work with data. His creation laid the foundation for the spreadsheet software we use today.

    
    

• Popular Spreadsheet Programs:

  • Microsoft Excel (Industry standard for spreadsheets)

  • Google Sheets (Cloud-based alternative for collaboration)

    
    

• Spreadsheets have become an indispensable tool for professionals and learners alike—unlocking the power of data and numbers at your fingertips!

Learn the differences between Excel for Desktop, Excel Online, Excel for Mobile, and Excel within Microsoft 365. This lecture compares all major versions of Excel, helping you decide which one fits your needs—whether you're working on a laptop, tablet, phone, or in the cloud. Great for anyone wondering what Excel version to install, use, or purchase.

• Microsoft Excel for the Web

  • Name: Excel for the Web (formerly known as Excel Online)

  • Description: A cloud-based version of Excel that runs in your web browser. It allows you to create, edit, and share Excel files online without installing any software. It’s part of Microsoft 365 and is accessible via OneDrive or SharePoint.

  • Best for: Basic editing, collaboration, and quick access from any device.

    
    

• Microsoft Excel (Desktop Version)

  • Name: Excel for Windows/Mac (Part of Microsoft Office/Microsoft 365)

  • Description: The full-featured, installable version of Excel, available as part of a Microsoft 365 subscription or as a one-time purchase (Excel 2021 or Office 2021).

  • Best for: Advanced functions, data analysis, macros, and offline work.

    
    

• Microsoft Excel (Mobile App)

  • Name: Excel Mobile

  • Description: A free app available for iOS and Android. It offers basic spreadsheet functionality and integrates with OneDrive.

  • Best for: Viewing and making simple edits on the go.

    
    

• Excel within Microsoft 365 (Cloud & Enterprise)

  • Name: Excel within Microsoft 365

  • Description: This is the cloud-connected version used in business and enterprise environments, with real-time collaboration, Artificial Intelligence features, and integration with other Microsoft apps.

  • Best for: Business teams, enterprise users, and collaboration.

"Microsoft Excel for the Web" and "Excel within Microsoft 365 (Cloud & Enterprise)" are similar but not exactly the same. Here's the key difference:

• Microsoft Excel for the Web is the browser-based version of Excel. It runs entirely online, meaning no installation is required, and it provides basic editing, collaboration, and cloud access. However, it lacks some advanced features like macros, complex data analysis tools, and offline functionality.

• Excel within Microsoft 365 (Cloud & Enterprise) refers to the full-featured, cloud-connected Excel that is part of Microsoft 365 for business and enterprise users. It includes real-time collaboration, AI-driven insights, and deeper integration with other Microsoft tools (e.g., Power BI, SharePoint, Teams). This version can be used both online (via the web) and as a desktop-installed application with advanced capabilities.

Are they the same software?

No, they are not the same. Excel for the Web is a lightweight, browser-only version, while Excel within Microsoft 365 includes both the desktop and web versions with enterprise-grade features. Enterprise users typically have access to both but will primarily use the desktop version for advanced tasks.

Resources:

• ChatGPT Excel Versions

• ChatGPT Excel Versions (Google Doc)

• The Pareto Principle

• The Pareto Principle (Google Doc)

Learn how to buy Microsoft Excel and choose the best option for your needs. This lecture explains the difference between a Microsoft 365 subscription and a one-time purchase of Excel. You’ll also discover free options like Excel Online and special discounts available to students and educators. We’ll walk you through where to buy—whether directly from Microsoft, Amazon, or Costco—and how to get the best value. Perfect for anyone looking to save money while getting the right version of Excel.

You can purchase Microsoft Excel in several ways, depending on whether you prefer a one-time purchase or a subscription model:

1. Microsoft 365 Subscription (Recommended)

• Best for: Frequent updates, cloud storage, and access to other Microsoft apps.

• Includes: Excel, Word, PowerPoint, Outlook, OneDrive (1TB storage), and more.

• Options:

  • Microsoft 365 Personal – $99.99/year or $9.99/month (1 user)

  • Microsoft 365 Family – $129.99/year or $12.99/month (Up to 6 users)

• Where to Buy: Microsoft 365 Subscription

  
  

2. Free Online Version

• Best for: Basic Excel use without cost.

• How to Access: Go to Excel Online and sign in with a Microsoft account.

• Limitations: Limited features compared to the full desktop version.

If you need to purchase Microsoft Excel, there are several options available to fit different budgets and needs.

Where to Buy Excel:

• Microsoft – Buy directly from Microsoft as a one-time purchase or as part of a Microsoft 365 subscription.

• Amazon – Find deals on standalone Excel licenses or Microsoft 365 subscriptions.

• Costco – Often offers discounted pricing for members on Microsoft Office products.

• Student and Educator Pricing – Students and educators may qualify for special discounts through Microsoft’s education programs.

Before purchasing, consider whether you need a one-time purchase of Excel or a Microsoft 365 subscription, which includes Excel along with other Office apps and cloud storage. Check different retailers for the best deals!

Resources:

• Excel Online

• Microsoft 365 Education Pricing

• Microsoft 365 Subscription

• Purchasing Microsoft Excel

• Purchasing Microsoft Excel (Google Doc)

In this lecture, you will learn how to install Microsoft Excel through a Microsoft 365 subscription. We will guide you step by step, starting with visiting the official Microsoft website, signing in to your Microsoft account, and accessing your subscriptions. You'll see how to locate and download the Office installer, run the installation process, and activate Excel to ensure it's ready for use. By the end of this lesson, you'll have Microsoft Excel installed and activated, allowing you to start working with spreadsheets right away.

1. Go to the Official Microsoft Website

   • Sign in with your Microsoft account.

2. Go to Your Account

   • Click on your profile picture (top-right) and select "My Microsoft Account".

   • Navigate to the "Services & subscriptions" section.

3. Download Excel

   • Find your Microsoft 365 subscription and click "Install".

   • Select "Install Office" → Download the Office Installer.

4. Run the Installer

   • Open the downloaded file and follow the installation prompts.

5. Activate Excel

   • Open Excel, sign in with your Microsoft account, and follow the activation steps.

Resources:

• VirusTotal - Checks for Viruses

• ChatGPT Install Instructions

• ChatGPT Install Instructions (Google Doc)

• Grok Install Instructions

• Grok Install Instructions (Google Doc)

• Gemini Install Instructions

• Gemini Install Instructions (Google Doc)

• Copilot Install Instructions (Google Doc)

Get familiar with essential Microsoft Excel terms that every beginner should know. In this lecture, you'll learn the meaning of workbook, worksheet, cells, columns, rows, ranges, and more. We’ll also cover how to save Excel files, understand file extensions, and how to save Excel files to different locations on your computer. Knowing these foundational terms and skills will help you feel confident and comfortable navigating Excel. Start building your Excel vocabulary and skills to set the stage for success with spreadsheets.

• Workbook

  • Every Excel file is called a workbook, which contains one or more worksheets.

• Worksheets

  • Also known as spreadsheets, these are made up of columns (vertical) and rows (horizontal).

• Columns

  • Vertical sections in a worksheet, labeled with letters (A, B, C, etc.).

• Rows

  • Horizontal sections in a worksheet, labeled with numbers (1, 2, 3, etc.).

• Cells

  • The intersection of a column and row forms a cell, where data is entered.

• Active Cell

  • The currently selected cell, highlighted with a box around it.

• Cell Address

  • Each cell is identified by its column letter and row number (e.g., B2).

• Ranges

  • A selection of two or more cells, often written using colon notation (e.g., B9:F9).

Mastering these fundamental terms will help you navigate and work efficiently in Excel!

Resources:

• 012-Excel-terminology.xlsx

In this hands-on exercise, you’ll get comfortable using Microsoft Excel’s core features. Learn how to navigate drop-down menus, enter numbers and text, and apply basic formatting for a clean, professional look. This guided activity walks you through each step so you can practice while you learn. It’s the perfect starting point for Excel beginners who want real experience using the software. Build confidence as you lay the foundation for more advanced Excel skills.

• drop down menus

• enter numbers

• enter text

• format text

Resources:

• 013-HOE-01-explore-Excel.xlsx

• 013-Excel-explore-web.xlsx

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Learn how to confidently navigate Microsoft Excel’s interface by mastering the Ribbon, Tool Tips, and Dialog Boxes. This lecture shows you how to use the Ribbon to access Excel’s most important tools, organized by tab. You'll also discover how hovering over icons reveals Tool Tips for quick feature descriptions. You will also learn about the Format Cells Dialog Boxes to unlock advanced customization and control. These interface skills will boost your speed, precision, and overall efficiency in Excel.

• Ribbons

• Tool tips

  • on hover

• Dialog boxes

  • Format cells dialog box

  • Clipboard

Keyboard shortcut:

• screenshot

  • windows + shift + s

  • snipping tool

  • on a mac:

    • cmd + shift + 3

    • cmd + shift + 4

Resources:

• Lecture Titles and Descriptions

• Lecture Titles and Descriptions (Google Doc)

• Lecture Preparation (Google Doc)

• Dialog Boxes vs Dialogue Boxes

• Dialog Boxes vs Dialogue Boxes (Google Doc)

• 015-Navigating Excel’s Ribbons, Tool Tips, and Dialog Boxes.xlsx

Unlock the full potential of Excel’s interface by learning how to use the Ribbon options, Name Box, and Formula Bar. This lecture shows you how to customize the Ribbon for quicker access to your most-used tools. You’ll also see how the Name Box shows you the name of your active cell. Learn to use the Formula Bar to view, enter, and edit data and formulas with precision. These features are essential for streamlining your workflow and working efficiently in Excel.

• Top of the bar options

• Name box

• Formula bar

Resources:

• Show My Ribbon Bar and Pin It (Google Doc)

• 016-Excel’s Ribbon Options, Name Box and Formula Bar.xlsx

Learn how to customize your Excel workspace using Zoom controls and the powerful Status Bar. This lecture shows you how to zoom in and out to comfortably view large datasets or fine details. You’ll also discover how the Status Bar instantly displays useful metrics like sum, count, and average—no formulas required. Plus, get tips for scrolling between sheet tabs to efficiently navigate multi-sheet workbooks. These features will boost your productivity and make Excel easier to use every day.

• Zoom

• Status bar

• Scroll sheet tabs

Resources:

• 017 Mastering Excel’s Zoom and Status Bar Features.xlsx

Learn how to tailor your Excel workspace using the View and Page Layout tabs for a cleaner, more efficient experience. This lecture covers how to show or hide gridlines, headings, and the formula bar for better visibility and focus. You'll also explore different Workbook Views like Normal, Page Break Preview, and Page Layout to control how your data is displayed and printed. Discover how to adjust Page Setup options for printing gridlines and headings with precision. These tools help you create spreadsheets that are both functional and presentation-ready.

• VIEW / SHOW

  • gridlines

  • headings

  • formula bar

• VIEW / WORKBOOK VIEWS

  • normal

  • page break preview

  • page layout

• PAGE LAYOUT / PAGE SETUP

  • print

    • gridlines

    • headings

Resources:

• 018 Customizing Excel View and Page Layout Options.xlsx

Discover how to use Excel for the Web alongside Microsoft 365 Copilot and OneDrive for seamless cloud productivity. In this lecture, you’ll learn to navigate the 365 Copilot Home, manage files and folders in OneDrive, and streamline your workflow across devices. We’ll also introduce the Draw ribbon—a handy tool for highlighting and annotating data—and show you how to enable it in Excel for Desktop. These features help you collaborate, stay organized, and use Excel’s AI tools to their fullest. Perfect for users working in cloud-based or hybrid environments.

• 365 Copilot home, OneDrive, and folders

• The Draw ribbon

  • turning it on in Excel for desktop

Resources:

• 019 Exploring Excel for the Web and 365 Copilot OneDrive.xlsx

• 019 DESKTOP EXCEL Exploring Excel for the Web and 365 Copilot OneDrive.xlsx

In this lecture, we’ll explore the importance of mouse pointer awareness in Microsoft Excel and how it enhances your efficiency. As you navigate through Excel, your mouse pointer changes based on context, indicating different functionalities such as selection, resizing, autofill, and more. Understanding these variations and recognizing what each pointer style represents will help you work smarter and avoid unnecessary errors. We’ll cover how to identify pointer changes, what actions they enable, and how to use them effectively to streamline your workflow. By developing this awareness, you’ll gain greater control over selecting, editing, and managing data with precision in Excel.

• Mouse pointer will change depending upon context

• Pay attention to the way the mouse pointer looks

Resources:

• 020 Mastering Mouse Pointer Awareness in Excel

Learn the power of right-clicking in Microsoft Excel and see how it provides quick access to context-sensitive menus that adapt to your selection. These menus offer time-saving shortcuts without the need to navigate through the Ribbon, allowing you to work more efficiently. We’ll cover practical examples, including Copy → Paste → Transpose, which lets you rearrange data effortlessly. Additionally, you’ll learn how to insert and delete columns and rows, add and rename sheets, and change sheet colors with just a few clicks. Mastering these right-click options will help you streamline your workflow and make Excel work more efficiently for you.

• context sensitive menu

• examples

  • copy → paste → transpose

  • columns & rows, inserting & deleting

  • adding a sheet, naming it, changing its color

Resources:

• 021 Right Clicking in Excel Context-Sensitive Menus.xlsx

Learn the fundamentals of entering and editing data in Microsoft Excel. We’ll start with the basics—simply click on a cell and type to input data. Need to make changes? You can edit directly in the cell by double-clicking or using the formula bar. We’ll also explore what happens when data overflows into adjacent cells and how to properly adjust column widths to ensure all content is visible. You'll discover how to resize columns and rows manually or use a quick trick—double-clicking the column divider—to automatically adjust column width to fit the content. By mastering these essential techniques, you’ll work more efficiently and keep your data well-organized in Excel.

• you can edit data in a cell by

  • double-clicking the cell

  • or up in the formula bar

• cells overflow if there is no data in the adjacent cell

  • #######

  • shows that there is data in that cell

    • widen the column to see it

  • double-click the divider to perfectly adjust

• you can make columns wider

• you can make rows taller

Resources:

• 022 Entering and Editing Data in Excel Essential Skills.xlsx

Description:
Put your Excel skills into action with this guided hands-on exercise focused on organizing and editing data. You’ll practice creating and renaming worksheets, changing tab colors, and entering meaningful content. Learn how to edit cell data using both the double-click method and the Formula Bar for full control. This activity reinforces your understanding of basic worksheet customization and efficient data entry. Great for building confidence with Excel’s everyday tools and layout features. This exercise will help you practice creating and managing worksheets, renaming and coloring tabs, organizing data, and editing cell content using different methods.

Instructions:

1. Open a new Excel workbook.

2. Create a new worksheet and rename it "Happy Items".

3. Change the worksheet tab color to a color of your choice.

4. In cell B2, start listing five things that make you happy, placing one item per cell from B2 to B6.

5. Edit the entry in B3 using the double-click method (double-click the cell, modify the text, then press Enter).

6. Edit the entry in B4 using the Formula Bar (select B4, edit the text in the Formula Bar, then press Enter).

7. Save your workbook.

Resources:

• 023 - Organizing and Editing Data in Excel.xlsx

Description:
This exercise will guide you through adjusting Excel’s View settings and preparing a sheet for printing. Practice customizing Excel’s display and print layout in this step-by-step exercise. You’ll adjust gridlines, headings, and the formula bar, then explore different workbook views to control how your data appears. Learn how to modify page setup options like orientation, scaling, and print settings for gridlines and headings. Finish by exporting your worksheet to a PDF to preview the final result. This activity helps you master formatting for both on-screen viewing and professional-quality printing.

Instructions:

1. Open a new worksheet and enter sample data in at least five rows and five columns. Use autofill as applicable.

2. Go to the View tab and toggle ON/OFF the following settings: Gridlines, Headings, and Formula Bar.

3. Switch between different Workbook Views:

   • Normal

   • Page Break Preview

   • Page Layout

4. Open Page Setup and modify the following:

   • Set the orientation to Landscape.

   • Enable Print Gridlines and Row & Column Headings.

   • Adjust the scaling to fit everything on one page.

     1. use a LLM chatbot if you need instruction on how to do this.

5. Print the worksheet to a PDF file to see the final layout.

Resources:

• 024 - Customizing Excel’s View and Page Layout.xlsx

• ChatGPT Page Layout Scale to Fit

• ChatGPT Page Layout Scale to Fit (Google Doc)

Description:
In this interactive exercise, you’ll explore how Excel’s mouse pointers change based on context and how to use them effectively. Learn to identify the selection cursor, autofill handle, and resizing tools for rows and columns. You’ll also dive into the right-click context menu to perform common tasks like copying, pasting, inserting rows, renaming sheets, and changing tab colors. Try Paste Special → Transpose to switch data orientation with ease. Finish with a quick reflection on how these shortcuts streamline your Excel workflow and save time.

Instructions:

1. Open a blank worksheet and move the mouse pointer over different areas of Excel. Identify when the pointer changes to:

   • The selection cursor

   • The autofill handle

   • The resizing cursor for columns and rows

2. Right-click on a cell and explore the Context Menu options. Perform the following:

   • Copy and Paste values

   • Insert a new row

   • Rename a worksheet

   • Change the tab color

3. Use Right-Click → Paste Special → Transpose to switch data from rows to columns.

4. Write a brief reflection on how these shortcuts improve efficiency.

Resources:

• 024 - Customizing Excel’s View and Page Layout.xlsx

• 025 - Mastering Mouse Pointers & Right-Click Shortcuts.xlsx

• ChatGPT: a Brief Reflection on Shortcuts and Efficiency

• Grok: a Brief Reflection on Shortcuts and Efficiency

• Gemini: a Brief Reflection on Shortcuts and Efficiency

• ChatGPT: a Brief Reflection on Shortcuts and Efficiency (Google Doc)

• Grok: a Brief Reflection on Shortcuts and Efficiency (Google Doc)

• Gemini: a Brief Reflection on Shortcuts and Efficiency (Google Doc)

• Copilot: a Brief Reflection on Shortcuts and Efficiency (Google Doc)

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Resources:

• 026 - Quiz #3 Review.xlsx

Get ready to build a strong foundation in Excel with this introduction to essential spreadsheet skills. This lecture previews key topics like entering formulas, using relative and absolute references, and formatting data with the Format Cells dialog. You’ll also get an overview of Excel’s most powerful functions—including SUM, IF, VLOOKUP, and XLOOKUP—and learn how to create charts that make your data come alive. Discover how templates and built-in tools can save you time and boost your productivity. Whether you’re new to Excel or looking to sharpen your skills, this section sets the stage for mastering core Excel concepts.

• In this introduction, we’ll provide a high-level overview of the key topics covered in this section, setting the foundation for your journey in mastering Excel.

  
  

• You'll begin by learning how to enter and edit formulas, the core of Excel’s powerful calculation capabilities. We’ll then explore relative and absolute references, essential for creating dynamic spreadsheets that adapt to changes in data. Next, you'll discover how to customize data formatting using the Format Cells dialog box, ensuring that your spreadsheets are both functional and visually appealing.

  
  

• We’ll also cover Excel functions, starting with an introduction to formulas vs. functions, followed by a deep dive into the Top 25 Essential Excel Functions, including SUM, IF, VLOOKUP, XLOOKUP, TEXTJOIN, and more. These functions will help you automate tasks, perform data analysis, and enhance productivity.

  
  

• To further elevate your skills, you’ll learn how to create charts to visualize data effectively, save time with templates, and work efficiently with Excel’s built-in tools. Whether you're a beginner or looking to refine your Excel expertise, this section will provide the essential building blocks to boost your confidence and efficiency in Excel.

  
  

• Let’s get started!

Learn how to enter and work with formulas—the foundation of Excel’s powerful calculation engine. This lecture covers the basic formula structure, starting with the equals sign (=), and introduces you to multiple methods for entering formulas, including the Point-and-Click technique and the Formula Ribbon. You’ll also discover how to toggle between formula view and calculated values using keyboard shortcuts. We’ll walk through tips for improving your workflow, like zooming and navigating with ease. Mastering these formula basics will set you up for success in more advanced Excel tasks.

• Formulas are the foundation of calculations in Excel, and every formula must begin with an equals sign (=). This tells Excel that a calculation is being performed rather than just displaying text. In this lecture, you’ll learn the basic formula structure, different ways to enter formulas using the Point-and-Click Method and Formula Ribbon, and how to view formulas instead of calculated values.

  
  

• We’ll also cover useful Excel shortcuts to enhance your formula workflow, such as toggling formula visibility and zooming in and out for better spreadsheet navigation. Mastering formulas is a key step toward unlocking Excel’s full potential!

Basic Formula Structure:

• All formulas in Excel begin with the = sign.

  • example =3+4

Ways to Work with Formulas:

• Formula Ribbon – Access formula-related tools for editing and managing calculations.

• Show Formulas – View all formulas in a spreadsheet instead of the calculated values.

Useful Excel Shortcuts:

• Show Formulas Instead of Values: Ctrl + ` (backtick, located above Tab key)

• Zoom In/Out of Spreadsheet:

  • Ctrl + Scroll Wheel

Resources:

• 028 Entering Formulas in Microsoft Excel - Web.xlsx

• 028 Entering Formulas in Microsoft Excel - Desktop.xlsx

Learn how to use relative references in Excel to create formulas that automatically adjust when copied to other cells. This lecture explains how relative referencing works and why it’s essential for building scalable spreadsheets. You’ll see how to apply the Point-and-Click method to insert cell references quickly and accurately. By mastering this concept, you’ll reduce manual errors and work more efficiently with your data. Relative references are a key skill for anyone looking to level up their Excel game.

• Relative references are a fundamental concept in Excel that allow formulas to adjust dynamically when copied to other cells. This feature helps streamline calculations and ensures formulas adapt as data changes.

• Mastering this concept will enhance your ability to create flexible and efficient spreadsheets.

Ways to Work with Formulas:

• Point-and-Click Method – Click on cells instead of manually typing references.

Resources:

• 029 Understanding Relative References in Excel.xlsx

Learn how to use absolute references in Excel to lock specific cells in your formulas, ensuring they don’t change when copied to other locations. This lecture explains how to apply the dollar sign ($) to create absolute and mixed references for more precise control. Mastering absolute references will help you build smarter, more dependable spreadsheets.

• Absolute references ensure that specific cell references remain fixed when copied across other cells. By using the $ symbol, you can lock either the row, the column, or both.

• Excel provides different types of cell references to control how formulas adjust when copied:

• Relative References – Adjust automatically when copied (e.g., =A1+B1).

• Absolute References – Stay fixed when copied, using a $ sign (e.g., =$A$1+B1).

• Mixed References – Lock either the row or the column (e.g., =A$1+B1 or =$A1+B1).

Using Absolute References ($) Effectively:

When working with formulas, you can switch between relative, absolute, and mixed references by manually adding the $ symbol or using shortcuts. This is useful for financial modeling, budgeting, and structured calculations.

Essential Shortcuts:

• Copy: Ctrl + C

• Paste: Ctrl + V

• Undo: Ctrl + Z

Understanding how to use absolute and mixed references correctly will help you create more dynamic and efficient spreadsheets!

Resources:

• 030 Understanding Absolute References in Excel.xlsx

Learn how to enhance the look and structure of your spreadsheets using Excel’s Format Cells dialog box. This powerful tool lets you customize number formats, align text, adjust fonts, apply borders, and add background colors. You’ll discover how to access it quickly using right-click or the Ctrl + 1 shortcut. We’ll walk through each tab—Number, Alignment, Font, Border, Fill, and Protection—so you can format your data with precision. Mastering this feature will improve both the readability and professional appearance of your Excel work.

• The Format Cells dialog box is a powerful tool that allows you to customize the appearance of your data.

• From adjusting number formats to modifying text alignment, fonts, borders, and colors, this feature enhances spreadsheet readability and presentation.

How to Access the Format Cells Dialog Box:

• Right-click on a cell or range of cells and select "Format Cells".

• Use the shortcut Ctrl + 1 to open the dialog box instantly.

Key Formatting Options:

• Number Formatting – Change how numbers, dates, and currency appear.

• Alignment – Adjust text positioning and orientation.

• Font – Modify text style, size, and effects.

• Border – Add and customize cell borders.

• Fill – Apply background colors or patterns.

• Protection – Lock or hide formulas for security.

By mastering the Format Cells dialog box, you can improve the readability and presentation of your Excel spreadsheets!

Resources:

• 031 Using the Format Cells Dialog Box in Excel.xlsx

Learn how to use Excel functions to streamline your calculations and perform powerful data analysis. Functions are one of Excel’s most powerful features, allowing users to automate calculations and perform complex data analysis with ease. In this lecture, you’ll get an introduction to Excel functions, how to enter them, and the difference between basic formulas and built-in functions. This foundational knowledge will prepare you to work with Excel’s most frequently used functions. Whether you're adding totals or running financial models, this skill is a must-have for Excel users.

Functions vs. Formulas: What’s the Difference?

• Formulas are user-defined expressions that perform calculations using cell references and mathematical operators. Example:

  • =A1 + B1 (Adds the values in A1 and B1)

• Functions are pre-built Excel commands designed to simplify complex operations. They follow a specific syntax and can perform calculations automatically. Example:

  • =SUM(A1:A10) (Adds the values in cells A1 through A10)

How to Use Functions in Excel:

1. Type = to start a formula.

2. Enter the function name (e.g., SUM).

3. Add arguments inside parentheses (e.g., cell ranges or numbers).

4. Press Enter to execute.

Resources:

• 032 Working with Functions in Excel.xlsx

• Alphabetical List of All Microsoft Excel Functions

Unlock Excel’s full potential with the 25 most essential functions for data analysis, automation, and everyday use. This lecture covers popular functions like SUM, IF, VLOOKUP, XLOOKUP, TEXTJOIN, COUNTIFS, and more. From basic math and logical tests to advanced lookups and filtering, these functions will save you time and increase your efficiency. Whether you're a beginner or leveling up your skills, mastering these Excel functions is a game-changer.

• Excel provides hundreds of functions, but some are essential for everyday use. This lecture covers the 25 most important functions, including SUM, AVERAGE, COUNT, IF, VLOOKUP, XLOOKUP, TEXTJOIN, CONCAT, and more.

Basic Math & Statistical Functions:

1. SUM(range)

   • Adds all numbers in a given range.

   • Example: =SUM(A1:A10)

2. AVERAGE(range)

   • Calculates the average (arithmetic mean) of numbers.

   • Example: =AVERAGE(A1:A10)

3. MIN(range)

   • Returns the smallest value in a range.

   • Example: =MIN(A1:A10)

4. MAX(range)

   • Returns the largest value in a range.

   • Example: =MAX(A1:A10)

5. COUNT(range)

   • Counts numeric values in a range.

   • Example: =COUNT(A1:A10)

6. COUNTA(range)

   • Counts non-empty cells (both numbers and text - alphanumeric).

   • Example: =COUNTA(A1:A10)

1. RAND & RANDBETWEEN

   • Generates random numbers for testing or simulations.

   • Example =RAND()

   • Example =RANDBETWEEN(1, 100)

2. ROUND, ROUNDUP, ROUNDDOWN

   • Controls decimal precision in calculations.

   • Example =ROUND(A1, 2)

3. TODAY & NOW

   • Provide dynamic date and date/time.

   • Example =Today()

   • Example =Now()

4. DAYS

   • Calculates the number of days between two dates.

   • Example =DAYS("12/31/2023", "01/01/2023")

Text Functions:

1. TEXTJOIN

   • Allows users to join text with a separator.

   • Example: =TEXTJOIN(", ", TRUE, A1:A5)

2. CONCAT

   • Joins text from multiple cells or ranges into one string.

     1. Does not allow for delimiters (like commas or spaces).

     2. Does not ignore empty cells when given a range.

   • Example: =CONCAT(A1:A3)

3. LEFT & RIGHT

   • Extracts text from the beginning or end of a string.

   • Example: =LEFT(A1, 3) // First 3 characters

   • Example: =RIGHT(A1, 3) // Last 3 characters

4. LEN

   • Counts the number of characters (including spaces)

   • Example: =LEN(A1)

5. TRIM

   • Removes extra spaces from text.

   • Example: =TRIM(A1)

6. TEXT

   • Converts numbers or dates into formatted text.

   • Example: =TEXT(TODAY(), "DD-MMM-YYYY")

Logical Functions:

1. IF(condition, value_if_true, value_if_false)

   • Returns different results based on a condition.

   • Example: =IF(A1>50, "Pass", "Fail")

2. COUNTIFS

   • Counts based on criteria.

   • Example: =COUNTIFS(A1:A10, ">50", B1:B10, "Pass")

     1. ✅ If A1 = 55 & B1 = "Pass", this row is counted.

     2. ❌ If A2 = 45 & B2 = "Pass", this row is not counted

3. AND(condition1, condition2, …)

   • Returns TRUE if all conditions are met.

   • Example: =AND(A1>50, B1>50)

4. OR(condition1, condition2, …)

   • Returns TRUE if at least one condition is met.

   • Example: =OR(A1>50, B1>50)

5. NOT(condition)

   • Reverses a logical condition.

   • Example: =NOT(A1>50) (Returns FALSE if A1 is greater than 50)

Data Functions:

1. UNIQUE

   • Extracts unique values from a range.

   • Example: =UNIQUE(A1:A10)

2. FILTER

   • Extracts only the data that meets certain criteria.

   • Example: =FILTER(A2:A10, B2:B10>50)

3. SORT

   • Sorts data dynamically.

   • Example: =SORT(A1:A10)

4. XLOOKUP: The Modern Alternative to VLOOKUP and HLOOKUP

   • XLOOKUP is the modern replacement for both VLOOKUP and HLOOKUP, providing a more flexible, efficient, and powerful way to perform lookups in Excel.

These functions make Excel a versatile and powerful tool for handling data, performing calculations, and automating tasks. Mastering them will significantly improve your efficiency and productivity!

Resources:

• Excel Functions (by category) - Our 10 Most Popular Functions

• ChatGPT Lecture Descriptions and Function Research

• ChatGPT Lecture Descriptions and Function Research (Google Doc)

Learn how to create professional, easy-to-read charts in Excel to visualize your data effectively. This lecture walks you through building bar charts, line charts, and pie charts, while explaining how to choose the right chart type for your data. You’ll also discover how to properly select data ranges—including non-contiguous cells—to ensure accurate and clear chart output. Mastering chart creation will make your data easier to analyze, present, and understand.

• Visualizing data through charts makes information easier to analyze and interpret.

• Discover best practices for selecting the right chart type for your data.

  • The data you select before creating a chart is crucial to how it will appear and function.

What to Select When Creating a Chart:

• Data (without totals) – Avoid including total values, as they can distort the chart.

• Column Headers – Helps label categories correctly in the chart.

• Row Headers – Ensures proper data organization and axis labels.

Selecting Non-Contiguous Data:

Sometimes, the data you need for a chart isn’t in a continuous block. In such cases, you can select multiple areas by using:

• Ctrl + Click & Drag – Hold Ctrl while selecting different regions to highlight only the necessary data.

Adjusting Your Chart for Better Results:

If the chart doesn’t look the way you expected, try:

• Selecting different data and recreating the chart.

• Exploring different chart types (e.g., column, line, pie) to see which one best represents your data.

• Using Chart Tools to format and refine your visualization.

By carefully selecting your data and experimenting with different formats, you can create clear and effective charts that enhance your data analysis in Excel!

Resources:

• 034 Creating Charts in Excel.xlsx

Save time and work smarter with Excel templates designed for everyday tasks like budgeting, invoicing, and tracking projects. In this lecture, you’ll learn how to find and customize built-in templates that fit your needs. Whether you're managing finances or organizing workflows, templates can help you stay efficient and consistent. Mastering this feature is a great way to boost your productivity in Excel.

• Excel templates allow you to save time by using pre-designed spreadsheets for common tasks like budgeting, invoicing, and project management.

Resources:

• Microsoft Excel Templates

Discover how artificial intelligence can transform the way you use Microsoft Excel. In this lecture, you’ll learn how to automate tasks, analyze data, get questions answered, generate formulas, and more using AI tools like Copilot, ChatGPT, Gemini, and Grok. You’ll also compare how different LLM chatbots respond to Excel-related questions and see how to upload screenshots or PDFs for AI assistance. Mastering these tools will help you work faster, reduce errors, and make more informed decisions in Excel.

• Artificial Intelligence (AI) is transforming the way we work in Microsoft Excel, making complex tasks easier and boosting productivity. In this lecture, you’ll explore how to leverage AI-powered tools like Microsoft Copilot to automate data analysis, generate formulas, and enhance decision-making.

• We will cover the four primary LLM (large language model) chatbots: Grok by X, ChatGPT by OpenAI, Copilot by Microsoft, and Gemini by Google. We demonstrate how each can provide different responses, helping you determine the best tool for various Excel-related tasks. Additionally, you’ll learn how to take a screenshot on both Windows and Mac and upload that image to ask questions about it. We’ll also show how you can upload Documents, like a PDF, for AI-powered analysis and assistance. By mastering AI-driven tools, you’ll unlock new levels of efficiency and accuracy in Excel.

Resources:

• 036 AI-Powered Excel.xlsx

• 036 AI-Powered Excel.png

Description:
Learn how to create formulas in Excel using the equals sign (=), the starting point for all calculations. In this hands-on exercise, by experimenting with simple formulas and parentheses, you’ll build a strong foundation for working with more advanced Excel functions. This exercise is perfect for beginners learning how Excel calculates and displays results.

• This exercise introduces you to the foundational concept of using the equals sign to create formulas in Excel. You'll practice performing basic arithmetic operations and explore how Excel follows the order of operations when evaluating expressions.

Instructions:

1. Open a new Excel workbook.

2. In cell A1, type =3+4 and press Enter. Observe how Excel calculates and displays the result.

3. In cell A2, type =10-5, in A3 type =6*3, and in A4 type =20/4. Press Enter after each.

4. Try using parentheses for a more complex calculation: Type =(5+3)*2 in A5 and press Enter.

5. Compare your formulas with the results and take note of how Excel follows standard math order of operations (PEMDAS).

6. Save your workbook as "Basic Formulas.xlsx".

Resources:

• Math Order of Operations PEMDAS

• Math Order of Operations PEMDAS (Google Doc)

• 037 - 01 - Mastering the Equals Sign in Formulas.xlsx

Description:
Practice creating dynamic formulas in Excel with this hands-on exercise focused on relative cell references. You'll learn how formulas automatically adjust when copied or when input values change, making your spreadsheets more flexible and efficient. By working with basic arithmetic and exploring the effect of changes in source cells, you’ll see the power of Excel’s built-in logic. You’ll also use the “Show Formulas” feature to understand how cell references behave when copied. This exercise will strengthen your understanding of how Excel adapts formulas using relative positioning.

Instructions:

1. In a blank worksheet, type the following values:

   • A1: 10

   • A2: 5

   • A3: 8

2. In B1, enter the formula =A1+A2, then press Enter. Notice how Excel calculates the sum dynamically.

3. In B2, enter =A1*A3 and press Enter.

4. Change the value in A1 to 20 and observe how the calculations in B1 and B2 update automatically.

5. In A4, enter 12.

6. Copy B1 to B3 then look at the results and inspect the formulas using Formulas / Show Formulas

7. Save your workbook as "Cell References.xlsx".

Resources:

• 038 - 02 - Using Relative References in Formulas.xlsx

Description:
Learn how to use absolute and mixed references in Excel to lock specific cells in your formulas. In this hands-on exercise, you’ll calculate tax values by anchoring a fixed rate using the $ symbol. You’ll see how absolute references keep certain cells constant when copying formulas across rows. This technique is essential for financial modeling, tax tables, and any scenario where consistency is key. Strengthen your formula-building skills and gain control over how Excel handles your data.

• In this exercise, you’ll learn how to lock specific cells in a formula using absolute and mixed references. These techniques are essential for building structured calculations like financial models or tax tables.

Instructions:

1. In A1:A5, enter values: 100, 200, 300, 400, 500.

2. In B1, enter a tax rate of 0.075.

3. In C1, write a formula =A1*$B$1.

4. Drag the formula from C1 down to C5.

5. Save as absolute-references.xlsx.

Resources:

• 039 - 03 - Applying Absolute References.xlsx

Description:
Master mixed references in Excel to build dynamic, structured formulas that work across rows and columns. In this exercise, you’ll lock either the row or column using $A2 and B$1 to create a multiplication table. You’ll see how mixed references let formulas adjust in one direction while holding constant in another—perfect for modeling scenarios like tax tables or pricing grids. Copy and apply your formula across a full range to see how Excel handles the references. This technique is essential for anyone working with multi-dimensional data sets.

• learn how to lock specific cells in a formula using absolute and mixed references.

• These techniques are essential for quickly building structured calculations.

Instructions:

1. In A2:A6, enter values: 10, 20, 30, 40, 50

2. In B1:F1, enter values: 2, 3, 4, 5, 6

3. In B2, enter formula =$A2*B$1

4. Copy the formula then paste it over the range B2:F6

5. Save as mixed-references.xlsx.

Resources:

• 040 - 04 - Applying Mixed References.xlsx

Description:
Practice formatting in Excel to make your data clear, professional, and easy to read. In this hands-on exercise, you’ll use the Format Cells dialog box to apply currency formatting, long dates, and text styling like bold, italic, and alignment. You’ll also learn how to access formatting options quickly with shortcuts like Ctrl + 1. Add borders and background fills to enhance visual appeal and structure. This activity will help you present your data effectively and build polished spreadsheets.

• This activity shows you how to format data for improved readability and presentation. You'll explore number formats, text styling, alignment, borders, and fill options using the Format Cells dialog box.

Instructions:

1. Create a new spreadsheet.

2. Enter the following data:

   • A1: $500.25

   • A2: 3/15/2025

   • A3: Hello World

3. Format:

   • A1 as Currency with 2 decimals.

     1. search for “format cells”

   • A2 as Long Date

     1. Click home / font down-angled arrow

   • A3 as Bold, Italic, and Center-aligned.

     1. Press Ctrl + 1

4. Add a border and background fill to A1:A3.

5. Save as formatting-practice.xlsx.

Resources:

• 041 - 05 - Using the Format Cells Dialog Box.xlsx

Description:
Learn how Excel functions can simplify your calculations and save you time. In this exercise, you’ll compare basic formulas with built-in functions like SUM and AVERAGE. You’ll manually add values using a formula, then see how functions can perform the same task more efficiently. This is a great way to understand the difference between writing custom calculations and using Excel’s powerful function library. Build a strong foundation for working smarter with your data.

• You’ll explore the difference between basic formulas and built-in Excel functions. This exercise introduces the SUM and AVERAGE functions and demonstrates how functions can simplify calculations.

Instructions:

1. Enter these values in A1:A5

   1. 12, 24, 36, 48, 60.

2. In B1, enter =SUM(A1:A5).

3. In B2, enter =AVERAGE(A1:A5).

4. In B3, enter a formula =A1+A2+A3+A4+A5 (manual method).

5. Note the difference between B1 and B3.

6. Save as functions-vs-formulas.xlsx.

Resources:

• 042 - 06 - Introducing Excel Functions.xlsx

Description:
Strengthen your Excel skills by practicing with some of the most commonly used functions for data analysis. In this hands-on exercise, you’ll explore MAX, MIN, COUNT, COUNTA, and ROUND to find key values, count data entries, and control numerical precision. These functions are vital for understanding datasets and ensuring clean, accurate results. You’ll see how each function behaves with different types of data and how they help automate repetitive tasks. Perfect for anyone looking to boost their efficiency in Excel.

Instructions:

1. Enter these values in A1:A5

   • 12, 24, 36, 48, 60

2. In C1:C5, try:

   • =MAX(A1:A5)

   • =MIN(A1:A5)

   • =COUNT(A1:A6)

   • =COUNTA(A1:A6)

   • =ROUND(A2,1)

3. Save as essential-functions.xlsx.

Resources:

• 043 - 07 - Exploring Excel Functions.xlsx

Description:
Learn how to efficiently merge text from multiple cells using Excel’s TEXTJOIN and CONCAT functions. In this exercise, you’ll combine values with and without separators, and observe how each function handles blank cells. TEXTJOIN lets you skip empty cells and add custom separators, while CONCAT merges everything as-is. You’ll get a clear comparison of how each function behaves in real-world scenarios. These functions are ideal for cleaning up text data, formatting names, and streamlining reports.

• This exercise teaches you how to combine text from multiple cells using the TEXTJOIN and CONCAT functions. You'll learn how these functions handle separators and blank cells differently.

Instructions:

1. In cells A1 through A5, enter the following values (one per cell):

   • A1: Neo

   • A2: Morpheus

   • A3: (leave blank)

   • A4: Red

   • A5: Blue

2. In cell B1, enter the following formula to combine all values with a comma and a space, while skipping blank cells:
   =TEXTJOIN(", ", TRUE, A1:A5)

3. In cell B2, enter the following formula to combine the same range without any separator and including blank cells:
   =CONCAT(A1:A5)

4. Observe how TEXTJOIN and CONCAT handle blank cells differently.
   Save your workbook as text-join-concat.xlsx.

Resources:

• 044 - 08 - Using TEXTJOIN and CONCAT Functions.xlsx

• The Matrix (1999) Official Trailer #1

Description:
Practice turning raw data into clear visuals by creating charts in Excel. In this hands-on exercise, you’ll insert both a column chart and a pie chart using real data, with proper selection of row and column headings. You’ll learn how to highlight trends, compare categories, and communicate insights more effectively through visual representation. Understanding how to choose and format charts is essential for making your data easier to analyze and present. This activity builds your confidence in using Excel's charting tools to bring your spreadsheets to life.

• Visualize your data by creating a chart in Excel. You'll select data and headings, insert a column chart, and learn how charts can make trends and comparisons easier to understand.

Instructions:

1. Use the data from 046 - 09 - starting-spreadsheet.xlsx

2. Insert a column chart.

   1. Select data, column headings, and row headings

3. Insert a pie chart

   1. Select data, column headings, and row headings

4. Save as Excel-chart.xlsx.

Resources:

• 045 - 09 - starting-spreadsheet.xlsx

• 045 - 10 - Creating a Chart.xlsx

Description:
Learn how to save time by starting with Excel’s built-in templates for common tasks like budgeting and invoicing. In this hands-on exercise, you’ll search for a template, make edits, and save a personalized version for future use. Templates help you jumpstart your work with pre-designed layouts and formulas. You’ll see how easy it is to adapt a template to your specific needs and reuse it anytime. This skill is perfect for streamlining your workflow and building professional spreadsheets fast.

• Save time by starting with a built-in Excel template for tasks like budgeting or invoicing. You’ll practice finding a template, making edits, and saving your own reusable version.

Instructions:

1. Go to File → New.

2. Search for a “Budget” or “Invoice” template.

3. Open the template and edit at least three fields.

4. Save a copy of the template as your own version.

5. Save as custom-template.xlsx.

Resources:

• 046 - 13 - Using Excel Templates.xlsx

Learn how to upload pictures to AI tools like ChatGPT, Copilot, Gemini, and Grok to get instant help with spreadsheets, quiz questions, and handwritten notes. This hands-on exercise walks you through capturing an image on your phone and using it in a real-world scenario—solving a quiz with AI support. You’ll see how visual input expands what AI can do, from interpreting data to answering complex questions. Whether it’s a screenshot or a photo of your notes, AI can now analyze and assist with what it sees. This skill opens up a whole new way to interact with your work and accelerate your learning.

• In this lecture, you’ll learn how to take a picture with your phone and upload it to an AI chatbot like ChatGPT, Copilot, Gemini, or Grok. We’ll walk through a real-world example—snapping a photo of a quiz question and getting the AI to solve it. This powerful feature lets you interact with your spreadsheets, Documents, and handwritten notes in an entirely new way.

Resources:

• ChatGPT Quiz Question Image (Google Doc)

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Resources:

• 048 - 02 - Quiz #4a.xlsx

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Resources:

• 049 - 03- Quiz #4b Review.xlsx

• TEXTJOIN and CONCAT ChatGPT

• TEXTJOIN and CONCAT ChatGPT (Google Doc)

Learn how to generate random numbers in Excel using the powerful RAND and RANDBETWEEN functions. This lecture shows you how to create random decimals between 0 and 1, as well as whole numbers within a custom range. These functions are ideal for simulations, sample datasets, and testing formulas. You’ll also learn how to refresh random values with F9 and convert results using “Paste as Values.” Plus, we’ll explore how to access function Documentation directly from Excel’s tooltips for quick reference.

• Excel makes it easy to create random values for simulations, tests, and data sampling. In this lecture, you'll learn how to use =RAND() to generate random decimals between 0 and 1

  1. Example =RAND()

• Use =RANDBETWEEN(start, end) to generate whole numbers within a specific range.

  1. Example =RANDBETWEEN(1, 500)

• pressing F9 will regenerate the numbers

• copy and “paste as values” to solidify the numbers

• We also saw how to open Documentation from a function’s tooltip

Resources:

• 050 - 04 - Generating Random Numbers.xlsx

Automatically display the current date or time in your spreadsheet using Excel’s =TODAY() and =NOW() functions. These dynamic tools are perfect for tracking updates, timestamping entries, and creating real-time reports that refresh with each workbook calculation. You’ll learn how each function works, when to use them, and how to freeze the values using keyboard shortcuts. Whether you're managing deadlines or logging activity times, this feature helps keep your spreadsheets up to date. Simple yet powerful, these functions bring automation to your time-sensitive data.

• Want to automatically display today’s date or the current time in your spreadsheet? The =TODAY() and =NOW() functions update dynamically to always show the latest date or date and time. Learn how to use these functions to timestamp data, track updates, or build real-time reports that update every day.

• Example =Today()

• Example =Now()

=TODAY()

• Returns: The current date (e.g., 3/26/2025)

• Time part: Always 00:00 (midnight)

• Example use: Tracking deadlines, calculating age, or anything date-related

• Updates: Every time the workbook is recalculated or opened

Example:
=TODAY()
Would return:
3/26/2025

=NOW()

• Returns: The current date and time (e.g., 3/26/2025 2:15 PM)
  Example use: Timestamping, calculating time differences, real-time clocks
  Updates: Like TODAY(), it updates on recalculation or when you open the workbook

Example:
=NOW()
Would return something like:
3/26/2025 2:15 PM

Quick Tip:

If you want to freeze the value (so it doesn’t keep updating), you can:

• Press Ctrl + ; to insert the current date

• Press Ctrl + Shift + ; to insert the current time

Resources:

• 051 - 07 - Inserting Dynamic Dates and Times.xlsx

Learn how to quickly calculate the number of days between two dates using Excel’s =DAYS() function. This lecture shows you how to use both static dates and cell references in your formulas. This function is ideal for anyone who needs to perform quick and accurate date-based calculations. It’s a simple yet powerful tool for managing time-sensitive data in Excel.

• The =DAYS(end_date, start_date) function makes it easy to calculate how many days are between two dates. In this lecture, you’ll learn how to use it to find deadlines, age durations, or the length of a project. This is a quick and powerful way to perform date arithmetic in Excel.

• Calculates the number of days between two dates.

• Example =DAYS("12/31/2023", "01/01/2023")

Resources:

• 052 - 10 - Calculating Date Differences with the DAYS.xlsx

Learn how to extract specific characters from the beginning or end of a text string using Excel’s =LEFT() and =RIGHT() functions. This lecture shows how to pull key parts of data like product codes, IDs, or prefixes for faster sorting and analysis. You'll explore syntax, real-world examples, and how optional arguments work. We’ll also cover how to access function Documentation from Excel for quick reference. These functions are essential tools for cleaning and formatting data efficiently.

• Sometimes you only need part of a text string—like the first few characters of a product code or the last digits of an ID number. With =LEFT(text, num_chars) and =RIGHT(text, num_chars), you can extract exactly what you need from the beginning or end of a cell’s content. This lecture shows how to use both functions to clean, format, and analyze data.

• Extracts text from the beginning or end of a string.

• Example: =LEFT(A1, 3) // First 3 characters

• Example: =RIGHT(A1, 3) // Last 3 characters

• Also we took a look at optional arguments and Documentation

Resources:

• 053 - 15 - Extracting Text with LEFT & RIGHT.xlsx

• 053 - 15 - outdoor gear generator.xlsx

• 053 - 15 - name generator.xlsx

Clean up and organize messy data in Excel using the Text to Columns tool. In this lecture, you’ll learn how to split text into multiple columns based on delimiters like commas, spaces, or tabs. This feature is perfect for formatting imported data or breaking apart full names, addresses, or combined values. You’ll also discover how to preview the split before applying changes, ensuring clean and accurate results. A must-know skill for anyone working with raw or unstructured data.

• When your data is combined into a single column with commas, spaces, or other separators, Excel’s Text to Columns feature can quickly split it into organized parts. In this lecture, you’ll learn how to use delimiters to separate text into multiple columns for easier sorting, filtering, and analysis. This tool is especially helpful when cleaning up exported or imported data.

Resources:

• 054 - 19 - Splitting Text with Delimiters Using Text to Columns.xlsx

• 053 - 15 - Outdoor Gear Generator.xlsx

• 053 - 15 - Name Generator.xlsx

Learn how to count the number of characters in a cell—including spaces—using Excel’s =LEN() function. This lecture shows how to use LEN to track text length, enforce character limits, and analyze string data. You’ll see real-world examples like validating entry lengths or preparing data for import/export requirements. Despite its simplicity, LEN is a powerful tool for data cleaning and quality control. A great function to have in your Excel toolkit for any text-based task.

• Need to know how many characters (including spaces) are in a cell? The =LEN(text) function does exactly that. Whether you're checking length limits or analyzing text data, this simple function is surprisingly powerful—and you'll see it in action in this lesson.

• Counts the number of characters (including spaces)

• Example: =LEN(A1)

Resources:

• 055 - 20 - Counting Characters with the LEN Function.xlsx

Remove unwanted spaces from your data with Excel’s =TRIM() function—perfect for cleaning up messy text. This lecture shows how TRIM eliminates leading, trailing, and extra spaces between words, leaving only single spaces. It’s a simple yet powerful tool for preparing data for analysis, import, or presentation. You'll learn when and why to use TRIM, especially when dealing with copied or imported text. Clean, standardized data starts with mastering this essential function.

• Messy data often comes with extra spaces—before, after, or in between words. The =TRIM(text) function removes all extra spaces from a string, keeping only single spaces between words. This is one of the best ways to clean and standardize your text data before performing analysis or importing into other systems.

• Removes extra spaces from text.

• Example: =TRIM(A1)

Resources:

• 056 - 22 - Cleaning Up Text with TRIM.xlsx

Practice using Excel’s RAND() and RANDBETWEEN() functions to create dynamic, random data sets. In this hands-on exercise, you’ll generate random decimal values and whole numbers to simulate test data and explore variability. You’ll also learn how to format decimal places and use F9 to refresh values on demand. These functions are perfect for building sample data, testing formulas, or creating simulations. A great way to understand randomness and build flexible, practice-ready spreadsheets.

• In this exercise, you’ll explore how to generate random numbers using Excel’s RAND() and RANDBETWEEN() functions. You’ll create simulated data sets that change each time the sheet recalculates. This is useful for creating sample data, testing formulas, or practicing with variability.

Instructions:

1. Open a blank worksheet and name the tab Random Data.

2. In cells A1 through A10, enter the formula =RAND() to generate decimal numbers between 0 and 1.

3. In cells B1 through B10, enter =RANDBETWEEN(1,7777) to generate random whole numbers between 1 and 7,777.

4. Format column A to show only 2 decimal places.

5. Press F9 to recalculate and observe how the values change.

6. Save the workbook.

Resources:

• 057 - 23 - HOE - Generating Random Numbers.xlsx

Learn how to insert real-time dates and timestamps using Excel’s =TODAY() and =NOW() functions. In this hands-on exercise, you’ll create a dynamic log that updates each time the workbook is opened or recalculated.

• Learn how to insert dynamic date and time stamps that update automatically. This exercise will show you how to use the TODAY() and NOW() functions to create real-time logs. These tools are perfect for dashboards, tracking sheets, or timestamps.

Instructions:

1. Open a new worksheet named Timestamps.

2. In cell A1, enter the label "Date Generated". In B1, enter =TODAY().

3. In cell A2, enter "Date & Time Generated". In B2, enter =NOW().

4. Format B1 as Short Date and B2 as Custom → MM/DD/YYYY hh:mm AM/PM.

5. Save the workbook.

6. Close and reopen the file to see the values automatically update.

7. Save the workbook.

Resources:

• 058 - 24 - HOE - Inserting Dynamic Dates and Times.xlsx

Practice calculating the number of days between two dates using Excel’s =DAYS() function. In this hands-on exercise, you’ll determine the duration of a project, event, or deadline by subtracting a start date from an end date. You’ll also test how updating the dates affects the result, giving you a feel for real-time time tracking. This function is ideal for project management, scheduling, and any time-based calculations. It’s a must-know tool for working with dates in Excel.

• Calculate the number of days between two dates using the DAYS() function. You’ll practice finding the duration between start and end dates for projects, events, or deadlines. This function is essential for time-based calculations.

Instructions:

1. In a new worksheet named Days Between, enter the following in columns A and B:

   • A1: Start Date, A2: 1/1/2023

   • B1: End Date, B2: 12/31/2023

2. In C1, enter Days Between, and in C2, type =DAYS(B2,A2).

3. Try changing the dates in A2 and B2 to see how the result in C2 updates.

4. Save the workbook.

Resources:

• 059 - 25 - HOE - Calculating Date Differences.xlsx

Practice pulling specific parts of a text string using Excel’s =LEFT() and =RIGHT() functions. In this exercise, you’ll extract state codes and item numbers from structured product codes. These functions are perfect for working with standardized text formats like IDs, codes, and labels. You’ll apply formulas across a list and see how Excel can quickly isolate key information. Great for cleaning and organizing data in real-world scenarios.

• Use the LEFT() and RIGHT() functions to extract parts of a string, such as codes or abbreviations. In this exercise, you’ll pull prefixes and suffixes from sample product codes. These functions are great for working with structured text formats.

Instructions:

1. In a worksheet called Text Extract, enter the following in column A:

   • A1: Product Code

   • A2–A6: TX-2023-001, NY-2022-502, CA-2023-999, WA-2021-812, NV-2020-301

2. In column B, use =LEFT(A2, 2) to extract the state code.

3. In column C, use =RIGHT(A2, 3) to extract the item number.

4. Fill formulas down to B6 and C6.

5. Save as Left-Right-Text.xlsx.

Resources:

• 060 - 01 - HOE - Extracting Text - used in lecture.xlsx

• 060 - 01 - HOE - Extracting Text with LEFT & RIGHT.xlsx

Learn how to measure text length in Excel using the =LEN() function. In this hands-on exercise, you’ll count the number of characters—including spaces—in names and phrases to better understand string lengths. This function is useful for tasks like data validation, formatting consistency, and preparing content for imports or exports. You’ll also add headers and apply basic formatting for a clean, organized look. A simple but essential tool for anyone working with text data in Excel.

• Discover how to count the number of characters in a cell—including spaces—with the LEN() function. You’ll apply this to names or phrases to measure text length. It’s useful for data validation, formatting, and text analysis.

Instructions:

1. Create a worksheet named Character Count.

2. In column A, enter five different full names or phrases.

3. In column B, use =LEN(A1) to count the number of characters in each name.

4. Add a header row and apply bold formatting to your headers.

5. Save the file as Len-Character-Count.xlsx.

Resources:

• 061 - 02 - HOE - Counting Characters with LEN.xlsx

Tidy up messy or inconsistent spacing in your data using Excel’s =TRIM() function. In this exercise, you’ll clean up text entries with extra spaces and compare the original and trimmed versions side by side. This is especially helpful when working with imported or copy-pasted data that includes hidden formatting issues. You’ll see how TRIM improves data consistency and prepares text for analysis or reporting. A quick and effective way to ensure cleaner spreadsheets.

• Clean up messy text by removing extra spaces using the TRIM() function. You’ll work with cells that have inconsistent spacing and compare the original text to the cleaned version. This function is a must-know for tidying imported or copied data.

Instructions:

1. Create a worksheet called Trim Text.

2. In column A, enter text with inconsistent spacing such as:

   • Hello World

   • Excel is fun

   • Clean Data

3. In column B, use =TRIM(A1) to clean each string.

4. Compare original vs. trimmed text side-by-side.

5. Save as Trim-Function.xlsx.

Resources:

• 062 - 03.2 - HOE - Counting Characters with LEN.xlsx

Review quiz answers with step-by-step explanations! Reinforce key concepts, learn from mistakes, and deepen your understanding with guided walkthroughs.

Resources:

• 063 - 04.2 - Quiz #5 Review.xlsx