- Tutor is available to students
Microsoft Office Specialist Excel 2010 Expert
Learning People
Summary
Overview
77-888 Microsoft Office Excel 2010 Expert
This certification is part of a series of Microsoft Office Specialist certifications covering all of the Microsoft Office software applications, and aimed at those who use MS Office programs in their jobs.
What you'll learn
- Applying Workbook Settings
- Sharing Workbooks
- Using Conditional and Custom Formats
- Using Templates
- Working with Advanced Filters
- Creating/revising Pivottables
- Using Range Names
- Consolidating Worksheets
- Using Advanced Functions
- Using Other Functions
- Using Auditing Tools
- Using Scenarios and Goal Seeking
- Using Worksheet Protection
- Creating Charts
- Formatting Charts
- Using Advanced Charting Features
- Recording Macros
- Creating Macro Buttons
Course media
Description
Please note this course DOES NOT include Learning People's exclusive benefits:
- Award winning StudentCare™ - who will be with you every step of the way
- CV detox - who will help you land your dream job
- NUS extra card - you can save thousands with - UK students only
Nor does it include KnowledgeCenter extras:
- Selected online books and videos
- Practice Labs
- Case Studies
- Monthly challenges
- Featured Topics
- Roadmaps
All these extras are included in our KnowledgeCenter bundles for just £200 more. Please search 'KnowledgeCenter' in the course search field for more information.
Enrol today and experience the next generation of online learning...
Who is this course for?
In this course, you will be introduced to the more advanced features of Microsoft Excel 2010. You'll learn how to manage, filter and generate reports from Excel data. The course also shows the participant how to summarise and analyse data using tools such as Pivot Tables, Scenarios and Goal Seek.
You'll also learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyse data efficiently with Microsoft Excel 2010.
Requirements
No prerequisites - just a passion and a desire to learn.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.