June 26, 2014
Categories: Formulas
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?
June 19, 2014
Categories: Front Desk & Admin
Tags: Multitask, Time Management
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 and lose focus on our…
Read More
June 19, 2014
Categories: Front Desk & Admin
Tags: Administration, Assertive, Front Desk, how to be assertive
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 TOO obvious (that would be…
Read More
June 19, 2014
Categories: Front Desk & Admin
Tags: Professionalism, Technology
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.
June 19, 2014
Categories: Macros
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 straightforward methods: Add a button…
Read More
June 12, 2014
Categories: Charts
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.
June 5, 2014
Categories: Formulas
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?
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 11+ million learners and 300,000+ businesses achieve meaningful and lasting success. Pryor Learning delivers 17,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access 12,000+ live seminars across the U.S. and Canada and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 40 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
Enter Express Code
Enter Express Code