Super-interactive, easy, fast introduction to SPREADSHEETS
5.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34 students enrolled

Super-interactive, easy, fast introduction to SPREADSHEETS

Learn by doing with a step-by-step interactive video simulation. Easy, fast, and fun. No prior knowledge needed.
5.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34 students enrolled
Created by Mathew Georghiou
Last updated 5/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 10 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Spreadsheet fundamentals
  • Equations
  • Relative cell references
  • Functions
  • Inserting rows
  • Adding titles
  • Formatting
  • Saving
  • Printing
  • Charts
  • Use a spreadsheet to build a basic business cash flow
Requirements
  • None - easy to get started!
  • The interactive video simulation will not run on a tablet or smartphone (but the non-interactive reference video will)
Description

This course is for you if: 

  • You are easily bored by lectures and reading.

  • You know absolutely nothing about spreadsheets.

  • You do use spreadsheets, but need a refresher on the fundamentals.

  • You want hands-on, experiential learning.

  • You want to go at your own pace, step-by-step.

  • Your English literacy is not strong.

  • You want to learn FAST.

Learn by doing
This course uses a highly-interactive video simulation to walk you through everything you need to know about spreadsheets. 

Good for all spreadsheets
It does not matter if you will use Excel, Calc, Google, Numbers, Lotus or any other spreadsheet program.  The fundamentals you will learn here apply to most popular spreadsheet programs. 

Basic and intermediate
If you know nothing about spreadsheets, or you are not comfortable with computers in general, then this course is for you.  If you already use spreadsheets, this course is a great refresher of the fundamentals, and it includes advanced tips too. 

Duration
30-90 minutes, depending on your own pace and the level of detail you want to review.  The lectures are VERY short.  The interactive video simulation is the longest module of the course.  A non-interactive video of the simulation is also included for reference (but the interactive video simulation is the reason you should take this course). 

Who this course is for:
  • Everyone - no prior knowledge needed
Course content
Expand all 27 lectures 57:30
+ About Spreadsheets
2 lectures 01:25
What is a spreadsheet?
About spreadsheets
00:13
What makes a spreadsheet useful?
Benefits and Features
01:12
+ Let's help an entrepreneur
2 lectures 02:19

We are going to learn about spreadsheets by helping an entrepreneur with his business.

Introduction
00:06
We are going to learn about spreadsheets by helping Paul Takashi, an organic farmer.  Let's find out more about Paul by watching a video about his business.
Preview 02:13
+ Cash Flow with a Spreadsheet (Interactive Video Simulation)
1 lecture 00:42
Time for the hands-on activity!  This interactive video simulation will step us through working with spreadsheets.  Duration is 20-60 minutes.
Play the interactive video simulation
00:42
+ Video Reference
19 lectures 51:33

17 video recordings of every step in the interactive video simulation.

Preview 00:14

This is a video recording of Step 1 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

Preview 04:33

This is a video recording of Step 2 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

2. Introduction to Cash Flow Statements
00:32

This is a video recording of Step 3 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

3. Build a Cash Flow - headers
00:39

This is a video recording of Step 4 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

4. Build a Cash Flow - details
02:24

This is a video recording of Step 5 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

5. Equations
07:36

This is a video recording of Step 6 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

6. Relative Cell References
01:23

This is a video recording of Step 7 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

7. Functions
02:22

This is a video recording of Step 8 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

8. Inserting Rows
01:17

This is a video recording of Step 9 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

9. Adding a Title
00:49

This is a video recording of Step 10 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

10. Formatting
06:48

This is a video recording of Step 11 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

11. Using Cash Flow Statement as a Projection Tool
02:54

This is a video recording of Step 12 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

12. Saving
00:41

This is a video recording of Step 13 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

13. Printing
00:50

This is a video recording of Step 14 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

14. Detailed Cash Flow
00:13

This is a video recording of Step 15 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

15. Visual Charts
00:36

This is a video recording of Step 16 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

16. Budget
00:28

This is a video recording of Step 17 in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

17. Summary
00:21

This is a video recording of Learn More in the interactive video simulation. It is provided as a helpful reference for when you may need it. You should play the interactive video simulation for the most effective learning experience.

18. Learn More
16:53
+ Quiz
0 lectures 00:00

Let's see what you have learned by answering these 10 questions.

Test your knowledge
10 questions
+ Wrapup
2 lectures 00:37

Reflect on what you have learned.

Reflection
00:21
Practice makes perfect!
Just do it!
00:15