Excel 2010 Basic & Advanced for Dummies


We have partnered with world-famous brand ‘For Dummies®’ to develop a user-friendly online learning course to help people of any ability to develop skills with Microsoft Excel 2010 from the very foundations to the expert level.

Report Abuse


Course Introduction

Discover everything there is to know about spreadsheet design with this three-part learning course designed to the take the mystery out of one of the world’s most popular spreadsheet creation program. We have partnered with world-famous brand ‘For Dummies®’ to develop a user-friendly online learning course to help people of any ability to develop skills with Microsoft Excel 2010 from the very foundations to the expert level.

Now a leading tool for planning, budgeting and reporting in workplaces all around the world, Excel 2010 is a user friendly way of creating systems to deal with numerical data. This course has been professionally crafted in the ‘For Dummies®’ style to be accessible to everyone, regardless of prior knowledge. Whether a total beginner or a confident user, learners will be guided through every part of the software with this comprehensive self-paced study course.

Take your time learning the basics of navigating the program and understanding how it manages and displays data. Or, if you’ve been using Microsoft Excel for a while, speed through the early lessons to get to tutorials on laying out your worksheets using tables, formatting and calculations. Later sessions cover the lesser-used aspects of the program, including reporting tools and Pivot Tables, which are a sure-fire way to mark yourself as an professional administrator or analyst.

By far the most popular part of this course according to past students is our emphasis on utilising the little-known tools and tricks to get better results from less effort. The Microsoft Excel 2010 for Dummies course provides everything you need to find your way around the spreadsheet creation process easily and stress-free. Learn the tricks and shortcuts used by IT professionals to get things done in the most efficient ways, and see just how much time and energy you will save.

Key Learning Points

Presented in the trusted ‘For Dummies®’ style, this course assumes no prior knowledge. Lessons are structured progressively, building from the very basics to an advanced understanding of Microsoft Excel 2010. First timers won’t be left behind, and students with some experience of the software can fast-forward their learning, using the interactive assessment tasks to check their understanding.

Some of the topics covered are:

Basic Functions:

  • Understanding spreadsheets and workbooks, and what they do.
  • Opening and saving workbooks.
  • Understanding the menu ‘Ribbon’.
  • Adding, deleting and moving information.
  • Basic cell options; size, alignment and number format.
  • Performing basic calculations.
  • Formatting borders, fonts and colours.
  • Using free templates for budgets, calendars, planners and forecasts.

Intermediate Functions:

  • Programming basic functions.
  • Programming basic functions.
  • Altering the look of cells and tables.
  • Printing with headers and footers.
  • Conditional formatting based on a cell’s contents.
  • Inserting charts and images.
  • Shortcuts and tricks to get things done quickly and accurately.

Advanced Functions:

  • Importing and exporting data.
  • Using Filters to display only relevant data.
  • Advanced formulas.
  • Error-checking, including tracing precedent and dependent cells.
  • Protecting documents with password encryption.
  • Constructing database-like reports using Pivot Tables.
  • Developing personalised macros for the ultimate time-saving shortcuts.
  • Adding macros to the toolbar.
  • Assigning personalised hotkey functions.

Not only will you test your knowledge, you’ll be given the opportunity to try out each skill via structured challenges to tackle at a pace that suits your learning style. Be rewarded with a faster and smoother experience with data management when you know how to make the most of Excel 2010. This comprehensive study course will guide you step-by-step to becoming a true expert.

Advantages of this course

  • Learn work-ready skills for administrative jobs and other computer-based employment, and impress your boss with expert skills.
  • Make sure all your written work looks exactly how you want it with almost no effort.
  • Gain all the skills required for MOS certification, the world’s most recognised qualification in Microsoft Office applications.
  • Become the computer expert in your home or office.
  • Utilise the built-in research and referencing systems for academic study.
  • Develop confidence to tackle even the most complex word processing tasks.
  • No prior knowledge required.
  • Improve efficiency using Microsoft Excel 2010 at home or in the office.
  • Professional skills taught by professional educators.
  • Self-paced study, with up to 12 months to complete the course.
  • Creating an Excel worksheet and entering cell content
  • Understanding workbooks
  • Adjusting rows and columns and formatting cells
  • Using formulas and functions such as square roots, sines, cosines, and tangents
  • Using advanced formatting techniques to make your Excel data accessible
  • Tackling common financial chores such as calculating loan payments and interest
  • Applying Excel’s tools for sophisticated data analysis
  • Creating and formatting PivotTables and PivotCharts
  • Correcting, protecting, and sharing the data in your workbooks
  • Tips and tricks to make you more productive

Additional information

Exams Included


Course Type

Online Course

Expiry Date After Purchase

1 year

Device Processor

1 gigahertz (GHz)

RAM Required

1 GB

Operating System

Windows 10, Windows 7, Windows 8


Google Chrome, Internet Explorer 8 or above, Mozilla Firefox




There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Vendor Information

  • Store Name: Otutu Online Store
  • Vendor: Otutu Online Store
  • No ratings found yet!

We want you to be satisfied, so all eligible courses purchased on Vogate can be refunded within 14 days. For whatever reason, if you are unhappy with a course, you can request a refund, provided the request meets the guidelines in our refund policy.

Certain restrictions may apply and some purchases may only be eligible for credit refunds. For more information regarding our refund policy, please see below.

How to submit a refund request

If you’re looking for instructions on how to submit a refund request, please visit our support and help section

Our 14-day policy

While our 14-day refund policy is to allow customers to learn risk free, we must also protect our vendors from fraud and provide them a reasonable payment schedule. Payments are sent to vendor after 30 days, so we will not process refund requests received after 14 days of purchase.

Additional reasons for denied refunds

We reserve the right, in our sole discretion, to limit or deny refund requests in cases where we believe there is refund abuse, including but not limited to the following:

  • A significant portion of the course has been consumed or downloaded by a customer before the refund was requested.
  • Multiple refunds have been requested by a customer for the same course or other courses
  • Excessive refunds have been requested by a customer.
  • Users who have their account reported, banned or course access disabled due to a violation of our Terms or Trust & Safety Guidelines. 
  • We do not grant refunds for any subscription services.

These refund restrictions will be enforced to the extent permitted by applicable law. 

Product Enquiry