Boost your career prospects with my Excel courses.
- Sheet Format
- Workbook Format
- Cell Formatting in Excel
- Dates, Currency, Numbers
- Export to Word, PDF
- Black and White Cross
- Autofill Cells
- Mathematical Calculations
- Date Operations
- Absolute References $
- Conditional Formatting
- Freeze Panes
- Drop-down Lists
- Sort and Filter
- Charts (Create and Configure)
- All Chart Types
- Pivot Tables
- Utilities and Tricks
- Pivot Charts
FUNCTIONS:
- Sum, Average Function
- Max, Min Function
- Count, CountArea Function
- CountBlank Function
- CountIf Function
- VLOOKUP Function
- Conditional If Function
- SumIf, AverageIf
Excel for Business Data Analysis: From Data Entry to Insight
