Search Results

What can Google Sheets do and should I learn it? This was a question I asked myself some time ago. I noticed more companies were switching to Google Sheets specially because of the events of 2020. In this post I talk about what Google Sheets can do.

These are 10 Excel features that are better than Google Sheets. This post is like a “top 10 tips and tricks” type of post. Even if you’re currently using Excel, you might discover new tips you can use.

Create an Excel report with the top values and categories. Sort them by ranking and also handle duplicated (tied) values. Get it done fast with Excel new dynamic array Sort & Filter formulas.

Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose – just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.

Discover what Excel’s NEW XLOOKUP Function can do for you and how it can help you with your Excel lookup problem. In this example we use XLOOKUP to lookup values on another sheet (Yes – No more VLOOKUP for these tasks!)

With this complete Excel Gantt chart, you can professionally present your project timeline. It includes task completion, planned timeline versus actual view in one single chart.

What’s an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you’ll find an impressive way to chart survey results in Excel. It’s not as difficult as you think.