advanced excel course, excel courses, excel training
advance excel courses

Advance Excel Course(2 Day Course)

WHAT IS THIS COURSE ABOUT?

This course is thus designed to give you the best training needed to increase you efficiency and accuracy in you work. We have only included the best and most sufficient content in this course.

WHO SHOULD ATTEND THIS COURSE?

We will never show anyone away, but we see to many people who think they can jump in and do an advance excel course and be good in excel. It is not that easy. You will have to have a good understanding of the basics of excel. Things like navigation, look and feel and basic formulas has to be second nature already. If it is not, then we recommend that you do our basic excel courses and intermediate excel courses first. Even after that you will have to practice a bit before attempting this course.

Anyone, in any business can attend. Engineers, financial and admin people see a great improvement in their work after this course.

COURSE OUTLINE

Unit 1: Advanced functions

Topic A

Logical functions (OR, AND, NOT, IF, IFERROR)

Topic B

Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, SUMIFS, COUNTIFS, AVERAGEIFS, ROUND)

Topic C

Financial functions (PMT)

Topic D

Displaying and printing formulas

Unit 2: Lookups and data tables

Topic A

Using lookup functions (VLOOKUP,HLOOKUP)

Topic B

Using MATCH and INDEX

Topic C

Creating data tables

Unit 3: Advanced list management

Topic A

Validating cell entries

Topic B

Exploring database functions

Unit 4: PivotTables and PivotCharts

Topic A

Working with PivotTables

Topic B

Working with PivotTables

Topic C

Formatting PivotTables

Topic D

PivotCharts

Unit 5: Exporting and importing

Topic A

Exporting and importing text files

Topic B

Exporting and importing XML data

Topic C

Querying external databases

Unit 6: Analytical options

Topic A

Goal Seek and Solver

Topic B

The Analysis ToolPak

Topic C

Scenarios

Topic D

Views

Unit 7: Macros and custom functions

Topic A

Running and recording a macro

Topic B

Working with VBA code

Topic C

Creating functions

Unit 8: Conditional formatting and SmartArt

Topic A

Conditional formatting with graphics

Topic B

SmartArt graphics

PRICING

The cost per delegate is R3,499. This included refresments and manuals.

BOOKING

If you are interested or need more details regarding this workshop please fill in the form below and we will contact you. Alternatively email us: info@speccon.co.za

 

E-mail us by filling out the form below:


advanced excel course, excel courses, excel training
Home | Testimonials | Terms & Conditions | Contact Us | Manuals | Sitemap | Articles | Links