Breaking News & Updates
16 Apps to Customise Hubspot But Xero Gets the Worst Rating ezylearn.com.au/2021/11/16-ap…
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).-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.