Category: 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

Why Excel Skills Are Important in the Job Market

If you are looking for a job, or hoping to move to a better one, you’re probably doing all the right things: Networking, updating your social presence on LinkedIn, honing your resume. But are you also improving your skills? And in particular, are your Excel skills where they need to be?

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

Microsoft® Excel® – Getting Help

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

When to Use Microsoft® Excel® for Text Products

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