Excel

How to calculate time in Excel
How to calculate time in Excel quickly and easily
  • Online sales

You can use the SUM function to quickly add up several values. But if you want to calculate hours in Excel, you first have to adjust the format of the cells. The format has to be correct, otherwise you’ll encounter problems when you add up more than 24 hours. In that case, your total could be missing an entire day. We’ll teach you how to add hours in Excel and avoid common mistakes.

How to calculate time in Excel quickly and easily
SEO add-ins for Excel - easily connecting data
SEO add-ins for Excel: optimizing and editing all in one
  • Search engine marketing

SEO data is the bedrock for any successful online marketing venture. The calculating power of Excel is a boon to data analysts when it comes to processing metrics and analysis data. But how can these large quantities of data gathered from SEO tools be directly processed in Excel? SEO plugins for Excel offer a very practical possibility here. We present the most useful extensions here.

SEO add-ins for Excel: optimizing and editing all in one
Excel if-then statements
Excel if-then: how the IF function works
  • Online sales

Excel’s if-then statement is one of its most helpful formulas. In many situations, you can create a logical comparison: if A is true, then B, otherwise C. To use this useful if-then formula in Excel, you first need to understand how it works and precisely how to use it. For example, which syntax rules does the IF function follow, and how can you extend the formula?

Excel if-then: how the IF function works
Excel macros: The useful scripts
Excel macros: How to optimize your work process with the popular spreadsheet programs
  • Online sales

Excel, the spreadsheet software from Microsoft, has been one of the most popular solutions for years when it comes to handling the ever-increasing flow of data. Simple, well-structured tables, meaningful diagrams, or complete budgets can easily be created. For daily office life, many companies can hardly imagine functioning without the Office application. But the more complex the project is, the...

Excel macros: How to optimize your work process with the popular spreadsheet programs
Excel shortcuts
30 Excel shortcuts to speed up your work
  • Web analytics

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

30 Excel shortcuts to speed up your work