Excel Clustered Column AND Stacked Combination Chart

Learn how to combine clustered column and stacked column in the same chart in Excel. There are many workarounds to achieve that, but we find that our method is the most comprehensive.

Excel Reset Week Number Every Month (start from Week # 1 every new month)

Find out how you can use the WEEKDAY and WEEKNUM functions in Excel to be able to reset the Week Number at the beginning of every month.

Excel Dynamic Chart with Drop-Down

With these simple steps you can easily create an interactive chart in Excel which will for sure impress your team. Once you learn the basics for dynamic chart ranges, you can create any dynamic graph you need in Excel.

Optimized Excel Line Charts: Prevent Drop to Zero

Learn how to create dynamic line charts and avoid common problems, such as line series dropping to zero and positioning the legend at the end of the line series.

Lookup Values Across Multiple Worksheets in Excel

In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

Excel Dependent Drop Down List with Tabular Data

How do you create conditional lists without name manager? You can use the offset formula directly in the data validation box. Watch this video to find out how.

Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

See how to set up a dependent dropdown list. In this example, the first dropdown list is the column headers of a table, and depending on what the user selects, that will define the contents of the second dropdown.

BMW Corporate Report Makeover in Excel: Better Tables in Reports

How could BMW improve the presentation of their tables in their 2015 annual report? Take a look at some suggestions for better presenting data in tables in this tutorial.

Corporate Report Makeover: Alternative for Excel Doughnut Charts

Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1)

In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on some of the tables and graphs used in the report. When comparing sales volume difference year over year, a cleverly formatted bar chart will be much more effective in telling the story than a simple table.

Excel – Use Symbols in Pivot Slicers

Learn how you can use symbols instead of text in your Pivot slicers to create visually effective Excel dashboard reports.

Excel Solver – Example and Step-by-Step Explanation

Quickly find out where you can find Excel’s Solver tool and how you can use it to solve for the optimal solution to your problem. It’s sometimes seen as an Advanced Goal Seek.

1 24 25 26 27 28 30

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

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