Author Archives: cobainbc15

Excel 2016: IFS Function

The following post was created by Kasper Langmann as a guest post for Excel Exposure.  If you’d like to see more of his work, check out Spreadsheeto for more Excel tutorials. Follow along with this workbook that he created specifically for Excel … Continue reading

Posted in Workbook/Reference Lessons | 3 Comments

How to recover unsaved Excel files

Imagine you had been working on a really important Workbook for hours and the system crashes. The file is not saved, and you just lost hours of work because you forget to hit the save button. But what about when … Continue reading

Posted in Quick Tips | Tagged | 8 Comments

Microsoft Excel Error – “The file is corrupt and cannot be opened”

We all have used Microsoft Excel and no matter what field of business we work in, Excel is an absolute necessity. It is a part of the very successful Microsoft Office suite which gets regular updates every year. Of course, … Continue reading

Posted in Quick Tips | Tagged , | 2 Comments

What-If Analysis

Another helpful Excel guide from Acuity Training’s Nick Williams. What-if analysis is a useful way of being able to test out various scenarios in Excel.  You can look at these things two different ways. The first way is to change … Continue reading

Posted in Workbook/Reference Lessons | 9 Comments

Protecting and Hiding Information and Formulas

Thanks again to Nick Williams at Acuity Training for this guest post! When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well … Continue reading

Posted in Quick Tips | 5 Comments

Learn by Doing: Intro to VBA via Adding Charts Example

Thanks to Nick Williams at Acuity Training for this guest post! All content that follows is credited to Nick Williams, and was directly provided to Excel Exposure: This article gives people who are new to Excel VBA a very good … Continue reading

Posted in VBA / Macros | Tagged , , , , | 13 Comments

Excel Shortcuts Cheat Sheet

Our friends over at filtered.com have provided a handy Excel Shortcut info-graphic going over some popular Excel shortcuts.  Hope you enjoy:

Posted in Workbook/Reference Lessons | 6 Comments

Infographic – Benefits of Learning Excel

Why should you learn Excel? SkilledUp.com was nice enough to share this infographic (below) with Excel Exposure.  It details some good reasons for why Excel can be a powerful tool to learn to use. If you’re on the fence about … Continue reading

Posted in Workbook/Reference Lessons | 3 Comments

VBA Important Tips

Thanks to Nick Williams at Acuity Training for this guest post! The lesson will go over the following tips:   1) Loop Through Code 2) Variable Scope 3) Error Checking 4) Immediate Window   VBA Tip #1 – Loop Through … Continue reading

Posted in Workbook/Reference Lessons | Leave a comment

Excel 2013: Real World Examples of New Functions

Real World Examples of Excel 2013’s New Functions [This is the second article I’ve written for the Microsoft MVP blog, but figured I would post it here as well for those who might find it handy] Microsoft included over 50 new … Continue reading

Posted in Function-Related Lessons, News / Updates | 10 Comments