Microsoft Excel is a powerful spreadsheet program that can be used for a variety of tasks, including basic math. Here's how to use Excel as a calculator to perform basic arithmetic operations such ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Microsoft Excel can be a powerful tool for large and small businesses alike. It is used to perform calculations, store and compile data, and create graphs based on that data. A variety of formulas are ...

Using the basic Excel filter function formula Before we explain how to use the Excel filter function with multiple criteria, it’s important to understand how the Excel filter function formula works.

We all have done some basic maths where we used to shorten a number with a lot of decimal digit. If Truncate and Round of sounds familiar, then you got it right. In this post, we will show how you can ...

A basic Excel feature from which many other visualizations derive is the PivotTable. Doing proper data visualization in Excel starts with knowing how to use PivotTables and understanding how they ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Follow these steps to set up a general ledger accounting system in Excel. A small business can use Excel as a substitute for expensive accounting software.

These step-by-step instructions show you how to add the Developer tab to the Ribbon in Word and Excel 2016 and Office 365, and to use it to launch the Visual Basic Editor and access Visual Basic ...