Excel

XLSX to XLS
Converting XLSX to XLS quickly and easily
  • Online sales

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.

Converting XLSX to XLS quickly and easily
Excel: opening XLSX files
Opening XLSX files with Excel
  • Online sales

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.

Opening XLSX files with Excel
Excel DATEDIF function
Excel: The DATEDIF function explained
  • Online sales

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.

Excel: The DATEDIF function explained
Excel WORKDAY function
Excel's WORKDAY function explained
  • Online sales

Many people use dates regularly in Microsoft Excel. However, the problem with dates is that they don’t automatically distinguish between working days and weekends. Excel does, however, provide a function that allows you to analyze working days separately. Using Excel’s WORKDAY function, you can calculate deadlines more precisely.

Excel's WORKDAY function explained
SUMIF in Excel
The Excel SUMIF function explained
  • Online sales

Get more out of Excel: SUMIF makes it easier to work with balance sheets and analyses. Add only the values you need – completely automatically. From simple calculations to complex formulas, it’s all possible with the SUMIF function in Excel. How do you use the function? And what does the syntax look like?

The Excel SUMIF function explained
Excel WEEKNUM function
Excel's WEEKNUM: Deriving the week number from a date
  • Online sales

In business, you often need to know the calendar week number. Excel’s WEEKNUM function ensures that you always have the correct week number right at your fingertips. The function even considers different counting methods, allowing it to adapt to international practices. WEEKNUM can also be combined with other functions.

Excel's WEEKNUM: Deriving the week number from a date
Excel: DATE function
Excel: working with dates
  • Online sales

Many countries have their own unique way of displaying dates and times. To be able to switch seamlessly between date and time formats, the information must first be stored in a universal format. You can use the DATE function in Excel for this purpose. In this article, you’ll learn how to work with the Excel DATE formula.

Excel: working with dates
Free Microsoft Excel alternatives
Microsoft excel alternatives: 5 premium free-of-charge applications
  • Online sales

For many companies, spreadsheets are a part of day-to-day business: whether to compare costs, create diagrams, or plan financing and revenue streams, most tend to gravitate towards Microsoft Excel for their calculations. But is there any way around having to pay for this expensive product? We’ll show you 5 of the best alternatives to Microsoft Excel here.

Microsoft excel alternatives: 5 premium free-of-charge applications
Excel CONCATENATE function
Excel: The CONCATENATE function explained
  • Online sales

Excel usually displays a single result in each cell. Because each cell contains only a single value, the contents can easily be transferred to other functions. However, sometimes you want to combine multiple elements. The Excel CONCATENATE function lets you combine text, numbers, and functions in a single cell.

Excel: The CONCATENATE function explained
Excel: ROUNDUP
Excel ROUNDUP function: How to use it correctly
  • Online sales

The Excel ROUNDUP function for figures is one of the basic functions of many commercial, scientific and financial applications. It is used to make calculation results easier to read where they have numerous decimal places. If you want to automatically round up your results, you can use the Excel ROUNDUP function.

Excel ROUNDUP function: How to use it correctly