Loading Classes

« All Classes

Sage | Excel Intermediate

July 19 @ 9:00 am - 4:00 pm

R2,366.50
Sage Excel Intermediate

Tickets

The numbers below include SELECT NUMBER OF ATTENDEES for this event already in your cart. Clicking "Get SELECT NUMBER OF ATTENDEES" will allow you to edit any existing attendee information as well as change ticket quantities.
Sage | Excel Intermediate
 
  • 1. ADD +1
 
  • 2. CLICK REGISTER NOW
 
  • 3. ADD THIS CLASS TO THE CART
 
  • 4. COMPLETE YOUR PERSONAL DETAILS
 
  • 5. SELECT A PAYMENT METHOD
 
R 2,366.50
4 available

What you will cover – Lesson Outline Intermediate

Lesson 01 – What is Microsoft Excel

  • Components of the Microsoft Excel screen and the ribbon

Lesson 02 – File Formats and Columns and Rows

  • Selection Techniques and Entering in Data
  • Page Setup and Page Breaks

Lesson 03 – Working with Formulae

  • Creating, copying and using formulae
  • Formulae with Absolute References and 3-D Formulae

Lesson 04 – Creating Multiple Views

  • Freezing and Hiding Columns and Rows
  • Split panes to see multiple worksheet areas

Lesson 05 – Formatting and Editing Worksheets

  • Editing, Formatting, Moving and Copying Data
  • Conditional Formatting

Lesson 06 – Printing and Page Setup

  • Print Preview, Printing Options and Headers and Footers
  • Setting Print Titles

Lesson 07 – Using Functions

  • Sum, AutoSum, Average, Max, Text
  • Conditional Formatting

Details

Date:
July 19
Time:
9:00 am - 4:00 pm
Cost:
R2,366.50
Class Category:

Company

Sage South Africa (Pty) Ltd – Virtual Classes
Microsoft Teams
Gauteng, South Africa
View Company Website