Microsoft Excel: Intermediate

Microsoft Excel: Intermediate

Overview and Objectives

This one-day course is designed to help a delegate to develop skills in using Microsoft Excel as a spreadsheet tool. A delegate will learn to manage and link together multiple worksheets, create charts (graphs), apply more advanced formatting & work with databases.

Course Outline

This course consists of 5 modules
Module 1Databases
Creating a Database
Naming a Database
Working with Table
Advantages of using Tables
Sorting a Database
Multiple Sorts
Sort in a Special Order
Sort by Custom Lists
Module 2Using Filters
Types of Filters
Using Custom Filters
Understanding the And/Or
Turning the Filter Off
Advanced Filter
Filter Unique Records
Remove Duplicates
Highlight Duplicates
Module 3Relative & Absolute References
Text Functions
Concatenate Function
Date & Time Functions
Linking – Copy & Paste Link
Create Links to Different Worksheets
Create Links to Different Workbooks
Using the Edit Links to Open Source Files, Change Source Files, Breaking Links to Source Files
Create Picture Links
Create Links between Excel & Word
Consolidate
Reports & Subtotals
Nested Subtotals
Outlining a Worksheet
Module 4Controlling Worksheet Display
Splitting of Panes
Freezing Panes
Validating Data
Separate Text into Columns
Transpose a Range
Copy a Sheet to the same Workbook
Copy a sheet between Workbooks
Moving Sheets
Working with Comments
Sheet Protection with a password
Workbook Protection with a password
Module 5Charting: Creating Charts, Sizing & Moving Charts, Modifying Charts, Changing Chart Types
Adding & Deleting Data
Inserting Chart Titles
Data Labels
Change the Legend
Line Charts
Creating Charts with a Secondary Axis
Creating Picture Charts
Module 6Create a Shape
Modify & Align Shapes
Insert a Picture
Format Pictures

Microsoft Excel: Intermediate

Who should attend?

Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheets to solve accounting and data analysis tasks.

Course Prerequisite

Microsoft Excel: Introduction

Duration

1 Day

Cost

R1 270,00 (excl. VAT)

Includes

  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire
Download Course Information

Microsoft Excel: Intermediate

Course Schedule

View the available course dates