Courses

Create, Open and Save Workbooks

• What is Excel?
• Create a New Blank Workbook
• Create a Workbook from a Template
• Open Excel Files
• Get Help
• Save Workbooks
• Navigate a Workbook

Explore the User Interface

• Backstage View
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs

Work with Data

• Enter, Edit and Delete Data
• Data Selection Methods
• Use Autofill and Autocomplete
• Cut, Copy, Paste and Paste Special
• Resize Columns and Rows
• Insert and Delete Columns, Rows, Cells
• Use Undo, Redo and Repeat
• Spellcheck and AutoCorrect
• Use Find, Replace and Go To
• Use Basic Functions
• Use SmartTags and Options Buttons
• Add, Edit, and Remove Comments

Format A Workbook

• Format Using the Home Ribbon
• Format Using the Mini-Toolbar
• Format Using Dialog Boxes
• Use and Modify Conditional Formatting
• Use the Format Painter
• Create and Modify Styles
• Add, Name, Move, Delete and Color Sheets Charts
• Create and Format a Chart
• Modify Chart Layout and Structure
• Change Chart Types, Options, Location and
• Data Source
• Save a Chart as a Template

Printing and Viewing A Workbook

• Use the View Ribbon
• Split and Freeze
• Manage Multiple Windows
• Use Page Layout, Print Preview and Basic
• Print Options
• Add Headers and Footers

Customize

• Customize the Quick Access Toolbar
• Show/Hide the Ribbon

Use Tables

• Create a Table from Data
• Modify Table Format and Structure
• Use Structured References in a Table

Formulas and Functions

• Understand Mathematical Operators
• Use Auto Functions
• Use Relative and Absolute References
• Explore the Function Ribbon and Overview of Categories
• Use the Insert Function Wizard and Dialog Box
• Use Basic Text, Financial, Date, and Logical Functions
• Name and Use Ranges of Cells in Formulas
• Use Array Formulas
• Audit Formulas
• Trace and Remove Trace Arrows
• Use a Watch Window

Sort and Filter

• Use Basic Sort Options
• Advanced Sort Options

Use Auto Filters

• Create Custom Auto filters
• Use Advanced Filters
• Use Data Validation
• Use Database Functions

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

Protect and Finalize

• Add Protection
• Allow Edit Options within Protection
• Info Panel Options*
• Share Panel Options*
• Use the Document Inspector
• Check Compatibility and Mark as Final
• Customize Excel Options

Views

• Create Custom Views
• Hide Workbooks, Sheets and Cells
• Set File Properties

Enhancing Workbooks

Customize Workbooks

• Comments
• Hyperlinks
• Watermarks
• Background Pictures

Manage Themes

• About Themes
• Customizing Themes

Create and Use Templates

• Templates
• Template Types
• Creating a Template
• Modifying a Template

Protect Files

• Recovering Lost Data
• The Changes Group
• Worksheet and Workbook Protection
• The Protect Worksheet Option
• The Protect Workbook Option

Preparing a Workbook for Multiple Audiences

• Displaying Data in Multiple International Formats
• Utilize International Symbols
• Modifying Worksheets Using the Accessibility Checker
• Managing Fonts

Auditing Worksheets

Trace Cells

• The Trace Cells Feature
• Tracer Arrows
• Troubleshoot Invalid Data and Formula Errors
• Invalid Data
• The Error Checking Command
• Error Types

Watch and Evaluate Formulas

• The Watch Window
• Formula Evaluation

Create a Data List Outline

• Outlines
• The Outline Group

VLOOKUP Review

Working with Multiple Worksheets and Workbooks

Consolidate Data

• Data Consolidation
• The Consolidate Dialog Box
• Consolidation Functions

Link Cells in Different Workbooks

• External References

Merge Workbooks

• The Compare and Merge Workbooks Feature

Exporting Excel Data

Export Excel Data

• The Export Process

Import a Delimited Text File

• The Import Process
• The Get External Data Group
• Delimited Text Files
• Methods of Importing Text Files

Integrate Excel Data with the Web

• The File Publishing Process
• Publish as Web Page Dialog Box

Create a Web Query

• Web Queries
• The New Web Query Dialog Box

Analyzing Data with PivotTables, Slicers, and Pivot Charts

• Create a PivotTable
• PivotTables
• Start with Questions, End with Structure
• The Create PivotTable Dialog Box
• The PivotTable Fields Pane
• Summarize Data in a PivotTable
• The “Show Values As” Functionality of a PivotTable
• External Data
• PowerPivot
• PowerPivot Functions

Filter Data by Using Slicers

• Slicers
• The Insert Slicers Dialog Box

Analyze Data with Pivot Charts

• Pivot Charts
• Creating Pivot Charts
• Applying a Style to a PivotChart

Automating Worksheet Functionality

Update Workbook Properties

• Workbook Properties

Create and Edit a Macro

• Macros
• The Record Macro Dialog Box
• Naming Macros
• Visual Basic for Applications
• Copying Macros Between Workbooks
• Macro Security Settings

Apply Conditional Formatting

• Conditional Formatting
• Conditional Formats
• The Conditional Formatting Rules Manager Dialog Box
• The New Formatting Rule Dialog Box
• Clear Rules

Add Data Validation Criteria

• Data Validation
• The Data Validation Dialog Box

Basics

• Create, Open and Save Documents
• What is Word?
• Create a New Blank Document
• Create a Document from a Template
• Open Word Files
• Get Help
• Save Documents
• Navigate a Word Document
• Add, Select and Delete Text

Explore the User Interface

• Office Button
• Backstage View
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs

Format Text and Paragraphs

