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.
- How to Calculate VAT in Excel
- How to use a Pivot Table Calculated Field
- Index Match Multiple Criteria
- 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.