MS Excel - Fundamentals
| |
| Venue | Online Live Stream |
| Date | Tuesday 7th October 2025 |
| Time | 09:00 - 12:00 GMT+2 |
| Information |
This course is aimed at users who have either never had formal Excel training or their training was several years ago and the program has changed significantly enough for them to re-attend training. Topics include: Working with the Excel interface working with text, numbers and dates formulas, functions and absolute references an introduction to defined names formatting and printing large worksheets. If you are self-taught and sometimes struggle with the Excel program then this course is for you – it’s never too late to fill in the gaps.
Course pre-requisites Is able to work with the Windows operating system.
Topics
1. Excel interface Elements, terminology, the Quick Access toolbar, ribbons, groups, commands and dialog boxes, Backstage view.
2. Working with text, numbers and dates Text vs numbers, using AutoFill, editing text, navigating and selecting and cut copy and replace.
3. Calculating in Excel Formulas (including operators and the order of operations), functions and absolute references.
4. Defined names How to create and edit defined names, use these in formulas and delete defined names.
5. Formatting in Excel Fonts, alignment, numbers and dates borders and fills column widths and row heights and how to copy formatting.
6. Printing Page setup, including page size, margins and orientation, headers and footers, setting the print area, repeating titles and page breaks.
|
| Presenter |
Vickie Watt
Vickie has an extensive background in communication and training consulting in various industries which include manufacturing, mining, insurance, retail, media, and ICT.
As a Microsoft Certified Professional and Microsoft Certified Trainer, Vickie has achieved Microsoft Office Specialist Expert status, and is an advanced user in Microsoft Excel, Word, Project, PowerPoint, and Outlook, with extensive experience in a number of other software applications.
She is a registered Assessor with the ETDP and MICT SETAs.
Close this popup
|
| CPD Units | 3 Hours verifiable CPD on full attendance |
| Price | R 500 |
| Booking Deadline | Tuesday 7th October 2025 |
|
|
|
