Coming April 2017…
- Data Analysis
About this Course
A spreadsheet is an electronic document that arranges data in a table by using columns and rows. Among other things, spreadsheets let you store, manipulate, share and analyze data. They're used in business to help make complicated decisions like where to open a new restaurant location, where to build a wind farm, or where to expand a business' marketing efforts. Spreadsheets aren't just for business use either. A household expense spreadsheet can help you determine when you will be able to afford a new car, or take your next trip.
In this course, you'll learn the basics of spreadsheets including the parts of a spreadsheet, spreadsheet vocabulary, how to import data, how to make complex calculations, how to reference data in different cells, and how to use spreadsheet functions. You'll also learn best practices for formatting spreadsheets, protecting your data, and more. When you're done you'll have built an entire spreadsheet complete with data, complex functions and formulas and colorful and meaningful formatting.
What you'll learn
- Spreadsheet concepts and vocabulary
- Importing data into a spreadsheet
- Using functions and formulas to analyze data
- Formatting spreadsheets
- Spreadsheet best practices
What are spreadsheets? Why do we use them? And how can they help you make better data-driven decisions?
Getting Started With Spreadsheets
Get started with spreadsheets and learn how to add data, create basics calculations, determine averages, sort and filter information, and how to reference data inside individual spreadsheet cells.
Spreadsheet Functions & Shortcuts
Spreadsheet functions give you the power to perform complex calculations on data. You can use them to derive totals, count the number of records, round numbers up and down and add complex logic to process data in different ways depending on their values.
Spreadsheet Best Practices
Super charge you spreadsheet use with best practices in formatting data, using templates, adding comments and notes, and using tabs to track inputs and outputs.
Build a Spreadsheet
Walk through the process of creating a spreadsheet from start to finish. Find and import data; format the spreadsheet; and use formulas and functions to give the data meaning.
Michael Watson is the COO of Treehouse. Before joining Treehouse he worked in private equity in Asia. He is a graduate of Tufts University and has an MBA from INSEAD. He loves sports and the great outdoors.