- Manage and analyze data with Excel features and functions.
- Get started with features like VLOOKUP and macros.
- Save time and do more in Excel.
Overview
Many Excel users hear terms like VLOOKUP, PivotTables, and conditional formatting and envision features reserved only for power users. Not so! These powerful functions are simple once you know the steps involved. Each concise course in this learning path walks you step-by-step through the basics
Syllabus
Courses under this program:
Course 1: Excel: VLOOKUP and XLOOKUP for Beginners
-Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.
Course 2: Excel: PivotTables for Beginners
-Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.
Course 3: Excel: Macros and VBA for Beginners
-Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).
Course 4: Excel: Filtering Data for Beginners
-Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.
Course 5: Excel: Conditional Formatting for Beginners
-Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
Course 6: Excel: Power Query for Beginners
-Get an intro to Power Query, a set of robust features in Microsoft Excel.
Course 7: Excel: Power Pivot for Beginners
-Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.
Course 1: Excel: VLOOKUP and XLOOKUP for Beginners
-Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.
Course 2: Excel: PivotTables for Beginners
-Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.
Course 3: Excel: Macros and VBA for Beginners
-Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).
Course 4: Excel: Filtering Data for Beginners
-Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.
Course 5: Excel: Conditional Formatting for Beginners
-Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
Course 6: Excel: Power Query for Beginners
-Get an intro to Power Query, a set of robust features in Microsoft Excel.
Course 7: Excel: Power Pivot for Beginners
-Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.
Courses
-
Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).
-
Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.
-
Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.
-
Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
-
Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.
-
Get an intro to Power Query, a set of robust features in Microsoft Excel.
-
Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.
Taught by
Jess Stratton, Dave Ludwig, Oz du Soleil, Dennis Taylor and Joshua Rischin