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).
Melio primarily competes with other accounts payable and payment automation platforms, including BILL (Bill.com), Tipalti, Stampli,…
As the end of the financial year (EOFY) approaches in Australia, small business owners need…
[A casual chat between two friends – Sam, a job seeker wanting to upskill, and…
In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…
Have you seen the recent ads promotion 90+ % approval from their customers? The claims…
Intuit is hunting for ways of helping their software become more relevant to Australian small…