Have you ever had to reopen an old workbook – or worse, a workbook that was set up by someone else – and figure out what was going on in it, update it without being sure that you weren’t going to break some of the calculations?
Microsoft Excel
Troubleshoot Excel Formulas with a Shortcut
Review all the formulas in your workbook quickly. On Friday, a longer article will tell you about troubleshooting worksheets. Here's how to get started: Switch from values to formulas with CTRL+`(that's single quote, the key just above the tab key on your Irish /...
Use a shortcut to scroll through Excel sheets
Sometimes, you need a good keyboard shortcut for Excel spreadsheets. When you are looking for values across multiple sheets in Excel, for instance. Use this precious shortcut instead of clicking through endless sheets with your mouse.
Learn to Automate Excel with Macros and VBA
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...
The Excel error that changed history (and why you don’t want to be the person who done it)
Carmen Reinhart and Kenneth Rogoff made a big mistake in Excel. The two Harvard economists miscalculated that countries with public debt of 90 percent of GDP or more tend to experience a slower growth at a (negative) rate of -0.1% when actual data suggests the...
Updated Post: Budget 2013 Universal Social Charge (US) Calculator (Excel)
Get the new calculator from this updated post #Budget2013 @OfficeCorner
Automate any spreadsheet: Excel Macros and VBA course. Dublin and nationwide.
Announcing this new course: Holy Macros! Unleash the Power of Excel with VBA (Course) Course Objectives At the end of this Excel Macros & VBA course, you will be able to: Record, edit and troubleshoot macros understand the Excel Object Model, write...
Date functions in Excel: last Monday, next Sunday, this month, this year
Understand how Excel treats dates and you will be able to create useful calculations and filters
Universal Social Charge (USC) Formula in Excel
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...
What is Power Pivot for Excel
If your data comes from multiple sources or you run out of cells (17 billion!) in Excel, activate PowerPivot and the Data Model.
All about Microsoft Excel