Advance Excel Training

Course Start Date

Microsoft Excel 2013 Training

Advanced Microsoft Excel Training Course

Advanced Excel Course includes all Features, Functions and Formulas of Microsoft Excel. This Advanced Excel Training help participants to
learn Pivot Table, VLookup, Hlook up, Filtering Data using Functions, Exporting and importing data, Basic Macros and many more tricks in Microsoft Excel.
This is a hands-on Advanced excel training where you will be working on live exercises of each topic.

Duration: 3 Days

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

Claim $500 from Skillsfuture Credit!!!

Microsoft Excel 2013 Training Advanced Microsoft Excel Course Outlines

Advanced Excel functions and formulas

  • Logical functions
  • Conditional functions
  • Financial functions
  • Text functions
  • Date functions
  • Array formulas

PivotTables and PivotCharts

  • Working with Pivot Tables
  • Rearranging Pivot Tables
  • Formatting Pivot Tables
  • PivotCharts

Lookups and data tables

  • Using lookup functions
  • Using MATCH and INDEX
  • Creating data tables

Exporting and importing data

  • Exporting and importing text files
  • Getting external data

Advanced data management

  • Validating cell entries
  • Advanced filtering

Analytical tools

  • Goal Seek
  • Scenarios

Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphical objects

Macros and Visual Basic

  • Running and recording a macro
  • Working with VBA code

Accessibility and language features

  • Accessibility consideration
  • Internationalization

Our Clients