Advanced Excel 2019
BASIC EXCEL
- Introduction Excel
- Page setup
- Data entry
- Data formatting
- Fill handle
- Format painter
- Cell styles
- Find and replace data
- Converting data type
- Shorts and filters
- Charts
- Link
- Selection pane
- Insert pictures, shapes, Icons, 3D models and Smart Art
- Table and format as table
- Protect sheet and protect work book
- Workbook views
- Freeze panes
- Printing
BASIC FORMULAS AND FUNCTIONS
- SUM
- COUNT
- AVERAGE
- MAX
- DATE FUNCTIONS
- MIN
- MODE
- MEDIAN
- SQRT
- ROUND
ADVANCED EXCEL
- Conditional formatting
- Paste options
- Pivot table
- Creating
- Sort and filter
- Calculate columns
- Grouping
- Formatting
- Report filter pages
- Value field setting
- Pivoting slicers
- Pivoting charts and automated dashboard
- Update and refresh
- Cell referencing
- Named ranges
- Introducing and working
- Define names
- Name manager
- Formula Auditing
- Data validation
- Macros
- Text to columns
- Remove duplicates
- Consolidate
- Goal seek
- Grouping and ungrouping
ADVANCED FORMULAS
- IF
- IFS
- PMT
- SWITCH
- CHOOSE
- IFERROR
- LOOKUP
- VLOOKUP
- HLOOKUP
- IF LOOKUP
- NESTED IF
- AND, IF AND
- OR, IF OR
- TEXT FUNCTIONS
- SUM IF AND SUM IFS
- COUNT IF AND COUNT IFS
- RAND
- RANDBETWEEN
- More functions