Join millions using the Alison App – faster, easier, and made for learning on the move... 📲 Learn On The Go With
The Alison App
Explore
en
LMS

Your Learner Verification

This is to verify that Sampson Ebere Ajah has completed the course Microsoft Excel 2013 - Advanced: Master Spreadsheets on Alison.

Sampson Ebere Ajah

Alison ID: 14900033

Course Completed: Microsoft Excel 2013 - Advanced: Master Spreadsheets

Date of Completion: 10th January 2020

Email: [email protected]

Total Study Time: 2h 54m

Final Assessment Score:

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

80%
CPD Hours Completed:

CPD approved learning hours
completed through this course

1-3h

Course Information

Learn how to master spreadsheets with this free online Microsoft Excel advanced training course.

In this online course Microsoft Excel 2013 - Advanced: Master Spreadsheets, learn about the advanced features and functions of Microsoft Excel 2013. The course starts by introducing you to the basic use of function and their arguments, along with how to find the one you want. Then you are taught about financial functions and how to use them, and about date and time functions.

Next the course talks about and demonstrates functions for statistical analysis of your data in Excel, moving to manipulating text with functions. Then the course will discuss how to use look up functions and apply logical operations into your functions. Finally, the course finishes by teaching you how to import data from external sources to your Excel spreadsheets and how to convert a selection in a spreadsheet to a table.

If you are interested in a career in data analysis, or you are a business/IT professional looking to learn new skills, then this is the course for you. Knowing how to use Excel for data analytics is a key skill in many business and IT departments, and this free online course will take your spreadsheeting skills to the next level. So, start this course today and by the end of the week you will have learned how to use advanced functions and formulas to help you supercharge your Excel skills.

Modules Completed

Module 1: Introduction to Advanced Excel 2013
Module 2: Functions
Module 3: Personal and Professional Financial Functions
Module 4: Date and Time Functions
Module 5: Statistical Functions for Description, Prediction and Inference
Module 6: Text Functions
Module 7: Lookup and Logical Functions
Module 8: Connecting to External Data
Module 9: Tables
Module 10: Course assessment

Tell us why you need your learner verification?



professional/learner-record.learner_verification.Save