| Course Name |
Hours |
List Price |
Content |
| Excel Data Mastery: Importing, Cleaning Shaping Data |
4.00 |
$279.00 |
|
Description: You will cover how data from different sources are imported in Excel. Use Power Query and M Language to transform the raw data into meaningful data that is ready for analysis. Once the query is finalized you will then learn how to save the query for future use as new source data needs to be brought into excel for analysis.
# of Days:
Setting:
|
| Excel Data Mastery: Modeling, Measures Power Pivot Dashboards |
4.00 |
$279.00 |
|
Description: This course covers data modeling, including how to connect multiple data tables to work together like a relational database. Students will then use PowerPivot to create PivotTables and PivotCharts, analyze data within the model, and build measures and KPIs.
# of Days:
Setting:
|
| Excel Essentials for Everyday Productivity |
4.00 |
$279.00 |
|
Description: This beginner friendly course gives new Excel users a strong foundation in navigating the interface, entering data, and building simple formulas. Even if students have used Excel before, this session uncovers timesaving shortcuts, smart data entry tools, and practical techniques that make everyday tasks faster and easier. Participants learn how to create workbooks, use AutoFill and Flash Fill, and build basic formulas with confidence.
# of Days:
Setting:
|
| Excel Formatting Worksheet Design Made Easy |
4.00 |
$279.00 |
|
Description: In this course, you will cover the formatting worksheets, creating custom number formats, preparing documents for printing or conversion into PDFs, using proofing tools, and creating custom shorthand using AutoCorrect.
# of Days:
Setting:
|
| Excel Power Functions: Lookup, Logic Data Summarization |
4.00 |
$279.00 |
|
Description: In this course, you will learn about how to use names in logical and lookup functions. You will also learn to use complex functions, such as SUMIF / SUMIFS and other functions to perform calculations on large data sets.
# of Days:
Setting:
|
| Excel Power Skills: Spot Trends, Build Visuals, Protect Your Work, and Create Templates |
4.00 |
$279.00 |
|
Description: You will sort and filter data, use conditional formatting, create and format tables and charts, and how to use the Quick Analysis tools. Apply protection to the worksheet, workbook, and file itself. You will work with graphics, run the Accessibility Checker and make the file Accessible (508 Compliant), create and work with comments, and finally create a custom template
# of Days:
Setting:
|
| Excel Power Skills: Text Functions Date/Time Intelligence |
4.00 |
$279.00 |
|
Description: This course focuses on how to use function formulas to manage text and its formatting, as well as performing complex date and time calculations.
# of Days:
Setting:
|
| Excel Productivity: Large File Management Linked Formula Techniques |
4.00 |
$279.00 |
|
Description: In this course, you will cover how to work with large worksheets and workbooks in Microsoft Excel. Create Named cells and ranges which are used in formulas and navigation. Write formulas that refer to other worksheets and workbooks.
# of Days:
Setting:
|