Online Session - MS Excel - Fundamentals
| |
| Venue | Online - Microsoft Teams |
| Date | Tuesday 20th February 2024 |
| Time | 14:00 - 17:00 |
| 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.
Topic
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.
This session is not eligible for the HRDC refund as it is being broadcasted from our Johannesburg office |
| Presenter |
|
| CPD Units | 3 units on full attendance |
| Seats Left | 26 |
| Price | Rs 2000 |
| Booking Deadline | Tuesday 20th February 2024 |
| Map | View Map |
|
|
|
