Excel - Starting From Scratch

Your very first look at excel, building confidence and getting you up and running.
4.0 (75 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,957 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 13
  • Length 44 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

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.

What are the requirements?

  • The basics of windows such as opening a program, opening, saving and closing files.
  • Have a working copy of excel

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Start using Excel
01:52

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

01:34

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
3 questions

Terminology

02:56

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
04:20

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
05:06

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


6 questions

Reviewing the keys to making excel do math

03:05

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
03:53

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
04:52
  • 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
01:25
  • 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
4 questions

cell references and cell ranges

02:54
  • Introduce autosum
  • Use the cell ranges
03:57
  • Group delete
  • Copy formulas with by dragging
  • Use the autosum
  • Insert a new row
  • Review some old tools and functions
06:15

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
02:07

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course