Excel 2010: Foundation

Request more details:

Description:
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2010 to manage, edit, and print data
Prerequisites:
To effectively understand this course, we recommend that you take the Microsoft Office Windows course or have equivalent knowledge.
Getting Started:
1: Starting Out
• What is Microsoft Office Excel 2010?
• What’s New in Excel 2010?
• Opening Excel
• Interacting with Excel
• Closing Excel
2: About Workbooks
• Creating a New Workbook
• Opening a Workbook
• Saving a Workbook
• About Excel File Types
• Closing a Workbook
3: Exploring your Workbook
• Using Worksheets
• The Active Cell
• Selecting Cells
• Exploring a Worksheet
• Using Zoom
4: Getting Help with Excel
• Opening Help
• Using the Help Screen
• The Help Toolbar
• Searching for Help
• Online Help vs. Offline Help
• Using the Table of Contents
• Getting Help in a Dialog Box
The Excel Interface:
1: The Quick Access Toolbar and File Menu
• The Default QAT Commands
• Adding Commands
• Removing Commands
• Customizing the Toolbar
• Using the File (Backstage) Menu
2: The Home Tab
• Understanding Tabs and Groups
• Clipboard Commands
• Font Commands
• Alignment Commands
• Number Commands
• Styles Commands
• Cells Commands
• Editing Commands
3: The Insert Tab
• Tables Commands
• Illustrations Commands
• Charts Commands
• Sparklines Commands
• Filter Commands
• Links Commands
• Text Commands
• Symbol Commands
4: The Page Layout Tab
• Themes Commands
• Page Setup Commands
• Scale to Fit Commands
• Sheet Options Commands
• Arrange Commands
5: The Formulas Tab
• The Functions Library
• Defined Names Commands
• Formula Auditing Commands
• Calculation Commands
.6: The Data Tab
• Get External Data Commands
• Connections Commands
• Sort and Filter Commands
• Data Tools Commands
• Outline Commands
7: The Review Tab
• Proofing Commands
• Language Commands
• Comments Commands
• Changes Commands
Excel Basics:
1: Working with Excel
• Columns, Rows, Cells, and Ranges
• Creating Worksheet Labels
• Entering and Deleting Data
• Printing your Worksheet
2: Basic Excel Features
• AutoFill
• AutoSum
• AutoComplete
• Working with Basic Formulae
3: Moving your Data
• Dragging and Dropping Cells
• How to Cut, Copy, and Paste Cells
• How to Cut, Copy, and Paste Multiple Cells
• Using the Clipboard
• Using Paste Special
• Inserting and Deleting Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
4: Smart Tags and Options Buttons
• What are Smart Tags?
• Setting Smart Tag Options
• The Error Option Button
• The AutoFill Option Button
• The Paste Option Button
5: Editing Tools
• Using AutoCorrect
• Using Spell Check
• Using Find and Replace
• Adding Comments
Editing your Workbook:
1: Modifying Cells and Data
• Changing the Size of Rows or Columns
• Adjusting Cell Alignment
• Rotating Text
• Creating Custom Number and Date Formats
2: Cell Formatting
• Conditional Formatting
• The Format Painter
• Cell Merging and AutoFit
• Find and Replace Formatting
3: Enhancing a Worksheet’s Appearance
• Adding Patterns and Colors
• Adding Borders
• Working with Styles
• Working with Themes
4: Working with Charts, Part 1
• Creating a Chart
• Styling Charts with the Design Tab
• Modifying Charts with the Layout Tab
• Additional Styling with the Format Tab
• Manipulating a Chart
5: Working with Charts, Part 2
• Changing the Type of Chart
• Changing the Source Data
• Working with the Chart Axes and Data Series
• Saving a Chart as a Template
• Absolute and Relative Cell References
Printing and Viewing your Workbook:
1: Using the View Tab
• Using Normal View
• Using Full Screen View
• Using Page Layout View
• Page Break Preview
2: Managing a Single Window
• Creating a New Window
• Hiding a Window
• Unhiding a Window
• Freezing a Pane
• Splitting a Worksheet
3: Managing Multiple Windows
• Switching Between Open Workbooks
• Arranging Workbooks
• Comparing Workbooks Side by Side
• Synchronous Scrolling and Resetting a Window
• Saving a Workspace
4: Printing your Workbook
• Print Commands
• Print Preview
• Using Basic Print Options
• Other Print Options
• Setting Printer Properties