Microsoft Excel Intermediate

Course Description

This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook.

Course Objectives

Upon successful completion of this course, you will be able to leverage the power of data calculations and presentation to make informed, intelligent organizational decisions. You will work with functions and lists, create advanced formulas, protect your spreadsheets and work with custom view.

COURSE CONTENT

VIEWS

• Create Custom Views

• Hide Workbooks, Sheets and Cells

• Set File Properties.

CREATING AND MODIFYING TABLES

• Create a Table from Data

• Modify Table Format and Structure

• Use Structured References in a Table

SORT AND FILTER

• Use Basic Sort Options

• Advanced Sort Options

• Use Autofilters

• Create Custom Autofilters

• Use Advanced Filters

• Use Data Validation

• Use Database Functions

FORMULAS AND FUNCTIONS

• Understand Mathematical Operators

• Use Auto Functions

• Explore the Function Ribbon and Overview of Categories

• Use the Insert Function Wizard and Dialog Box

• Use Basic Text, Financial, Date, and Logical Functions

• Use name ranges in formulas

• Use Array Formulas

AUDITING YOUR FORMULAS AND FUNCTIONS

• Audit Formulas

• Trace and Remove Trace Arrows

• Use a Watch Window

PROTECT AND FINALIZE

• Add Protection

• Allow Edit Options within Protection

• Use the Document Inspector

• Check Compatibility and Mark as Final

• Customize Excel Options

• Create a Template

WORKING WITH MULTIPLE WORKBOOKS

• Using the Arrange all to view data

• Viewing several worksheets at the same time

• Linking data from one workbook to another

• Adding data from several sources

• Using the Consolidate tool

• Getting data from other sources (access, Text files)

ENHANCE A WORKBOOK

• Insert Symbols and Characters

• Add and Format Shapes

• Manipulate Shapes

• Use and Modify SmartArt

• Add a Signature Line

• Add and Format Text Boxes and WordArt

• Use Screenshot

• Link and Embed Objects