Basic Excel Formulas and Functions
Excel formulas and functions are powerful tools for performing calculations and data analysis. Formulas are custom calculations you...
top of page
Recent Posts
How to Remove Extra Spaces from Text
Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....
How to Change Cell Color in Excel
Changing cell color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...
How to Wrap Text in Excel and When to Use it
The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...
How to Find and Replace Values in Excel
Find and Replace allows you to find specific information across large workbooks and make sweeping changes if necessary. Contents: 1....
How to Link Workbooks in Excel
When working with multiple Excel workbooks, you'll often find yourself needing to reference numbers from one workbook in a separate...
The Basics to Creating and Using Formulas in Excel
Formulas are an integral part of Excel, and are the defining feature that elevates a workbook far above a simple calculator. Contents: 1....
How to Extract Everything to The Left of a Specific Character in Excel
A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to pull out...
How to Quickly Copy Worksheets in Excel
Often times you'll want to create copies of existing worksheets to tweak or use as a template elsewhere in your workbook. There are a few...
How to Change Text and Font Color in Excel
Changing text color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...
How to Use the Format Painter in Excel
The Format Painter tool will help you quickly copy the formatting from anywhere in your workbook, saving you the time and hassle of...
How to Remove Duplicates in Excel
Sometimes it is necessary to remove duplicate items from a column or duplicate rows out of an entire table. Removing duplicates will help...
How to Freeze Rows and Columns in Excel
Often times when scrolling through data in Excel, you want to keep the top few rows visible so you can easily see the column headers...
How to Hide and Unhide Sheets in Excel
Often, you won't want every worksheet in your workbook to be able to easily be viewed by everyone. Hiding and unhiding sheets will let you p
How to Zoom in Excel - 5 Methods
When working in Excel, it can sometimes be difficult to get an overview of an entire worksheet, especially if you're working on a smaller...
What is Paste Special in Excel? Everything You Need to Know
Paste special allows you to copy any cell or range of cells, and paste specific characteristics from those cells, it is also one of the...
What Is the Best Way to Learn Excel?
Excel is massive. It can be intimidating to learn. What's the best way to start? What different methods are there to help you learn?
What is Excel? A General Overview and History
What is Excel? Why do people use it? What came before it?
Understanding the Basic Layout of Excel
If you're just learning to use Excel, learning to navigate efficiently is a crucial building block that will allow you to get better,...
bottom of page