Microsoft Excel Data Management
Course Code: MSEXDMA
Duration: 1 day
Price: £385
Upcoming Events
- Virtual Classroom
- Tue 9 June 2026
- 1 day
- £385.00 (€445.00)
- Virtual Classroom
- Wed 12 August 2026
- 1 day
- £385.00 (€445.00)
- Virtual Classroom
- Mon 30 November 2026
- 1 day
- £385.00 (€445.00)
- Virtual Classroom
- Wed 24 February 2027
- 1 day
- £385.00 (€445.00)
- Virtual Classroom
- Wed 5 May 2027
- 1 day
- £385.00 (€445.00)
Course 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.
Target Audience:
This course is designed for those wishing to gain the skills necessary to automate some common Excel tasks.
Course Objectives:
By actively participating in this course, delegates will be able to:
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
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
Passwords and security issues
Prerequisites:
To be successful in this course, we recommend you first attend 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.
Further Information:
For more information or to book this course, please contact our Course Enquiries Team on 0117 370 1970 (Option 2) or email us at enquiries@skilltec.co.uk.
You can also find more courses in this curriculum by visiting our website: www.skilltec.co.uk
