Spreadsheets Course
This Spreadsheet course covers the essential topics relating to using a spreadsheet application for everyday use. It's suitable for complete beginners.
By the end of this course you will be able to work with spreadsheets and save them in different file formats. Use the Help facility. Enter data into cells and use good practice in creating lists. Select, copy, sort and move and delete data. Copy, move, delete and rename worksheets. Create mathematical and logical formulas. Format numbers. Choose create and format charts. Lastly you will learn how to adjust page settings before committing to printing.
Includes updates as of September 2021 affecting 14 lessons.
Estimated Course duration is 2 - 3 hours. Each lesson take on average 3-5 minutes to complete.
| MS Excel Environment |
| Backstage View |
| Creating New Workbooks - UPDATED |
| Navigating within Workbooks - NEW |
| Opening and Closing Workbooks |
| Saving and Updating - UPDATED |
| Saving Workbooks as Templates |
| File Formats - UPDATED |
| Switching between Workbooks |
| Available Help Functions - UPDATED |
| Entering Text and Values - UPDATED |
| Selecting Ranges |
| Using Undo/Redo |
| Searching and Replacing Content |
| Copying and Moving Contents - UPDATED |
| Sorting Cell Ranges |
| Inserting Columns and Rows |
| Deleting Columns and Rows |
| Modifying Worksheets - UPDATED |
| Modifying Worksheets |
| Freezing Panes |
| Order of Calculation |
| Creating Formulas - UPDATED |
| Relative and Absolute Cell Referencing |
| AutoSum |
| Sum Function |
| Average Function |
| Min and Max Functions |
| Count Function |
| Round Function |
| IF Function |
| Formatting Numbers |
| Formatting Font Size and Type |
| Cell Contents Formatting - UPDATED |
| Format Painter |
| Text Wrapping - UPDATED |
| Aligning Cell Contents |
| Cell Content Orientation - UPDATED |
| Merging Cells - UPDATED |
| Creating Column Charts |
| Creating Bar Charts |
| Creating Line Charts |
| Creating Pie Charts |
| Editing Charts - UPDATED |
| Formatting Charts |
| Page Setup |
| Headers and Footers |
| Print Set-Up |
| Previewing and Printing |
| Printing Workbooks |
| Printing Selected Ranges |
