Training Course:Mac Excel AdvancedSchool/Trainer:Mouse Training
London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros
Lookup Functions
Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index
Informational Functions
IsText
IsValue
IsDate
IsNull
IsErr, Is Error, IsNa
Summarising Data with Pivot Tables
Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart
General Analysis Tools
Scenarios
Custom Views
Reports
Goal Seek
Solver
Protecting and Sharing Excel Files
Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Customisation Options
Showing / Hiding Toolbars
Customizing Toolbars
Customizing Menus
Adaptive Menus
Default Options
Add-ins
Introduction to Macros
Purpose of Macros
Recording macros
Where to save macros
Absolute and relative recording
Running macros
Custom buttons, menu items, keyboard shortcuts
...''
Please go to the school's official website for training price and schedule:
http://www.mousetraining.com/
Phone:+44 (0) 20 7920 9500
School Address:
7th Floor Crystal Gate
28-30 Worship Street
London
EC2A 2AH
United Kindom
Jobs & Resumes: London
Houses & Roommates: London
Other training courses offered by Mouse Training:
MS PowerPoint 2007 Advanced
MS Visio 2007
MS Project 2007 Introduction
MS Project 2007 Advanced
MS Outlook 2007
FrontPage Introduction
Microsoft FrontPage Advanced
MS Publisher
Mac Excel Introduction
Mac Excel Intermediate
Mac Excel VBA Macros
Mac VBA Macros
Mac Word Advanced
Mac Word Intermediate
Mac Word Introduction
Mac PowerPoint Advanced
Mac PowerPoint Introduction
Mac Entourage
Adobe Flash Intermediate
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:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
| 
