TOPICS COVERED:
Advanced Excel Course – More Functions
Date and time functions
Text functions
Power Functions (CountIf, CountIFS, SumIF, SumIfS)
Advanced Excel – Lookup Functions
Vlookup / Hlookup
Index & Match
Vlookup with Helper Column
Advanced Excel – Formatting
Using auto formatting option for worksheets
Using conditional formatting option for rows, columns and cells
Advanced Excel – WhatIf Analysis
Goal Seek
Data Tables
Scenario Manager
Advanced Excel – Charts
Using Charts
Formatting Charts
Using 3D Graphs
Using Bar and Line Chart together
(Data Modified in Excel, Chart would automatically get updated)
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources
Using data consolidation feature to consolidate data
Show Value As ( % of Row, % of Column, Running Total)
Viewing Subtotal under Pivot
Description:
Microsoft Excel is one of the most powerful tools used for data management. Almost all the top organizations use Excel as a tool for maintaining and analyzing their data operations. The primary objective of this is to equip the learners with the skills that can be used to digitally store, process, and conduct important office functions like communicating daily routines, creating spreadsheets. It contains a spreadsheet that can automatically input, calculate and analyze data, which makes it a valuable skill for the workplace. Employees can use Excel to accomplish an abundance of daily tasks.
Classes are conducted by both offline and online.
COURSE DURATION: 1 MONTH
