Search Results

This is a simple but advanced Pivot Table technique in Excel. If you’d like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

With Version Recovery and Version History in Google Sheets you get to easily revert back to any previous version of your Google Spreadsheet. You can even create Named versions and use cell edit history to track changes to values inside cells.

With Microsoft Forms you can easily create surveys & quizzes to share with others. You can export the Microsoft Form results to Excel (You can also create an automatic connection between Forms and Excel online). Check out the complete tutorial to find out more.

Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don’t notice when we watch presentations we love. I’ve broken it down into 5 tips which you can apply to your PowerPoint slides.

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.

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It’s a mix of Google sheets basic to advanced functions and hidden features.

Do you know these 5 PowerPoint hacks? With these you can get your PowerPoint presentation done a lot faster. Not only that, but your presentation will also look more professional.

Histogram charts are easy to make in Excel. It might not be straightforward though how to adjust the bin numbers. It’s really easy once you know. Check out this quick tutorial.

Did you know you have access to absolutely FREE Excel add-ins which can improve your reporting, data analysis and make your life a LOT easier? I share my top 6 useful and free Excel add-ins in this post.

Working with time in Excel – for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.

The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. Should you use this function in your files? Find out more in the complete tutorial.