Tag Archives: Excel

Excel’s Newest Features That You’ll Want to Know About!

Excel’s Newest Features That You’ll Want to Know About! thumbnail

If you use Excel through an Office 365 subscription, you know that new features appear regularly throughout the year. Because of this ‘trickle’ you might easily miss something new and useful, especially if your updates take place automatically in the background. As we head into a new year, here are several new features and functions…
Read More

Top Excel Interview Questions to Prepare For

Computer skills and Data analysis are among the top “hard” skills that employers are looking for in job candidates. Employers want to know that you can use the tools you need to stay organized, to communicate important information and accurately interpret the information you use daily. Microsoft Excel is the most popular spreadsheet tool in…
Read More

5 Excel Data Entry Tips and Tricks You’ll Wish You’d Learned Earlier

When you start learning Excel, you begin by using the simplest methods for entering data and creating calculations. It is a credit to the software that so many tasks are able to be performed by the most inexperienced of users right from the beginning of their training. Once you gain experience and confidence, however, these…
Read More

How to Lock Cells in Excel to Protect Your Work from Changes

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

How to Password Protect an Excel File

How to Password Protect an Excel File thumbnail

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

Using the Excel Pivot Table Grouping by Month to View Data Differently

Default Image

PivotTables have some useful “hidden” features that can make interpreting your data even easier. One such feature allows you to view data by date groupings (such as month, quarter, even week and hour of day). By grouping within the PivotTable itself, you avoid constantly changing your source data and creating multiple PivotTables from the same…
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