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

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 official Certification, which is a great way to share your achievement with the world. Your Alison Certification 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 Certification 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 Certification is available to purchase through the Alison Shop. For more information on purchasing Alison Certification, please visit our faqs. If you decide not to purchase your Alison Certification, 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 Certification pricing, please visit our Pricing Page.



    You have received a new notification

    Click here to view them all