Search Results

What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

Properly sharing your screen in a Microsoft Teams meeting is really important. Screen resolution and whether you share desktop or window is a big factor. How can you properly share a PowerPoint presentation? Let’s find out.

This is the list of the most useful, new Excel Functions you need to know. These will save you from wasting time with complex formulas!

The Query function in Google sheets is one of the most powerful Google Sheets functions. It’s easy to learn if you follow the rules laid out in this tutorial. You’ll be ready to solve any data analysis problem in Google Sheets.

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 2, we will create a Lambda function that can reference itself.

Easily create QR codes for free. You can copy and paste the QR code into any application including Microsoft Word, Excel and PowerPoint. I use a function in Google Sheets to set this up. You can grab your copy and replace the URLs with your own.

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.

With the Office mobile app you can easily convert an image or a photo (jpeg, png or gif) into an editable Word document. You can also use this technique to convert an image into an Excel spreadsheet.

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 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.

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.