Step-by-step Spreadsheets for Absolute Beginners Premium class

Kathleen Farley, Robobunnyattack!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (2h 2m)
    • Welcome

      2:49
    • Why are spreadsheets so awesome

      3:21
    • What you need to get started

      3:13
    • Choose your weapon Free alternatives to Microsoft Excel

      11:10
    • Project overview 5 song CD recording budget

      2:34
    • Meet your spreadsheet

      8:14
    • Data entry tips and tricks

      10:43
    • Thinking ahead Building a flexible template

      15:03
    • Calculations Don't do the math

      7:04
    • Formulas Magic recipes

      5:06
    • Tips and tricks for writing formulas

      5:37
    • Functions Uber formulas

      14:24
    • Subtraction in action Are we going to break even

      2:44
    • Playing with numbers Tweaking our budget

      4:04
    • Bonus round Splitting the proceeds

      4:28
    • Choosing the right spreadsheet file format

      18:54
    • Hooked on spreadsheets What's next

      2:34

About This Class

Are you mystified by Microsoft Excel? Feeling intimidated by spreadsheets? Want to really learn how to use a spreadsheet properly, but have no idea where to start?

In this fun and friendly course, suitable for absolute beginners, we'll use a real-world example to practice spreadsheet navigation, data entry tips and tricks, calculations, formulas, and more.

We'll focus on WHY and HOW things work in spreadsheets –– so you can develop an intuitive understanding of how to use ANY spreadsheet software.

By the end of this course, you'll be able to use Microsoft Excel or any other spreadsheet software application with confidence!

Spreadsheet programs such as Microsoft Excel have replaced paper-based systems throughout the business world. Initially developed for accounting and bookkeeping tasks, they're also used extensively to organize and store tabular lists.

In these tutorials, I'll demonstrate each step using LibreOffice, a free and open-source office productivity suite. You can apply these skills in your preferred spreadsheet application program, such as Microsoft Excel, LibreOffice, or OpenOffice.

COURSE GOAL AND OBJECTIVES

  • In this course, we'll use a real-world example to practice spreadsheet navigation, data entry tips and tricks, calculations, formulas, and more
  • We'll focus on WHY and HOW things work in spreadsheets –– so you can develop an intuitive understanding of how to use ANY spreadsheet software
  • By the end of this course, you'll be able to use spreadsheet software with confidence!


INTENDED AUDIENCE

  • Beginner-level users with little or no experience using Microsoft Excel (or any spreadsheet software)
  • Students seeking to strengthen their data management skills
  • Learners of all ages who want to REALLY understand how to use spreadsheets –– not just memorize a series of steps!


COURSE REQUIREMENTS

  • A computer (Windows, Mac, or Linux)
  • Rudimentary computer skills (using a mouse, opening and saving files)
  • Any spreadsheet software, such as Microsoft Excel, LibreOffice, or OpenOffice
  • Basic grade-school level math comprehension
  • A desire to learn!

2 of 2 students recommendSee All

Very good class

49

Students

--

Projects

Kathleen Farley

Robobunnyattack!

Kathleen Farley is a computer geek, teacher, learner, vinyl junkie, hockey fan, and recovering non-profit executive. Occasionally she breaks (and fixes) computers. Not necessarily in that order.

Kathleen produces technology training videos under the moniker Robobunnyattack!

The Montreal-born technologist trained as an audio engineer before moving to Hamilton, Canada in 2007. She now runs Maisonneuve Music, a Hamilton-based independent record label.

Kathleen teaches technology and management skills at a music industry school in Toronto, Canada. She's also the co-founder of Audiohackr, a startup that helps indie musicians, producers, and DIY labels make the most of technology.