MICROSOFT EXCEL 2010/2013/ 2016/2019/365 : INTERMEDIATE

Course Objectives

The objectives of this course is to enable participants to understand intermediate Excel functions such as SUMIF, COUNTIF, VLOOKUP, HLOOKUP and how to use them to perform basic data analysis. Conditional formatting also will be taught so participants will know to highlight data based on specific criteria, such as color scales, data bars, and icon sets. Some useful Date function also will be taught.

The course also covers how to create advanced charts and graphs, such as combination charts to better illustrate data trends and relationships. On top of charts, The course also shows how to use advanced data visualization techniques, such as sparklines, data bars, and conditional formatting icons, to provide quick insights into data trends and patterns

Course Outline

Module 1 : Calculating With Formulas

Module 2 : LOOKUP

Module 3 : Conditional Formatting

Module 4 : Charts

Module 5 : Sparklines

Module 6 : Text Function


Module 7 : Useful Functions