Microsoft Excel

Course Overview

Now that you have been working with the advanced features in Microsoft Excel, you are
ready to take your skills to the next level. Please note that you should know how to use the
commands shown in the DPA Excel Intermediate and Advanced course before attending this
course. This course will focus especially on Excel formulas and functions and how to create
an efficient and well designed spreadsheet.

On Request Only - Contact DPA

Course InformationRelated Training

Duration: Two-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Create a Well Designed Spreadsheet

Logical Functions

Text Functions

Date and Time Functions

Statistical Functions

Lookup and Reference Functions

Database Functions

Math & Trig Functions

Financial Functions

Data Tables

Data Validation

Pivot Tables

Array Functions

What If Analysis (If time Permits)

Application Overview: Microsoft Excel 2003

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.