Excel - Beginner

Price:
R448.50 (VAT Incl.)
Level:
Individual Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
120 Minutes
Additionals:
   CPD Assessment
   Certificate

Lesson Outline


Outline:
Are you new to Excel? Have you just joined the work force? Is there a new recruit who will need to use Excel to fulfil daily work duties?

If you’ve answered yes to any other above questions, then join us for a two-hour webinar where we introduce you to Microsoft Excel.

Course Content:
• Introduction:
o Terminology
o Layout and interface
o Move or copy sheets
o Status Bar
o Print Preview and set print area

• Completing / Filling in a Spreadsheet

• Working with Data:
o Formatting data (changing appearance, font, size, colour and upper-case / lowercase) and Format Painter
o Inserting Line Breaks
o Various ways to Paste data

• Recovering Lost Documents: Auto-save function.

• Built in Templates: Exploring pre-created templates eg. budgets, expense tracker, invoices

• Creating and Editing a Spreadsheet:
o Insert, delete and adjust rows and columns
o Executing sum formula
o How to do spell-checks

• Navigating Seamlessly:
o Freeze panes
o How to navigate without a mouse
o How to search for text
o Quick access toolbar