How to use AVERAGE function and go to special | Excel Practice Case #04 إتعلم حيل إكسل مع دكسلو

In this video we illustrate the use of the average function and the Go To Special dialog box.

Excel provides a dedicated dialog box to access special groups of cells, called "Go To Special". To access this dialog with the keyboard, type Control + G, then click the Special button (or use Alt + S) on Windows. There you'll find a large list of options.

The AVERAGE Function is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.

🙋🏼‍♂️ PLEASE SUBSCRIBE

✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ 🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3OQknMt

SUPPORT THE CHANNEL

👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n

Social Media / Contact Me

🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU 📥 Business Inquiries 👉 dexcelo03@gmail.com

📊 In this course you will learn how to:

• CTRL + ENTER to populate all cells with the Average Function
• Go To (F5) Shortcut, Special, Blanks to highlight all blank cells
• CTRL + Enter to put zero in all selected cells
• Average function uses Zeros in the calculations but not blanks

====================== ✏️ Course developed by Dexcelo.

⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️

0:00:00 - 0:01:15 Intro 0:01:15 - 0:05:14 Using the average function 0:05:14 - 0:07:01 Go To Special 0:07:01 - 0:09:27 Objectives Summary

🔗 Useful Links

⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8

Thank you for your support 🙏🙏🙏 !!!

Tags #excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial ... https://www.youtube.com/watch?v=AKqpGb94wxw