Visual Basic for Application (VBA) is the programming language which powers Excel macros and many other Microsoft Office applications, like Word, Outlook and PowerPoint. The benefits of learning VBA are many: You will be able to automate repetitive tasks. You will...
Did you have a bit of a shock when you received your payslip at the start of the year? Did you gasp? Did you reach for your calculator to double-check the amount but then realised you were a little confused by the Universal Social Charge (USC) calculation rules given...
If your company data comes from multiple sources or you find that the limit of 17 million cells in an Excel 2003 sheet (17 billion in an Excel 2007-2010 workbook format) is a problem, get some PowerPivot love in Excel 2010. Power What? An add-on for Excel 2010 (or...
Want to know the impact of changing one cell in your spreadsheet on the rest of your data? Want to create interactive scenarios but don’t have time to learn scenarios or programming? Create an interactive spreadsheet with simple conditional formatting and watch cells...
