General Excel Features and Functions
- How to use Excel formulas and functions
- How to create a pivot table in Excel
- How to use VLOOKUP in Excel
- How to use Excel for data analysis
- How to create and format charts in Excel
- How to filter data in Excel
- How to use Excel shortcuts
- How to create conditional formatting rules in Excel
- How to create and manage Excel tables
- How to protect Excel sheets with a password
Excel Formulas and Calculations
- How to sum a column or range in Excel
- How to use IF statements in Excel
- How to calculate percentage in Excel
- How to use the INDEX and MATCH functions in Excel
- How to use the COUNTIF function in Excel
- How to round numbers in Excel
- How to use the SUMIF and SUMIFS functions in Excel
- How to create a running total in Excel
- How to use the AVERAGE function in Excel
- How to create nested IF formulas in Excel
Data Management and Organization
- How to merge cells in Excel
- How to freeze rows and columns in Excel
- How to sort data in Excel
- How to remove duplicates in Excel
- How to split text into columns in Excel
- How to transpose data in Excel
- How to consolidate data from multiple sheets in Excel
- How to group and ungroup rows/columns in Excel
- How to create drop-down lists in Excel
- How to use data validation in Excel
Advanced Features and Customization
- How to use Macros in Excel
- How to use Power Query in Excel
- How to use Excel’s XLOOKUP function
- How to perform a what-if analysis in Excel
- How to use Excel’s Solver Add-in
- How to use Excel VBA for automation
- How to create custom number formats in Excel
- How to build dashboards in Excel
- How to connect Excel to external data sources
- How to import and export data in Excel
Collaboration and Sharing
- How to share Excel workbooks for collaboration
- How to track changes in Excel
- How to link Excel to Word or PowerPoint
- How to print Excel spreadsheets properly
- How to save an Excel file as a PDF
- How to use Excel with OneDrive
- How to add comments and notes in Excel
- How to create a shared workbook in Excel
- How to recover unsaved Excel files
- How to set up automatic backups in Excel