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,475 students enrolled
$60
Take This Course
  • Lectures 13
  • Contents Video: 1 hour
    Other: 4 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2013 English

Course 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!)

What are the 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!

What am I going to get from this course?

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

What 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!

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Article

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.


Article

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

Section 2: Spreadsheet navigation and formatting
09:19

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.

02:26

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.

Section 3: Spreadsheet functions
04:49

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.

07:01

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.

06:21

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.

03:45

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.


Section 4: Data clean-up
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.

Section 5: More spreadsheet functions
08:13

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.

07:27

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.

Section 6: Conclusion
Article

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


Article

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kathleen Farley, 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!

Ready to start learning?
Take This Course