Now a days, many jobs require advanced Excel skills. Naturally, you are interested to know what are these Advanced Excel Skills?

Microsoft Excel is Advance excel training entrance excel user’s ability in data analysis summary, pivot data consolidation power query, workbook sharing etc.The skills and knowledge acquire in Microsoft excel 2016 are sufficient to be able to perform data filleting data form, working with external data as well as customizing news. It improves the productivity or efficiency at work it manipulates amount of data with minimal requirement of time.

Advance Excel

  • Live Demonstration
  •  Internship/Career Opportunities from Ignite and its associates.
  •  Hands on Practice Sessions
  •  24*7 Email Supports through Email.
Course Contents: 1) Data filters:            
  • AutoFilter and advanced filters
  • Sorting, customize sorting
  • Subtotals.
 2) Cell level validations
  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell
  • Using data tables for data analysis
3) Mastering PivotTables
  • Using external data sources
  • Multiple consolidation ranges
  • Customizing PivotTable layou
  • PivotTable advanced options
  • Pivot Charts
4) Working with external data
  •             Querying external databases
  •             Saving, editing and reusing external data queries
  •             Web queries
  •             Importing text files in Excel
  •             Refreshing data
 5) Using data forms for managing tabular data
  •             Specifying criteria for a form
  •             Searching with a form
 6) Workbook sharing
  •             Tracking changes
  •             Merging workbooks
  •             Workbook and sheet protection
 7) Online collaboration
  •             Scheduling meetings and web discussions
  •             Goal Seek
  •             Scenario Manager
  •             Creating and editing scenarios
  •             Merging scenarios
 8) Auditing
  •             Tracing precedents and dependents
  •             Tracing errors
 9) Managing add-ins
  •             Customizing toolbars and menus
 10) Customizing views
  •             Customizing calculations and iterations
  •             Settings
  •             Creating custom lists
 11) Conditional formatting of cells
  •             Creating, managing and merging styles for cell formatting.
 12) Working with functions
  •             Financial functions
  •             Date and time functions
  •             Statistical functions
  •             Lookup and reference functions
  •             Database functions
  •             Text manipulation functions
  •             Logical functions
  •             Worksheet and cell information functions
 13) MS Excel - Macros topics
  •             Recording and running macros
  •             Types of references in macros
  •             Assigning a macro to a toolbar or menu