The Microsoft Excel Data Manipulation Online Course is designed for those people who work with large lists or sets of data. Big data needs to be effectively filtered, pivoted, outlined, collapsed, expanded and reported in a variety of ways quickly. Once techniques are learnt manually then all processes are automated with the use of macros and basic coding. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable.
The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning. The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.
At the completion of the course, you will be issued with a Certificate of Completion.
Register and join us today!
Comprehensive coverage of:
- filtering and advanced filtering
- remove duplication and data validation
- database functions
- macros and coding
- subtotals and flash fill
- outlining and custom views
- and more
This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.
Microsoft Excel - Data Manipulation Online Course (Level 3)
A basic understanding of working with large lists of data in Excel is required. If you do not have this consider the Level One The Essentials course. Level Two is not a prerequisite to this course, but it is a definite advantage.