Archive for category General Tips

Keep Row and Column Headings Visible in Excel With Freeze Panes

Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.

Ranking List Entries in Excel

Learn how to rank list entries in Excel without resorting your data.

Copy or Move Tabs in an Excel Workbook

See how to easily copy or move tab within or between workbooks.

Automatically Look Up Data in Excel using VLOOKUP

Tired of looking up information on one spreadsheet just to manually enter it on another? You need to learn about VLOOKUP.

Excel Flash Fill – The Data Entry Shortcut You’ve Been Looking For

Excel’s Flash Fill is an amazing tool that combines elements of text-to-columns, concatenate, and find & replace. Not only is it powerful but it’s unbelievably simple to use.

Forcing Page Breaks in Excel

Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I’ll show you two methods for controlling page breaks in your Excel workbooks. First we’ll cover the old-school method. It’s simple but effective. Just put […]

How to Split One Column into Multiple Columns In Excel

Many times on a project you have the right data, but in the wrong format. In this tip I’ll show you how you can break apart a single column of data into two or more columns in Excel using the Text To Columns feature.

Taking Advantage of Tables in Excel

In the general sense, a table is just data that you have arranged into columns and rows. But in Excel, when you use the Format As Table button to define an area on your spreadsheet as an Excel table, there are several things you’ll be able to take advantage of that make entering and working […]

Highlight Differences In Lists Using Excel’s Go To Command

While there are several ways to compare lists in Excel and highlight differences, an option in the Go To feature provides a really quick and simple method.

Using AND() or OR() in Excel to Allow Multiple Conditions When Using IF()

Excel’s IF() function, in case you aren’t familiar with it, allows you to do one thing if a chosen condition is met, but do something else if that condition is not met. For example, when evaluating test scores you might want to display “Pass” if the score is 80% or better, but display “Fail” if […]