Loading

Microsoft Excel 2010 - Revised 2017

Software Tools
Free Course
Microsoft Excel 2010 is part of the Microsoft Office 2010 productivity suite, and 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 Microsoft Excel 2010 basics course will give you a thorough knowledge and understanding of Excel and its most important applications, so that you can boost your productivity skills in no time at all.
Start Course Now
  • Duration

    6-10 Hours
  • Assessment

    Yes
  • Certification

    Yes
  • Responsive

    Yes
  • Publisher

    Microsoft

Description

Outcome

Certification

View course modules

Description

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.

Certification

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.

Careers

Course Reviews

JIMOH L.
5 months ago
NG
JIMOH L.

The best course ever offered

Bello O.
2 years ago
NG
Bello O.

It was worth every second

Romana S.
2 years ago
GB
Romana S.

Very good course!

Owais Ahmed K.
2 years ago
PK
Owais Ahmed K.

great knowledge

Sara D.
2 years ago
JO
Sara D.

this course was amazing .. thank you

View All Reviews
Notification

You have received a new notification

Click here to view them all