Microsoft Excel 2010 Level 3
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.