Excel - Beginner

Course status:
Inactive
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:

  • Terminology
  • Layout and interface
  • Move or copy sheets
  • Status Bar
  • Print Preview and set print area

Completing / Filling in a Spreadsheet: Working with Data:

  • Formatting data (changing appearance, font, size, colour and upper-case / lowercase) and Format Painter
  • Inserting Line Breaks
  • 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:

  • Insert, delete and adjust rows and columns
  • Executing sum formula
  • How to do spell-checks

Navigating Seamlessly:

  • Freeze panes
  • How to navigate without a mouse
  • How to search for text
  • Quick access toolbar