Most popular top 5 Excel help videos

At Computer Tutoring as well as running training courses, the team have been busy creating bitesized help videos. 

Last year, 5 videos proved to be the most popular. As they have already helped thousands of Excel users we wanted to share the top 5 videos with our Cambridge Network community.   

  1. How to Calculate VAT in Excel
  2. How to use a Pivot Table Calculated Field
  3. Index Match Multiple Criteria
  4. How to create a financial year in Excel

 

Top 5 Excel Help Videos 

Access out top 5 videos along with text help and pictures for that little extra help!
 

1. How to Calculate VAT in Excel

  • How to calculate the gross from the net
  • How to calculate the net from the gross
  • How to calculate VAT

2. How to use a Pivot Table Calculated Field

  • What is a calculated field?
  • How to add a calculated field to a pivot table
  • How to calculate the percentage of two columns in a pivot table

3. Index Match Multiple Criteria

  • How to take the index match function to the next level
  • What is Index Match multiple criteria?

4. How to create a financial year in Excel

  • Financial year calculation
  • How to get the 6th of April financial year calculation
  • Financial quarter calculation 
  • Sorting a pivot table by financial year
  • Financial Year Using EOMonth

The team hope you find these helpful!

If you have an Excel issue you would like a help video for please let us know. 



Read more

Looking for something specific?