| |Microsoft Excel 2010 – Learn To Master the Interface
| |
ID: SAE100 | Course Length: 1 |  |
|
| | |
Module 0: Course Overview |
| | | - Duration A One-day Course
- Basic Knowledge of Windows
- Good Knowledge of Computers, Mouse
- Objectives
- A Brief Overview of All the Groups in the Ribbon
- Different Features of the Interface
- Editing – Find, Replace, Select Text and Data
- Saving and Printing
- The Basics of Formatting
- Working with Basic Formulas
- Prerequisites
|
 |
| | |
Module 1: Getting Started | |
| | | - What Is Microsoft Excel 2010
- Dealing with File Formats
- Exploring Properties
- Default Values in Excel Options
|
|
| | |
Module 2: Exploring The Interface |
| | | - The Title Bar
- The Quick Access Toolbar
- The Default Qat Group
- Using the File (backstage) Menu
- The Status Bar
|
|
| | |
Module 3: The Home Tab |
| | | - Understanding Tabs and Groups
- Clipboard Group
- Font Group
- Alignment Group
- Number Group
- Styles Group
- Cells Group
- Editing Group
|
|
| | |
Module 4: The Insert Tab |
| | | - Tables Group
- Illustrations Group
- Charts Group
- Sparklines Commands
- Filter Commands
- Links Group
- Text Group
- Symbol Commands
|
|
| | |
Module 5: The Page Layout Tab |
| | | - Themes Group
- Page Setup Group
- Scale To Fit Group
- Sheet Options Group
- Arrange Group
|
|
| | |
Module 6: The Formula Tab |
| | | - The Functions Library
- Defined Names Group
- Formula Auditing Group
- Calculation Group
|
|
| | |
Module 7: The Data Tab |
| | | - Get External Data Group
- Connections Group
- Sort and Filter Group
- Data Tools Group
- Outline Group
|
|
| | |
Module 8: The Review Tab |
| | | - Proofing Group
- Language Commands
- Comments Group
- Changes Group
|
|
| | |
Module 9: The View Tab |
| | | - Workbook Views Group
- Show Group
- Zoom Group
- Window Group
- Macros Group
|
|
| | |
Module 10: Excel Basics |
| | | - Working with Excel
- Columns, Rows, Cells, and Ranges
- Creating Worksheet Labels
- Entering and Deleting Data
- Using Autofill, Autocomplete, Autosum
- Printing Your Worksheet
|
|
| | |
Module 11: Copying And Moving Your Data |
| | | - Dragging and Dropping Cells
- Cut, Copy, and Paste Cells
- Cut, Copy, and Paste Multiple Cells
- Using the Clipboard
- Using Paste Special
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
|
|
| | |
Module 12: Smart Tags And Options Buttons |
| | | - What Are Smart Tags
- Setting Smart Tag Options
- The Autofill Option Button
- Autocomplete
- Using the Clipboard
- The Paste Option Button
|
|
| | |
Module 13: Editing Tools |
| | | - Using Autocorrect
- Using Spell Check
- Adding Comments
- Editing Your Workbook
- Changing Size of Rows Or Columns
- Adjusting Cell Alignment
- Rotating Text
|
|
| | |
Module 14: Formatting Numbers And Text |
| | | - Using Number Formats
- Using the Styles and Fonts
- Changing Decimal Places
|
|
| | |
Module 15: Cell Formatting |
| | | - The Format Painter
- Cell Merging and Autofit
- Find and Replace Formatting
|
|
| | |
Module 16: Enhancing Worksheet Appearance |
| | | - Adding Patterns and Colors
- Adding Borders
- Working with Styles
- Working with Themes
|
|
| | |
Module 17: Basic Math |
| | | - Overview of Mathematical Operators and Order of Operations
|
|
| | |
Module 18: Editing – Find And Replace |
| | | - Using Find and Replace
- Using Select
|
|
| | |
Module 19: Printing |
| | | - Printing and Previewing
- Introducing the Printing Page Setup Options
|
|
| | |
Module 20: Drawing Objects |
| | | - Working with Graphics
- Using Effects and Objects
- Adding Shapes
- Inserting Smart Art and Word Art
|
|
| | |
Module 21: Lab |
| | |
|
|