Use Spreadsheets Confidently: Navigation, Functions and More
4.9 (7 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.
2,477 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Use Spreadsheets Confidently: Navigation, Functions and More to your Wishlist.

Add to Wishlist

Use Spreadsheets Confidently: Navigation, Functions and More

Supercharge your spreadsheet & data management skills! Learn essential Excel functions, data clean-up tricks and more
4.9 (7 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.
2,477 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $60 Discount: 83% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
In this course, we'll use a real-world example to practice spreadsheet navigation, formatting tricks, understanding and writing functions, and how to use data clean-up tools
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, so you can better analyze and understand your data!
View Curriculum
Requirements
  • A computer (Windows, Mac, or Linux) with Internet access
  • Any spreadsheet software, such as Microsoft Excel, LibreOffice, or OpenOffice
  • Some rudimentary spreadsheet skills (data entry, basic calculations)
  • A desire to learn!
Description

Want to do MORE with Microsoft Excel? Need to speed up your spreadsheet workflow

  • Spreadsheet software programs like Microsoft Excel, Apple Numbers and LibreOffice are more than just tables! Used properly, they're essential tools for helping you analyze and understand just about any kind of data.

In this practical course suitable for beginner and intermediate-level spreadsheet users, we'll use a real-world example to learn more about spreadsheet navigation, formatting, functions, and simple data clean-up tools.

Whether you want to just get faster and feel more confident using spreadsheets, or just use spreadsheet software to better analyze your data, understanding spreadsheets makes it possible.

HOW IS THIS COURSE DIFFERENT?

My name is Kathleen, and I've been teaching technology to beginners under the moniker Robobunnyattack! since 2009. I believe that with the right approach, anyone can learn anything.

  • My goal in this course is to help you get better and faster at using ANY spreadsheet software.

In this course, I'll demonstrate practical and time-saving steps using a real-world example. As we work together, I'll explain WHY and HOW things work the way they do, so you can learn more quickly and with more confidence.

As we sort through and analyze our spreadsheet data, we'll cover:

  • How to quickly navigate and format large data sets
  • How to use functions to answer specific questions about your data
  • Handy tricks for speeding up your workflow
  • And much more...!

I'll demonstrate each step using LibreOffice, a FREE and easy-to-use office productivity suite. You can apply these skills in your preferred spreadsheet software program, such as Microsoft Excel, Apple Numbers, or Google Spreadsheets.

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

WHAT'S INCLUDED?

  • This course includes lifetime access to over 50 minutes of step-by-step videos.
  • You'll also get supplementary text lectures, free downloads, and links to helpful resources.

HOW LONG WILL IT TAKE ME?

  • This completely depends on your availability and learning preference. You can work through all the video lectures in one afternoon, or pace yourself over several days or weeks — it's up to you!
WHAT IF THIS COURSE ISN'T FOR ME?
  • This course comes with an unconditional 30-day Udemy-backed guarantee. Try out this course for 30 days and see for yourself if my approach to learning how to improve your spreadsheet skills is right for you. If you're not 100% satisfied with this course, simply request a full refund within 30 days — no conditions, no questions asked!

I'm confident you'll LOVE this course, and I'm excited to help you learn. Enrol now and you can start working more efficiently with spreadsheets today!

—Kathleen Farley (aka Robobunnyattack!)

Who is the target audience?
  • Beginner and intermediate-level users of Microsoft Excel (or any spreadsheet software)
  • Knowledge workers 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!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 59:04
+
Introduction
2 Lectures 02:55

In this course, we'll learn more about spreadsheet navigation, formatting tricks, understanding and writing functions, and how to use data clean-up tools. Here's what the course will cover, and what you'll need to get started.

I use LibreOffice in this course, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.


Preview 01:25

Before we begin, let's review some common spreadsheet file formats.

Understanding spreadsheet file formats
01:29
+
Spreadsheet navigation and formatting
2 Lectures 11:45

In this lesson, we tackle how to sort rows in a spreadsheet that has column labels (in other words, a header row along the top of your spreadsheet). This tutorial also explains how (and why!) to sort using more than one sort key.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

Preview 09:19

This tutorial explains how to stop the top row in a spreadsheet from moving by using the "Freeze" tool. This is super handy when you're working with large spreadsheets!

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

How do I stop the top row from moving in a spreadsheet? (Freezing rows)
02:26
+
Spreadsheet functions
4 Lectures 21:56

This tutorial walks you through how to add up a column of numbers using the SUM function, like this:

=SUM(D2:D1644)

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

Preview 04:49

This tutorial walks you through how to reference cells on another sheet in the same spreadsheet file, like this:

=SUM('Some Other Sheet'.D2:D1644)

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

How do I reference cells on a different sheet?
07:01

This tutorial walks you through how to use the SUMIF function to add up values in a spreadsheet that only meet a specific criteria.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

How do I add up values that only meet a specific criteria? (Using SUMIF)
06:21

This tutorial walks you through how to use the SUMIF function while referencing values on another sheet in the same spreadsheet file.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.


How do I use a SUMIF function that references cells on a different sheet?
03:45
+
Data clean-up
1 Lecture 06:00

This tutorial walks you through how to use a text editor like TextWrangler or Notepad++ to automagically (!) sort through and delete duplicate lines in a set of data.

I use TextWrangler (for Mac) in this tutorial, but you could use any other powerful text editor such as Notepad++ (for PC).

NOTE FOR PC USERS! If you're using Notepad++ for PC, you'll need the TextFX plugin. This used to be included in older versions of Notepad++, but if you have a newer version, you can add it from the menu by going to Plugins -> Plugin Manager -> Show Plugin Manager -> Available tab -> TextFX -> Install.

The check boxes and buttons required will now appear in the menu under: TextFX -> TextFX Tools.

Make sure "sort outputs only unique..." is checked. Then select a block of text (ctrl-a to select the entire document). Then click "sort lines case sensitive" or "sort lines case insensitive"

I also use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

Preview 06:00
+
More spreadsheet functions
2 Lectures 15:40

This tutorial walks you through how to use absolute addressing (vs relative addressing) in your spreadsheet. This allows you to "lock" the row and/or column value in a cell's address.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

How do I "lock" the row or column value in a cell's address? (Absolute/Relative)
08:13

This tutorial walks you through how to use functions, absolute addressing, a text editor, and your brain (!) to answer interesting questions about your data.

I use TextWrangler (for Mac) in this tutorial, but you could use any other powerful text editor such as Notepad++ (for PC).

I also use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.

You can download the example spreadsheet we are using from the "Downloadable Resources" section in Lecture 1. The spreadsheet is available in both .xls (Microsoft Excel) or .ods (Open Document Format Spreadsheet) formats.

How to answer questions about your data using your new spreadsheet skills!
07:27
+
Conclusion
2 Lectures 01:28

Wow, you did it! Let's review everything we covered.


Course review
00:42

This bonus lecture provides additional resources and links to my other courses on Udemy so you can continue your learning.

Bonus Lecture: Additional Resources
00:46
About the Instructor
Kathleen Farley
4.5 Average rating
507 Reviews
11,910 Students
9 Courses
aka Robobunnyattack! + co-founder of Audiohackr

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.

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.

Kathleen produces technology training videos under the moniker Robobunnyattack!