ACF Academy
Operations and IT Training Training
Category:
 Operations and IT Training
Targeted Audience:
 
Prerequisites:
 
CPE Credits:
 
Course Level:
 Foundation
 
Date  DurationCostVenueRegister
27-28 Nov 2018  2 days$1350.00New York
22-23 Jan 2019  2 days$1350.00New York
13-14 Mar 2019  2 days$1350.00New York

Introduction to Excel

Seminar Objectives

The principal objectives of this small, bespoke two-day course are to:

l

Explain some of the most useful Excel functions used to manipulate text and data

l

Demonstrate how to use Excel for forecasting

l

Improve delegates’ mastery of formatting, including sophisticated conditional formatting

l

Show how range names can be used to improve readability and usage of spreadsheets

l

Expand delegates’ skills in techniques like data validation, goal-seeking, data tables, macros, and controls

l

Illustrate how Excel can be used with large data sets

l

Explain how to create and use pivot tables and pivot charts

 


 

Seminar content

l

Introducing Excel

l

Editing a spreadsheet

l

Key design issues

l

Commonly used Excel functions

l

Excel functions

l

Formatting skills

l

Range names

l

Further Excel techniques

l

Working with large data

 

 
Accreditation


 

By far and away the best professional course I’ve been too. The course was great – really interesting and challenging, and the instructor was really knowledgeable and enthusiastic.

– Maria H.