Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
We all want to be productive in the workplace, right? This means days filled with tasks that are all considered “top priority.” If you’re like me, you may be good at creating task lists, but do you know how much time to devote to each task? If I’m so organized, why am I still leaving…
Read More
Have you ever lost your macro or decided it is just too useful for only one workbook? You can save your macro in PERSONAL.xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal.xlsb will not be available on other computers.) Save a macro to your…
Read More
Excel records Macros in absolute mode by default. In absolute mode, a Macro will start working in the same cell it was in when it was recorded. If, when it was recorded, A1 was the active cell, then it will return to A1 and begin working from there no matter which cell was selected prior…
Read More
A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table’s filters and analysis. The short answer is “Excel doesn’t do that”. Meaning, there isn’t a simple way to change the Value Field Settings to calculate “Median”. The closest you can get is “Average”. However, averages aren’t…
Read More
The idea of work-life balance can be controversial. Some successful people say that it’s nearly impossible to achieve a real balance between one’s career and one’s personal life. Others use some variation of the tired phrase, “Work to live, don’t live to work.”
At the beginning of a new year, you’ve probably been hearing a lot about work-life balance. You may find yourself asking: How am I supposed to achieve this balance? There are so many suggestions out there that it can be difficult to decide what advice to follow.
The modern office can be hectic. New projects, deadlines and new crises can result in long hours at work. Worse, smartphones enable our jobs to spill over into our homes, allowing emails and messages to demand our attention at all hours.
Sometimes you need your data to tell you more about itself. The versatile IF function is how you can turn raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want a way to quickly calculate…
Read More
Storing information is only part of the useful things Excel spreadsheets can do. Once you have collected a set of data, Excel can help you organize it and analyze it. One of the most powerful tools for analysis is the PivotTable. PivotTables do more than generate graphs out of one or two data points. When…
Read More
Creating reports on a regular schedule is a common task for the business Excel user. When you need to create a Rolling chart that reflects data in a specific timeframe – such as the previous 12 months – you can quickly find yourself in a maintenance nightmare, updating your charts manually to include the new…
Read More
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 9,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars 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 50 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.
