Advance Excel 2013

Course Start Date

Advanced Microsoft Excel 2013 Training

Advanced Excel 2013 Course includes all Features, Functions and Formulas of Microsoft Excel 2013. 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!!!

Other Microsoft Excel Courses

Advanced Excel 2013 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