Free Articles and Tutorials: Microsoft Excel
This page contains a listing of free articles and tutorials.
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.
How to Accept and Reject Changes in Microsoft Excel
It takes only four simple steps to accept or reject changes in Excel.
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.
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.
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.
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.
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.
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.
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.
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.
How to Insert a Chart in Microsoft Excel
You can insert a chart into an Excel workbook in just a few simple steps.
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.
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.
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.
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?
How to Quickly Name Multiple Single Cells in Microsoft Excel
You can quickly name cells in Microsoft Excel using their row and column headings.
How to Record a Macro in Microsoft Excel
Follow these five steps to record a macro in Excel:
How to Select a Range of Cells in Microsoft Excel
To select a range of cells in Microsoft Excel, just follow these three steps.
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.
How to Set Tracking Options in Microsoft Excel
It's easy to set tracking options in Excel. Just follow these three steps.
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.
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.
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.
How to Use the CONCATENATE Function in Microsoft Excel
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.
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.
How to Use the LEFT and RIGHT Functions in Microsoft Excel
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.
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.
How to Use the VLOOKUP Function in Microsoft Excel
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.
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.
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) 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