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