top of page

Excel Getting Started

Excel is a really powerful application and can seem daunting if you are using it for the first time. It really is quite straightforward to use and allows you do so much from simple calculations to charts and also data management.

Creating and Saving a New Spreadsheet

The first thing to do with Excel is to create a new spreadsheet, this is where you will do your work. Naturally if you will need to save it. It gets saved as a workbook.

VIEW MORE

Saving an Excel Workbook and setting up Autosave

Keep your clients up to date with what's happening. To make this content your own, just add your images, text and links, or connect to data from your collection.

VIEW MORE

AutoFill

Keep your clients up to date with what's happening. To make this content your own, just add your images, text and links, or connect to data from your collection.

VIEW MORE

How to Create Formulas

Formulas are the reason you are using it Excel are calculations that allow you to enter a value that automatically updates the calculation.

VIEW MORE

How to Create Formulas

Formulas are the reason you are using it Excel are calculations that allow you to enter a value that automatically updates the calculation.

VIEW MORE

How to Create Formulas

Formulas are the reason you are using it Excel are calculations that allow you to enter a value that automatically updates the calculation.

VIEW MORE
Getting Started with Excel 2010 an Overview
13:59

Getting Started with Excel 2010 an Overview

If you were using Excel 2003 and now using Excel 2010 or more recent versions you might be a bit puzzled about where everything is. Microsoft went and moved everything around in Excel 2007 and have kept it that way in Excel 2010 but have fixed a few things and added new features. In this video Gary Schwartz from http://www.jargonfreehelp.com gives a quick overview that will get you started. Gary has many more videos on Excel 2010 and creating more all the time so come back or visit his website.
Creating a New Workbook in Excel Including Using a Template
02:46

Creating a New Workbook in Excel Including Using a Template

You can create a new blank workbook in Excel or create one using one of the templates which are built in or readily available to download. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.
How to Save Excel Workbooks and Setup AutoSave/Autorecover
03:17

How to Save Excel Workbooks and Setup AutoSave/Autorecover

It is important to save your data regularly when using Excel, you don't want to lose all that hard work. Here is how you can save it and also set up Autorecover, which is like Autosave where it saves a copy should anything go wrong. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.
Using AutoFill in Excel
04:07

Using AutoFill in Excel

Auto Fill is a great way to add data such as months, dates, or repetitive information. There are also some useful tricks like adding a series of dates and leaving out weekends. Related videos: Fill weekdays using AutoFill: https://youtu.be/sVAAWa5pPKw Fill months and years using AutoFill: This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.
Excel: How to Create Formulas - Calculations
07:41

Excel: How to Create Formulas - Calculations

Excel is great for working with numbers which means doing calculations. Calculations in Excel are called formulas and here is an introduction to doing some simple calculations that includes addition, subtraction, multiplication and division. You will also see how to use brackets in formulas and Autosum. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. Introduction to Functions: http://youtu.be/vkwQwWY_lKQ Introduction to Function on a Mac: http://youtu.be/B9mSM9B01o4 AutoSum: http://youtu.be/75Y_AsIavPs Autofill: http://youtu.be/2FTxjK60gKM
Excel 2003: AutoSum (works in all versions including 2007, 2010, 2013, 2016)
03:09

Excel 2003: AutoSum (works in all versions including 2007, 2010, 2013, 2016)

Totalling up figures in Excel is easy using AutoSum and even if you know how to use it there are some useful tricks here to. Gary Schwartz from http://www.jargonfreehelp.com show us how.
Excel - What Are The $ signs for? Absolute Referencing and Mixed Referencing
03:06

Excel - What Are The $ signs for? Absolute Referencing and Mixed Referencing

Have you ever seen the $ signs used in an Excel formula and wondering what they are for? Perhaps you have copied a formula and a cell reference has changed and you didn't want it to. What you want to know about is absolute and mixed referencing and here Gary Schwartz from http://www.jargonfreehelp.com shows us what it is about.
Excel: Using Percentage in Formulas (calculations)
01:17

Excel: Using Percentage in Formulas (calculations)

If you need to do a calculation and you want to use a percentage then it is easier than you might think. In this short tutorial by Gary Schwartz from http://www.jargonfreehelp.com you will see how to work out the percentage of a value.
Excel 2003: Naming Cells and Ranges
05:17

Excel 2003: Naming Cells and Ranges

By naming cells and ranges in Excel you can make formulas and functions easier to read and also provides a great way to navigate around your worksheet and workbook. It really does speed up the way you get around from one part of the sheet to another. It is also useful when using Scenarios. In this video Gary Schwartz from http://www.jargonfreehelp.com shows you how to use the VLOOKUP function.
bottom of page