excel_training_courses_singapore_logo

Excel 2016 - Level Series

In this course, participants will use Microsoft Office Excel 2016 which they can upskill and develop upon to become an expert in creating and managing data.

Share on facebook
Share on twitter
Share on linkedin

Overview

Excel 2016 – Level 1
In this course, participants will use Microsoft Office Excel 2016 which they can upskill and develop upon to become an expert in creating and managing data.

Excel 2016 – Level 2
In this course, participants who already have the foundational knowledge and skills in Excel 2016 will expedite further by learning some of the higher-level functionality to analyze and present data.

Excel 2016 – Level 3
Participants enrolling in this class should have experienced working on Excel 2016 which includes creating, managing, and collaborating workbooks and data.

Prerequisites

Excel 2016 – Level 1

To succeed in this course, participants should have the basic Windows operating skills including understanding the basic usage of a mouse and keyboard; able to navigate and store information; and being able to manage files and programs on the computer.

Excel 2016 – Level 2

  • Excel 2016 – Level 1

Excel 2016 – Level 3

Participants enrolling in this class should have experienced in working on Excel 2016 which includes creating, managing and collaborating workbooks and data.

  • Excel 2016 – Level 1
  • Excel 2016 – Level 2

Course Outline Level 1

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
  • Insert, Delete, and Adjust Cells, Columns, Rows
  • Search for and Replace Data
  • Using Proofing and Research Tools
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and User Templates
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Course Outline Level 2

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
  • Create a Pivot Table
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Course Outline Level 3

  • Use Linked and External References
  • Use 3-D References
  • Consolidate Data
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Apply Data Validation
  • Search for Invalid Data for Formulas with Errors
  • Work with Macros
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Open chat