Finally, an EASY Way to Calculate Percentages in Excel | PERCENTOF Function
It is easy to calculate percentages in Excel with the PERCENTOF function.
This new Excel function was introduced with the GROUPBY and PIVOTBY function of Excel but can be used in any formula to calculate percentages, such as percent of total, or percent change since last month.
📚 Resources
Download the practise file used in the video
https://computergaga.com/_excel/files/formulas/percentof.xlsx
Advanced Excel Formulas book
https://www.amazon.co.uk/Advanced-Excel-Formulas-Unleashing-Brilliance/dp/1484271246
⌚ Timestamps
00:00 Introduction
00:24 Calculate percentage of total
01:45 Percentage change since last month
02:32 PERCENTOF with GROUPBY and PIVOTBY
03:23 GROUPBY function with PERCENTOF
04:32 PERCENTOF function in PIVOTBY
06:32 Percent of parent row total
📺 Related Videos
https://youtu.be/FfXjooeY68U - Choose columns for dynamic array formulas
https://youtu.be/X2ybRZbvR5k - 8 things to know about dynamic array formulas
https://youtu.be/333IMGoNAqo - 11 PivotTable tips in 11 minutes
Find more great free tutorials at; https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
TikTok ► https://www.tiktok.com/@computergaga
#excelformulas #excel #exceltutorial