Microsoft Excel 2016/365-Intermediate

Program  Objective     

This course will enable participants to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target audience for this course are participants who desire to gain the skills necessary to manage worksheets, sort and filter data, creating charts and using Functions. In addition, this course is suitable for those interested to step-up a level with existing knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets

Pre-requisites

Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 7 and above, and Microsoft Excel 2016 Basic.

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Duration: 1 Day

COURSE Outline

The topics in this course are as follows:

Managing Worksheets

• Organizing Worksheets
• Working with Multiple Worksheets
• Finding and Replacing Data

Format as Table

• Using Quick Style
• Removing Style from a Table
• Defining a Title
• Using the Total Row Command
• Removing Duplicates
• Using a Slicer to View Table Data
• Converting a Table into a Range

Using Conditional Formatting

• Apply a Specific Conditional Format
• Apply Multiple Conditional Formatting Rules
• Use the Rules Manager to Apply Conditional Formats

Data Validation

• Restrict Cell Entries to Certain Data Types
• Allow Only Specific Values to Be Entered in Cells
• Remove Duplicate Rows from a Worksheet

Sorting Data

• Sort Data on a Single Criterion
• Sort Data on Multiple Criteria
• Sort Data Using Cell Attributes

Filtering Data

• Using AutoFilter
• Creating a Custom AutoFilter
• Filtering Data Using Cell Attributes

Creating Charts

• Building Charts
• Formatting a Chart with a Quick Style
• Formatting the Parts of a Chart Manually
• Modifying a Chart
• Using New Quick Analysis Tools

Using Functions

• Displaying Dates and Times with Functions
• Summarizing Data with Functions
• Uncovering Formula Errors