wconsulting.mu

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 its 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