Advance Excel Course contents
-
- Introduction – Source Data & Interface
- Navigation Shortcuts
- Formatting
- Format Painter
- Sorting
- Autofill
- Filtering
- Custom Lists
-
- Look Ups: HLook Up, VLookUP, 2 ways Look Up
- Index & Match
- IF, Nested IF & IFS
- AND & OR
- IF + AND
- IF + OR
- NOT & IF + NOT
- Statistical formulas: Large, Small & Rank
- SWITCH
- Date, Time, Text Formulas
-
- Inserting various Charts in Excel
- Dynamic Charts
-
- Inserting Pivot Table
- Clear, Select, Move, Layouts, Table styles
- Number & Conditional Formatting
- Sorting, Grouping, Filtering
- Slicer, Timeline
-
- OVERVIEW OF ACCOUNTS PAYABLE PROCESS.
- PROCURE TO PAY CYCLE PROCESS.
- BASIC CONFIGURATION ACTIVITIES.
- END USER ACTIVITIES IN ACCOUNTS PAYABLE.