Overview

The objectives of this course are as follows :-
Creating, Maintaining, Filtering and using Subtotals in a List
Recording, Assigning and Using Macros
Creating and Using User?Defined Functions
Performing “What If” Analyses
Working with Scenarios
Querying a Database
Importing and Exporting Files and Data
Protecting Data

Duration

1 Day

Target Audience

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts

Topics

Working with Lists
Working with Macros and User?Defined Functions
Using Basic Analysis Tools
Using Advanced Analysis Tools and External Data

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.