Skip to main content

EXCEL: AN INTRODUCTION: HOME

An introduction to key Excel features that are short and specific

INTRODUCTION

When you begin to use Excel, it may seem complicated at first. However, you only need to know a few important tips to get stated with making your own spreadsheets! This page will cover all of the basic topics that you need to begin working in Excel. Each video tutorial is two minutes or less. If you’re stuck on a particular skill, you can browse the videos by title and find the skill you want to understand. 

THE BARE BONES

Have you ever worked with Excel before? Have you heard of “cells, rows, and columns” before. If you have not heard of them, start here:

OPERATIONS AND THE FILL HANDLE

Are you lost on how to enter formulas in Excel? Did you know Excel is a powerful calculator? If not, take a look at this video.

THE SUM FORMULA AND AUTO-SUM FEATURE

Want to learn how to use Excel formulas? Want to know how to add up over 9000 entries in Excel? You can learn how to do this here! 

CREATING NEW TABS AND COPYING AMONG TABS

Are you familiar with creating and organizing tabs? Do you have trouble with copying values from tab to tab? If so, this video was made for you! 

FORMATTING GRAPHS AND REGRESSION

Need to learn how to format axes and create regression lines? Want to include legends and label your graphs accordingly? If so, look at the following video:

CHECK FOR KNOWLEDGE

ADJUSTING COLUMN WIDTH AND ADDING TEXT BOXES

Are you having trouble adjusting your columns? Do you need to include a text box in your spreadsheet? If so, take a look at this video:

USING THE F4 LOCK

Are formulas giving you trouble? Does the fill-handle give you trouble with complicated data? Look here for one of the most important features of Excel.

FORMATTING CELL VALUES - CURRENCY AND DATES

Are you frustrated by Excel cells? For some reason you try to put in numbers and they appear as dates in your cells? Well, there’s an easy way to fix this, so take a quick look! 

CREATING EXCEL GRAPHS

Are you confused on how to graph data using Excel? Do you want to learn an easy way to choose an appropriate graph for your data? If so, look here:

ERRORS IN EXCEL

Are you getting #ref, #Div/0, #value, ####. Want to know how to fix these issues? Look here! 

RATE THIS GUIDE