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
What does reputation management mean?
Reputation management: How to show your best side
  • Online sales

The good reputation of a company is enormously important – especially on the internet. Through well thought-out reputation management, you can ensure that public attitude toward your brand doesn’t fall into the negative. For this, you need to know your target audience and their interests on the internet, and observe their behavior on social media. We explain what exactly is meant by online...

Reputation management: How to show your best side
Password protect pdf
Password protect PDFs: How to encrypt a PDF
  • Online sales

Due to its platform independence and the option to combine text and images with navigation aids in one document, the PDF format has been one of the most popular file formats for years. But when it comes to the security of the files, the same applies as to all other digital files: Only by password protecting PDFs is the information contained in the file secured. But how do you encrypt a PDF?

Password protect PDFs: How to encrypt a PDF
How chatbots are revolutionizing online marketing
Chatbots in online marketing
  • Online sales

Mobile advertising, Facebook marketing, and marketing automation: marketers are making their way even closer to the user, trying to understand them so they can show them advertisements tailored to their needs and reach them over the most appropriate channel. Only a few have actually been successful on one level of online communication: private Facebook and WhatsApp chat. This should soon change....

Chatbots in online marketing
Convert Excel to PDF
Convert Excel files to PDFs
  • Online sales

In order to convert an Excel file to PDF format, you don’t need a special program. Within the Office application itself, Excel files can be easily saved or exported as a PDF. This is convenient because PDF files are smaller in file size and thus easier to share online. This article shows you how to convert your documents.

Convert Excel files to PDFs
Excel SUMPRODUCT function
Excel: What can you do with the SUMPRODUCT function?
  • Online sales

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.

Excel: What can you do with the SUMPRODUCT function?