Microsoft Excel has many functions that help you produce calculations, statistics, and tables. Some of these functions do not even make it into the official list in the software. DATEDIF is one of those hidden functions that can help you calculate periods of time. The result can be shown in days, months or years. We’ll explain how it works.
The XLSX format has been the standard format for Microsoft Excel files for some time now. Microsoft replaced the old XLS format with a new file extension back in 2007. Since then, all workbooks in the popular spreadsheet program have been saved as XLSX files. Here, you will learn how to open these files and how to use them in older versions of Excel.
VBA in Excel stands for Visual Basic for Applications. The programming language can be used to create useful Excel tools to automate recurring tasks. Excel’s VBA programming is one of the easiest ways to exchange Excel data with other Office applications such as Word or PowerPoint. Learn all the basics in our VBA tutorial.
How do you convert XLSX to XLS? Sometimes an Excel spreadsheet is sent to you in the wrong file format. The easiest way to allow you to work with the information is by converting it into the correct format. You can either convert XLSX to XLS directly in Excel or use an external converter.
What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...
A Gantt chart is a useful tool in project management. Using this graphic, teams are able to quickly gain an overview of the timing of tasks. To be able to create this kind of chart, however, you don’t necessarily need any kind of specialist software. You can also create a Gantt chart in Excel without any difficulties. We’ll explain step-by-step how it works.
It can often be incredibly time-consuming to search for a specific entry in an Excel table by hand, which is where VLOOKUP comes into play. This practical function allows you to find the exact value for a specific search criterion. The VLOOKUP function is indispensable for managing price lists, members directories, and inventory catalogues. To ensure you can benefit from this practical function,...
Excel offers over 400 useful functions. The AND function is one of the most popular ones. It allows you to check whether spreadsheet values meet certain conditions in just a few clicks. This article provides step-by-step instructions on how to use Excel AND with the help of an example. We will also show you how to get the most out of Excel by combining it with the IF function.
Excel is an integral part of everyday business activities. Whether it is being used for tables, statistics or spreadsheets, this software simplifies complicated calculations and data analysis. The Excel OR function is one of the program’s easy-to-use commands. In this guide, we will explain and provide practical examples to illustrate how it can be used to make simple comparisons and check...
Besides its clear tables and informative diagrams, Excel impresses in its ability to perform complex calculations automatically. Microsoft’s spreadsheet software offers many different tools to help you do just that. For example, you can use Excel’s SUMPRODUCT function to add and multiply values in a single step. We’ll explain how it works.