08 6210 8500
Love them or hate them, Excel charts have always been a key feature. They're a powerful way to visualize data, communicate trends, and highlight anomalies. Excel 2016 has taken charts to a whole new level by adding several charts that users have been requesting for many years! Here’s a quick tour of the top 3 [...]
We’ll go into much more detail on these in future posts but this is very new stuff and we thought we’d let you know about it Key Points: It’s free and it’s pretty amazing. If you want to get more advanced then it is $9.99 per user per month. Pull your data together from single [...]
Sticking with the theme of the health of your spreadsheet, have you ever notice spreadsheet become inexplicably bigger? Suddenly becoming 20MB instead of 2MB. One cause is unused rows and columns. How do I check and how do I fix it? Simple, on each worksheet in your file press End then Home. Your cursor will [...]
Ever get the warning that Excel has “run out of resources” or “too many formats” or you simply can’t paste into it anymore. There’s a glitch in Excel 2010 and 2007 (fixed in Excel 2013) Am I affected? Here’s how to check. Open your Excel Files (your important ones), go to the Home Ribbon [...]
Creating a Waterfall Chart in 5 Steps By Wyn Hopkins A waterfall chart is a great way of illustrating the causes of differences between two data points. The most common being Actual v Forecast or Current Year v Prior Year. It can be quite a tedious manual process to create this chart, [...]
Saving a Default Template By Wyn Hopkins, 26 Jun 15 (updated 30/09/2016) Why? Life can be very repetitive. If you find yourself making the same changes to Excel every day such as setting custom number formats, fonts, cell styles, colours, print headers and footers then you should set up a template. Even better than this [...]
Mail Merge in 7 easy steps By Wyn Hopkins Let’s say we have a list of people that have overdue library books, and we need to email each of them to let them know how many days overdue they are. It’s easier than you think. 1) Set your Excel list of contacts up in a [...]
Power BI Companies of the World By Wyn Hopkins, 13 May 15 Data extracted from LinkedIn based on a company's specialty being Power BI. Kudos goes to the ever-informative powerpivot(pro) team for detailing how to do this.
Display Day of the Week How can I display the day of the week in a cell instead of the date? By Neale Blackwood, 18 Jun 09 To have the day of the week displayed in a cell based on another cell, use one of these formulae (this assumes that the date you are [...]
Display Sheet Name Is there a formula to insert the sheet name into a cell? By Neale Blackwood Yes. In cell A1 insert the formula =CELL("filename", A1). In another cell, enter =MID(A1,SEARCH("]",A1)+1,LEN(A1)-SEARCH("]",A1)) The first formula will display the file's full path. The second formula will display the sheet name. This is also a useful [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
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
