This is the list of videos that are now available:
Video for 3.1.1 – Using AutoFilter
Video for 4.1.1 part 1 – Cleaning up data using AutoFilter
Video for 4.1.1 part 2 – Cleaning up data using AutoFilter
Video for 5.1.1 – Perform an Advanced Filter
Video for 5.1.2 – Advanced Filter using Wildcards (search text within cells)
Video for 5.1.3 – Advanced Filter for multiple search criteria
Video for 5.1.3 – Narrowing search results using Advanced Filter
Video for 6.1.1 – Inserting a Pivot Table
Video for 6.1.2 – Filtering data in a Pivot table
Video for 6.1.3 – Sort dates by month in a pivot table
Video for 6.1.5 – Changing the value field settings in a pivot table
Video for 7 – Creating pivot table charts
Video for 8.1.1 – Get months values using the Choose function
Video for 8.1.2 – Show grades for student results data using CHOOSE function
Our new video references match the many exercise tasks you can complete to master the skills taught in the videos. Everything you watch in the videos you can re-produce using the exercise files that come with the course. The training workbooks contain step by step instructions so you can print them out and practice where-ever you are.
If you are an existing EzyLearn student with LIFETIME access you’ll have access to these new videos and all new content that we create. Stay tuned for more updates soon as we create new videos for the other advanced Excel topics covered in courses 308 and 309. Plus we’ll show you how to create your own macros.
If you like what you read and want to enrol to take advantage of lifetime student access as well as access to all levels of Microsoft Excel for just one price, use our enrolment form. Enrol into the Excel course today and start by 5pm tomorrow (next business day).
I hope you had a good school holiday and enjoyed some time off with family…
Is your name on this list? I want to thank the following students for choosing…
There are many finance professionals — who does your business need? Does your business need a…
Employers like small business owners are looking for staff online using Google. From office admin…
Most complete courses are now discounted. If you want to learn something new now is…
The features that each of these companies provide is invaluable for businesses. We can't do…