arrow_back
Introduction to Excel
What is Excel?
Importance of Excel
Wikipedia
Understanding the Excel interface
Navigating through a workbook
Working with sheets and tabs
Data Entry and Formatting
Entering data into cells
Formatting cells
Using basic formatting options
Applying number and date formats
Working with fonts and alignments
Formulas and Functions
Understanding formulas and functions
Creating basic formulas
Using mathematical operators
Working with common functions
Using relative and absolute cell references
Data Analysis and Visualization
Sorting and filtering data
Creating tables and charts
Applying conditional formatting
Using data validation
Creating pivot tables
Advanced Excel Features
Working with advanced functions
Using logical and lookup functions
Using conditional formulas
Working with named ranges
Protecting and securing your workbook
Automating Tasks with Macros
Introduction to macros
Recording and playing macros
Editing and managing macros
Assigning macros to buttons and shortcuts