|
|
Microsoft Excel 2007
Available for immediate download. Please click on each picture to see a larger view.
|
Microsoft Excel 2007 - Getting Started
|
|
Microsoft Excel 2007 is a program designed to create and use a spreadsheet.
This Guide will take you through getting started and building your confidence in the skills needed to use the software productively. |
Table of Contents
Lesson 1
Running the Excel program
Title Bar, Main Menu bar
Maximise a window
Activating menus
Toolbar and Reference bar
Switching Sheets
Scrolling
Go To
Moving around with Shortcuts
Name Box
Exiting the Program
Lesson 2
Text Entries
Number Entries
Body Area
Date Entries
Selecting Cells
Increase Decimal Position
Cancel a Selection
Sum Formula
Currency Format
Undo, Redo
New Folder
Saving a File
Closing a File
New Sheet
Lesson 3
Open a sheet
Edit
Deleting
Center Align
Bold
Sum Formula
AutoSum
Resave
Inserting Rows
Merge & Center
Underline
Increase Font
Lesson 4
Widening Columns
Font Colour
Font Size
Lesson 5
Show Formulas
Addition, Subtractions, Division and Multiplication
Remove Decimal Position |
Lesson 6
Save File to Another name
Switching between Files
Arrange windows Side by Side
Multiply Formula
Lesson 7
Print Preview
Zoom
Margins
Adding Icons to the toolbar
Dividing a cell with a set number
Gridlines
Arrange Windows – Cascade
Lesson 8
Column Width
Fonts
Fill Color
Borders
Decrease Margins
Page Setup – Landscape
Lesson 9
Selecting an Entire Sheet
Lines & Borders
Lesson 10
Right Lines/Borders
Page Setup – Fit to One Page
Using Excel as a Calculator
Lesson 11
Using Excel as a Calculator
Lesson 12
Comma Format
Formulas with brackets
Text Wrap
Divide
Italics
Selecting a Row
Adjusting Row Height
Percentage Format
Formulas with Percentages
|
|
|
Microsoft Excel 2007 - Popular Functions
|
|
Microsoft Excel 2007 is a program designed to create and use a spreadsheet.
This Guide will take you through the popular most-used functions and building your confidence in the skills needed to use the software productively.
It assumes you have the skills taught in the previous Guide. |
Table of Contents
Lesson 1
Inserting Rows
Borders
Format Cells - Font
Thick Line Borders
Drawing Borders
Erasing Borders
Copy & Paste
Average Formula
Maximum Formula
Minimum Formula
Number Formatting
Multiple Select
Creating a New Folder
Lesson 2
Save As
Displaying Multiple Sheets
Switching between Sheets
Select Entire Sheet
Gridlines & Headings
Lesson 3
Excel Options Font Settings
Inserting Multiple Rows
Inserting Columns
Deleting Rows
Text Orientation
Multiple Column Widths
Sort - Ascending
Sort - Descending
Lesson 4
Add 1 Formula
Selecting an Entire Sheet
AutoFit Multiple Column Widths
Copy & Paste
Replace
Cut / Move
Lesson 5
Page Setup - Print Row Titles
Gridlines, Headers
Show Margins
Adjust Margins
Fit to One Page
Row and Column Headings
Headers and Footers
Dates, Page Numbers, File Path
Printing |
Lesson 6
Absolute Referencing
Print Areas
Hide Columns
Lesson 7
Unhide Columns
Selecting Multiple Areas
Password Protection
Page Orientation
Headers and Footers
Normal View
Page Layout View
Lesson 8
Today Formula
Date Formats
Lesson 9
Formula with Brackets
Selecting Multiple Columns
Percentage Format
Freeze Panes
Show Formula
Lesson 10
Text Wrapping
Editing Sheet Tags
Lesson 11
Insert Sheets
Row Heights
Lesson 12
Inserting Comments
Editing Comments
Lesson 13
Customise Sort
Sort - Add Levels
Hide Rows
Filters
Clear Filters
Custom Filters – Greater Than
Removing Filters
|
|
|
Microsoft Excel 2007 - Intermediate
|
|
Microsoft Excel 2007 is a program designed to create and use a spreadsheet.
This Guide will take you through the intermediate functions and building your confidence in the skills needed to use the software more productively.
It assumes you have the skills taught in the previous Guides.
|
Table of Contents
Lesson 1
Fill/Series
WorkBook Settings
Text Wrap
Top Align
ClipArt
Resizing images
Top and Bottom Margins
Lesson 2
Hyperlinks
Activating Hyperlinks
Lesson 3
Creating a Chart
Moving & Sizing a Chart
Chart Legend
Chart Plot Area
Chart Value Axis
Chart Horizontal Axis
Chart Data Series
Chart Data Labels
Major and Minor Gridlines
Chart Titles
Chart WordArt Styles
Lesson 4
Pie Chart
Chart Layout
Edit Chart Types and Pieces
Shape Styles
Selecting a Pie Piece
Selecting an Area
Exploding a Pie Piece
Change Chart Type
Lesson 5
Group & Outline
Close & Open Outlines
Outline Levels
Ungroup Outlines
Subtotals
Remove subtotals |
Lesson 6
Paste / Values
3D Cylinder Chart
Creating a Chart from scratch
Data Series
Paste / Transpose
Lesson 7
IF Formulas
Lesson 8
IF Formulas with multiple statements
Absolute Cell Referencing
Lesson 9
CountIf formula
Count formula
CountBlank formula
Delete Sheets
Sumif formula
Lesson 10
Conditional Formatting
Creating a Template
Opening a Template
Lesson 11
Link Formula
Saving files to a WorkSpace
Arrange Windows Cascade
|
|
|
Microsoft Excel 2007 - Advanced
|
|
Microsoft Excel 2007 is a program designed to create and use a spreadsheet.
This Guide will take you through the advanced functions and building your confidence in the skills needed to use the software more productively.
It assumes you have the skills taught in the previous Guides.
|
Table of Contents
Lesson 1
Text Boxes
Selecting Text Boxes
Text Effects - Transform
WordArt Styles
Increase Indent
Unlock Cells
Protect Sheets
Unprotect Sheets
Lesson 2
Send Sheet via Email
Consolidate
WorkSpace
Lesson 3
AutoFilters
Working with Filters
Removing Filters
Pivot Tables
Working with Pivot Tables
Selecting a Pivot Table
Clear a Pivot Table
Lesson 4
VLookup formula
Hide Columns/Rows
Unhide Columns/Rows
Lesson 5
Data Validation
Subtotals
Lesson 6
Count Formula
CountIF Formula
Advanced Filters
Extracting Data |
Lesson 7
Advanced Filters – Unique Records
CountIF Formulas
Working Formulas on several sheetsAbsolute Cell Referencing
Lesson 8
PMT Formula
Lesson 9
Hyperlinks
Lesson 10
Goal Seek
Lesson 11
SQRT Formula
Macros
Running a Macro
Arrays
Grand Arrays
Labelling Sheets
Lesson 12
Scenario
Lesson 13
Cell Names
Go To a Cell Name
Deleting a Macro
Excel Help
| |
|
 |
|
|
|
Browse our Mall
See Similar ItemsRecommendations
Search
| |
|
|
|
|
|
