Intermediate Excel Course

INTRODUCTION

The Excel Intermediate course focuses on the more advanced formulas and data manipulation.

You also get free access to our online E-Learning platform which includes videos, questions, examples and exams. This is the exact same content as the course. This access is valid for 12 months.

DURATION OF THIS INTERMEDIATE EXCEL COURSE

This course is normally 6 hours in total. These 6 hours can be delivered in different ways:

  1. One full day
  2. 2 Sessions of 3 hours each. (This can be split over different weeks or different months).


WHO SHOULD ATTEND THIS COURSE?

This course is aimed at anyone who is proficient in the Basic Excel Outcomes and wishes to learn more about Microsoft Office Excel.

The following people will find this course helpful:
 Anyone who has worked on Excel before
 Anyone who has worked a bit on Excel but is not familiar with all its functions
 Database Administrators
 Managers and Supervisors who need to extract information from databases



COURSE DATES

We do not have workshops currently, but only provide on site training customized to your needs.



ASSESSMENTS

If you are not sure of your level, click here to do our excel assessment.



OUTLINE

Unit 1: Creating and Applying Templates

Topic A: Use built-in Excel Templates

Topic B: Create a Template

Unit 2: Creating and Modifying Charts

Topic A: Insert a Chart

Topic B: Modify Chart Options

Topic C: Formatting Charts

Topic D: Working with Chart Types

Topic E: Chart Locations

Unit 3: Calculating with Advanced Formulas

Topic A: Introduction to Advanced Functions

Topic B: Date and Time Functions

Topic C: Financial Functions

Topic D: Statistical Functions

Topic E: Lookup and Reference Functions

Topic F: Logical Functions

Topic G: Working with Range Names

Topic H: Linking Cells

Topic I: Calculate Across Worksheets

Unit 4: Sorting and Filtering Data

Topic A: Sort a List

Topic B: Filter a List

Topic C: Work with Advanced Filters

Topic D: Use Database Functions in a List

Topic E: Add Subtotals to a List

Unit 5: Importing and Exporting Excel Data

Topic A: Export Excel Data

Topic B: Import Excel Data

Unit 6: Working with Graphic Objects

Topic A: Insert Graphics

Topic B: Create AutoShapes

Topic C: Format Graphic Objects

Topic D: Change the Order of Graphic Objects

Topic E: Group Graphic Objects

Topic F: Move, Copy, and Resize Objects

Topic G: Create a Diagram

Unit 7: Comments and Web Features

Topic A: Working with Comments

Topic B: Create a Hyperlink

Topic C: Use Web-based Research Tools

Topic D: Publish a Worksheet to the Web

Topic E: Import Data from the Web

Topic F: Create a Web Query

 

Empower Yourself - BOOK NOW!

Intermediate Excel Course
For Learnership Interviews (On appointment only)
1st Floor - SpecCon Holdings (above Huge PC),
1294 Heuwel Ave
Centurion, 0046
South Africa

For Corporate Appointments
4th Floor, Block 2
Anew Hotel Centurion (Conference Centre)
Cnr Gordon Hood and Hendrik Verwoerd Drive
Centurion 0046
South Africa

Contact Details:

Tel: 012 667 4928
Email: [email protected]



VAT No: 4410263224

*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela