Search Results

What is the Excel Spill error and how can you fix it? Sometimes it’s obvious but sometimes it’s not clear why you get this error. Find out why and how to fix it in this article.

This free training is your complete guide to Microsoft Teams. You’ll learn how to hold online meetings, schedule meetings, use channels, chat and upload files. Bookmark it for future reference.

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

In finance, leverage (or gearing) is about using debt (other people’s money) rather than equity (your own money) for the purchase of an asset. This tutorial explains when this can be good for your business and when it can ruin your business.

Get the latest stock data in Excel with Excel Data Types. You don’t have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

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.

Learn how to create a Professional Clustered Column chart in Excel. This Excel chart is not any column chart. It has overlapping bars. It’s a column chart with an overlay. Using an existing chart, we will recreate it step-by-step.

Learn how to use IMPORTRANGE in Google Sheets. You can also use it together with QUERY to import and append data from multiple sheets. IMPORTRANGE is great when you’d like to import data from other spreadsheets.

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 1, discover the LAMBDA logic and learn how to write your first Lambda.

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.

There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It’s simple trick that doesn’t involve Apps Script. Check it out here.

Easily create template replies in Outlook by saving your common responses. You can save it with all the formatting you want. Let me show you how.