Microsoft Excel 2007 - Level 1
Short course
Inhouse
Description
-
Type
Short course
-
Methodology
Inhouse
-
Duration
1 Day
If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.
About this course
Basic PC knowledge required
Reviews
Course programme
If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.
PREREQUISITES
Basic PC knowledge required
GETTING STARTED
-
Starting Out
-
About Workbooks
-
Exploring your Workbook
-
Getting Help in Excel 2007
-
The Quick Access Toolbar
-
The Home Tab
-
The Insert Tab
-
The Page Layout Tab
-
The Formulas Tab
-
The Data Tab
-
The Review Tab
-
Working With Excel 2007
-
Columns, Rows, Cells, and Ranges
-
Creating Worksheet Labels
-
Entering and Deleting Data
-
Printing Your Worksheet
-
Columns, Rows, Cells, and Ranges
-
Basic Excel Features
-
What is AutoFill?
-
What is AutoSum?
-
What is AutoComplete?
-
Working with Basic Formulas
-
What is AutoFill?
-
Moving your Data
-
Dragging and Dropping Cells
-
How to Cut, Copy, and Paste Cells
-
How to Cut, Copy, and Paste Multiple Cells and Items
-
How to Use Paste Special
-
How to Insert and Delete Cells, Rows, and Columns
-
Using Undo, Redo, and Repeat
-
Dragging and Dropping Cells
-
Smart Tags and Options Buttons
-
What Are Smart Tags?
-
The Error Option Button
-
The AutoFill Option Button
-
The Paste Option Button
-
Setting Smart Tag Options
-
What Are Smart Tags?
-
Editing Tools
-
Using AutoCorrect
-
Using Spell Check
-
Using Find and Replace
-
Adding Comments
-
Using AutoCorrect
-
Modifying Cells and Data
-
Changing the Size of Rows or Columns
-
Adjusting Cell Alignment
-
Rotating Text
-
Creating Custom Number and Date Formats
-
Changing the Size of Rows or Columns
-
Cell Formatting
-
Conditional Formatting
-
The Format Painter
-
Cell Merging and AutoFit
-
Conditional Formatting
-
Find and Replace Formatting
-
Enhancing a Worksheet's Appearance
-
Adding Patterns and Colours
-
Adding Borders
-
Working with Styles
-
Enhancing a Worksheet's Appearance
-
Working With Charts, Part 1
-
Creating a Chart
-
Formatting a Chart
-
Modifying Charts with the Layout Tab
-
Manipulating a Chart
-
Enhancing a Chart with Shapes and Graphics
-
Creating a Chart
-
Working with Charts, Part 2
-
Changing the Type of Chart
-
Changing the Source Data
-
Working with the Chart Axis and Data Series
-
Saving a Chart as a Template
-
Changing the Type of Chart
-
Using the View Tab
-
Managing a Single Window
-
Creating a New Window
-
Hiding a Window
-
Unhiding a Window
-
Freezing a Pane
-
Creating a New Window
-
Managing Multiple Windows
-
Switching Between Open Workbooks
-
Arranging Workbooks
-
Comparing Workbooks Side by Side
-
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
-
Switching Between Open Workbooks
-
Printing your Workbook
-
Opening Print Preview
-
Using the Print Preview Tab
-
Quick Printing
-
The Print Dialog
-
Using Page Setup
-
Opening Print Preview
Microsoft Excel 2007 - Level 1