Sometimes we use the EzyLearn blog to provide some free tips from new training material that we create, like manipulating Pivot Tables we mentioned earlier in the week. Today we are announcing that 14 new training videos are now available for our advanced Microsoft Excel course (number 308).

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).

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Who is Melio? US payment provider that might become global because of Xero?

Melio primarily competes with other accounts payable and payment automation platforms, including BILL (Bill.com), Tipalti, Stampli,…

7 hours ago

Top 5 Things Small Businesses Must Do Before June 30 to Get Their EOFY Accounting in Order

As the end of the financial year (EOFY) approaches in Australia, small business owners need…

2 weeks ago

How EzyLearn Gets Xero Skills Into Your Brain (So They Stick!)

[A casual chat between two friends – Sam, a job seeker wanting to upskill, and…

3 weeks ago

Mastering Xero with EzyLearn: Building Confidence Through Practical Learning

In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…

4 weeks ago

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

1 month ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

1 month ago