Level 1 – 1 Day
This course shows you the basics of how Excel can calculate budgets and financial projections for you by teaching you how to create a small spreadsheet from the beginning of a blank page to the end of saving and printing a professional-looking document. If you’ve never used Excel before, or have only used it to fill in spreadsheets that other people have created for you, this is the course for you. This course is also suitable for people who are new to Microsoft Office in general and are looking for someplace to start.
Worksheet Entries
Rules For Entering Data
Deleting Cell Contents
Editing Cell Entries
Moving Around A Worksheet
Selecting Cells (Short Cuts)
Spreadsheet Formatting
Setting Column Widths
Setting Row Heights
Choosing Number Formats
Date Formats & Custom Date Formats
Setting Decimal Places, Negative Display
Aligning Entries In Cells – Left, Centre, Right
Centering A Heading
Using Paste Special
Copy, Move, & Fill
Drag & Drop
Clipboard Cut, Copy, & Paste
Using Paste Special
Using Fill To Automate Entering Months, Days, Numbers, And To Copy Formulas
Inserting & Deleting
Columns
Rows
Partial Columns And Rows
Cell Formatting
Changing Font
Bold, Italic, Underline, Font Colour, etc.
Applying Borders
Filling Cells with Colour
Files
Saving & Opening
Working In More Than One File
Closing & Creating New Files
Page Setup
Portrait & Landscape
Scaling
Paper Size
Margins
Centre On Page
Print & Print Preview
Page Breaks
Page Break Preview
Preview
Print Options
Multiple Sheets
Switching From Page To Page
Modifying Sheets & Sheet Tabs
Moving and Copying Sheets
Setting Defaults for All Sheets
Changing the Number of Pages
Format Sheet
Sheet Background
Background Picture
Using AutoCorrect
Using Format Painter to Copy Formats