Microsoft Excel 2016

Apply now for our Microsoft Excel 2016 Course



  • Get started with Excel 2016
  • Insert lesson titles in a bulleted list.
  • Features New in 2016
  • Advanced Formulas
  • Visualizing Your Data


Course Details


Instructor Led Learning


  Duration: 3 Days

  Registration Open Now!

Online Learning


  Duration: 365 Days

  Registration Open Now!

Call us : 0861 111 460

Microsoft Excel Course overview

Part 1:
In this Introduction to Microsoft Excel 2016 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Part 2:
This Intermediate Microsoft Excel 2016 training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles

Part 3:
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.





 Microsoft Excel training course cape town

Is this course for you?

Microsoft Excel 2016 is the standard spreadsheet application for both business and personal use. Microsoft Excel 2016 features graphing tools, calculations, pivot tables and more. Whether you’re new or already an advanced user, MasterGrade IT’s Excel courses for Microsoft Excel 2016 will teach you all you need to know – from basic to advanced features – to become an excel power user.

From formatting to design, this short Excel training course will allow you to create a range of documents for use in both the business and personal realm.


Available Microsoft Excel Exams and Certification Paths

Start off with Microsoft Excel exams: Other Microsoft Office Course:

Job Opportunities

Job Title:Office Administrator

Responsibilities:
The Microsoft Excel will you build a spreedsheets that helps your business. You will be responsible for the working on spreedsheets for business equipment, such as status and business maintains. Responsibility for staff login.

3 Steps to Master Microsoft Excel

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Microsoft Excel 2016 Training Course

  • Lesson 1:Microsoft Excel Part 1:
  • Lesson 2:Microsoft Excel Part 2:
  • Lesson 3:Microsoft Excel Part 3:

Full course outline
Microsoft Excel 2016 Training Course

Microsoft Excel 2016 Part 1

Lesson 1: Creating a Microsoft Excel Workbook

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window

Lesson 2: The Ribbon

  • The Ribbon
  • Tabs
  • Groups
  • Commands

Lesson 3: The Backstage View (The File Menu)

  • Introduction to the Backstage View
  • Opening a Document
  • New Documents and Word Templates
  • Configuring Documents to Print
  • Adding Your Name to Microsoft Word
  • Adding Values to Document Properties
  • Working with Autosaved Versions of Documents

Lesson 4: The Quick Access Toolbar

  • Adding Common Commands
  • Adding Additional Commands wtih the Customize Dialog Box
  • Adding Ribbon Commands and Groups

Lesson 5: Entering Data in Microsoft Excel Worksheets

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Define the Page Layout
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Lesson 6: Formatting Microsoft Excel Worksheets

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Lesson 7: Using Formulas in Microsoft Excel

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Lesson 8: Working with Rows and Columns

  • Insert lesson titles in a bulleted list.
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Lesson 9: Editing Worksheets

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Lesson 10: Finalizing Microsoft Excel Worksheets

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Lesson 11: Microsoft Excel Features that Were New in 2013

  • One Workbook Per Window Feature
  • Using Flash Fill

Lesson 12: Features New in 2016

  • Tell Me
  • Smart Lookup

Microsoft Excel 2016 Part 2

Lesson 1: Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

Lesson 2: Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Lesson 3: Working with Illustrations

  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

Lesson 4: Visualizing Your Data

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template

Lesson 5: Working with Tables

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

Lesson 6: Advanced Formatting

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Lesson 7: Microsoft Excel Features that Were New in 2013

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

Lesson 8: Features New in 2016

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

Microsoft Excel 2016 Part 3

Lesson 1: Using Pivot Tables

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • CMore Pivot Table Functionality

Lesson 2: Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Lesson 3: Data Tools

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Lesson 4: Working with Others

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Lesson 5: Recording and Using Macros

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Lesson 6: Random Useful Items

  • Sparkline
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files

Lesson 7: Microsoft Excel Features that Were New in 2013

  • Using Slicers to Filter Data
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Lesson 8: Features New in 2016

  • PivotTable Updates
  • Ink Equations
  • Multi-Select Option in Slicers
  • Quick Shape Formatting
  • Sharing with SharePoint or OneDrive

Do you want to create sales dashboards using Microsoft Excel?