Blog Feed
Excel Formula References: Why Copying Formulas Sometimes Goes Wrong
Have you ever copied a formula to another tab in your workbook, and the result was not at all what you expected? Moved a formula to a new location and were surprised that it didn’t change? References in Excel work just as you would expect in most situations; but to…
Read More
5 Tips & Tricks for Better Time Management and Multitasking
Go faster! Work harder! Get more done in less time! MULTITASK! Sound familiar? Everyone’s trying to find the secret formula for cramming as much work as possible into every workday. Too often, though, the result of our super-scheduled, overly tight timelines is that we obsess over double-, triple- or quadruple-tasking…
Read More
Three Steps to a New Assertive You
I sat at my desk, fiddling with my pen, clicking the ballpoint in and out repeatedly. Anyone who knew me would have read that as a sure sign of agitation. I tapped the keys of my keyboard and glanced at the clock repeatedly, trying to be obvious – but not…
Read More
What does Professionalism Look like?
What does professionalism look like? Do you “know it when you see it”? Take a look at the images below and sort them into two groups: More Professional and Less Professional. Did you sort all of the people with digital devices into one group or the other? If not –…
Read More
How to Create Shortcuts in Excel by Adding an Excel Macro Button
If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks. But, once you have a macro, how do you access it? The easiest way is to add a macro button to your spreadsheet, for which Excel offers three…
Read More
How to Use Excel Chart Templates
How often do you need to insert a favorite chart style, consistent with your prior submission, to maintain a consistent look and feel to your monthly reporting packages? That consistency is one element that increases the appearance of professionalism—especially if it reflects your company’s brand, typography, and color scheme. The…
Read More
Using the Age Formula in Excel to Calculate Age
Have you ever needed to calculate a person’s age from a birthdate in Excel? Or find the number of years since the last audit? Excel includes two functions that perform well: YEARFRAC and DATEDIF. The YEARFRAC Function YEARFRAC gives the number of years between two dates. The FRAC is short…
Read More