Tutorials for Excel, Outlook and Google Sheets, page 4

Excel status bar not showing sum, average or count

Excel not displaying sum, average or count in the status bar can be a frustrating issue, especially when you rely on these calculations for your work. There are several potential causes for this problem, and in this article, we will explore the common issues and provide solutions to get the necessary calculations back on track. Continue reading

Excel status bar missing: how to get it back

When it comes to the analysis of various data sets, the Excel status bar emerges as a vital component, providing users with a wealth of essential information and seamless access to key features. However, there are situations where the status bar mysteriously disappears, leaving users puzzled and unable to access its features. Continue reading

How to calculate standard error of the mean in Excel

Whether you are a student, researcher, or data analyst, understanding the standard error of the mean can help you draw more accurate conclusions from your data and make more informed decisions. This article will show you a few quick ways to calculate the standard error in Excel. Continue reading

#NUM error in Excel - fixing number error in formulas

Are you staring at your computer screen, sipping on your coffee, and wondering why your Excel spreadsheet is suddenly showing a strange error message with the hashtag symbol? It is frustrating, confusing and downright annoying, but fear not! We're here to unravel the mystery of the #NUM error in Excel and help you fix it. Continue reading

Ablebits stands with Ukraine

What is really happening in Ukraine? On the orders of Putin, on February 24, 2022, Russian troops launched an all-out war in Ukraine. Since then, tens of thousands of civilians have been killed, tens of thousands of Ukrainian soldiers have … Continue reading

#NAME error in Excel: reasons and fixes

Even experienced Excel users may encounter errors while working with complex spreadsheets. One such error is #NAME, which can be frustrating to deal with but is usually easy to fix, especially when you know the reasons behind it. Continue reading

How to edit, copy and delete drop down list in Excel

A drop-down menu in Excel makes data entry easier, faster and less prone to errors. Once a drop-down list is created, you may need to change it for a variety of reasons. For example, you may want to update the list with new options, insert the same picklist in other cells, or remove it from the sheet entirely. Continue reading

How to use EDATE function in Excel with examples

Microsoft Excel provides a variety of functions to calculate dates. When it comes to adding or subtracting months to/from a given date, EDATE is the function to use. Additionally, it can help you calculate expiration dates, anniversary dates, due dates, and a lot more. Continue reading

Excel DROP function to remove rows or columns from range or array

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers or footers. In earlier Excel versions, you'd have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by "dropping" irrelevant data. Continue reading

Excel AVERAGEIFS function with multiple criteria

When it comes to calculating an arithmetic mean of a group of numbers in Excel, you'd generally use the AVERAGE function. To average cells that meet a certain condition, AVERAGEIF comes in handy. To find an average with multiple criteria, AVERAGEIFS is the way to go. Continue reading