Improving Productivity with Excel

Course Length

3 hours

Course Objective

Become more efficient in your daily use of Microsoft Excel

Target Student

This class is for Excel users who are comfortable with the basics and want to learn shortcuts to become more productive, for those who havenít taken a training class recently (or ever) and to learn Excelís new features.

Prerequisites

Students should be comfortable with saving, opening, closing and basic editing and math.

Delivery Model

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

Course Outline

Daily Use Shortcuts
Modify the Quick Access Toolbar
Freeze Panes
Shortcuts for writing & copying functions
Autofill
Page Layout View
Changing Defaults
Autocorrect
Custom Lists
Moving around and selecting data
Recent Documents & Recent Folders
Formatting Efficiency
Repeat Key
Advanced Value Formatting
Format Painter
Styles
Excel Templates
Using Excel with Other Programs
Insert and link an excel worksheet into Word & PowerPoint
Emailing Excel attachments
Creating PDFs
Moving & Copying Tricks
Move and copy cells with drag and drop
Using paste options
Collect and paste multiple items

Also Includes

  • Courseware book for each student.
  • Certificate of completion.