Microsoft Excel Data Management [SKT_MSEXL4]

OVERVIEW

This course is designed for users who want to take more control of Microsoft Excel and use it to facilitate business decisions.  This course allows users to start analysing data for the good of the business rather than just using it as an end user.

OBJECTIVES

By actively participating in this course, you will learn about the following:

• Create and manipulate PivotTables and PivotCharts
• Use Input Tables
• Create and use hyperlinks
• Understand linking and embedding
• Use various methods of sorting and filtering data
• Use the Track Changes feature
• Use Notes and Comments
• Create and use Scenarios
• Understand and use Data Validation
• Create and run Macros
• Use passwords and security features

AUDIENCE

This course is designed for those wishing to gain the skills necessary to automate some common Excel tasks.

NEXT STEP

MSEXVBAP2 - Microsoft Excel VBA Part 2

CONTENT

• PivotTables
• PivotCharts
• Input tables
• Hyperlinks
• Linking and embedding
• Sorting and filtering data
• Tracking and reviewing changes
• Scenarios
• Data validation
• Notes and comments
• Macros