Introduction
Elements of this syllabus are subject to change.
This in-depth one-day instructor-led course provides students with the knowledge of using shortcuts in your daily work as well as expands your Microsoft Excel knowledge. The workshop will empower you to have answers to Excel questions at your fingertips. There are numerous new tips you will learn regardless of the Excel versions you or your students use. Be it Excel 2002 or 2003, you will be armed with the knowledge to provide a nifty solution. This course will serve as a refresher as well as a reference. The course is for users at all levels, from beginners through intermediate and advanced.
Audience
Information workers who want to take advantage of Microsoft Excel shortcuts capabilities and time saving tools.
At Course Completion
After completing this course, students will be able to:
Organize standard data tables using shortcuts.
Create custom data tables with shortcuts.
Identify applicable shortcuts to optimize data.
Execute shortcuts to edit, merge, apply and create spreadsheets.
Use Excel shortcuts to expand, create and modify data features.
Prerequisites
Before attending this course, students must have:
An intermediate user of Microsoft Excel 2002 or 2000 for at least 1 year.
:: Course 50100A ::
Module 1: EXCEL SHORTCUTS
This module explains how to use various shortcut keys available in Microsoft Excel.
Lessons
Excel Shortcuts
Lesson Practice 1
No practice exercises for module 1.
After completing this module, students will be able to:
Use shortcuts available to perform various task in Microsoft Excel
Module 2: PERFORM QUICK CALCULATIONS
This module explains how to use various techniques to perform calculation quickly.
Lessons
Use AutoCalculate
Add a Calculator to the Toolbar
Use Range Borders to Modify Formulas
Enter Formulas in Multiple Cells
Review 2
Lesson Practice 2
Perform calculations using shortcuts.
After completing this module, students will be able to:
Use AutoCalculate to check on calculation results
Add a link to Windows calculator
Modify formula ranges quickly
Module 3: COPY AND MOVE DATA
This module explains how to use tips and tricks in copying and moving data in Microsoft Excel.
Lessons
Use Paste Options Button
Use Paste List to Transpose Data
Copy and Link Data
Use Clipboard Task Pane
Review 3
Lesson Practice 3
Use copy and move data shortcuts.
After completing this module, students will be able to:
Use Paste Options, Paste Link and the Clipboard task pane.
:: Course 50100A ::
Module 4: AUTOFILL AND FILL OPTIONS
This module explains how to use AutoFill and fill options to quickly fill ranges with data.
Lessons
AutoFill Data
Use Fill Options To Create a Weekday List
Create Custom List
Review 4
Lesson Practice 4
Practice AutoFill and Fill options shortcuts
After completing this module, students will be able to:
Use Fill options and create custom AutoFill list
Module 5: APPLY AUTOMATIC FORMATTING AND STYLES
This module explains how to save time formatting using AutoFormat feature and using styles.
Lessons
Apply an AutoFormat
Change AutoFormat Options
Extend Data Range Formats and Formulas
Create a Style By Example
Apply a Style
Create a New Style
Merge Styles
Review 5
Lesson Practice 5
Apply shortcuts to alter formats and styles
After completing this module, students will be able to:
Save time formatting using the AutoFormat and styles feature in Microsoft Excel.
Module 6: WORKING WITH LABELS AND NAMES
This module explains how to use range name and labels instead of cell address in formulas.
Lessons
Use Natural Language
Use Names as Constants
Display a Constant and Its Value
Create Range Name
Use Names in Formulas
Create Worksheet Level Range Name
Use Labels
:: Course 50100A ::
Use Labels in Formulas
Use Labels to Refer to Individual Cells
Use Multiple Stacked Headings
Review 6
Lesson Practice 6
Apply shortcuts work with Labels and names.
After completing this module, students will be able to:
Create and use range name in formulas
Use labels in formulas
Module 7: CREATING 3D FORMULAS
This module explains how to create 3D formulas to simplify calculation between worksheets.
Lessons
Work with 3D Range
Apply Formatting to 3D Range
Use 3D Ranges in Functions
Create a 3D Range Name
Use 3D Range Name In Formula
Review 7
Lesson Practice 7
Use shortcuts to create 3D formulas.
After completing this module, students will be able to:
Use 3D range in formulas.
Module 8: CONSOLIDATING DATA
This module explains how to use data consolidate feature in Microsoft Excel.
Lessons
Consolidate Data
Consolidate Data By Position
Consolidate Data By Category
Consolidate Data From Multiple Workbooks
Review 8
Lesson Practice 8
Use shortcuts to combine data from multiple worksheets into one worksheet.
After completing this module, students will be able to:
Consolidate data by position and category
Consolidate data from multiple workbooks
:: Course 50100A ::
Module 9: ANALYSE DATA WITH DATA TABLES
This module explains how to use data tables to manage calculation in one variable and two variable data table.
Lessons
Use Data Tables
Create a One-Variable Table
Extend Formula in a Table
Create a Two-Variables Table
Editing a Data Table
Review 9
Lesson Practice 9
Use shortcuts to create one- and two-variable tables.
After completing this module, students will be able to:
Create calculation based on one-variable and two-variable data table
Module 10: WORKING WITH OUTLINES
This module explains how to use outlining feature in Microsoft Excel to quickly summarize tables.
Lessons
Use Outlines Effectively
Create An Auto Outline
Collapse and Expand an Outline
Create Outline by Grouping Data
Modify Outline Settings
Clear an Outline
Review 10
Lesson Practice 10
Use Auto Outline and modify outlines using shortcuts.
After completing this module, students will be able to:
Use outline feature to collapse and expend rows and columns
:: Course 50100A ::
Module 11: WORKING WITH VIEWS AND MULTIPLE WORKBOOKS
This module explains how to create customized views to display different perspective of the current worksheet.
This module also shows how to create workspace file.
Lessons
Use Views
Create A Normal View
Create a Custom View
Display a Custom View
Delete a Custom View
Save a Workspace File
Open a Workspace File
Review 11
Lesson Practice 11
Use shortcuts to increase workbook proficiency.
After completing this module, students will be able to:
Create and use custom views that save print settings
Create workspace file to quickly open multiple files in Microsoft Excel.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.