Advance Excel Course

advance excel course

Advance Excel Course | MCS

Advanced excel Course offered by MCS (Make Career Solutions) mainly focus on the practical aspect of Microsoft excel. Many of us know its basic working and it is used almost in every business.

However there is special demand from working class to learn advanced excel techniques, which help them to solve the complex problem faced during preparation of various MIS reports in their office.

Benefits of the course:

  • Improving Your Efficiency and Productivity
  • Making Yourself a More Valuable Member of the Company
  • It Can Make Your Job Easier
Enquiry Now

Course Curriculum

  • Advance Application
  • Number Formatting
  • Advance Conditional Formatting
  • Power View, Power Map, Power Query, Power Pivot
  • Match & Index, Financial Functions, Array Formulas
  • ASAP Utilities, Mail Merge through Google Drive, Dashboard
  • Spreadsheet basics
  • Creating, Editing, Saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data: Charts & Graphs
  • Analysing data: Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets, Securing & Protecting spreadsheets
  • Formulas & Macros Formulas in Advanced Excel Course
  • What-if-analysis
  • Data Tables
  • Scenario Manager
  • Goal Seek
  • Reporting
  • Character Functions
  • Date Functions & Age Calculations
  • Consolidation of Data
  • Data Validation
  • Pivot Tables is part of Advanced Excel Course
  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Sparkline’s, Inline Charts,
  • Data Charts
  • Create charts, enhance charts, Drawing toolbar features
  • Use multiple windows Copy/ paste between Worksheets
  • Link worksheets, Consolidate worksheets

Download Brochure

Advance Excel Course

advanced exce in delhil advance excel course in delhi advance excel learnin in delhig
advanced excel course fees in delhi advanced excel course online in delhi advance excel classes near me in delhi
advanced excel training in delhi advanced excel course near me in delhi advance excel fees in delhi
advanced ms excel in delhi advanced excel course online with certificate in delhi advanced excel certification in delhi
ms excel advanced course in delhi advance excel in hindi in delhi advanced excel skills in delhi
complete excel course in delhi advanced excel training online in delhi advanced microsoft excel in delhi
mis excel course in delhi advanced excel course with certification in delhi microsoft excel advanced course in delhi
advanced excel essentials in delhi advanced excel skills for data analysis in delhi advanced spreadsheet skills in delhi
in delhi