08 6210 8500
Top 10 reasons why winning CFOs are flocking to Power BI for data analysis “A (data analysis) picture is worth a thousand words” (Frederick R. Barnard – 1921) “Time is Money” (Benjamin Franklin – 1706 to 1790) The above truths are even more relevant in today’s real-time business environment. Those who make the smart decisions [...]
Last Cell used on a Row Find the reference of the last cell used in a row By Neale Blackwood One of the articles on our site allows you to find the cell reference of the last used cell in a column. You can see it below in the related articles. Someone asked if there [...]
Hyperlink Me! The HYPERLINK Formula (who knew that formula existed?) can be really useful when navigating around large spreadsheets The simplest format is along the lines of =HYPERLINK("#A1","Any Helpful Message") This would jump you to cell A1 of the current sheet. But that's no different to a normal old Hyperlink (via RIGHT-CLICK > Hyperlink or Insert [...]
So firstly lets face facts. Not many people need to bring 4 million rows of data into Excel. Point accepted. However, some do, and I recently needed to do this. If you've ever checked (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula [...]
A report is more useful if it is formatted well Steps: Highlight the numbers you want to format Right Click - Format Cells Custom > then copy and paste (or type) the following into the Type box: #,##0_);[Red](#,##0);-??_) Done If you want to format other numbers with the same format you can always right [...]
A little macro never hurt anyone So here's a little macro that can automatically create and update a contents page with hyperlinks in any of your Excel files. Create a new sheet (call it Contents for example) Right Click on the sheet tab name and select View Code Copy and Paste the [...]
There are so many keyboard shortcuts and every year I come across new ones. These are a few that I've been using recently: Windows key & e Open up My Computer (windows Explorer) Windows key & d Jump to Desktop Windows key & + Screen Zoom (very useful for training courses and presentations), the minus [...]
3 Bonus Pivot Buttons you really need Free Add-in By Wyn Hopkins If you’re a regular Pivot Table creator then download this free add-in to save yourself some time. There are a number of steps involved when creating a Pivot Table that are often repetitive and frustrating. So much so I’ve created [...]
Depreciation is one of those concepts that sounds easy and simple … until you try to put it into a financial model! In this blog, we start with Excel’s standard depreciation functions, then show two much better, more functional and more elegant ways to calculate depreciation. 1. Excel Functions Excel has some [...]
Introducing SUBTOTAL SUBTOTAL is an incredibly useful function for producing reports … yet it’s relatively unknown. If you have a list of values that are in categories and you want a subtotal for each category, then a grand total at the bottom, it’s so much better & far more reliable than using SUM. The key [...]
Apologies for the Dad joke above (not really), but in this article, I’ll show you how you can easily get data labels on all your data series, even if you have LOTS. All it takes is a little VBA code. In the data set below, I’ve made up some stats about how [...]
The next version of Microsoft Office is just around the corner and we’re nearly as excited as this girl! So here are the top 3 new features (according to us) … let us know if you agree (download preview). 1. Cool new charts Check them out! 2. More Powerful Power Query Power Query has been with [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
