How to use the average function in excel and go to special | #04 إتعلم حيل إكسل مع دكسلو 🇹🇳

2 years ago
1

How to use the average function in excel 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
#howtousetheaveragefunction #average #averagefunction #excel #اكسل #gotospecial

Loading comments...