Required Skills: You MUST have the basic knowledge of excel, e.g. Basic formula writing for simple calculations like addition, subtraction, multiplication, division, percentage & sum. You should know various types of formatting methods and page layouts.ÂÂ
ÂÂ
Course Content:
Fetching data from within or outside the file
Using combination of VLOOKUP & IF functions
Alternative to VLOOKUP function â?? INDEX & MATCH Combo
Writing complex formula with multiple conditions
Using a combination of IF, AND & OR functions
Using nested IF functions
Using IFS function
VLOOKUP v/s Nested IF v/s IFS
Correct sequencing of logic in Nested IF / IFS
Using COUNTIF, COUNTIFS, SUMIF & SUMIFS function
& more
Data Handling & Analysis
Using Sorting function
Using Filters in different ways
Using Filters with logical conditions
Using Conditional Formatting methods
Using Conditional formatting along with formula
Reporting & Data Analysis
Creating various types of Charts
Deciding the type of Chart to be used
Data management prior to preparing the chart
Creating complex combination charts
Analyzing Data using Charts
Creating Pivot Tables
Managing data for pivot table
Different layouts of a pivot table
Analyzing Pivot tables from different perspective
ÂÂ
Notes for Student
Excel will be taught using real life Excel files.
These Excel files will be provided to students.
It would be good if student can get own laptop with Excel, otherwise student can learn using Instructor's laptop.
View this Course
Certified
You have 
