08 6210 8500
Great news! XLOOKUP is going to replace INDEX MATCH eventually but in the meantime….. We've written a number of articles in the past around how INDEX MATCH is a technically better option compared to VLOOKUP. However, it is a trickier formula and therefore not as widely used. In May 2016 Wyn, added a new [...]
This eBook has some great ideas on how to have more fun in Excel than you can poke a kitten at (usually at your colleague’s expense!) *evil laugh* If you’d like some ideas for some mischievous adventures that will mess with your friend’s head (and their models), download this now! You'll learn things [...]
A collection of our favourite keyboard shortcuts in Excel. Pin it up on your wall & share it with your friends. Shortcuts to save time and maximise productivity including: Creating charts faster Faster formatting Navigating a large spreadsheet and 19 more!
By Wyn Hopkins This simple tip may save you a lot of time and effort, but it must be used carefully. With the arrival of Excel 2013 we were finally able to easily split Excel between two screens and happily copy and paste between the two with full paste capability and without the worry of worksheet [...]
58 Crazy Excel Stories (that are probably happening in your company right now)!Crazy things happen when you mix untrained users with Excel.It’s not really rocket science. Crazy things would happen with any complex system if you don’t train people properly.But many companies simply assume that everyone knows Excel, so they don’t need much (if any) [...]
Stop merging cells! One Microsoft Excel Insider has been quoted as saying that 53% of Excel Users merge cells. There is a standard tool on the toolbar called “Merge and Center”, it “merges” two or more cells into one and then centers the text horizontally within the merged cell. This can cause a number of [...]
The Great 48 Excel Toolbar We love Excel & Word and they can do some pretty amazing stuff. But sometimes there are a lot of unnecessary steps and clicks which are quite annoying, especially when you’re using Excel all day long! So we developed these toolbars for ourselves and now we’re sharing them [...]
In the current environment, reducing costs and increasing productivity are the keys to success. This was emphasised strongly by a recent PriceWaterhouseCoopers (PwC) report which found that profits at the world's top 40 mining companies, including BHP Billiton and Rio Tinto, slumped by half as the mining boom came off its highs, then reduced by [...]
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 [...]
Drag letters the same as numbers Is it possible to have Excel increment the letters of the alphabet in the same way it increments numbers, when you drag the fill handle? By Neale Blackwood Yes, Excel's Custom List feature will allow you to do that. The easiest way to create a Custom list is [...]
Alt + Enter = Insert a line in a cell Keyboard Shortcut By Neale Blackwood To insert a line within a cell hold the Alt key (next to your space bar) and press Enter. This inserts a fixed line break in the cell. This operates differently to the Wrap Text format. Wrap [...]
F4 key - Repeat last action and add $ signs Keyboard Shortcut By Neale Blackwood The F4 function key has a dual personality. When used normally it will repeat your last action. This is useful for formatting, deleting rows and other operations that require a few keystrokes. Pressing F4 can reduce the keystrokes. Its [...]
Pay my invoice
