Quick Gantt Chart

How can you create a Quick Gantt Chart in Excel? A Gantt Chart is great for visualizing and presenting your project plan. But let's say, you just setup a preliminary project plan in Excel. You did that with the help of WORKDAY and NETWORKDAY

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data

5 Design Tips for Better Excel Dashboards

What results do you want to show in your Excel dashboard? What should readers take away from it? These five design tips will help you showcase your data clearly and directly. Scroll down for the video. Learn how to create this interactive Excel report

3 Ways to Improve Readability of Excel Stacked Charts

Add Total Values, Percentages & Dynamic Legends   There is so much potential to improve the standard Excel stacked chart. For one, adding total values outside the last stack would ease comparison between categories. Adding percentages to the stacks would also help identify and

Dependent Drop Down Lists in Excel

Learn how to create conditional drop-down Excel Validation lists using the INDEX function, OFFSET, CHOOSE and INDIRECT Functions. In this video, I'll show you how you can use the OFFSET formula, CHOOSE formula and INDIRECT function to create drop-down lists that are dependent on

VLOOKUP and HLOOKUP Basics

VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns.