Loading...

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

GET 75% OFF THE COURSE
Free Ebook

Latest Tutorials

  • Reset Weekly Number per month in Excel

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

In this video I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to start from 1

  • Excel dynamic chart drop-down for dynamic chart ranges

Excel Dynamic Chart with Drop-Down

Excel Dynamic Column Chart with Average Line Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges,

  • Excel Line chart. Avoid drop to zero.

Optimized Excel Line Charts: Prevent Drop to Zero

You'll face two main problems when creating dynamic line charts in Excel: Problem 1: Line series crashes to zero once you attempt to cut-off the series from a certain point. For example you'd like

  • Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need

Trusted by