Rejoignez des millions de personnes qui utilisent l'application Alison – plus rapide, plus simple et conçue pour apprendre en déplacement... 📲 Apprenez en déplacement avec l'application Alison
Explorer
fr
EntreprisesPasser à PremiumAffiliate coin
Language icon fr

Votre vérification d'apprenant(e)

Ceci atteste que Kavya Lakkoju a terminé le cours MS Excel 2013 Advanced sur Alison.

Kavya Lakkoju

ID Alison: 59385206

Cours terminé: MS Excel 2013 Advanced

Date d'achèvement: 01 juillet 2026

E-mail: [email protected]

Temps d'étude total: 3h 57m

Note de l'évaluation finale:

Les cours Alison nécessitent au moins
70% pour réussir l'évaluation finale

83%
Heures CPD complétées:

Heures d'apprentissage approuvées CPD
complétées dans le cadre de ce cours

2-4h

Informations sur le cours

In this free online course learn advanced data manipulation and create scenarios and statistical analysis using MS Excel

Would you like to develop your knowledge of Excel and improve your professional skillset? MS Excel 2013 Advanced is a free online course that has been specifically prepared to teach you about advanced customization and formatting features for easy data manipulation and organization. This course teaches you how to apply conditional formatting with a particular focus on the conditional formatting rules manager. Do you know that the conditional formatting rule manager can be edited? When working on Excel, it is important how to add data validation criteria to ranges of cells in a workbook. In this course, you will learn how to trace cells with the error tracing tool.

Next, this course will teach you how to create sparklines. Completing this course will help you know how to create and save different groups of values as scenarios. We are going to create scenarios and perform a what-if analysis. You will learn how to perform a statistical analysis using the analysis toolpak. When defining a Power View, it is said to be a data visualization technology that lets you create interactive charts. You will learn how to create a power view worksheet and create interactive data. As you proceed in this study, you will be exposed to the steps of data consolidation. When you create formulas in Excel and refer to a data point in another workbook, Excel creates a link to that workbook. This course teaches you how to link cells in different workbooks. The techniques for comparing and merging workbook features will be covered.

Furthermore, you will learn how to export Excel data and save your workbook in different formats. Do you know that an Excel workbook can also be saved in PDF or XPS? This course has been designed for all those who depend heavily on MS-Excel to prepare charts, tables, and professional reports involving a large amount of complex data. If you are a learner who is required to have advanced knowledge of the MS Excel 2013 features, then don’t hesitate to enroll today.

Modules terminés

Module 1: Automating Worksheet Functionality
Module 2: Auditing Worksheets
Module 3: Analyzing and Presenting Data
Module 4: Working With Multiple Workbooks
Module 5: Exporting Excel Data
Module 6: Course assessment

Dites-nous pourquoi vous avez besoin de votre vérification d'apprenant(e) ?



professional/learner-record.learner_verification.Save