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: 2 Days

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

Key Features

Click Here to Register

  • 100% payable using SkillsFuture Credit
  • Step-By-Step Course
  • 100% Satisfactory Record
  • Trained more than 10000 Participants
  • 20 Year Experienced Trainer
  • ACTA & Microsoft Certified Trainer
  • One Time Free Refresh Class within 6 Month
Skillsfuture Advanced Excel Course Singapore

What will you learn in the Advanced Excel Training?

By the end of the course, you will be able to:
Click Here to Register

  • Advanced Excel Functions and Formulas
  • How to use PivotTables and Pivot Charts
  • Lookups and Data Tables Functions
  • How to Exporting and Importing Data
  • Advanced Data Management using Excel
  • How to use advanced Analytical Tools in Excel
  • Advanced Charting Methods in excel
  • Macros and Visual Basic
  • Accessibility and Language Features

Who should take up the Microsoft Advanced Excel Course?

  • Business owners and entrepreneurs who wish to have a better understanding of their Business performance.
  • Aspiring entrepreneurs who would like to start their own business
  • Working professionals who are looking to boost his career in IT Fields.

Prerequisites

  • Basic computer Skills and knowledge

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