Turning your cluttered spreadsheet of data into living, actionable information can be as simple as adding visual cues. Unless you are really good at doing date calculations in your head, conditional formatting is especially helpful when determining ages or anticipating birthdays and anniversaries. The following steps show how to perform a common Human Resources task:…
Read More
As a continuation of our post last week, we decided to expand on some great uses from conditional formatting. Highlighting negative values in red and using several built-in conditions is great when you are starting out, but you are not getting nearly enough bang for your buck! Here are three ways to get more out…
Read More
Excel lives up to its name when crunching numbers or organizing data. However, when you want to convey ideas beyond the table or graph, you will almost certainly turn to Word or PowerPoint. In the examples below, we are going to look at several different ways you can export, or incorporate, spreadsheets into your Word…
Read More
Becoming an Excel expert is more than learning functions and cobbling together formulas. A significant part of using Excel to its full potential is knowing the art of data management. This includes everything from knowing how to set up your worksheets to managing data entry to good maintenance practices. Here are several tips to good…
Read More
Ever find yourself wondering if Excel could help you answer the question: “What values would I need to get a known result?” The What-if Analysis features, available in Excel 2010 and up, give you the tools to do just that. Unlike functions and formulas that take given values and return a result, what-if scenarios allow…
Read More
If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel’s What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to look at Scenarios. What is…
Read More
To follow using our example, download MacrosForBeginners.xlsx Once you get comfortable navigating Excel, it won’t be long before you start to hear about this wondrous feature called a “Macro” that can leap tall projects with a single keystroke and make boring tasks go by faster than a speeding bullet. While Macros aren’t really the superman…
Read More
The best way to manage our time in the workplace isn’t necessarily to have a more comprehensive schedule, but instead to have a smarter schedule. The real trick is to make sure you have the energy and attention to deal with all your tasks. Here are some tips to help you do just that:
One of the best approaches to time management is to acknowledge that no one can do everything. Yet, many time management trainers still focus on schedules and productivity instead of prioritization, energy and coping with distractions. The truth is that time is limited and you are a finite resource. The effort to “keep up” can…
Read More
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
Tepring Crocker is a freelance copywriter and marketing consultant. Her projects include everything from course development and webinars for business training clients such as Fred Pryor Seminars to email, website, and content marketing strategy for small businesses in the Kansas City area. Tepring has been active in internet marketing since 1998 where she started as a product and content manager at Go.com, a search portal owned by Disney.
Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
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.
