All Tutorials

Excel Debug Formulas and Correct Errors

In this video tutorial, you will learn about the various tools you can find under the Formula Auditing group in Excel that can help you figure out the problem whenever you get stuck or your formula throws an error.

Continue Reading

Dynamic Series Labels in Excel

Default legends often put a lot of effort on the chart reader. Consider how you can improve the readability of your charts so that your readers don’t struggle to interpret them. One solution can be replacing the default legend with dynamic series labels.

Continue Reading

Why you Need This Feature Before Distributing Your Excel Files

Discover the Inspect Document feature in Excel. It is particularly useful when you collaborate on files with others. It helps you find hidden information in your workbook, such as comments, personal information, hidden sheets, rows and columns, etc.

Continue Reading

Excel, BI or Both?

Compare the strengths and weaknesses of Excel versus purpose-built Business Intelligence systems, and learn what Excel is really good at when it comes to KPI tracking, analysis and reporting.

Continue Reading
Excel Black Belt course cover

Featured Course

Black Belt Excel Package

What would your life look like if you became an Excel Black Belt? You’ll get the best deal with this (cost savings) package. It will take you from Excel Newbie to Grand Master.
Learn More

Speed Up Your Excel Files

Download the cheat sheet with practical tips to improve the performance and speed of your workbooks.

Continue Reading

Use This Instead of the Pie Chart

A parts-to-whole chart doesn’t necessarily have to be a pie chart which has gotten a rather bad rep in recent years. In this tutorial, you will learn an alternative – a bar chart sorted dynamically by rank, created with the help of RANK, and INDEX and MATCH functions.

Continue Reading

Do you use Dashboards to Manage Risks?

When choosing a business intelligence system to create and implement dashboards, go through the checklist you’ll find in this article. Make sure you understand what an effective dashboard should be.

Continue Reading

Why Managers Might Not be a Fan of Business Dashboards

Some managers are resistant to implementing dashboards to summarize their data, preferring cold, hard numbers. They might be missing a lot of crucial benefits of a well-designed, effective dashboards. In this article, you’ll learn what a dashboard really is, how it can be a cost-saver for the department, and why Excel is the optimal tool for creating dashboards.

Continue Reading