Table of Contents: Excel Fundamentals
Lost? No problem! Here's a complete table of contents for this course:
Introduction
Introduction
Get started here - we'll go over what you'll learn in this course and how to navigate through sections and lessons.
The Excel interface
What is Excel?
What is Excel, and what is a spreadsheet? Learn the basics in this simple explainer.
Workbook and worksheets
"Workbook" is just another name for an Excel file. Each workbook contains multiple worksheets full of data. Learn more about workbooks and worksheets here!
Rows, columns, and cells
Excel's worksheets are organized into a grid of rows and columns that contain cells. Learn how to use them here!
Shortcuts
Data in Excel can be manipulated extremely quickly and accurately using shortcuts. In this lesson, we'll explore some of Excel's most important hotkeys and how to use them.
Sorting and filtering
Sorting data
In this tutorial, we highlight the best ways to alphabetize and sort a list in Excel, including ascending and descending sorts.
Filtering data
Excel's autofilters allow you to filter a large set of data to show or hide a select subset of rows. Learn how to use them here!
Functions and references
Basic formulas
Formulas are calculations that Excel can perform automatically. Let's experiment with some formulas to add, subtract, multiply, and divide numbers together. Then, we'll look at some formulas that reference other cells.
Formulas exercise
Let's use what we've learned so far to write some basic formulas that perform simple calculations.
What is a function?
What is a function in Excel? Let's walk through the basics of what a function is and how to use one in your spreadsheet.
Functions exercise
Can you use the SUM function to perform some calculations on a basic spreadsheet?
Nested functions
The beauty of functions is all about the synergies between them. Let's learn how to combine functions together to create more complex, nested formulas.
Advanced references
Basic cell references become even more useful when we start tweaking them with absolute and relative modifiers.
References exercise
Try some advanced cell references out for yourself by using the '$' sign to convert pointers from relative to absolute.
Formatting data
Freezing panes
Freezing panes allows us to keep column headers and row labels displayed on our screen as we scroll through an Excel sheet.
Number formats
Use Excel to format your numbers as currency, numerals, and more!
Formatting cells
Excel contains a huge variety of cell formatting options, like colors, borders, and more.
Tables
Tables are a data construct built in to Excel that allow us to manipulate similar ranges of data quickly and easily.
Tables exercise
Try your hand at converting a normal data range into a beautiful Table with easy references.
Conclusion
Conclusion
This marks the conclusion of our course! Check in here to review what we've learned.