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? Of course, you may already know about...
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 calculations: last Monday, next Sunday, this month, this year…[Excel Date Functions]
Created for a client who needed to use these as criteria in Excel queries (in fact a Microsoft Query, more about this later), this Excel worksheet shows Excel functions used to determine date ranges such as Monday of this week, last Monday, last Sunday, next Sunday,...
Universal Social Charge (USC) Formula in Excel (aka “What’s the Damage, Boss?”)
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...
Power Pivot for Excel
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...