Got a quick question or comment?
Send us enquiry.
Enter your details and we will call you back to discuss your requirements
Course Information (Top) | View Dates & Pricing
Overview
FAQs
What's Included?
Why Choose us?
Reviews
Who Should Attend the Course?
Users with a basic understanding of Microsoft Excel 2010 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. Delegates are required to bring with them there own laptop with the Software already installed.
Course Outline
Advanced File Tasks
• Using Windows Explorer within Excel • Saving your Files • Using File Management Tools, Part One • Using File Management Tools, Part Two
Working with Functions and Formulas
• Using Formulas in Excel • Exploring Excel Functions • Using Functions in Excel • Working with Names and Ranges • Working with Array Formulas
Managing Tables
• Working with Tables • Working with Records and Fields • Working with Tables and Filters • Using Excel as a Database
Adding the Finishing Touches
• Research Tools • Using Themes • Adding Text Boxes • Inserting Pictures and ClipArt • Editing Pictures
Showing Data as a Graphic
• Inserting SmartArt • Formatting SmartArt • Adding Symbols, Equations, and Shapes • Sparklines • Editing Sparklines
Course Availability
The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.
What is Microsoft Office New Features
Describes and shows what has been updated within the Microsoft suite for Excel, Word, PowerPoint, Access & Project for 2007 & 2010
What time shall I arrive at the venue?
Please arrive at the venue for 08:45am
Am I using Microsoft Office 2007?
Click Microsoft OFFICE button, click relevant OPTIONS button. Within OPTIONS click RESOURCES to find your version.
Am I using Microsoft Excel 2010?
Click the FILE tab. In BACKSTAGE view, click HELP. Within PRODUCT ACTIVATED, find your version.
- Highly Experienced Instructor
- Detailed User-Friendly Manual
- Pre/Post Course Email Support
- Refreshments
- Attendance Certificate
-
Certified and Approved
We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.
-
Best Price Guarantee
As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.
-
World's Largest Global Training Provider
We offer training in the more locations than any other provider with over 1200 training locations globally.
-
Trusted by Industry Leading Brands
We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few
-
Hands-on, Expert Instructor-led Classroom Training
All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.
-
Dedicated 24/7 Support
We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training