+91 78900 06640   +91 98309 36993

Advance Excel

Advance Excel

MS Excel is the most common software used for spreadsheet. Our course aims to impart the basic and advanced techniques of Excel to acquaint users with the latest technology as well as lessen their work load.
What will you learn?
  • Predicting trend and Dsum Functions
  • Importing from internet (Web Query)
  • Data Validation (List, Error Message)
  • Using Circular Formula (Storage of Data)
  • Pivot Tables and Charts

Course Outline

Advance Excel Career courses with industry-endorsed course curricula give you the best in IT education as they have been designed by industry veterans and professionals.

Advance Excel Course Outline
  • Introduction to Excel.
  • Cell Referencing outside of the WorkBook, Subtotals, Protection of Cell, Sheet, WorkBook, Excel File.
  • Compute and Analyze data with certain Functions.
  • Extract and Compute data with certain Functions.
  • Logical, String, Financial, Information and Numeric Functions
  • Predicting trend with Statistical functions.
  • Searching Data with Lookup, Vlookup, Hlookup.
  • Manipulating Date and Time using Functions
  • Predicting trend and Dsum Functions
  • What If Functions and Data Importation
  • Pivot Tables and Charts
  • Power Query Function
  • Filtering, Sorting & Subtotalling Lists
  • Macro and Printing Excel Data

Quick Query

Adavnced Excel