Our Microsoft Excel Essentials program is designed for students who wish to advance their computer skills by learning to work with Microsoft Excel. The course is aimed at those who have no or limited experience with Excel.
Course facilitators are knowledgeable in all levels of Excel and use the software on a daily basis.
- Hands-on training by our patient, experienced facilitators
- Easy to read printed courseware for future reference
- Facilitator support for 30 days following attendance at a course
- Option to return for refresher training (up to 6 months after course) if course is running and training places are available
What Will I Receive?
Upon successful completion of the course, participants will be issued with a Certificate of Completion.
For those who have limited or no experience using Excel, and wish to learn its essential functions and features.
- Basic Excel concepts and uses
- Ribbon, Status Bar and Quick Access toolbar
- Create and Save a Workbook
- Insert, Delete, Copy and Move Worksheets
- Naming and colouring worksheets tabs
Editing and Formatting in Excel
- Insert or Delete Cells/Rows/Columns
- Use AutoComplete and AutoFill
- Cut, Copy, and Paste text
- Wrap, Merge and Centre Text
- Number and text formatting and alignment
- Borders and Shading
Basic Excel formulas
- Use Math Operators
- Relative and Absolute references
- Copying formulas
Work with Rows and Columns
- Set Row Height and Column Width
- Hide and Unhide Rows and Columns
- Freeze Panes
- Find and Replace Data
- Sort Data
- Create and Use Comments
- Page Orientation
- Set and Clear Print Area
- Set Margins
- Print Scaling
- Headers and Footers
- Print to PDF
- Create, Format, and Move Charts
- Print Charts
- Online Help
- Smart Lookup
- Tell Me
The Excel Essentials program is one day in duration.
Dedicated corporate classes may be scheduled, and these may be delivered onsite depending on availability of computers at the client’s premises, or in our training rooms using our computers. Please speak to our friendly staff regarding onsite delivery.
How to Enrol
For a dedicated course, contact our office. Dates will be scheduled at the time of booking.