Zoom fatigue

Zoom fatigue: how to avoid getting tired during video conferences

 

The number of people working from home has increased rapidly since the start of the coronavirus pandemic and so has, of course, the number of online meetings. Video conferencing is an indispensable tool in working remotely, but also comes with drawbacks. Video calls quickly...

 

Excel: Transpose

Transposing in Excel – How it Works!

Realigning a table can be a marathon task. Copying or re-typing each cell individually – that takes time. Thankfully, areas can be transposed in Excel. This way, you can convert rows into columns and columns into rows, almost like turning the table on its side. Excel offers a function to do this with paste and even its own array formula.

How to Delete Empty Rows in Excel

Excel: Deleting Blank Rows – Made Easy!

If you regularly work with tables, you often encounter rows without content when reworking and restructuring them. Removing each of these rows by hand is often very tedious. However, Excel can find these blanks automatically. There are even several ways to delete blank rows in Excel. We will introduce two of them in the following.

Excel DATEDIF function

Excel: The DATEDIF function explained

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: INDIRECT Function

Excel: The INDIRECT Function Explained

In Excel, we almost always work with cell references. Rather than entering values into formulas individually, we pull them from the cells of tables. The INDIRECT Excel function enables you to even obtain references from other cells. This can be helpful when working with multiple worksheets or when creating complex formulas, for example. We explain how to use INDIRECT in Excel.

Excel WORKDAY function

Excel's WORKDAY function explained

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 analyse working days separately. Using Excel’s WORKDAY function, you can calculate deadlines more precisely.

Excel: MATCH Function

Excel: The MATCH Function Explained

To work with large data sets, long tables, and large arrays, Excel offers several features. These facilitate navigation through the mass of values and data. For instance, to quickly find the right cell, you can use MATCH in Excel. The function searches for a value and then specifies the position of the cell. How does it work?

SUMIF in Excel

The Excel: SUMIF function explained

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?

Excel: SUM Function

Excel: Calculate the Sum of a Group of Numbers

The Microsoft Excel program is a convenient and easy way to collect and archive data. In addition, mathematical formulas can be solved using the software. For example, you can use the Excel SUM function to add the values of specific cells or entire ranges of cells without having to use a calculator.

Excel WEEKNUM function

Excel's WEEKNUM: Deriving the week number from a date

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: DATE function

Excel: working with dates

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.


Wrap up 2020 with online success
We've cut prices on some of our best products to help you
get your business ready for the festive season.
Save up to 75 %