Search Results

Search XelPlus

Master Excel’s SUMPRODUCT Formula

Master one of the most useful functions in Excel – SUMPRODUCT. This tutorial explains how it works in easy steps. You’ll understand why you have to use a multiplication operator or a double negative, how to handle ‘and’ & ‘or’ conditions, and what to watch out for. You can test your knowledge with the attached exercise book.

Waterfall Chart Business Examples

A waterfall chart or a bridge chart is a way of visualizing your data that helps you understand how you got from one balance to another balance. They are very popular in business environment, especially for financial results or HR attrition statistics. Watch a couple of real-life examples to see how they work in practice.

Easiest Waterfall Chart in Excel from Scratch (works with negative cumulative values)

Learn how to create a waterfall chart from scratch, using simple but unusual techniques. This version works with negative cumulative values and allows you to customize the data labels.

Waterfall Chart in Excel 2016 – Advantages & Limitations

Excel 2016 introduced built-in waterfall charts. They are super easy to create, but not fully customizable. Learn how to set up and format a waterfall in Excel 2016 and see what its limitations are.

Excel Charts: Matrix or Excel Panel Charts

When you have too much to tell, don’t tell it all in one overcrowded chart. Instead create a panel chart: ONE chart that looks like mini charts placed beside each other. It’s often called small multiples and significantly improves readability. Learn how to set it up in Excel.

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.

Excel Charts: Dynamic Line Series Labels

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.

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.

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.

Speed Up Your Excel Files

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

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.

How to Fix Slow Excel Spreadsheets

Poor design slows down your spreadsheets. There are several frequent offenders to watch out for. Find out what they are and how you can optimize your workbooks.

Free Guide!

The ONE Critical Excel Skill You Need in 2023

This free QuickStart guide will help you to:

  • Pinpoint the skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill