Microsoft Exccell 2010 Training Course | 2017 | Alison

Microsoft Excel 2010 - Revised 2017

Learn how to work with spreadsheets more efficiently and effectively with this Microsoft Excel 2010 tutorial course.

Software Tools
Free Course
This free online course on Microsoft Excel 2010 is designed to give you a thorough understanding of Excel and its most important applications. Microsoft Excel 2010 is one of the most popular software applications used by individuals and businesses all over the world. Whether you are a beginner or an intermediate user, this course will teach you all the tips and tricks so that you can boost your productivity in no time at all.
  • Duration

    6-10 Hours
  • Assessment

  • Certification

  • Responsive

  • Publisher






View course modules


Take advantage of this Microsoft Excel 2010 tutorial and learn how to navigate the revised version of Excel. We will help you explore the menu bar and teach you the different tasks that can be done with it. You will work on Microsoft Excel 2010 practical exercises and sample spreadsheets for basic math, adding and deleting columns and rows, and preparing the worksheet for printing. You will also learn how to represent your data visually to show trends, patterns and comparisons between the data in a chart, table or other template.

There are a lot of improvements and new features in the Microsoft Excel 2010 software. You can automatically do calculations once you add in the formula which makes it a great tool for analyzing data in accounts, budgets, billings, and many other areas. With this Microsoft Excel 2010 training course, you will learn to work with formulas and functions as well as use VLOOKUP to search through the data in the spreadsheet. You will also be able to a check conditions with the IF function, describe the save and run macros and calculate dates using formulas.

If you learn the Microsoft Excel 2010 functions and use them to your advantage, then keeping track of your work and business schedules as well as stocks becomes much easier. The software is also useful for planning and tracking your personal and business finances so you’ll know if you’re within or above your budget. So start learning the Microsoft Excel 2010 new features with this Microsoft Excel 2010 training course and stay organized!

Start Course Now


Module 1: Making the switch to Excel 2010

Module 2: What's new in Excel 2010

Module 3: Basic Tasks in Excel 2010

Module 4: Create your first spreadsheet

Module 5: Create Formulas

Module 6: VLOOKUP - What it is and when to use it

Module 7: Understand Data at a glance with Conditional Formatting

Module 8: Sparklines - Use tiny charts to show data trends

Module 9: Use Excel tables to manage information

Module 10: The IF Function - What it is and how to use it

Module 11: How to create a basic chart in Excel 2010

Module 12: Save time by creating and running macros in Excel 2010

Module 13: Figure out dates by using formulas in Excel 2010

Module 14: Plan payments and savings in Excel 2010

Module 15: Keyboard shortcuts in Excel 2010

Course assessment

Learning Outcomes

After completing this Excel course, you will be able to:

  • Describe how to navigate Excel's menu.
  • List the improvements and new features of the software.
  • Explain how to create, save, prepare for printing and apply templates to a worksheet.
  • Work with formulas and functions.
  • Use VLOOKUP to search through the data in the spreadsheet.
  • Identify patterns and trends with conditional formatting, sparklines and charts.
  • Apply a table to the data.
  • Check conditions with the IF function.
  • Describe the save and run macros.
  • Calculate dates using formulas.
  • Work quicker with keyboard shortcuts.


All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:

Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Certificates for completed Certificate courses:

Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping

All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.


    Need Some Help?

    What is Microsoft Excel?
    How much does an online Microsoft Excel course cost?

    You have received a new notification

    Click here to view them all