Got a question? Call +632 8244 2098   |   
Contact usCheckoutContact us
Microsoft Excel 2016 – Part 3

Microsoft Excel 2016 – Part 3

  • Length 1 day
Course overview
View dates &
book now
  • Register interest

Why study this course

This course is intended to help all users get up to speed on the different aspects of Microsoft Excel, including some of its more advanced features.

We will cover how to automate worksheet functionality, audit worksheets, analyse data, work with multiple workbooks, export Excel data, as well as import and export XML data.

This version of Microsoft Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

At the completion of this course you should be able to:

  • Automate worksheet functionality

  • Audit worksheets

  • Use a variety of different analysis tools

  • Work effectively with multiple workbooks

  • Export Excel data

  • Import and export XML data to and from a workbook

  • Create Excel forms

Microsoft Office Applications at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.

View all Microsoft Office Applications courses

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Get in touch today
Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

This course is designed for users of Microsoft Excel who need to use some of the more advanced features of Microsoft Excel 2016.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us via email on ph.training@ddls.com.ph

.

Course subjects

Lesson 1: Automating Worksheet Functionality

TOPIC A: Update Workbook Properties

  • Workbook Properties

TOPIC B: Create and Edit Macro

  • Macros

  • The Record Macro Dialog Box

  • Naming Macros

  • Visual Basic for Applications

  • Copying Macros Between Workbooks

  • Macro Security Settings

TOPIC C: Apply Conditional Formatting

  • Conditional Formatting

  • Conditional Formats

  • The Conditional Formatting Rules Manager Dialog Box

  • The New Formatting Rule Dialog Box

  • Clear Rules

TOPIC D: Add Data Validation Criteria

  • Data Validation

  • The Data Validation Dialog Box

  • Summary

  • Review Questions

Lesson 2: Auditing Worksheets

TOPIC A: Trace Cells

  • The Trace Cells Feature

  • Tracer Arrows

TOPIC B: Troubleshoot Invalid Data and Formula Errors

  • Invalid Data

  • The Error Checking Command

  • Error Types

TOPIC C: Watch and Evaluate Formulas

  • The Watch Window

  • Formula Evaluation

TOPIC D: Create a Data List Outline

  • Outlines

  • The Outline Group

Lesson 3: Analysing and Presenting Data

TOPIC A: Create Sparklines

  • Sparklines

  • Types of Sparklines

  • The Sparkline Tools – Design Tab

TOPIC B: Create Scenarios

  • Scenarios

  • The What-If Analysis Tools

  • The Scenario Manager Dialog Box

TOPIC C: Perform a What-If Analysis

  • Add-In Types

  • Goal Seek Feature

  • The Solver Tool

TOPIC D: Perform a Statistical Analysis with the Analysis ToolPak

  • Analysis ToolPak

  • The Data Analysis Dialog Box

TOPIC E: Create Interactive Data with Power View

  • The Power View Add-In

  • Enabling Power View

  • Creating a Power View

Lesson 4: Working with Multiple Workbooks

TOPIC A: Consolidate Data

  • Data Consolidation

  • The Consolidate Dialog Box

  • Consolidation Functions

TOPIC B: Link Cells in Different Workbooks

  • External References

TOPIC C: Merge Workbooks

  • The Compare and Merge Workbooks Feature

Lesson 5: Exporting Excel Data

TOPIC A: Export Excel Data

  • The Export Process

TOPIC B: Import a Delimited Text File

  • The Import Process

  • The Get External Data Group

  • Delimited Text Files

  • Methods of Importing Text Files

TOPIC C: Integrate Excel Data with the Web

  • The File Publishing Process

  • Publish as Web Page Dialog Box

TOPIC D: Create a Web Query

  • Web Queries

  • The New Web Query Dialog Box

Lesson 6: Importing and Exporting XML Data

TOPIC A: Import and Export XML Data

  • XML

  • XML Components

  • XML Schemas

  • XML Maps

  • The XML Source Task Pane

  • Import and Export XML Data

Prerequisites

This manual assumes the user has completed or has an understanding of the materials covered in the second part of the Microsoft Excel 2016 course, including:

  • Creating advanced formulas

  • Analysing data with logical and lookup functions

  • Organising worksheet data with tables

  • Visualising data with charts

  • Analysing data with PivotTables, slicers, and PivotCharts

  • Inserting graphics

  • Enhancing workbooks

Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

Looking for more course options?

View all Microsoft Office Applications coursesView all End User Applications coursesView all Business Applications courses