Microsoft Excel 2013 Advanced

Purchase this product now and earn 600 Points!
0 out of 5 based on 0 customer ratings

 Microsoft-Excel-2013-Advanced-HRDF-Trainings

Objective

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:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Record and Run a Macro

Prerequisites

REQUIRED PREREQUISITES:

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 create simple to complex formulas and functions, like:
  • COUNTA, COUNTIF & COUNTIFS Function
  • AVERAGEA, AVERAGEIF & AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Database Function
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

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.

Methodology

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

Module

  • OUTLINING AND GROUPING DATA
    • Using Automatic Outlining
    • Displaying and Collapsing Levels
    • Grouping Data Manually
    • Creating Subtotals
  • WHAT IF ANALYSIS?
    • Lesson 2.1: Exploring Scenarios
      • What is a Scenario?
      • Creating a Scenario
      • Saving Multiple Scenarios
      • Creating a Scenario Summary Report
  • PIVOTING DATA
    • Lesson 3.1: Getting Started with PivotTables
      • What is a PivotTable?
      • Creating a PivotTable
      • Using the PivotTable Tools Tabs
      • Adding and Removing Data with the Field List
      • Changing the Field List Layout
      • Pivoting Data
    • Lesson 3.2: Working with PivotTable Data
      • Expanding and Collapsing Data
      • Filtering Data
      • Sorting Data
      • Grouping Data
      • Refreshing Data
      • Editing the Data Source
    • Lesson 3.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
  • CHARTING PIVOTED DATA
    • Lesson 4.1: Getting Started with PivotCharts
      • Creating a PivotChart from Existing Data
      • Adding Data to your Chart
      • Pivoting Data
      • Using the Analyze Tab
  • ADVANCED EXCEL TASK
    • Lesson 5.1: 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
    • Lesson 5.2: Using the Advanced Function
      • Using the INDEX Function
      • Using the MATCH Function
      • Combining the MATCH and INDEX functions

RM1,300.00 RM850.00

Qty:
Request For In-House
If you purchase this product you will earn 850 Points!

Fee: RM 850 per pax


Loyalty Points: 850 Points


Duration: 1 Day


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

 Microsoft-Excel-2013-Advanced-HRDF-Trainings

Objective

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:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Record and Run a Macro

Prerequisites

REQUIRED PREREQUISITES:

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 create simple to complex formulas and functions, like:
  • COUNTA, COUNTIF & COUNTIFS Function
  • AVERAGEA, AVERAGEIF & AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Database Function
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

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.

Methodology

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

Module

  • OUTLINING AND GROUPING DATA
    • Using Automatic Outlining
    • Displaying and Collapsing Levels
    • Grouping Data Manually
    • Creating Subtotals
  • WHAT IF ANALYSIS?
    • Lesson 2.1: Exploring Scenarios
      • What is a Scenario?
      • Creating a Scenario
      • Saving Multiple Scenarios
      • Creating a Scenario Summary Report
  • PIVOTING DATA
    • Lesson 3.1: Getting Started with PivotTables
      • What is a PivotTable?
      • Creating a PivotTable
      • Using the PivotTable Tools Tabs
      • Adding and Removing Data with the Field List
      • Changing the Field List Layout
      • Pivoting Data
    • Lesson 3.2: Working with PivotTable Data
      • Expanding and Collapsing Data
      • Filtering Data
      • Sorting Data
      • Grouping Data
      • Refreshing Data
      • Editing the Data Source
    • Lesson 3.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
  • CHARTING PIVOTED DATA
    • Lesson 4.1: Getting Started with PivotCharts
      • Creating a PivotChart from Existing Data
      • Adding Data to your Chart
      • Pivoting Data
      • Using the Analyze Tab
  • ADVANCED EXCEL TASK
    • Lesson 5.1: 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
    • Lesson 5.2: Using the Advanced Function
      • Using the INDEX Function
      • Using the MATCH Function
      • Combining the MATCH and INDEX functions

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel 2013 Advanced”

You're reviewing: Microsoft Excel 2013 Advanced . How do you rate this product? *

Jarina Muhamad Ismail
Biodata: 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.

Redemption Products

Pin It on Pinterest