|
Microsoft Excel 103 Tutorial Outline 0.
INTRODUCTION
Objectives
Pre-Requisites
1. SETTING UP OUR SHEET
Building an Income & Expense Report Sheet
Setting up Income & Expense Categories
Moving a range of cells with the mouse
Formatting our sheet
Inserting blank rows
AutoFill Review
2. WORKING WITH LARGE SHEETS
Freezing panes
Window, Freeze Panes
Window, Unfreeze Panes
Splitting the Screen
Window, Split
Window, Remove Split
Window, New Window
Insert Comments
Edit Comment
Delete Comment
Hiding Columns and Rows
Unhiding Columns and Rows
3. PAGE SETUP, PART ONE
Print Preview
Using the Magnifying Glass
Zooming in and out
Closing Print Preview
File, Page Setup
Page Orientation
Portrait v. Landscape
Scaling
Adjust to % Normal Size
Fit to pages
Print quality (resolution)
First Page Number
Additional printer options
Page Margins
Top, Bottom, Left, Right Margins
Header & Footer Margin Settings
Center on Page Horizontally, Vertically
Adjusting margins visually
4. PAGE SETUP, PART TWO
Headers & Footers
Using the stock page headers
Page header previews
Creating a custom header and footer
Left, center, right sections
Using the insert codes for headers/footers
Page numbering
Number of pages
Putting an ampersand in your headers
Inserting the date and time
The path and file of your workbook
Inserting a picture in your sheet
Changing text format of headers/footers
5. PAGE SETUP, PART THREE
Working with the Page Setup, Sheet tab
Specifying a Print Area
Using the range popup boxes
Rows to repeat at top
Columns to repeat at left
Showing gridlines
Black and white printing only
Draft quality
Showing row and column headings
Showing comments, options
Forcing comments to stay visible on sheet
Displaying Cell Errors
Page Order (numbering)
6. WORKING WITH MULTIPLE SHEETS
Viewing the page breaks
View, Page Break Preview
Moving the page break lines
View, Normal
Changing the name of your sheet tabs
Creating a copy of a sheet
Changing the color of a sheet tab
Using the keyboard to move between sheets
Deleting a sheet tab
Inserting a blank new worksheet
Moving a sheet tab with the mouse
Selecting multiple sheet tabs
Moving multiple sheet tabs
Format, Sheet, Background
Creating a background picture for the sheet
7. REVIEW
Review topics
|
