Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

The Tricks to Writing a Conditional Formatting Rule Formula

When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Left Vlookup Formula

Excel VLOOKUP–Left or Right and HLOOKUP Up or Down

Better late than never to the VLOOKUP week as started by Mr. Excel, Bill Jelen.I have never been a big fan of the Excel...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link