Master Excel Basics

Master Excel Basics

Learn to harness Microsoft Copilot for essential Excel tasks including data analysis, formula creation, and visualization. Transform complex spreadsheets into actionable insights with AI assistance.

Automate Advanced Features

Automate Advanced Features

Explore powerful Excel automation using Copilot for dynamic arrays, VBA macros, and Python integration. Save time and reduce errors in complex data manipulation tasks.

Enhance Data Analysis

Enhance Data Analysis

Master Excel's data profiling, visualization, and recommendation features with Copilot. Create professional reports and uncover insights using natural language commands.

Microsoft CoPilot

Nearly 70% of Fortune 500 companies use Microsoft 365 Copilot, which includes CoPilot in Excel.  This course ensures your ahead of the pack.

Curriculum

6 Chapters · 24 Lessons

  1. 1

    Getting Started

    1. (Included in full purchase)

      Meet the Instructor

    2. (Included in full purchase)

      Overview

    3. (Included in full purchase)

      Getting Setup

    4. (Included in full purchase)

      CoPilot in Excel Kickoff

    5. (Included in full purchase)

      Data Analyzing Market Campaign Data

  2. 2

    Adding Formula Columns

    1. (Included in full purchase)

      How to Add Formula Columns

    2. (Included in full purchase)

      Working with Text

    3. (Included in full purchase)

      Working with Date Calculations

    4. (Included in full purchase)

      Working with Conditional Logic

    5. (Included in full purchase)

      Working with Lookups

  3. 3

    Sorting, Filtering, and Highlighting

    1. (Included in full purchase)

      Working with the Sort and Filter Option

    2. (Included in full purchase)

      Highlighting Data

    3. (Included in full purchase)

      Working with Formula Based Formatting

    4. (Included in full purchase)

      Working with Color Scales and Data Bars

    5. (Included in full purchase)

      Editing Spreadsheets

  4. 4

    Analyzing Data

    1. (Included in full purchase)

      Data Analysis

    2. (Included in full purchase)

      Data Profiling

    3. (Included in full purchase)

      Summarizing Data

    4. (Included in full purchase)

      Visualizing Data

    5. (Included in full purchase)

      Making Recommendations

  5. 5

    Advanced Use Cases

    1. (Included in full purchase)

      Dynamic Arrays

    2. (Included in full purchase)

      Macros

    3. (Included in full purchase)

      Working with Python

  6. 6

    Closing

    1. (Included in full purchase)

      Wrap Up

Victor Cuevas

Hi, I am Victor Cuevas, the founder of The Knowledge Jar, a hub for AI literacy, AI community, and IT development solutions. My goal is to promote AI literacy for teachers, parents, and the next generation. I look forward to having you in my class.

Learn How to Use CoPilot AI with Microsoft Excel

Join the course to learn everything you need to know about Microsoft CoPilot in Microsoft Excel.

$20.00

Enroll now