Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel - Starting From Scratch
Rating: 4.4 out of 5(112 ratings)
2,009 students

Excel - Starting From Scratch

Your very first look at excel, building confidence and getting you up and running.
Created bySteve Hartshorn, M.Ed., D.A.
Last updated 7/2015
English

What you'll 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

Course content

1 section • 13 lectures • 44m total length

  • Introduction1:52

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

  • The Environment1: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
  • Pop Quiz 1
  • Creating a new sheet, save and close.2: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
  • Entering Data4: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
  • Getting excel to do some math5: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


  • Pop Quiz 2
  • Cell references3: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
  • Doing math with cells references.3: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
  • The grocery list4: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
  • Cell ranges1: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
  • Pop Quiz 3
  • Auto SUM2:54
    • Introduce autosum
    • Use the cell ranges
  • The grocery list, improvements3:57
    • Group delete
    • Copy formulas with by dragging
    • Use the autosum
    • Insert a new row
    • Review some old tools and functions
  • Aesthetics6: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
  • Conclusion2:07

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

Requirements

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

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.

Who this course is for:

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

Report abuse