| About this Course
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 Profile
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
Course Outline
Module 1: EXCEL SHORTCUTS
This module explains how to use various shortcut keys available in Microsoft Excel.
Lessons
After completing this module, students will be able to:
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
Lab : 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
Lab : Use copy and move data shortcuts.
After completing this module, students will be able to:
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
Lab : Practice AutoFill and Fill options shortcuts
After completing this module, students will be able to:
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
Lab : Apply shortcuts to alter formats and styles
After completing this module, students will be able to:
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
- Use Labels in Formulas
- Use Labels to Refer to Individual Cells
- Use Multiple Stacked Headings
- Review 6
Lab : Apply shortcuts work with Labels and names.
After completing this module, students will be able to:
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
Lab : Use shortcuts to create 3D formulas.
After completing this module, students will be able to:
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
Lab : Use shortcuts to combine data from multiple worksheets into one worksheet.
After completing this module, students will be able to:
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
Lab : Use shortcuts to create one- and two-variable tables.
After completing this module, students will be able to:
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
Lab : Use Auto Outline and modify outlines using shortcuts.
After completing this module, students will be able to:
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
Lab : Use shortcuts to increase workbook proficiency.
After completing this module, students will be able to:
For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100 |
