Microsoft Excel 2013 Advanced



Upon completion of this program, participants should be able to:

  • Create Subtotal Using The Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function


Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to perform IF Functions
  • Able to perform NESTED Functions
  • Able To define And use Range Names
  • Able To use Auto And Advanced Filter

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.


This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise


    • Lesson 1.1: Outlining and Grouping Data
      • Using Automatic Outlining
      • Displaying and Collapsing Levels
      • Grouping Data Manually
      • Creating Subtotals
    • Lesson 2.1: Getting Started with PivotTables
      • What is a PivotTable?
      • Recommended PivotTables
      • Creating a PivotTable
      • Using the PivotTable Tools Tabs
      • Adding and Removing Data with the Field List
      • Changing the Field List Layout
      • Pivoting Data
    • Lesson 2.2: Working with PivotTable Data
      • Expanding and Collapsing Data
      • Filtering Data
      • Sorting Data
      • Grouping Data
      • Refreshing Data
      • Editing the Data Source
    • Lesson 2.3: Formatting a PivotTable
      • Modifying Fields and Labels
      • Modifying Values
      • Using the Layout Group on the Design Tab
      • Applying a Style to a PivotTable
      • Changing PivotTable Style Options
      • Manually Formatting a PivotTable
      • Using the PivotTable Options Dialog
    • Lesson 2.4: Advanced PivotTable Tasks
      • Use Slicer with Pivot Tables
      • Slicer Tools Tab
      • Timeline to show Data for Different Time Periods
    • Lesson 3.1: Getting Started with PivotCharts
      • Creating a PivotChart from Existing Data
      • Adding Data to your Chart
      • Pivoting Data
      • Using the Analyze Tab
    • Lesson 4.1: Using Data Analysis Tools
      • Using a One or Two Input Data Table
      • Using Goal Seek
    • Lesson 4.2: Exploring Scenarios
      • What is a Scenario?
      • Creating a Scenario
      • Saving Multiple Scenarios
      • Creating a Scenario Summary Report
    • Lesson 4.3: Using Solver
      • Understanding Solver
      • Generating Reports and Scenarios with Solver
      • Changing Solver Values
      • Managing Solver Constraints
      • Using Solver as a Goal Seek Tool
    • Lesson 5.1: Working with Array Formulas
      • What are Array Formulas?
      • Defining Basic Array Formulas
      • Using Functions within Array Formulas
      • Using the IF Function in Array Formulas
      • Using IFERROR with Array Formulas
    • Lesson 5.2: Using the VLOOKUP Function
      • Understanding VLOOKUP and HLOOKUP
      • Using VLOOKUP to Find Data
      • How to Find an Exact Match with VLOOKUP
      • Finding an Approximate Match with VLOOKUP
      • Using VLOOKUP as an Array Formula
      • Lesson 5.3: Using the Advanced Function
      • Using the INDEX Function
      • Using the MATCH Function
      • Combining the MATCH and INDEX functions
      • Logical Functions AND/OR
      • Using Nested Logical Functions (IF (OR…, AND))
    • Lesson 5.4: Linking, Consolidating, and Combining Data
      • Linking Workbooks
      • Consolidating Workbooks
      • Combining Worksheets
    • Lesson 5.5: Excel and Hyperlinks
      • What is a Hyperlink?
      • Inserting Hyperlinks
      • Editing Hyperlinks
      • Formatting Hyperlinks
      • Using Hyperlinks in Excel
    • Lesson 5.6: Creating and Using Shared Workbooks
      • Sharing a Workbook
      • Opening and Editing a Shared Workbook
      • Tracking Changes
      • Resolving Conflicts in a Shared Workbook

Fee: RM 850 per pax

Loyalty Points: 850 Points

Duration: 2 Days

Note: In-house course is available. Request it HERE


Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.