 |  |  |  |  |  |
| Course | Microsoft Excel Introduction | |
| Duration | 1 or 2 days as required | |
| Overview |
Run as a 2 day course this is a very solid foundation for any student completely new to spreadsheets. The course introduces the three main components of Excel: Spreadsheet, Database and Charting. As with other 2 day courses ample time is given for the student to work through prepared exercises. At the end of the course the student should be able to setup and print a spreadsheet, create a chart and setup a database in Excel. Run as a 1 day course this is a thorough fast paced introduction to Excel.
Excels database features are not covered on this course and charting is
covered if time permits. |
|
| Content | Introducing Excel | Loading Excel, The Excel Window, Toolbars, Online
Help, Creating a New Workbook Saving, Closing & Opening a Workbook |
| Inputting & Editing | Cursor Movement & Scrolling Selecting Ranges Working with Sheets Entering Text & Values Editing/Clearing Cell Contents Using Autofill and Autocomplete Inserting/Deleting Rows & Columns Changing Columns Widths & Row Heights Undo & Redo |
|
| Moving and Copying Cells/Ranges |
Cut Copy & Paste |
|
| Building Formulae | Entering Formulae & Functions Arithmetic Operators Using Sum & AutoSum Copying a Formula Relative & Absolute Cell References Order of Calculation, Using Brackets in Formulae Common Functions (Average, Min, Max, Count, If) Using Paste Function Viewing & Printing Formulae |
|
| Worksheet Formatting |
General Worksheet Formats |
|
| Printing a Worksheet | Printing Selected Ranges Using Print Preview Printing in Landscape Changing Margins/Scaling the Printout Page Breaks Inserting Headers/Footers/Page Numbers |
|
| Multiple Worksheets | Inserting/Deleting/Moving/Copying Worksheets Naming Worksheets Grouping & Ungrouping Sheets Selecting 3D Ranges Summing Across a Group of Sheets Printing Multiple Worksheets Inserting Page Breaks Hiding/Unhiding Rows & Columns |
|
| Working with Windows | Freezing Window Panes Splitting Windows into Panes |
|
| Creating Graphs |
Building a Graph Using the Wizard |
|
| Database Features | An introduction to Excels database features | |