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.
This course is normally 6 hours in total. These 6 hours can be delivered in different ways:
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
Managers and Supervisors who need to extract information from databases
We do not have workshops currently, but only provide on site training customized to your needs.
If you are not sure of your level, click here to do our excel assessment.
The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training.
You can also do the course online for $50. Our elearning platform is one of the best in the world and includes videos, simulations, assessments, examples and examinitions. You can print your own certificate on completion of the examination.. Contact us for a free demo.
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