How to Create a Button Link in Excel – Link Between Worksheets
When we are building dashboards in Excel, we often want to build links between worksheets or spreadsheets. To do that we can use hyperlinks. This was kind of a life changing concept to me because it allowed you to build and style your own buttons into whatever...
Excel Customer Aged Receivables Dashboard: Summarizing Your Aged Receivable Data To Help You Make Quicker Decisions
Building an Excel customer receivables dashboard came to me when I realized that most companies seem to really make use of their invoice information to look at their customer credit performance. Reviewing how your customers are doing in terms of making their payments...
Excel Formulas Not Working Part I: Understanding Relative, Mixed and Absolute Referencing
I know what you're thinking. The title of this post is a sad attempt at stringing together an English phrase that actually makes sense (i.e. Excel Formulas Not Working). To that I say, you're absolutely right! Nevertheless, it seems that the majority of people out...
Excel Navigation Shortcut: Double Click Your Way to Faster Spreadsheet Navigation
This is an incredibly easy and simple tip and an Excel navigation shortcut that I quite honestly had no idea existed until just recently. I've always used Ctrl + left/right/down/up arrow to quickly get to the top/bottom of my current columns or start/end of my...
11 Reasons Why You Should Check Out The VLOOKUP Book From Chandoo.Org
I recently purchased a copy of Chandoo's The VLOOKUP Book and realized that it was the first piece of material that I had read that covered pretty much all of the bases when it came to the Vlookup formula and other lookup formulas in general. Because I was able to...
29 Excel Skills And Tips You Need to Learn – A Tutorial For Beginners
I first started really using Excel when I moved out of my first position right out of University into my role as an Inventory Controller for a company that sells products in the mining industry. Now that I've settled into my even newer role with the same company as a...