We’ve all done it. Mis-clicked. Mis-typed. Hit enter when we meant to hit tab. And while it’s frustrating to make mistakes in a spreadsheet of our own data, when managing important company assets those mistakes can have expensive consequences. When many people work on the same spreadsheet, these normal opportunities for errors are multiplied. This…
Read More
Why You Might Need to Protect an Excel File Information in today’s corporate environment is as important as raw materials are to a manufacturer or labor is to the service industry. Organizations collect data from consumers, vendors, employees and even competitors every day. When that data contains sensitive information, then it is in the organization’s…
Read More
Like many software tools, Microsoft® Excel® has a LOT more functionality than most people need for most standard assignments. Consistent with the 80/20 rule, which holds that 80% of the results flow from 20% of the work, most people really only need 20% of the functionality of a tool for 80% of their work. Unfortunately,…
Read More
Microsoft® does a good job of creating different software for different core business functions, however, there can be some overlap between tools. For example, we often select Microsoft® Word for text-heavy documents with tables, but there are times when Excel® may be your best starting point. Here are examples of when it may be best…
Read More
Many of today’s desktop applications are designed to show the final formatting on the screen as you work on the product. For example, in Microsoft® Word, as long as you view the document in “Print Layout” as you are typing, you will generally see on the screen what you can expect when you print. For…
Read More
Jump to: Formatting Shortcuts | Navigation and Display Shortcuts | Formulas and Functions Shortcuts Selection and Editing Formatting Navigation and Display Formulas and Functions
Applies to Excel 2010-2016 Adjusting how rows and columns of data are displayed can quickly become a nuisance. Every extra click you perform to make your spreadsheet readable is time spent away from more important tasks. Here are four tips for making common spreadsheet tasks simpler and faster: Add More Than One Row or Column…
Read More
Worksheets can be linked so that information shared between the two is always identical. This reduces errors and ensures consistency as information only needs to be entered in one place to be available in multiple locations. In our example today, data is gathered and duplicated between employees and departments. One employee compiles a sheet with…
Read More
Have you ever inherited a worksheet that someone else set up or you created and haven’t played in for some time? If you need to update the formulas and functions, but do not know what other calculations will be affected you could quickly make a lot of work for yourself! You might also be hunting…
Read More
Subtotals are dynamic in that they adjust instantly based on filters. They are very useful when reviewing a table, as you can make small adjustments to see different perspectives on the information. Create a Subtotal Determine which column you want to subtotal. Sort the selected column (Column A in this example) so that the like…
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 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 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.
