Microsoft Excel 2010/2013 Advance Training

Microsoft Excel 2010/2013


One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions. This course will also show how to record and execute simple macros. This course is designed for students who need to use Pivot Tables and more advanced functions in Microsoft® Office Excel® 2010.

Microsoft Excel is commonly used for financially-related activities. The reason for its popularity is that the user can define custom formulas for calculating quarterly, half yearly and annual reports. This spreadsheet software also helps the individuals and professionals to effectively keep a track of sales leads, project status reports, and invoice reports. Microsoft Excel is also very popular among professionals from science background as it allows them to easily work with statistical formulas and graphing.


Excel 2010/2013 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

  • understanding Pivot
  • increase productivity and improve efficiency by streamlining your workflow.
  • Understanding If Functions
  • collaborate with others using workbooks.
  • audit worksheets.
  • work with multiple workbooks.
  • import and export data.
Date Venue Early Bird
25-26thApril 2018 Training Centre: Wisma Goshen, Plaza Pantai, KL
15th April 2018
FEE PAX Early Bird After Early Bird
1 RM 475 RM 575

OR Register 1st and 2nd Person gets 20% Discount


Module 1

Getting the Most from Your Data

  • Sorting Data
  • Sorting based on a Custom List
  • Filtering Data
  • Advance Filtering
  • Filtering with Wildcard Characters

Module 2

Introduction to Pivot Tables

  • Creating A Pivot Table
  • Changing the Layout of the Pivot Table
  • Using Filters and Report Filters

Module 3

Finding Solutions & Viewing Scenarios with What If Analysis Tools

  • Finding a solution with Goal Seek
  • Viewing multiple scenarios with Data Tables
  • Finding the Optimum Solution with Solver

Module 4

Working with Logical Functions and Nesting Functions

  • AND Function , OR Function
  • IF Function
  • Nesting IF & AND
  • Nesting IF & OR, Nesting IFs

Module 5

Auditing Formulas in Worksheets

  • Tracing data in cells & Troubleshooting Errors in Formulas
  • Setting Up Watch and Evaluating Formulas

Module 6

Working With Data From Multiple Worksheets & Workbooks

  • Consolidating Data from Multiple Sources
  • Consolidating With Formulas
  • Linking Cells with other Worksheets & Workbooks
  • Repairing Broken Links

Module 7

Importing & Exporting Data

  • Importing data from Text Files
  • Exporting data from Excel