Spreadsheet Course - Introduction
This Course is CPD Certified
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. Enhance your productivity and 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 and dates. Create, edit and format Value and Category comparison charts and work with Time Related charts too. Lastly you will learn how to adjust page settings before committing to printing.
Estimated Course duration is 2 - 3 hours. Each lesson take on average 3-5 minutes to complete.
| Opening and Closing Workbooks |
| Creating and Saving Workbooks |
| File Formats |
| Switching between open Workbooks |
| Backstage View |
| Getting Help |
| Excel Environment |
| The Ribbon |
| Mini Toolbar |
| Quick Access Toolbar |
| Navigating Worksheets |
| Entering Data |
| Selecting Data |
| Editing Cells |
| Using Undo & Redo |
| Find and Select |
| Sorting by Value |
| Moving and Copying Data |
| Moving and Copying Formulas |
| Creating Custom Lists |
| Clearing vs Deleting Data |
| Inserting Columns and Rows |
| Deleting Columns and Rows |
| Managing Columns and Rows |
| Inserting and Deleting Worksheets |
| Managing Worksheets |
| Moving and Copying Worksheets |
| Understanding Formulas |
| Order of Calculation |
| Entering and Editing Formulas |
| Relative and Absolute Cell References |
| Formula Errors |
| SUM Function |
| MIN and MAX Functions |
| AVERAGE Function |
| COUNT Function |
| ROUND Function |
| IF Function |
| Formatting Numbers and Dates |
| Text Formatting |
| Cell Styles |
| Format Painter |
| Text Wrapping |
| Text Alignment |
| Text Orientation |
| Merge and Centre |
| Cell Borders |
| Chart Basics |
| Value Comparison Charts (Column, Bar) |
| Category Comparison Charts (Pie, Doughnut) |
| Time Related Charts (Line, Area) |
| Advanced Chart Editing |
| Formatting Charts |
| Advanced Chart Formatting |
| Page Setup Options |
| Headers and Footers |
| Spell Check |
| Advanced Printing Settings |
| Print Preview |
| Printing Worksheets |
