Tag: Excel

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

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.

Read More

4 Paste Special Tips and Tricks You’ll Wish You’d Known Sooner

There’s a moment in everyone’s experience with Excel when you are both fairly comfortable using the tool and at the same time recognize just how much more there is to learn! This is often at the point where you want to take on a new task and realize that tools you need aren’t already in your toolbox.

Read More

Top Excel Interview Questions to Prepare For

Microsoft Excel is the most popular spreadsheet tool in use today, so it is likely that you will answer at least some questions about this important program during interviews. This is true whether you are looking for work as a senior manager or an intern.

Read More

How to Freeze a Row in Excel

Why is this mentioned in a post about Freezing Rows? Imagine trying to read a sheet with the headers 1000 rows above the data you are looking at.

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.

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.

Read More

How to Password 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.

Read More

Create a PivotTable Calculated Item in Excel

Excel's PivotTable feature allows you to organize information in such a way that you can answer many questions about your data that would otherwise require lots of formulas, functions and "IF" statements. To get even more answers out of your data, PivotTables offer Calculated Fields and Calculated Items. Calculated Fields…
Read More

How to Unlock Specific Cells in Excel

When using a shared document you may only want to allow specific cells to be changed. Here are some steps to help you keep certain cells unlocked while the rest of the document is protected. Step 1: Select the cell(s) you would like to leave unlocked. Step 2: Go to…
Read More

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

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…
Read More