MICROSOFT EXCEL - ADVANCED

Previous 3 / 9 Next


Microsoft Excel - Advanced

Course Duration: 2 Days

Audience:

This course is suitable for participants who are working with nested formulas, performs what if analysis, consolidating data and creates Pivot Table to have in depth understanding of how electronic spreadsheet works.

Prerequisites:

  • Have attended Microsoft Excel Foundation & Intermediate level
  • Able to switch between task applications
  • Able to create simple to complex formulas & functions
  • Able to validate data in a Worksheet
  • Able to filter data using Auto & Advanced Filters
  • Able to clean duplicate records

Benefits:

  • Create subtotal using the Subtotal Function
  • Analyze data using Pivot Tables
  • Perform What If Analysis
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & consolidating data
  • Record and run a Macro

Course Outlines:

Module 1: Getting the Most from Your Data

  • Outlining and Grouping Data

Module 2: What If Analysis

  • Using Data Analysis Tools
  • Exploring Scenarios
  • Using Solver

Module 3: Advanced Excel Task

  • Working with Array Formulas
  • Using VLOOKUP Function
  • Using the Advanced Function
  • Linking, Consolidating and Combining Data

Module 4: Advanced Chart

  • Create Advanced Chart

Module 5: Analyzing Data with PivotTable, Slicer and PivotCharts

  • Creating a PivotTable
  • Filter Data by Using Slicers
  • Analyzing Data with PivotChart

Module 6: Enhancing Workbooks

  • Customizing Workbooks

Module 7: Macros and Form Controls

  • Macros
  • Form Controls

Module 8: Publishing & Protections

  • Finishing Workbook
  • Protecting Worksheet and Workbook

Please leave your enquiry here, we will reply as soon as possible.
Name*  
Company Name  
Product Interested  
Quantity  
Email*  
Contact No.*  
Messages*  
   

Switch to Mobile Version
available in
Subscribe Newsletter