Use Spreadsheets Confidently: Navigation, Functions and More

Introduction 2 lectures 00:00 Course overview 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. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Introduction 2 lectures 00:00 Course overview 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. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Course overview 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. Course overview 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. Course overview 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. Course overview 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. 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. 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. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Understanding spreadsheet file formats Before we begin, let's review some common spreadsheet file formats. Before we begin, let's review some common spreadsheet file formats. Before we begin, let's review some common spreadsheet file formats. Spreadsheet navigation and formatting 2 lectures 11:46 How do I sort rows in a spreadsheet? (Using the Sort tool) 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. How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) Spreadsheet navigation and formatting 2 lectures 11:46 How do I sort rows in a spreadsheet? (Using the Sort tool) 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. How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) How do I sort rows in a spreadsheet? (Using the Sort tool) 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. How do I sort rows in a spreadsheet? (Using the Sort tool) 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. How do I sort rows in a spreadsheet? (Using the Sort tool) 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. How do I sort rows in a spreadsheet? (Using the Sort tool) 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. 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. 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. How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) How do I stop the top row from moving in a spreadsheet? (Freezing rows) 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) 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) 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) Spreadsheet functions. 4 lectures 21:57 How do I add up a column of numbers in a spreadsheet? (Using the SUM function) 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 ut you could use any spreadsheet application such as Microsoft Excel or...