Excel - Starting From Scratch
4.0 (83 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,965 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel - Starting From Scratch to your Wishlist.

Add to Wishlist

Excel - Starting From Scratch

Your very first look at excel, building confidence and getting you up and running.
4.0 (83 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,965 students enrolled
Last updated 7/2015
Current price: $12 Original price: $20 Discount: 40% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 44 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Create; open; save a spread sheet
  • Understand and use basic excel terminology.
  • Get excel to do calculations
  • Understand what a function is and how to use one (Autosum).
  • Format a spread sheet, make your spread sheet look nice.
  • Use a spread sheet
View Curriculum
  • The basics of windows such as opening a program, opening, saving and closing files.
  • Have a working copy of excel

A beginners guide to excel.

Learn the basic concepts, tools, and functions that you will need to build fully functional excel spread sheets. The concept is simple; to get you up and running in the shortest time possible, just 50 minutes of training videos, that's less than 4% of your day.. In just a few short videos you will know everything you need.

If you have never used a spreadsheet before this course could change your life.

Build a strong foundation in Excel with this tutorial for beginners.

  • Open close and save files
  • Use functions and math
  • add text and numbers
  • Formatting.

A Powerful Skill at Your Fingertips The beginners guide to excel puts a powerful and very useful tool at your fingertips. Excel is easy to learn, has excellent documentation, and is the most popular of all spread sheet applications. Jobs requiring excel are in high demand and the use grows exponentially as does the requirement to work with them. This course gets you in the game.

Who is the target audience?
  • This course is for beginners or novices.
  • You have never used a spreadsheet before.
  • You don’t see any value in learning excel and aren’t exactly sure why it’s so “useful”.
  • You have opened excel but felt lost and intimidated?
  • You crunch numbers such as grocery receipts, utility bills, and vacation costs with pen, paper and a calculator.
  • You don’t care about being an expert. You just want the basics and don’t want to waste a lot of time getting there.
Compare to Other Excel Courses
Curriculum For This Course
Start using Excel
13 Lectures 44:16

Welcome, This lesson discusses who should be taking the course and goes over what you will be getting out of the journey.

Preview 01:52

We Introduce excel, show you the work area and its main concepts.

  • What a worksheet is
  • What a cell is
  • How to select a cell
  • What the letters at the top are for
  • What the numbers at the side are for
Preview 01:34


Pop Quiz 1
3 questions

We create a new worksheet, learn how to save and close.

  • Choosing a name and location to save
  • Save as you work
  • Close a worksheet
  • Create a blank worksheet
  • Open a saved worksheet
  • Close excel
Preview 02:56

We introduce entering text and numbers into cell, discuss what data type is and how it relates to text and numbers

  • How to enter data
  • Two data types (text and numbers)
  • Changing cell using the enter key
  • Adjust cell width
  • Adjust cell height
Preview 04:20

We look at the most common math symbols used in excel, learn what and operator is and introduce the equation symbol

  • Introduce addition, subtraction, multiplication and division operators
  • Introduce the equation symbol "="
  • Use brackets
  • Build our first formula

Getting excel to do some math

Reviewing the keys to making excel do math

Pop Quiz 2
6 questions

We look at what a cell reference is and how to define one

  • What a cell reference is
  • Determine a cell reference
  • How to write a cell reference
  • Build a formula using a cell reference
Cell references

We will build a formula to do some math using multiple cells

  • Learn advantages to using cell references
  • Two ways to reference a cell, keyboard or mouse
  • Build a formula that uses multiple cells
Doing math with cells references.

  • Take everything we have learned so far and apply it to a real world situation
  • Open an existing excel file
  • How to delete items from the worksheet
  • Build a grocery list
  • Calculate what we expect our bill to be
The grocery list

  • Review the cell reference
  • Learn what a cell range is
  • Learn what an array is
  • Learn how to select and define a cell range and array
Cell ranges

cell references and cell ranges

Pop Quiz 3
4 questions

  • Introduce autosum
  • Use the cell ranges
Auto SUM

  • Group delete
  • Copy formulas with by dragging
  • Use the autosum
  • Insert a new row
  • Review some old tools and functions
The grocery list, improvements

We take the grocery list and make it look a lot nicer by using some of the formatting tools available in excel

  • Correct the decimal places
  • Add the "$" sign to monetary values
  • Font, size, colour bolding adjustments
  • Define spaces using cell border
  • Add cell colouring

Before we say good bye, we just have a few more things wed like to share with you.

About the Instructor
Steve Hartshorn, M.Ed., D.A.
3.9 Average rating
241 Reviews
3,386 Students
4 Courses
CEO Sensiom training

Dr. Stevan W. Hartshorn (M. Ed. D.A.), lead author for Sensiom's "Express Solution to Better Grades" and author of the educational research titled "Success in the Face of Failure," an extensive background in developing learning strategies for adults and children. Stevan's academic qualifications began with a Higher National Diploma in Teaching and a Bachelor of Arts degree in Psychology. He then obtained a Masters of Education in Mathematics, which culminated in a Doctor of Arts in Education.