Free Articles and Tutorials: Microsoft Excel

This page contains a listing of free articles and tutorials.


Microsoft Excel

Microsoft Excel: Tips and Tricks

Here we provide a list of free articles and tutorials of tips and tricks that will make you more effective with Microsoft Excel.

Read Article

How to Accept and Reject Changes in Microsoft Excel

It takes only four simple steps to accept or reject changes in Excel.

Read Article

How to Add a Macro to the Quick Access Toolbar in Microsoft Excel

Creating a macro and adding it to the Quick Access Toolbar makes it easier to complete a set of operations that you perform regularly. To add a macro to the Quick Access Toolbar, follow these steps.

Read Article

How to Add Shapes in Microsoft Excel

You can easily add a wide variety of shapes to your Microsoft Excel worksheets, including squares, circles, stars, arrows, smiley faces, lines, equation shapes, and callouts. To insert a shape into a worksheet, follow these four easy steps.

Read Article

How to Convert a List to a Table in Microsoft Excel

Converting a list to a table makes it very easy to format your data and to keep the formatting consistent as you make changes to the data. You can convert a list to a table in three short steps.

Read Article

How to Create a Formula That Spans Multiple Microsoft Excel Worksheets

Creating a formula that spans multiple Excel worksheets is easy. Just follow these steps.

Read Article

How to Create a Pivot Table Timeline in Microsoft Excel

The following seven steps show how to create a pivot table timeline for filtering your Excel data by time.

Read Article

How to Format Numbers in Microsoft Excel

By default, numbers in Microsoft Excel do not show commas and do show the first two decimals (unless they are 0). However, numbers can be formatted to appear in many different ways.

Read Article

How to Freeze Panes in Microsoft Excel

Freezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet. To freeze panes in an Excel worksheet, follow these four steps.

Read Article

How to Group and Ungroup Data in a List in Microsoft Excel

It's easy to group and ungroup data in any list in Excel. Just follow these simple steps.

Read Article

How to Insert a Chart in Microsoft Excel

You can insert a chart into an Excel workbook in just a few simple steps.

Read Article

How to Insert a Pivot Table in Microsoft Excel

The following steps show how to insert a pivot table. A pivot table is an interactive table that can be used to analyze, organize, and summarize large amounts of data. Pivot tables make it easy to rearrange data, quickly displaying it in different ways. Before inserting a pivot table, make sure the data you want to analyze is in an organized table and that your data includes a header row, no empty rows or columns, and no subtotals.

Read Article

How to Insert a Slicer in a Pivot Table in Microsoft Excel

Slicers make it really easy to filter data in a pivot table. Adding a Slicer is similar to adding a second Page field (Report Filter) but is even easier to use. To add a Slicer to a pivot table, follow these four steps.

Read Article

How to Insert Clip Art in a Microsoft Excel Worksheet

A large library of Clip Art, including drawings, videos, sounds, and photographs, is available from Office.com. Inserting Clip Art into an Excel worksheet can be done in just a few simple steps.

Read Article

How to List Day Names in Excel without Dates

In Excel, you can use the TEXT() function to output the day name from a date. For example, if cell A1 contains 12/18/2017, you can output "Monday" in another cell using TEXT(A1,"dddd"). But I needed a way to list 10 day names in a row without any associated dates. And I wanted the list to update based on the value in the first cell. So, how do you do that?

Read Article

How to Quickly Name Multiple Single Cells in Microsoft Excel

You can quickly name cells in Microsoft Excel using their row and column headings.

Read Article

How to Record a Macro in Microsoft Excel

Follow these five steps to record a macro in Excel:

Read Article

How to Select a Range of Cells in Microsoft Excel

To select a range of cells in Microsoft Excel, just follow these three steps.

Read Article

How to Set Locale in Microsoft Excel

If you need your workbook to be available to an international audience, follow these steps for displaying data in a different international format in Excel.

Read Article

How to Set Tracking Options in Microsoft Excel

It's easy to set tracking options in Excel. Just follow these three steps.

Read Article

How to Split the Worksheet Window in Microsoft Excel

When working in Excel, it can sometimes be helpful to split the worksheet in two, so that you can compare data within the sheet. To split the window in Excel follow these three easy steps.

Read Article

How to Use Ink Equations in Microsoft Excel

Ink Equations allows you to "write" equations on a tablet device using a stylus or your finger and then converts them to text. If you are not using a touchscreen device, you can do the same using a mouse. To employ Ink Equations just follow these few steps.

Read Article

How to Use Smart Lookup in Microsoft Excel

Get more insight into what you're working on by using Smart Lookup. Just follow a few simple steps to find articles, top searches from the web, and more.

Read Article

How to Use the CONCATENATE Function in Microsoft Excel

The CONCATENATE function is used to join the contents of multiple cells. For example, if you have a worksheet with first names in one column and last names in another column, you can use the CONCATENATE function to join the first and last names into one column. To use this handy function, follow these three steps.

Read Article

How to Use the Fill Handle in Microsoft Excel

If your Excel data follows a pattern, you can use the Fill Handle to quickly and easily add data to multiple rows and columns.

Read Article

How to Use the LEFT and RIGHT Functions in Microsoft Excel

The LEFT and RIGHT functions are used to return characters from the start or end of a string. The following explains how to select these functions and some possible uses.

Read Article

How to Use the Quick Analysis Tool in Microsoft Excel

Use the Quick Analysis tool to convert your data quickly and easily into a chart or table.

Read Article

How to Use the VLOOKUP Function in Microsoft Excel

The VLOOKUP function is used to pull a value from a list or table based on a corresponding value. For example, if you have a worksheet with a table showing employee names, hire date, and salary, you could use VLOOKUP in a separate worksheet to pull the hire date and salary for individual employees from the first worksheet. In this example, the employee name serves as a key, identifying which information from the first worksheet you wish to pull.

Read Article

Microsoft Excel 2016 Isn't Much Different from Excel 2013 or Excel 2010

Aside from superficial color and labeling, Microsoft Excel 2016 isn't much different from Excel 2013 or 2010. All the menu items and often-used features are the same. There are some new features that you may be interested in. Below is a list of features introduced with the 2013 and 2016 versions. There is also a link to a video that walks you through the Microsoft Excel 2016 interface.

Read Article

Use Excel 365 to create a Sorting Hat and House Point Scoreboard

Here’s the challenge: you are going to randomly assign each of 20 new students to one of the four houses. You will then populate a (between -100 and 100) to a random student. You will show both the student name and house on the scoreboard. And then you will show a list of unique students who scored points. In our solution, we use the INDEX, RANDBETWEEN, ROWS, XLOOKUP, and UNIQUE functions.

Read Article