Buying for a Team? Gift This Course
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.4 (78 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,958 students enrolled
Last updated 7/2015
English
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 44 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 44:16
+
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

Terminology

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

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

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

  • 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
04:52

  • 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
01:25

cell references and cell ranges

Pop Quiz 3
4 questions

  • Introduce autosum
  • Use the cell ranges
Auto SUM
02:54

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

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
Aesthetics
06:15

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

Conclusion
02:07
About the Instructor
4.1 Average rating
175 Reviews
3,252 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.

Report Abuse