Search Results

Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can’t add a formula to the drop-down version of the data validation. But there is another way.

Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

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.

Discover 3 free options to create and insert your electronic signature in a PDF document, WORD or any other document of your choice. This makes it easy to sign pdf or other documents really fast.

Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.

Find out to quickly use column stats in Google Sheets to get information about a specific column. Cleanup suggestions is another new feature in Sheets – but can you rely on it?

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.

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

With SmartFill in Google Sheets you get to auto fill a column based on a pattern. For example, if you’d like to grab the first name of a person, you don’t have to write the formula. Just write the end result and Sheets will fill down with the correct formula.

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.

Learn how to use Filter and Filter Views in Google Sheets. A Filter View is really easy to create. Plus, you get to sort your data without changing the original sort order.