Complete Beginner's Guide to Excel
A 56-part course with Todd McLeod
Start Free Preview Start CourseCourse Overview
Teacher
My education includes a Bachelor’s degree in Economics from UC Santa Cruz and an MBA from CSU Fresno. My academic honors include: UCLA Alumni Scholar, UCSC Graduating Honors, CSUF Phi Kappa Phi, CSUF Beta Gamma Sigma, CSUF Dean’s List all semesters,... View ProfileDetails
- Total Time 6 hr, 18 min
- Lessons 56
- Attachments 115
- Exercises 144
-
216 CQ
56 Lessons in This Course
-
13 minFREEMicrosoft Office lesson 1Free7 CQ
This lesson introduces Todd McLeod’s course on the Microsoft Excel spreadsheet program. Learn about the Excel tables, functions, equations, and more!
with Todd McLeodThis lesson introduces Todd McLeod’s course on the Microsoft Excel spreadsheet program. Learn about the Excel tables, functions, equations, and more!
-
5 minFREEMicrosoft Office lesson 2Free3 CQ
In this introductory lesson, your instructor provides a guided tour of the basic components of a spreadsheet, and introduces cell formatting and formulas.
with Todd McLeodIn this introductory lesson, your instructor provides a guided tour of the basic components of a spreadsheet, and introduces cell formatting and formulas.
-
3 minMicrosoft Office lesson 32 CQ
Learning the basics of Microsoft Excel? In this lesson, follow a simple formula example of relative references with Copy, Paste, and Auto Fill in Excel.
with Todd McLeodLearning the basics of Microsoft Excel? In this lesson, follow a simple formula example of relative references with Copy, Paste, and Auto Fill in Excel.
-
4 minMicrosoft Office lesson 43 CQ
In this lesson, learn to differentiate between relative and absolute references and why this distinction is so important for spreadsheet formulas!
with Todd McLeodIn this lesson, learn to differentiate between relative and absolute references and why this distinction is so important for spreadsheet formulas!
-
5 minMicrosoft Office lesson 53 CQ
In this lesson, learn about the difference between functions and formulas, and how to use AutoSum and the Loan Payment function within an Excel spreadsheet.
with Todd McLeodIn this lesson, learn about the difference between functions and formulas, and how to use AutoSum and the Loan Payment function within an Excel spreadsheet.
-
5 minMicrosoft Office lesson 63 CQ
This lesson demonstrates the basic approach to creating and formatting charts in Microsoft Excel to showcase your data and make it really stand out!
with Todd McLeodThis lesson demonstrates the basic approach to creating and formatting charts in Microsoft Excel to showcase your data and make it really stand out!
-
12 minMicrosoft Office lesson 77 CQ
In this lesson, learn to set up an Excel spreadsheet to calculate your grades as a strategy for managing your time and ultimately getting better grades!
with Todd McLeodIn this lesson, learn to set up an Excel spreadsheet to calculate your grades as a strategy for managing your time and ultimately getting better grades!
-
6 minSTEM lesson 84 CQ
Looking for an easy way to collect group data? In this lesson, learn how to create a survey that tallies responses in a spreadsheet, using Google Forms.
with Todd McLeodLooking for an easy way to collect group data? In this lesson, learn how to create a survey that tallies responses in a spreadsheet, using Google Forms.
-
7 minMicrosoft Office lesson 94 CQ
In this lesson, get a guided tour of the basic features of Microsoft Excel, including columns, rows, cells, worksheets, and the status bar.
with Todd McLeodIn this lesson, get a guided tour of the basic features of Microsoft Excel, including columns, rows, cells, worksheets, and the status bar.
-
6 minMicrosoft Office lesson 104 CQ
Learn the basics of writing formulas in Microsoft Excel and using cell references in a formula, and pick up a few spreadsheet mouse pointer tips.
with Todd McLeodLearn the basics of writing formulas in Microsoft Excel and using cell references in a formula, and pick up a few spreadsheet mouse pointer tips.
-
3 minMicrosoft Office lesson 112 CQ
In this lesson, learn essential MS Excel formula tips, including using correct the order of operations, viewing spreadsheet formulas, & making figures visible.
with Todd McLeodIn this lesson, learn essential MS Excel formula tips, including using correct the order of operations, viewing spreadsheet formulas, & making figures visible.
-
6 minMicrosoft Office lesson 124 CQ
In this lesson, learn about the difference between relative, absolute, and mixed cell references in MS Excel with a simple spreadsheet example.
with Todd McLeodIn this lesson, learn about the difference between relative, absolute, and mixed cell references in MS Excel with a simple spreadsheet example.
-
6 minMicrosoft Office lesson 134 CQ
In this lesson, learn how to use some of the most popular spreadsheet functions in Microsoft Excel, including AutoSum, Average, CountA, and Min.
with Todd McLeodIn this lesson, learn how to use some of the most popular spreadsheet functions in Microsoft Excel, including AutoSum, Average, CountA, and Min.
-
5 minMicrosoft Office lesson 143 CQ
Learn two important financial functions in MS Excel: PMT and IPMT. Find out how they can help determine loan and interest payments with precision.
with Todd McLeodLearn two important financial functions in MS Excel: PMT and IPMT. Find out how they can help determine loan and interest payments with precision.
-
4 minMicrosoft Office lesson 153 CQ
What does your retirement investment mean in real dollars? In this lesson, learn to crunch the future value of your nest egg and pension payments in MS Excel.
with Todd McLeodWhat does your retirement investment mean in real dollars? In this lesson, learn to crunch the future value of your nest egg and pension payments in MS Excel.
-
2 minMicrosoft Office lesson 162 CQ
In this lesson, learn the VLOOKUP function in Microsoft Excel. Find out how to pull a value from a range, then return a matching value to a spreadsheet cell.
with Todd McLeodIn this lesson, learn the VLOOKUP function in Microsoft Excel. Find out how to pull a value from a range, then return a matching value to a spreadsheet cell.
-
2 minMicrosoft Office lesson 172 CQ
In this lesson, learn how to pair an “if” function with a “concatenate” function to link text and produce an answer of true or false in Microsoft Excel!
with Todd McLeodIn this lesson, learn how to pair an “if” function with a “concatenate” function to link text and produce an answer of true or false in Microsoft Excel!
-
4 minMicrosoft Office lesson 183 CQ
In this lesson, learn about conditional formatting, to format cells based on set specifications, and IfError, to dynamically return results of an Excel table.
with Todd McLeodIn this lesson, learn about conditional formatting, to format cells based on set specifications, and IfError, to dynamically return results of an Excel table.
-
5 minMicrosoft Office lesson 193 CQ
Want to create compelling visual data representations in MS Excel? In this lesson, learn how to transform data tables into pie, line, and column charts.
with Todd McLeodWant to create compelling visual data representations in MS Excel? In this lesson, learn how to transform data tables into pie, line, and column charts.
-
5 minMicrosoft Office lesson 203 CQ
In this lesson, explore chart editing features in Excel. Learn to format data labels, delete chart elements, create stacked charts, add 3-D effects, and more!
with Todd McLeodIn this lesson, explore chart editing features in Excel. Learn to format data labels, delete chart elements, create stacked charts, add 3-D effects, and more!
-
6 minMicrosoft Office lesson 214 CQ
A Microsoft Excel scatter charts is great for representing individual data points. In this lesson, learn how to create and format scatter charts!
with Todd McLeodA Microsoft Excel scatter charts is great for representing individual data points. In this lesson, learn how to create and format scatter charts!
-
6 minMicrosoft Office lesson 224 CQ
In this lesson, learn all about the combo chart in Microsoft Excel! Find out how to put bar charts and line charts together, and how to add a second axis.
with Todd McLeodIn this lesson, learn all about the combo chart in Microsoft Excel! Find out how to put bar charts and line charts together, and how to add a second axis.
-
3 minMicrosoft Office lesson 232 CQ
Pivot charts are some of the most powerful data presentation tools in MS Excel. Learn how to use them, and how to spice them up with Microsoft Excel templates.
with Todd McLeodPivot charts are some of the most powerful data presentation tools in MS Excel. Learn how to use them, and how to spice them up with Microsoft Excel templates.
-
3 minMicrosoft Office lesson 242 CQ
In this lesson, learn about finding and harvesting data. Todd McLeod gives an introduction to gathering data from the Web to use in Microsoft Excel.
with Todd McLeodIn this lesson, learn about finding and harvesting data. Todd McLeod gives an introduction to gathering data from the Web to use in Microsoft Excel.
-
9 minMicrosoft Office lesson 255 CQ
Copying and pasting web data into Microsoft Excel can be a frustrating process. Learn how to import web data into clean, formatted Excel spreadsheets.
with Todd McLeodCopying and pasting web data into Microsoft Excel can be a frustrating process. Learn how to import web data into clean, formatted Excel spreadsheets.
-
3 minMicrosoft Office lesson 262 CQ
Harvesting data is easy, but formatting data can be tricky. Learn more methods to copy and paste website data into Microsoft Excel spreadsheets.
with Todd McLeodHarvesting data is easy, but formatting data can be tricky. Learn more methods to copy and paste website data into Microsoft Excel spreadsheets.
-
9 minMicrosoft Office lesson 275 CQ
In this lesson, learn to parse data from a company website in Microsoft Excel, turning data anomalies and glitchy formatting into a clean Excel spreadsheet.
with Todd McLeodIn this lesson, learn to parse data from a company website in Microsoft Excel, turning data anomalies and glitchy formatting into a clean Excel spreadsheet.
-
2 minMicrosoft Office lesson 282 CQ
In this lesson, learn about using web scraping software to ease data collection from the web—a great tool for both business people and researchers!
with Todd McLeodIn this lesson, learn about using web scraping software to ease data collection from the web—a great tool for both business people and researchers!
-
13 minMicrosoft Office lesson 297 CQ
If you only use Microsoft Excel to keep records, you’re missing out on some seriously cool features! Learn how to freeze frames, sort and filter data, and more.
with Todd McLeodIf you only use Microsoft Excel to keep records, you’re missing out on some seriously cool features! Learn how to freeze frames, sort and filter data, and more.
-
12 minMicrosoft Office lesson 307 CQ
Learn a whole new way of looking at spreadsheet data: the pivot table! Todd McLeod shows how to generate pivot tables in Microsoft Excel workbooks.
with Todd McLeodLearn a whole new way of looking at spreadsheet data: the pivot table! Todd McLeod shows how to generate pivot tables in Microsoft Excel workbooks.
-
7 minMicrosoft Office lesson 314 CQ
Microsoft Excel pivot tables give you a wide variety of options for viewing spreadsheet data. Learn to group pivot table data, and add slicers and pivot charts!
with Todd McLeodMicrosoft Excel pivot tables give you a wide variety of options for viewing spreadsheet data. Learn to group pivot table data, and add slicers and pivot charts!
-
6 minMicrosoft Office lesson 324 CQ
Organizing your data is not enough for a killer MS Excel workbook. Learn to make spreadsheets that look great and are easy to read by formatting cells!
with Todd McLeodOrganizing your data is not enough for a killer MS Excel workbook. Learn to make spreadsheets that look great and are easy to read by formatting cells!
-
8 minMicrosoft Office lesson 335 CQ
An Excel spreadsheet can display a lot of data, so it’s important to make sure it looks good. Learn some of the MS Excel formatting options in this lesson!
with Todd McLeodAn Excel spreadsheet can display a lot of data, so it’s important to make sure it looks good. Learn some of the MS Excel formatting options in this lesson!
-
9 minMicrosoft Office lesson 345 CQ
Maximize your work in Microsoft Excel by mastering the insert ribbon's formatting options. There's a whole world of worksheet glory waiting!
with Todd McLeodMaximize your work in Microsoft Excel by mastering the insert ribbon's formatting options. There's a whole world of worksheet glory waiting!
-
6 minMicrosoft Office lesson 354 CQ
What's the secret to fantastic formatting in Microsoft Excel? Learning how to use the functions on the Page Layout, Review, and View ribbons.
with Todd McLeodWhat's the secret to fantastic formatting in Microsoft Excel? Learning how to use the functions on the Page Layout, Review, and View ribbons.
-
12 minMicrosoft Office lesson 367 CQ
Data entry got you down? Learn how to use macros in Microsoft Excel for faster data entry! Your spreadsheets will practically fill in themselves!
with Todd McLeodData entry got you down? Learn how to use macros in Microsoft Excel for faster data entry! Your spreadsheets will practically fill in themselves!
-
6 minMicrosoft Office lesson 374 CQ
Dynamically share data when you embed or link Microsoft Excel worksheets, pivot tables, and charts into Microsoft Word documents. Save time and work smarter!
with Todd McLeodDynamically share data when you embed or link Microsoft Excel worksheets, pivot tables, and charts into Microsoft Word documents. Save time and work smarter!
-
12 minMicrosoft Office lesson 387 CQ
Worried about securing your spreadsheets? Keep Excel data safe from prying eyes, or embezzling employees, with this lesson on protecting your information.
with Todd McLeodWorried about securing your spreadsheets? Keep Excel data safe from prying eyes, or embezzling employees, with this lesson on protecting your information.
-
10 minMicrosoft Office lesson 396 CQ
Learn how to print in Excel with this simple lesson. You'll also learn how to upload to the cloud for easy information transfers. Share your Excel excellence!
with Todd McLeodLearn how to print in Excel with this simple lesson. You'll also learn how to upload to the cloud for easy information transfers. Share your Excel excellence!
-
10 minSTEM lesson 406 CQ
Wonder what the heck a Google Drive is? Get Google savvy with this user friendly tech lesson. Create spreadsheets, documents, forms, and more—all for free!
with Todd McLeodWonder what the heck a Google Drive is? Get Google savvy with this user friendly tech lesson. Create spreadsheets, documents, forms, and more—all for free!
-
4 minFREEMicrosoft Office lesson 41Free3 CQ
Managing student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.
with Todd McLeodManaging student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.
-
7 minMicrosoft Office lesson 424 CQ
In this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.
with Todd McLeodIn this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.
-
2 minMicrosoft Office lesson 432 CQ
In this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.
with Todd McLeodIn this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.
-
2 minMicrosoft Office lesson 442 CQ
Learn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!
with Todd McLeodLearn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!
-
3 minMicrosoft Office lesson 452 CQ
Add Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!
with Todd McLeodAdd Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!
-
2 minMicrosoft Office lesson 462 CQ
In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!
with Todd McLeodIn this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!
-
5 minMicrosoft Office lesson 473 CQ
In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.
with Todd McLeodIn this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.
-
3 minMicrosoft Office lesson 482 CQ
Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.
with Todd McLeodLearn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.
-
2 minMicrosoft Office lesson 492 CQ
You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.
with Todd McLeodYou’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.
-
9 minMicrosoft Office lesson 505 CQ
In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.
with Todd McLeodIn this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.
-
8 minMicrosoft Office lesson 515 CQ
Planning loan repayment for a house or other major expense? In this lesson, learn how to create a loan amortization payment schedule in Microsoft Excel.
with Todd McLeodPlanning loan repayment for a house or other major expense? In this lesson, learn how to create a loan amortization payment schedule in Microsoft Excel.
-
9 minMicrosoft Office lesson 525 CQ
In this lesson, learn about the applications and potential pitfalls of using data tables in Microsoft Excel Spreadsheet, using a PMT function example.
with Todd McLeodIn this lesson, learn about the applications and potential pitfalls of using data tables in Microsoft Excel Spreadsheet, using a PMT function example.
-
2 minMicrosoft Office lesson 532 CQ
In this lesson, learn the simple steps of using Microsoft Excel’s filter features to home in on specific values and text in an Excel spreadsheet!
with Todd McLeodIn this lesson, learn the simple steps of using Microsoft Excel’s filter features to home in on specific values and text in an Excel spreadsheet!
-
11 minMicrosoft Office lesson 546 CQ
In this lesson, find out about the Excel advanced filter option. Learn to use AND and OR Boolean searches, wildcards, and multiple keywords.
with Todd McLeodIn this lesson, find out about the Excel advanced filter option. Learn to use AND and OR Boolean searches, wildcards, and multiple keywords.
-
6 minMicrosoft Office lesson 554 CQ
In this lesson, learn how to filter data for keywords using the Microsoft Excel FIND and OR functions—a great alternative to the advanced filter!
with Todd McLeodIn this lesson, learn how to filter data for keywords using the Microsoft Excel FIND and OR functions—a great alternative to the advanced filter!
-
11 minMicrosoft Office lesson 566 CQ
In this lesson, learn how to organize Microsoft Excel spreadsheet information by sorting and finding relevant cell data and removing duplicates entries.
with Todd McLeodIn this lesson, learn how to organize Microsoft Excel spreadsheet information by sorting and finding relevant cell data and removing duplicates entries.
-
1045 min10-part Microsoft Office course27 CQ
With the basic Microsoft Excel knowledge introduced in this course, build a gradebook based on a course syllabus, format and customize data, and use formulas and functions to calculate grades!
with Todd McLeodWith the basic Microsoft Excel knowledge introduced in this course, build a gradebook based on a course syllabus, format and customize data, and use formulas and functions to calculate grades!
-
17183 min17-part Basic Computing course98 CQ
Computers are essential tools that can increase your productivity and boost your quality of life. Improve your understanding of technology and basic computer skills with this beginner-friendly course.
with Todd McLeodComputers are essential tools that can increase your productivity and boost your quality of life. Improve your understanding of technology and basic computer skills with this beginner-friendly course.
-
10115 min10-part Basic Computing course62 CQ
Understanding how a computer stores data is an essential computer skill. In this course, computer expert Todd McLeod shares everything he knows about computer data storage and how to manage memory.
with Todd McLeodUnderstanding how a computer stores data is an essential computer skill. In this course, computer expert Todd McLeod shares everything he knows about computer data storage and how to manage memory.
-
17130 min17-part Hardware course74 CQ
If you’re looking for a course that covers the basics of computer hardware in plain language, this is it! Learn everything from drives to ROM with technology and computer expert, Todd McLeod.
with Todd McLeodIf you’re looking for a course that covers the basics of computer hardware in plain language, this is it! Learn everything from drives to ROM with technology and computer expert, Todd McLeod.
-
1484 min14-part Basic Computing course49 CQ
Want to learn the basics of how computers work? In this course, tech expert Todd McLeod demonstrates essential computer skills—including how to use keyboard shortcuts and customize your desktop.
with Todd McLeodWant to learn the basics of how computers work? In this course, tech expert Todd McLeod demonstrates essential computer skills—including how to use keyboard shortcuts and customize your desktop.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.