08 6210 8500
Calculate part of a formula Keyboard shortcut By Neale Blackwood Sometimes when creating a spreadsheet you need to see where errors are coming from. In longer formula this can be difficult. However one technique can make it easier. If you select part of a formula in the Formula Bar and press the F9 key [...]
Extend the Name Box Excel 2007 only By Neale Blackwood New in Excel 2007, you can change the width of the Name Box to allow you to display long range names. If you point to the right of the drop down arrow in the Name Box you will see a double-headed arrow that you [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Create a Flow Chart Built-in feature By Neale Blackwood, 30 Apr 15 Do you need to draw a Flow Chart or document a process? In Excel 2003 and earlier versions, right click the toolbar and select the Drawing Toolbar. In the toolbar there is an AutoShapes button. Click that to see a list of [...]
Merge and Center warning! Formatting issue By Neale Blackwood Ever had an error message which stated that you couldn't do something to a merged cell? Well the merge format is the culprit. The Merge and Center tool on the toolbar is commonly used to format headings to make them look good by centering a [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Using Dates in Dynamic Headings & symbol and the TEXT function By Neale Blackwood Excel stores dates as numbers and when you try to use a date in a heading with the & symbol Excel will display the number, not the date. Hence, if cell A1 contained Sales For and A2 contained 1/1/08 then [...]
Drawing perfectly horizontal or vertical lines Shift key By Neale Blackwood Have you ever tried to draw a perfectly horizontal or vertical line using Excel's drawing tools? It can be done, but it is fiddly and frustrating. Well, next time try holding the Shift key down whilst you're dragging the line and see how [...]
Page Break View Print feature By Neale Blackwood In Excel 2003 and earlier versions the View menu has an option called Page Break Preview. This displays your spreadsheet slightly differently. It usually zooms out so you can see more of the sheet. Areas that won't print have a grey background and the white area [...]
In cell Drop Down Data Validation By Neale Blackwood To create a drop down list in a cell you need to use Validation, which is in the Data menu in Excel 2003 and earlier versions. In Excel 2007 it is in the Data Ribbon in the Data Tools section under Data Validation. In the [...]
Pin the File on the list Excel 2007 only By Neale Blackwood In Excel 2007 when you click the round Office symbol in the top, left-hand corner of the Excel screen, the Recent Document files are listed on the right-hand side of the listing. You may notice a symbol of a pin on the [...]
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