Amazing April SALE! 🤩 25% off Certs & Diplomas - now on!Ends in  : : :

Claim your Discount!
Explore

Your Recent Searches

    en
    LMS
    en
    Site language

    Your Learner Verification

    This is to verify that Michael Amanquarnor has completed the course Microsoft Excel 2010 on Alison.

    Michael Amanquarnor

    Alison ID: 7671304

    Course Completed: Microsoft Excel 2010

    Date of Completion: 16th November 2016

    Email: [email protected]

    Total Study Time: 0h 43m

    Final Assessment Score:

    Alison courses requires at least
    80% to pass the final assessment

    94%
    CPD Hours Completed:

    CPD approved learning hours
    completed through this course

    0-1h

    Course Information

    Learn how to use Microsoft Excel and how to update spreadsheets more efficiently.

    Microsoft Excel 2010 is one of the most popular software applications worldwide and is part of the Microsoft Office 2010 productivity suite.

    This course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. You can use Excel to analyse data, for example, in accounts, budgets, billing and many other areas.

    You learn how to navigate this revised version of Excel, exploring the menu bar and the different tasks that can be done with it. You will work on sample spreadsheets doing basic math, adding and deleting columns and rows, and preparing the worksheet for printing. You will learn how to represent your data visually to show trends, patterns and comparisons between the data in a chart, table or other template, and how Excel 2010 will automatically do all the calculations for you once you add in the formula.

    This course will be of great interest to all professionals in business, finance and many other areas that need to analyse data in accounts, or keep records of stock or schedules, and to anyone trying to keep track of their personal finances at home.

    Modules Completed

    Module 1: Module 3: Basic Tasks in Excel 2010
    Module 2: Microsoft Excel 2010 - First Assessment
    Module 3: Microsoft Excel 2010 - Second Assessment
    Module 4: Module 17: Microsoft Excel 2010 - Final Assessment
    Module 5: Resources
    Module 6: Resources
    Module 7: Module 16: Microsoft Office 2010 Security
    Module 8: Module 1: Make the Switch to Excel 2010
    Module 9: Module 2: What's New in Excel 2010
    Module 10: Module 4: Create Your First Spreadsheet
    Module 11: Module 5: Get to Know Excel 2010 - Create Formulas
    Module 12: Module 6: VLOOKUP - What It Is and When to Use It
    Module 13: Module 7: Understand Data at a Glance with Conditional Formatting
    Module 14: Module 8: Sparklines - Use Tiny Charts to Show Data Trends
    Module 15: Module 9: Use Excel Tables to Manage Information
    Module 16: Module 10: The IF function - What It Is and How to Use It
    Module 17: Module 11: How to Create a Basic Chart in Excel 2010
    Module 18: Module 12: Create and Run Macros in Excel 2010
    Module 19: Module 13 : Figure Out Dates by Using Formulas in Excel 2010
    Module 20: Module 14: Plan Payments and Savings in Excel 2010
    Module 21: Module 15: Keyboard Shortcuts

    Tell us why you need your learner verification?



    professional/learner-record.learner_verification.Save