• Use the Home Ribbon to Format Font and Paragraphs
• Format with the Mini-Toolbar
• Font and Paragraph dialog boxes
• Use the Quick Style Gallery
• Use Basic Bullets and Numbering
• Add Borders and Shading
• Set Tabs and Use the Ruler

Editing

• Using Cut, Copy, Paste
• Use the Office Clipboard
• Undo/Redo
• Find, Replace and Go To
• Use the Format Painter
• Check Spelling and Grammar

Printing and Viewing Your Document

• Use the View Ribbon Commands
• Show/Hide Markings
• Use the Page Set-Up Group and Dialog Box
• Print Preview and Print Options
• Print Panel

Customize

• Customize the Quick Access Toolbar
• Show/Hide the Ribbon

Explore the User Interface

• Office Button
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs

Work with Templates

• Create a Template
• Modify a Template
• Attach a Template to a Document

Working with Styles

• Create a Style from Text
• Use the Styles Pane
• Modify and Delete Styles
• Use the Style Inspector
• Use Reveal Formatting
• Manage Styles

Bullets and Numbering

• Custom Bullets and Numbering
• Create a Multi-Level List
• Restart or Continue Numbering

Advanced Page Formatting

• Use Columns
• Insert Page Breaks, Column Breaks, Section Breaks and Line Breaks
• Set Break Options
• Create a Blank Page and a Cover Page
• Add Page Colors, Watermarks, Borders, and Horizontal Lines
• Add Headers and Footers
• Use Header and Footer Galleries
• Add a Header or Footer to the Gallery
• Link and Unlink Headers and Footers
• Use and Modify Themes

Hyperlinks

• Add Hyperlinks
• Edit Hyperlinks
• Remove Hyperlinks

Use Time Saving Tools

• Use Hyphenation and Word Count
• Use Research, Language and Translation Tools
• Use and Customize Autocorrect
• Insert the Date and Time
• Insert Symbols and Special Characters
• Work with Smart Tags

Mail Merge

• Use the Mail Merge Wizard
• Use the Mailings Ribbon
• Create Envelopes and Labels

Use Send Options

• Fax a Document
• Email a Document
• Use Email Features

Working with Graphics

• Add Pictures and Clipart
• Format and Modify Images
• Add Captions
• Add and Format WordArt
• Add and Format AutoShapes
• Add and Format Text Boxes
• Align, Distribute, Group and Order Graphics
• Add Quick Parts and Use Building Blocks
• Add and Format SmartArt

Working with Tables

• Insert a Table
• Table Selection Options
• Format a Table
• Modify Table Structure
• Draw a Table
• Use Table Options Dialog Boxes
• Convert Text to Table
• Sort a Table

Working with Data and Charts

• Use and Insert Equations
• Insert a Chart
• Format a Chart
• Modify Chart Options
• Embed and Link Excel Tables and Charts

Explore the User Interface (If Required for Upgrade Students)

• Office Button
• Backstage View
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs

Work with Forms

• Use the Developer Tab
• Create Forms
• Add and Format Form Controls
• Group Controls
• Test, Protect and Distribute Forms
• Assign Help to a Form Field
• Use Legacy Controls

Work with Webpages

• Create Webpages
• Use Legacy and ActiveX Controls on Webpages
• Save as Webpage Options

Macros

• Set Macro Security
• Record a Macro
• Assign a Macro to a Keystroke or Quick Access Toolbar
• Copy a Macro from a Template

Reviewing Documents

• Add, Edit, Navigate and Delete Comments
• Use the Review Pane
• Track and Review Changes
• Track Changes Options
• Inspect the Document
• Prepare for Sharing
• Compare and Combine Documents
• Protect Documents
• Create and Modify Outlines

Use Reference Tools

• Create a Table of Contents from Heading Styles
• Create a Table of Contents from an Outline
• Format, Modify and Update a TOC
• Add Footnotes and Endnotes
• Navigate and Edit Footnotes and Endnotes
• Use Bookmarks
• Use Cross References
• Create a Bibliography
• Manage Bibliography Sources and Choose Styles
• Add Captions and Create a Table of Figures
• Mark Entries and Create an Index
• Update and Modify an Index
• Create and Update a Table of Authorities
• Create and Use Outlines
• Drag and Drop Headings
• Create a Master Document
• Create and Work with Sub Documents

Customizing

• Customize Word Options
• Use the Info Pane
• Use the Share Pane

Getting Started with PowerPoint

• Navigate the PowerPoint Environment
• View and Navigate a Presentation
• Create and Save a PowerPoint Presentation
• Use PowerPoint Help

Developing a PowerPoint Presentation

• Select a Presentation Type
• Edit Text
• Build a Presentation

Performing Advanced Text Editing Operations

• Format Characters
• Format Paragraphs
• Format Text Boxes

Adding Graphical Elements to Your Presentation

• Insert Images
• Insert Shapes

Modifying Objects in Your Presentation

• Edit Objects
• Format Objects
• Group Objects
• Arrange Objects
• Animate Objects

Preparing to Deliver Your Presentation

• Review Your Presentation
• Apply Transitions
• Print Your Presentation
• Deliver Your Presentation

Modifying the PowerPoint Environment

• Customize the User Interface

Customizing Design Templates

• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master

Adding SmartArt and Math Equations to a Presentation

• Create SmartArt
• Modify SmartArt
• Write Math Equations

Working with Media and Animations

• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions

Collaborating on a Presentation

• Review a Presentation
• Store and Share Presentations on the Web

Customizing a Slide Show

• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation

Securing and Distributing a Presentation

• Secure a Presentation
• Broadcast a Slide Show
• Create a Video or a CD