Microsoft Excel 2010 Training with an Exam

Extend your skillset and expertise by completing this comprehensive course in using Excel 2010. Step-by-step training takes novice Excel users and teaches them how to build professional quality spreadsheets with which to capture, manipulate and report on data.

In just three modules learners will move from understanding the most basic principles of Excel 2010, to mastering the most advanced concepts needed to build enterprise-class spreadsheets. They will then be more than ready to sit the bundled Microsoft Office Specialist exam and earn one of the world’s most sought-after spreadsheet qualifications.

The Microsoft Excel 2010/2013 Training with an Exam package is best suited to:

• Professionals who need to learn how to create and manage business-class spreadsheets using Microsoft Excel 2010 to track and report data.
• Employees who want to expand their knowledge of the Microsoft Office suite of applications and become a proven expert.
• Individuals who would like to learn and apply some of the more advanced Excel techniques to help them be more productive.
• Individuals who would like to build their own spreadsheets for use at home or at work.

Using an intuitive blend of instructor-led videos, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach means that students can work at their own pace, as and when suits them – all they need is an Internet-connected computer and a copy of Microsoft Excel 2010.

At the end of the course students will be able to sit the Microsoft Office Specialist exam which is included in the cost of the package. The exam is delivered online and uses genuine skills testing, rather than a multiple-choice quiz or written essay exam. At the end students will receive instant confirmation of their success along with a downloadable certificate proving their achievement.

Students can also rely on the social networking platform to ask for help should they encounter problems whilst completing exercises, or to share their own tips and advice with other learners.

key learning points

The Microsoft Excel 2010/2013 Training with an Exam package is split into three sections – Basic, Intermediate and Advanced. Starting gently with the basics of understanding the Excel interface, training quickly moves on to cover:

• Entering and editing data into cells and workbooks.
• Creating formulae to perform automated calculations or other data functions.
• Preparing and printing spreadsheets for use offline.
• Inserting pivot tables to provide additional analytical potential.
• Copying and pasting data into cells, and inserting other objects like images into a sheet.

The Intermediate modules cover several more advanced topics including:

• Creating a sparkline.
• Editing and auditing formulae to ensure they are delivering accurate calculation results.
• Sorting and filtering data to display pertinent information more quickly and assist with other analytic tasks.
• Creating and managing charts to visually display key data.
• Using multiple workbooks to manage separate, but related data.
• Freezing panes and autosizing columns to make it easier to read data.

Finally students will master a number of advanced Excel 2010 topics including:

• Using the VLOOKUP function to find precise data more quickly.
• Using “Paste Special” to transpose data and save time re-editing and reformatting information.
• Deleting duplicate records to maintain data integrity.
• Grouping data for analysis.
• Applying conditional formatting to highlight certain datasets based on user actions.
• Protecting data using passwords or the Final and Read Only designations.

The course modules cover all these topics and more, ensuring students will demonstrate complete mastery of Excel 2010 by the end of their studies.

advantages of this course

This three-phase course helps students move quickly from understanding the basics of Excel to mastering advanced techniques of using spreadsheets that they can immediately apply to their own projects. More importantly still, learners will be ready and able to sit their Microsoft Office Specialist (MOS) Excel 2010 exam.

Other benefits of the Microsoft Excel 2010/2013 Training with an Exam package include:

• The skills and experience required to create useful spreadsheets that can be used to analyse and report on key business data and inform strategic business decisions.
• Bundled exam fees means students can sit their MOS qualification as soon as they have finished the course materials
• A boost in confidence when building new spreadsheets from scratch.
• An in-demand skill that will help secure new opportunities at work.
• A good understanding of Excel 2010 that can also be used to train other employees.

Upon completion of the Microsoft Excel 2010/2013 Training with an Exam package, students will have an advanced working knowledge of building spreadsheets and will be fully prepared to sit the included Microsoft Office Specialist qualification exam.

• Units of study

Introduction In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.
List of Lessons:

• Introduction to Excel
• Data entry and editing
• Worksheet navigation and basic settings
• Cell range selection
• Manipulation with cell ranges
• Cell inserting and deleting
• Text and cell formatting
• Number, Date and Time format
• Formatting via style gallery
• Working with files and windows
• Printing smaller tables
• The AutoSum button and formula copying
• Custom formula creation
• Work with functions
• Chart creation
• Chart formatting
• Proofing
• Basic Excel settings
• Getting help

Intermediate In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.
List of Lessons:

• Lock
• Advanced cell formatting
• Conditional and custom formatting
• Templates
• Workbook properties and work with sheets
• Sharing workbooks and tracking changes
• Comments and workbooks comparing
• Copying options, orders and lists
• Formula creation and absolute links
• Errors and formulas dependencies
• Connected sheets
• The IF, MIN, and COUNT functions
• Functions and formulas used for Date and Time data
• Functions for working with text
• Rounding off
• Financial functions
• Techniques of work with relation tables
• Data validation and sorting
• Go To, Find and Replace orders
• Printing larger tables
• AutoFilter
• Criteria table and advanced filter
• Database functions
• Outlines and totals
• Splitting text into columns
• Pivot table
• Editing pivot tables and charts
• Advanced chart editing

Advanced In this course, you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.
List of Lessons:

• Work with range names
• Form creation in a sheet
• Protection options within workbooks
• Conditional calculations
• Conditional calculations using SUMIF and COUNTIF
• Working with an array
• Calculation criteria in database functions
• Using functions for searching in tables
• Data import
• Work with Microsoft Query
• Complicated queries in Microsoft Query
• Data merging
• Sheet scenarios
• Resolver
• What-if analysis and goal seek
• Statistical methods and functions
• Macros recording and usage
• The VBA code view and editing
• Webpages, links and e-mail sending
• File security
• Permission control
• Introduction to XML
• Working with data in the XML format