-
Please login to continue
-
Sign Up For Free
Join the World’s Largest Free Learning Community
- Already have an Alison account? Log In
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
6
Modules
36
Topics
3-4
hours
Modules (6)
Resources ()
-
learn about advanced data manipulation using ms excel 2013, creating scenarios and statistical analysis.
-
Module 1
Automating Worksheet Functionality
Resources availableIn this module, you will be introduced to steps on how to update workbook properties. A macro is an action or a set of actions that you can run as many times as you want, you will discover how to create and edit a macro. You will also learn how to apply conditional formatting and data validation criteria to ranges of cells in your workbook.Automating Worksheet Functionality - Learning Outcomes
Start TopicUpdating Workbook Properties
Start TopicCreating and Editing a Macro
Start TopicApplying Conditional Formatting
Start TopicAdding Data Validation Criteria
Start TopicAutomating Worksheet Functionality - Lesson Summary
Start TopicAutomating Worksheet Functionality - Assessment
Start Assessment -
Module 2
Auditing Worksheets
Resources availableIn this module, you will be introduced to steps on how to trace cells. You will learn how to troubleshoot invalid data and formulas, how to watch and evaluate formulas. Excel allows you to group rows or columns so that they can be hidden or displayed with a single mouse click. You will learn how to create a data list outline using Excel 2013.Auditing Worksheets - Learning Outcomes
Start TopicTracing Cells
Start TopicTroubleshooting Invalid Data and Formula
Start TopicWatching and Evaluating Formulas
Start TopicCreating a Data List Outline
Start TopicAuditing Worksheets - Lesson Summary
Start TopicAuditing Worksheets - Assessment
Start Assessment -
Module 3
Analyzing and Presenting Data
Resources availableIn this module, you will be introduced to the creation of sparklines, as well as create scenarios and perform a what-if analysis. You will learn how to perform a statistical analysis using the analysis tool pack. You will also learn about how to create interactive data using power view.Analyzing and Presenting Data - Learning Outcomes
Start TopicCreating Sparklines
Start TopicCreating Scenarios
Start TopicPerforming a What-If Analysis
Start TopicPerforming a Statistical Analysis with the Analysis ToolPak
Start TopicCreating Interactive Data with Power View
Start TopicAnalyzing and Presenting Data - Lesson Summary
Start TopicAnalyzing and Presenting Data - Assessment
Start Assessment -
Module 4
Working With Multiple Workbooks
Resources availableIn this module, you will be introduced to steps on how to consolidate data. When you create formulas in Excel and refer to a data point in another workbook, Excel creates a link to that workbook. This module teaches you how to link cells in different workbooks and how to merge workbooks.Working With Multiple Workbooks - Learning Outcomes
Start TopicConsolidating Data
Start TopicLinking Cells in Different Workbooks
Start TopicMerging Workbooks
Start TopicWorking With Multiple Workbooks - Lesson Summary
Start TopicWorking With Multiple Workbooks - Assessment
Start Assessment -
Module 5
Exporting Excel Data
Resources availableIn this module, you will be introduced to steps on how to export Excel data. A comma-delimited file is one where each value in the file is separated by a comma. You will learn how to import a delimited text file, integrate Excel data with the web and how to create a web query.Exporting Excel Data - Learning Outcomes
Start TopicExporting Excel Data
Start TopicImporting a Delimited Text File
Start TopicIntegrating Excel Data With the Web
Start TopicCreating a Web Query
Start TopicExporting Excel Data - Lesson Summary
Start TopicExporting Excel Data - Assessment
Start Assessment -
course assessment: MS Excel 2013 Advanced
-
Module 6
Course assessment
Resources available