Excel Advanced

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course is designed to take delegates through performing complex data analysis, using complex formulae, importing and exporting of data and introducing them to recording macros and editing in the Visual Basic environment.
Course Contents
Data Validation
Setup Rules for Data Entry
Display Help and Error Messages
Text to Speech
Lookup Function
Horizontal
Vertical
Across Worksheets
If Statements
Simple
Nested
‘AND�and ‘OR�
Scenarios
Create
Summarise
Merging Summaries
Beyond Basic Functions
Date Functions
Index() & Match()
And, Or
Statistical Functions for Lists (Countif)
Text Functions �Left(), Mid(), Len(), Upper(), Proper(), Lower()
Miscellaneous functions �indirect
Views and Reports
Creating Views
Add Scenarios
Using Report Manager
Grouping & Outlining
Goal Seeker
Setting Up
Running
Parsing / Importing Data
De-limited Data
Fixed Length Data
Shared Workbooks
Saving to Network
Multi-user Functions
Keystroke Macros
Create the Macro
Overview of VBA
Editing Macros Using Visual Basic (VB)
Assigning Macros ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Excel Advanced training resources.

Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports
Excel - Formulae and Functions
Excel Intermediate
Excel Foundation
Excel VBA
FrontPage Advanced
FrontPage
MapPoint
Outlook
Powerpoint - Advanced
Powerpoint

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.