Library

Course: MS Excel Advanced Level with Formulas

MS Excel Advanced Level with Formulas

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

In this course you will gain the skills to efficiently work with Excel Shortcuts, creating Management Reporting, pulling data from other files using Vlookup Function. You will also learn graphs and advanced formulas, and design simple-to-complex formulas by nesting Excel functions.

Basic knowledge
  • You should know how to work in MS Excel at basic level, like formatting, saving, opening & basic formulas
What you will learn
  • Excel Shortcuts
  • Conditional Formatting
  • Charts (Column, Line, Pie & Combination Charts)
  • Pivot Table (Basic to Advanced Level)
  • Text to Column
  • Vlookup function
  • IF Condition
  • Multiple Level of IF
  • Recording Macro
  • SumIF
  • CountIF
  • Change Case
  • Concatenate
  • Trim
  • Protection
  • etc.
Curriculum
Number of Lectures: 32
Total Duration: 02:50:18
MS Excel Advanced Level with Formulas
  • Sum and SubTotal Formula  
  • Min Max & Average Formulas  
  • Removing UnWanted Characters  
  • Trim Formula  
  • Change Case Formula  
  • Concatenate Formula  
  • CountIF in Same Sheet  
  • CountIF & SUMIF from other Sheet  
  • COUNTIFS in Same Sheet  
  • SUMIF in Same Sheet  
  • SUMIFS in Same Sheet  
  • IF Condition Formula  
  • Advanced IF Formula  
  • Linking data from multiple sheets  
  • Linking Multiple Sheets with Array Formula  
  • Vlookup Part 1  
  • Vlookup Part 2  
  • Vlookup with IFError Part 3  
  • Vlookup with IFError Part 4  
  • Left Right Formula  
  • Left with Find Formula  
  • Mid Formula  
  • Today and Now Formula  
  • Round RoundDown RoundUp  
  • Text Formula  
  • Len Formula  
  • Substitute Formula  
  • Networkdays Formula  
  • Networkdays Intl Formula  
  • IF Condition with AND & OR  
  • Index and Match Formula  
  • Practice Files Formulas  
Reviews (0)