TRAINERS FOR COURSE

Lawrence Maoka

Lawrence is a Sales Manager and Training instructor at Leading Edge Business Solutions (Pty) Ltd since April 2008 and has been a technical instructor since 2004. Lawrence combines technical knowledge with good communications skills and consistently receives enthusiastic reviews from his students. Lawrence has trained in all 9 provinces of South Africa as well as in the DRC, Botswana, and Swaziland.

Cost

PC Hire:

Duration:

1 Day

Brochure:

Prices have changed from 1 March 2018. Information may change without notice.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web

Pre-Requisites

Microsoft Office Excel Basic

Course Outline / Curriculum

Lesson 1: Creating Advanced Formulas

Apply Range Names

Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

Leverage Questions and Testing to Write Formulas

Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3:Organizing Worksheet Data with Tables

Create and Modify Tables

Sort and Filter Data

Use Summary and Database Functions to Calculate Data

Lesson 4: Analyzing Data with Pivot Tables, Slicers, and PivotCharts

Create a PivotTable Report

Filter Data by Using Slicers

Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic

Insert and Modify Graphic Objects

Layer and Group Graphics Objects

Incorporate SmartArt

Lesson 6: Enhancing Workbooks

Customize Workbooks

Manage Themes

Create and Use Templates

Protect Files

Schedule Dates and Booking

To apply for a booking, click on the
relevant "Book Now" button below.Note: places are only fully secured once payment has been
made.