Forum Login | Courses Login

AVERAGEIF Formula in Excel

AVERAGEIF Formula in Excel

by | Jun 10, 2020 | Online Business Courses

The AVERAGEIF Formula is used to return the average (arithmetic mean) of all the cells in a range which you reference that meet given criteria.=AVERAGEIF (range, criteria, average_range) Below are the formula syntax for the averageif formula Range (required) –...
20+ Formatting Tips In Excel

20+ Formatting Tips In Excel

by | Jun 10, 2020 | Online Business Courses

These 20+ formatting tips will help make things easier on the eye! Good presentation is crucial for a good impression on top management and provides an easier way to look at your work. 1) How to hide Page Layout/Disable View Gridlines in Excel Hiding the gridlines is...
20+ Date Formulas In Excel

20+ Date Formulas In Excel

by | Jun 9, 2020 | Online Business Courses

These 20+ date formulas can save you lots of time and struggle as you can develop several shortcuts! Dates are arguably one of the most important aspects of Excel to understand because they are used almost in every scenario of reporting. The following 20+ Date...