Microsoft Excel Intermediate & Advanced

Microsoft Excel is useful for data organization, analysis, calculations, projections, planning and decision making. Our research and experience point to the fact that users only utilize less than 5% of the features. In order to appreciate the technology training is essential. This intensive three days hands on workshop focuses on excel features meant to sharpen delegates skills so as to provide solutions to various challenging excel tasks.

Our experienced tutors have simplified and tailored the training material for easier understanding and quick assimilation. We have multiple examples and hands on exercises to perfect the acquired skills. Our training builds up from the basics to make sure all the participants are at the same platform.

Some of the topics that will be discussed include but not limited to the following: –

  • Level 1 Basic – Provides the firm foundational knowledge and builds a solid understanding on the Basics of Microsoft Excel in readiness for more challenging tasks. We look at the General Architecture of Microsoft. We also look at Basic Essential Skills, Formulas and Formula Auditing and Graphs.
  • Level 2 Intermediate: Builds up from the Basics and Basic Skills, topics include; Introduction to functions such (SUM, SUMIF, SUMIFs, MAX, AVERAGE, COUNT, COUNTA, COUNTIF, DATEDIF, TODAY (), NOW(), MID, LEFT, RIGHT,CONCATENATE, ETC) . WE also look at Data Validation and Security, NESTED IF Function, IFs and other advanced functions.
  •  Level 3 Advanced: Builds up from Basic and Intermediate skills, we look at reference functions such as VLOOKUP, HLOOKUP, MATCH and INDEX Functions, Pivot Tables, Pivot Charts and VBA Macros. We further look at Advanced Excel Skills, short cuts and tools for handling complex data.