Search Results

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.

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.

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.

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.

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.

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.

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.

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

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.

Goal Seek is part of the What-If Analysis tools, which you’ll find in Excel’s Data tab. It allows you to find the values necessary to achieve a target. Learn all about it in this tutorial.

Learn how to customize the Excel theme and make it the default by saving it the Excel Start folder.

Learn a simple method to deal with gaps in your data, specifically missing dates. You don’t want to display them in a chart, but Excel treats a date axis as continuous and will try to connect the line.