How to use Excel

Many also have step-by-step instructions below the video.

• Basic maths in Excel

  Let Excel be your calculator. Learn how to add, subtract, multiply and divide using formulas and functions

• Cell references: understanding and using

  Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically.

• Create a chart from start to finish

  Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline.

• Filter data

  Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest.

• Free or lock panes

  Freeze rows and columns to keep specific areas visible when you scroll in a worksheet.

• Sort data

  You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons.

• Using AutoFill

  Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

• Using FlashFill

  Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.

A special thanks to Duke University and Westport Library for sharing these valuable resources.