Categories
Excel

Excel Tools

In this post I’ll be introducing three Excel tools I use for data cleansing that take only a few clicks.

Categories
Excel

Excel Logical Functions

Here are six more useful functions to use in Excel. This time, logical functions that return a result based on the conditions.

Categories
Excel

Excel VLOOKUP

VLOOKUP lets Excel do the hard work of matching up a value from one spreadsheet to another. It saves time and is an essential Excel tool.

Categories
Excel

Add-Ons for Google Sheets

If you’re new to Google Sheets there are some great addons you can use to add functionality and make it feel more like Excel

Categories
Business Intelligence Excel

Dashboard Design

There are some simple things you can do to make the message clearer and quicker for the user to understand.

Categories
Excel

Excel Pivot Tables

Here is the second part of my Excel series showing the tools I use for ad hoc analysis and data cleansing.

Categories
Excel

Excel Functions for Text Cleansing

Microsoft Excel should be part of your analysis toolkit for ad hoc analysis and data cleansing.