MS Excel 2019 - Introduction
This introductory MS Excel course is for anyone who needs to understand how Excel works. Suitable for beginners.
By the end of this course you will be able to navigate a spreadsheet, use the ribbon and the quick access toolbar. You will be able to enter and edit data as well as copy and move it. You will learn about absolute and relative referencing and be able to determine the order of calculations. You will learn how to create basic formulas and use basic functions such as the auto-sum, minimum, maximum, average and count Functions. You will also learn how to format worksheets, create basic charts and lastly manage large worksheets..
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.
| Excel Environment |
| Worksheet Terminology |
| Navigating Worksheets |
| Switching between open Workbooks |
| The Ribbon |
| Customising the Ribbon |
| Mini Toolbar |
| Quick Access Toolbar |
| Status Bar |
| Backstage View |
| Getting Help |
| Opening & Closing Workbooks |
| Creating & Saving Workbooks |
| File Formats |
| Editing Data |
| Clearing vs Deleting Data |
| Selecting Data |
| Moving & Copying Data |
| Editing Cells |
| Using Undo & Redo |
| Find & Select |
| Creating Custom Lists |
| Working with Comments |
| Managing Columns & Rows |
| Inserting Columns & Rows |
| Deleting Columns & Rows |
| Managing Worksheets |
| Inserting & Deleting Worksheets |
| Moving & Copying Worksheets |
| Understanding Formulas |
| Order of Calculation |
| Entering & Editing Formulas |
| Moving & Copying Formulas |
| Relative & Absolute Cell References |
| Using Autosum |
| SUM Function |
| MIN & MAX Functions |
| AVERAGE Function |
| COUNT Function |
| Live Preview |
| Text Formatting |
| Text Alignment |
| Text Wrapping |
| Merge & Centre |
| Text Orientation |
| Formatting Numbers & Dates |
| Format Painter |
| Cell Styles |
| Conditional Formatting |
| Chart Basics |
| Formatting Charts |
| Recommended Charts |
| Print Preview |
| Page Break Preview |
| Page Setup Options |
| Setting Print Areas |
| Spell Check |
| Printing Worksheets |
