ExcelExpert.pro

Introduction to Excel: Interface and Navigation

Creating and Saving Workbooks

Entering and Editing Data

Basic Formatting Techniques

Introduction to Formulas and Functions

Sorting and Filtering Data

Using Conditional Formatting

Data Validation Techniques

Basic Data Analysis: Sum, Average, Min, and Max Functions

Text and Date Functions

Creating and Formatting Tables

Advanced Sorting and Filtering

Managing Large Data Sets

Using VLOOKUP and HLOOKUP Functions

Introduction to PivotTables

Creating Basic Charts and Graphs

Customizing Chart Elements

Advanced Chart Types: Combo, Treemap, and Waterfall Charts

Using Sparklines for Data Visualization

Creating Interactive Dashboards

Keyboard Shortcuts and Excel Tips

Protecting and Sharing Workbooks

Collaborating in Real-Time with Excel Online

Introduction to Excel Macros and VBA

Course Review and Next Steps