Category Archives: Excel®

Hidden Security Options in Excel

Default Image

If you have any experience in Excel, then you have probably found a few reasons to want to secure your workbooks.  Here’s an example of what happened to Mary.  She spent weeks making the perfect worksheet for her sales team to collect data about their sales.  Then, accidentally, one of the sales reps deleted five…
Read More

Create a Custom AutoFill Series in Excel

Default Image

Excerpted from QuickClicks Microsoft Excel 2016 Reference Guide You have a set of offices and sales regions, products and specific business time units (quarters, semi-annual) that you enter repeatedly. AutoFill would be helpful, but the default AutoFill lists do not contain these terms. What can you do? Create a customized AutoFill list. When you have…
Read More

Create a 3-D Power Map in Excel

Default Image

Microsoft’s latest release of Excel has some powerful updates. Our latest 2016 highlight is the popular Power Map add-in. This feature can plot geographic and temporal data on a globe or custom map in a three-dimensional presentation. You can view data changing over time and create animated presentations called “tours”. Imagine you’re creating a presentation…
Read More

Accounting Magic – What You Need to Know About Accounting Excel Formulas

Default Image

Accounting is more than just debits and credits. It is the calculation and analysis of those debits and credits that generate accounting information an organization can act upon. Let’s take a look at two types of reports a professional in the Accounting Department might be asked to generate. Then, we’ll see how that information can…
Read More

Excel Finance Formulas

Default Image

Given the number crunching power of Excel, you might surmise that when it comes to calculating money matters, it really shines. And, so it does. In order to understand how the various financial functions, work, there are a few components to understand. Most of the fifty-five functions that are classified as financial functions in Excel…
Read More

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories