COURSE OBJECTIVE:
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
TARGET AUDIENCE:
This course is designed for those wishing to gain the skills necessary to automate some common Excel tasks.
COURSE PREREQUISITES:
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
•
Microsoft Excel Level 1
•
Microsoft Excel Level 2
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses. Delegates may notice differences in their software if using a MAC.
COURSE CONTENT:
• PivotTables
• PivotCharts
• Input tables
• Hyperlinks
• Linking and embedding
• Sorting and filtering data
• Tracking and reviewing changes
• Scenarios
• Data validation
• Notes and comments
• Macros
FOLLOW ON COURSES:
MSEXVBAP1 – Microsoft Excel VBA Part 1MSEXVBAP2 – Microsoft Excel VBA Part 2