EXCEL PRACTICE

EXCEL PRACTICE FILES

FREE COURSE SERIES:

  • Excel Basic 

  • Advance Excel

  • Data Visualization Through Excel

  • Data Analysis with Excel

BASIC FUNCTION

DATE FUNCTION 

SUM SET

·         Sum

·         Sum if

·         Sum ifs

COUNT SET

·         Count

·         Counta

·         Count if

·         Count ifs

·         Count blank 

ORGANIZE  DATA 

  • SORT 
  • FILTER 
  • GROUP
  • DATA VALIDATION
  • CONDITIONAL FORMATTING

 

CELL REFERENCING 

  • RELATIVE REF
  • ABSOLUTE REF
  • MIXED REF
  • 3D  REF
 
NAME MANAGER
 
DATA TRANSPOSE
 
PASTE SPECIAL 
 
FREEZE PANES 
 
HYPER LINK
 
CUSTOM LIST
 
GRAPH
  • BAR
  • COLUMN
  • PIE 
  • DONUT
  • AREA
  • LINE
 
SPARKLINE
 
TRENDLINE
 
  • LOGICAL FUNCTION
  • IF
  • AND
  • OR 
  • NESTED IF 
  • IF with MATCH
  • IF + MATCH +  DATA VALIDATION

SEARCHING TOOLS 

  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  •  INDEX
  • INDEX with MATCH

STRING MANIPULATION

  • LEN
  • LEFT
  • RIGHT
  • MID
  • CONCATENATE
  • TRIM
  • FLASHFILL

STATISTICAL FUNCTION

  • MEAN
  • MEADIAN
  • MODE
  • STD DEVIATION
  • QUARTILE ANALYSIS
  • VARIANCE
  • CORELATION

FINANCIAL FUNCTION

PIVOT TABLE 

 

 WHAT – IF ANALYSIS 

  • SCANARIO MANAGER
  • GOAL SEEK
  • DATA TABLE 
  • SOLVER

 IMPORT DATA

 EXPORT DATA 

 
 
%d