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).
Xero has always used its partner network to reach it's users. I remember one claim…
The purpose of a well designed course is to provide a series of steps for…
I've tried and tested hundreds of software programs over the last 25 years and I've…
Working with our graduates we've discovered that organisations are still looking for staff who can…
We receive lots of bookkeeping course enquiries from students who are changing careers and want…
Am I speaking gibberish or just crazy? No, I'm speaking the language of eInvoicing! PEPPOL…