Features Excel Guides
Articles and tutorials about Features, organized so you can find related Excel guides in one place.
41 articles
Learn How to Add In Excel Using the SUM Function and AUTOSUM
We focus here on the SUM function and AUTOSUM feature, demonstrating how these tools are essential for understanding how to add in Excel....
The Best Excel Book to Purchase from Amazon
We have compiled a list of the ten best Excel book options that can help you use Excel with ease and to its full potential. Check this out!...
The History of Microsoft Excel: How It Came to Be
Excel is a popular spreadsheet system, which organizes data in columns and rows. Learn more here about the history of Microsoft excel....
How to Remove Duplicates in Excel: An Easy Guide
Are you wondering how to remove duplicates in Excel? Check out our easy guide for step by step instructions and all the information you need....
How to Round Numbers in Excel: What You Need to Know
Use Excel’s feature to round decimals or large numbers in a spreadsheet. In this article, we'll show you how to round numbers in Excel....
How to Delete Duplicates in Excel: An Easy Guide
Learn how to easily delete duplicates in Excel with our step-by-step guide. Remove duplicate entries and keep your spreadsheets clean and organized....
How to Freeze A Row in Excel: A Practical Guide
Learn to how to freeze a row in excel (or even more than 2 rows) using this practical how-to guide. Excel has an available feature allowing users the ability to freeze a row....
How to Use Goal Seek in Excel
Use this guide to learn how to use goal seek in excel as well as how to put it into action. To use Goal Seek, you will have to open a new sheet....
How to Make a Line Graph in Excel
Organize data by learning how to make a line graph in Excel. Present information over time with this simple guide to creating a line graph....
5 New and Creative Ways To Utilize Excel
Excel is a program that is beneficial to anyone who wants to organize the utility bills or for professionals who need to stay organized at the office. To most Excel users, it can seem like a pretty cut and dry program. W...
The 20 Most Useful Excel Shortcuts to Utilize
Do you use Excel every day but working with it seems slow and tedious? Learn 20 Excel shortcuts that help make creating spreadsheets faster and easier to do....
Pivot Tables (PV Table): Everything You Need to Know
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...
Learn How to Unhide Cells in Excel Using Keyboard Shortcuts or the Home Menu
Learn how to unhide columns in Excel using keyboard shortcuts or the Home Menu methods. While Excel does not allow you to Hide and Unhide individual cells using the Hide/Unhide command, here’s a trick showing how to hide...
The Drop Down Basics: How to Make a Drop Down List in Excel
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. You can follow the instructions to create a new dropdown list...
Where is Control+Home for Excel on a Mac
The control + home keyboard shortcut in Excel for Windows is replicated in Excel for Mac by either fn+control+left arrow or fn+command+left arrow....
Control + Home in Excel for Mac
I figured out how to get a Control + Home keyboard shortcut to work in Excel 2011 (for Mac). It's an Excel Windows favorite of mine....
How to Customize Default Workbook and Default Worksheet in Excel for Mac
Boost productivity is by customizing the default workbook and default worksheet in Excel to reflect your preferences....
Settings and Shortcuts for Excel 2003
Here is a list of things I do to "normalize" Excel 2003. Along with a few explanations, reasons, and/or rationalizations....
Where is the Insert Tab in Excel 2011?
The Excel 2007 and 2010 Ribbon both have an Insert Tab, which does not exist in Excel 2011 (Mac). Here is a chart to tell where each item is located....
Worksheet Tab Protection Icon in Excel 2011
I opened a file from a colleague and realized that the padlock icon on the worksheet tab meant that the worksheet was protected. Only in Excel 2011....
Ribbon Home Tab Comparison - Excel 2010 Windows and 2011 Mac
The Ribbon Home Tab in Excel 2010 (Windows) is quite different than in Excel 2011 (Mac) so here is a guide to finding those things that seem lost....
Create a List in Excel 2008
The List feature in Excel 2008 is a hybrid with a List Wizard providing lots of functionality. However a List with a Defined Name is not updated....
Create a List in Excel 2003
The List Object in Excel 2003 is the forerunner of the modern Excel Table with some of the same features....
Spreadsheet Size in Excel for Windows
Saving an older XLS file to the newer XLSX file format in Excel will not produce a bigger spreadsheet, unless you know the quirk involved....
Spreadsheet Size in Excel for Mac
When you open an XLS file in Excel for Mac versions 2008 and 2011, there are 1,048,576 rows and 16,384 columns. How odd....
Total Row Formulas in Excel Tables
Excel Tables have a Total Row that can be toggled on and off from the Ribbon. Several functions are available when the Total Row is turned on. In Excel 2010 and...
Excel Tables - Styles, Conditional Formatting and Data Validation
Format Excel Tables with Table Styles, Conditional Formatting, and Data Validation. Turn off worksheet gridlines to make the Table more distinctive....
Table Design in Excel
I design a regular data table in Excel, show how it fails, then convert to an Official Excel Table and show how a Table remembers cell formatting....
Migrating to Tables in Excel
I'm going on quest to find out all about Tables in Excel....
Fat Fingers on the Space Bar - A Conditional Formatting Example
There is a Conditional Formatting solution for entering a blank or space character into a cell. A space character causes #VALUE! errors in formulas....
Use Formula Auditing to Help Explain Formulas Excel
When you need to present a complicated spreadsheet, the Formula Auditing feature in Excel visually helps to explain formula relationships....
How to Copy Data to Another Worksheet with Advanced Filter
Unlock the power of Excel's Advanced Filter to seamlessly copy and organize data between worksheets. Learn techniques for precise data migration and efficient workflow....
Sorting with Custom Lists in Excel
Sorting with a Custom List makes things simpler when Excel doesn't have a default sort order to fit your needs....
Open File As Read Only in Excel
To discourage users from making any changes to a macro file you can have the file recommend Read-Only when it's opened....
Sorting Columns From Left To Right in Excel Causes Problems
You may never have the opportunity to Sort columns of data from Left to Right , but beware of some apparent problems . A reader mentioned that when sorting from...
Sorting Columns Left to Right in Excel
A little know option in the Excel Sort feature allows sorting columns of data from left to right instead of the normal top to bottom....
Goal Seek in Excel
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature...
Quick Access File List in Excel 2010
In Excel 2010 there's an new optional feature at the bottom of the File>Recent menu to Quickly access this number of Recent Workbooks....
Equation Editors in Excel 2010 and Word 2011
The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as graphical object. Word 2011 has the same Equation Editor....
Introduction to PowerPivot
PowerPivot works with Excel 2010 to import millions of rows of data from different sources, build relationships, and visualize data with PivotTables....
A Sparkline Example in Excel 2010
Create a dynamic range sparkline graphic to show the last seven data points. Sparklines are new in Excel 2010 and don't work with earlier versions....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us