Advanced Excel at GLM
This advanced excel course is designed for intermediate excel user who desires to learn more advanced excel skills. Learn the most advanced formulas, functions and conditional formatting to be an Excel pro. The course will be ten hours divided across five lessons.
Lesson 1: Advanced Functions and Formulas
- Overview of excel functions
- Text Functions
- Date and Time Functions
- Array Formulas
- Data Protection: Locking cells, protecting sheets, and workbooks
Lesson 2: Pivot Tables and Charts
- Creating and formatting pivot tables, slicers and timelines
- Calculated fields and items
- Grouping based on numbers and dates
Lesson 3: Visualization in Excel
- Bar and Column charts, Histogram and Pareto Charts, Line charts, area charts, scatter plots, pie and donuts, waterfall and funnel charts etc
Lesson 4: Logical Functions
- AND, OR, IFS, XOR, IFERROR
- What if analysis
- Nested if
Lesson 5: Lookup Functions
- Understanding data Lookup Functions
- Index and Match
- Indirect
- VLookup/HLookup
Course Project
- At the end of the course, you will be given a project that will test your understanding of the concepts taught
Certification
- A certificate for undertaking in the excel course will be offered after the training
Charges
The charges for the course are KES. 3,000 per person, payable through
KCB Account: 1323571582
Or
Paybill: 522522
Account: 7800609