Course Content


Advance Excel

  • Introduction to M.S. Excel 2016
  • Excel Worksheet & Workbooks
  • Entering & Editing worksheet data
  • Cell range operations
  • Introducing Formulas & Functions
  • Creating Formulas
  • Use Format cells
  • Data Sorting/ Custom Sorting in multiple columns
  • Data Filter/ Advance Filter
  • Insert/ Delete Row, Column, Sheet, Cells
  • Hide/Unhide Row, Column, Sheet, Cells
  • Protect sheet & Formulas
  • Apply Custom and prebuilt conditional formatting
  • Using Number/alpha/date series
  • Flash Fill Series
  • Text to columns
  • Whatif analysis
  • Use Goal Seek
  • Data table using PMT Function
  • Data validation
  • Create and use data validation rules
  • Create and manage scenarios
  • Remove duplicate data
  • Use Outlining in Excel
  • Totals and Subtotals Total
  • Working with Functions
  • Working with Text e.g. upper, lower, proper, trim, concatenate, replace, left/right Functions etc.
  • Working with Mathematical Function e.g., Mod, Quotation, Sqrt, power, round fun. , small, large, median functions etc.
  • Logical Function such as IF, And , OR, Array etc.
  • Working with Banking Function Such as PMT, FV, PV, RATE, IRR Etc.
  • Working with lookup, vlookup, hlookup, Index functions.
  • Create & use macros
  • Create Macros Buttons in Upper, Lower functions.
  • Introduction to Chart
  • Create a simple Graph/Chart
  • Create a pivot table & Pivot Chart
  • Practical Assignment & Practical Notes

Send Quick Enquiry

Course Details

Hours: 15 Hours

Intermediate

Course Fee: 2000

Course Features

2 Free Demo Classes

Free Course Material

Completion Certificate

Lifetime Membership

What Student Says