Basic Excel - Introduction for Entry-Level Users

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

Lesson 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.

  • 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