Course details

This course is one of two Excel Advanced courses and focuses on the more specialized and advanced database capabilities of Excel. This will target people who are using Excel to manage large spreadsheets that contain rows and rows of imported data from third party programs in order to generate reports.

Student Profile

This course was designed for students desiring to gain the skills necessary to create macros, analyze worksheet data using database features and formulas and import and export data.

Objectives

  • Using lookup functions
  • Exploring database functions
  • Working with Pivot Tables and Pivotcharts
  • Exporting and Importing text
  • Working with macros
  • Working with text functions

Course Outline

  • Lookup with Data tables
  • Advanced Data management
  • Exporting and Importing
  • Macros and Custom Functions
  • Pivot Tables and Pivot Charts

Requirements

To ensure your success, we recommend you first take the following ExecuTrain courses or have equivalent knowledge:

  • Microsoft  Office Excel  2010 Basic
  • Microsoft  Office Excel  2010 Intermediate
Updated on 22 March, 2016

About ExecuTrain - South Africa

With over 29 years in the training business, ExecuTrain is the trusted and internationally recognized training provider for many companies. We address the training needs from top-level executives to entry-level employees. Keeping in touch with the business needs of our clients allows us to recommend and deliver short term courses for immediate implementation and roll-out into the workplace.

At ExecuTrain, our goal is to listen and deliver “ Training As Unique As You Are.” To achieve this goal we provide business and computer training products and services designed to offer flexible training alternatives that result in the most effective skills transfer. In other words, our training helps you and your company “get the job done”.

Serving People by Increasing Their Effectiveness Through
QUALITY TRAINING AND SUPPORT
 

The ability to perform, to work efficiently, communicate clearly and lead effectively, determines your company's success. It's up to management to ensure that staff are prepared to excel on the job, and to help them progress so that the company can succeed.

With over 29 years in the training business, ExecuTrain has seen it all; from top-level executives who need to keep up with technology trends, to entry-level employees who need an introduction to computers with keyboard and typing skills. With the ever-increasing demands brought on by fierce competition in your market your employees will benefit from a blended training solution. Even minor shortcomings that the most experienced businessperson may have, can be addressed to help them continue to move your company in the right direction.

See all ExecuTrain - South Africa courses
Are you from ExecuTrain - South Africa ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or