Call Me
Excel Basics

 

 

 

 

 

 

 

 

 


  Introduction to Excel

  • Overview
  • Home Tab
  • Conditional Formatting
  • Paste special
  • Go to special

 

 
 

 

 

 

 

 

 

 


  Data Tab

  • Overview
  • Simple sort and filter
  • Advanced Sort and Filter
  • What if Analysis
  • Data Validation

 

 
 

 

 

 

 

 

 

 


  Functions

  • Text Functions like CONCATENATE, TRIM, SEARCH, SUBSTITUTE
  • Logical Functions like IF, AND, OR
  • Lookup Functions like VLOOKUP, HLOOKUP, REFERENCE, INDEX,MATCH
  • Advanced Functions like DCOUNT, DSUM

 

 
 

 

 

 

 

 

 


  Dynamic Charts Charts
  & Pivot Tables

  • Overview
  • Create charts & Using Dynamic charts
  • Connecting to Form Controls
  • Simple Pivot Tables & Functions in Pivot Tables
  • Integrating Charts with Tables