Overview

You are welcome to this TWO in one course.**The FIRST SECTION is all about Excel Workbook, charts and pivot table1) It deals with The Dynamics of Microsoft Excel Workbook2) It deals with Conditional Formatting3) It deals with The Dynamics of Microsoft Excel Charts and Maps4) It deals with The Dynamics of Microsoft Excel Pivot Table and Pivot Chart**The SECOND SECTION is all about the mastery of MS Excel Functions (Office 2021)1) It deals with Mastery of MS Excel Functions (Office 2021/Microsoft 365) such as Maths & Trig Functions, Date & Time Functions, Logical Functions, Text FunctionsIn the FIRST SECTION, you will be able to:Be able to use the conditional formatting tool to present data and create your own custom formattingExplore the dynamics of Pivot Table and Pivot ChartUnderstand how Pareto Chart works and gain apt understanding of the Pareto lineUnderstand how Histogram works and be able to manipulate the grouped data in binsBe able to create a Map Chart with multiple levels of geographic detailsUnderstand how Bubble Chart works and be able to interpret the dataCreate 3D Map with Time LineLearn how to create a Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more.In the SECOND SECTION, you will be able to:Learn how to work with Excel functions from scratch (absolute beginner) to a comfortable professional:Master the skill of tracing dependents and precedents of dataFlourish in the skill of nesting functionsUnderstand how to create lists of items with Data ValidationMaster the tool of evaluating dataCreating and Deleting and Editing Defined NamesUnderstand how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, LCM, GCD, SIN, COS, TAN, etc.Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, WEEKDAYS, etcUnderstand how to work with Logical Functions - IF, IFS, IFERROR, NOT, OR, AND, etcUnderstand how to work with Text Functions - CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc

Skills

Reviews