Microsoft Excel Intermediate
Time & Location
About the Course
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
- 4 or more Course Participants$299+$38.87 HST$299+$38.87 HST0$0
- 2 - 3 Course Participants$399+$51.87 HST$399+$51.87 HST0$0
- Course Calendar Date Pricing$299+$38.87 HST$299+$38.87 HST0$0
- 1 on 1 Training$499+$64.87 HST$499+$64.87 HST0$0