How to Plan & Create Excel Spreadsheets
A 6-part course with Geoff Hudson
Start Free Preview Start CourseCourse Overview
Teacher
As a Microsoft Certified Professional, I have trained a wide range of government, corporate and private individuals. My experience extends over 20 years as a teacher and trainer. Understanding and using today's technology is critical to not only... View ProfileDetails
- Total Time 47 min
- Lessons 6
- Attachments 6
- Exercises 20
-
27 CQ
6 Lessons in This Course
-
10 minFREEMicrosoft Office lesson 1Free6 CQ
Follow along to learn how to plan a spreadsheet in Excel to calculate whether or not a bank will grant a loan, and complete the course for specific details.
with Geoff HudsonFollow along to learn how to plan a spreadsheet in Excel to calculate whether or not a bank will grant a loan, and complete the course for specific details.
-
6 minMicrosoft Office lesson 24 CQ
Learn how to use what-if data analysis tools in Excel to customize the calculations and display of data, including Goal Seek and Scenario Manager.
with Geoff HudsonLearn how to use what-if data analysis tools in Excel to customize the calculations and display of data, including Goal Seek and Scenario Manager.
-
7 minMicrosoft Office lesson 34 CQ
You'll learn how to use various features of Excel, like Auto Fill to automatically calculate data, and creating a chart using a keyboard shortcut.
with Geoff HudsonYou'll learn how to use various features of Excel, like Auto Fill to automatically calculate data, and creating a chart using a keyboard shortcut.
-
6 minMicrosoft Office lesson 44 CQ
Follow along to learn how to adjust the layout and tabs or sheets in a workbook, and how to create a table of contents in Excel.
with Geoff HudsonFollow along to learn how to adjust the layout and tabs or sheets in a workbook, and how to create a table of contents in Excel.
-
7 minMicrosoft Office lesson 54 CQ
In this lesson, learn how to format a chart in Excel, customizing everything from axis titles to the legend and more!
with Geoff HudsonIn this lesson, learn how to format a chart in Excel, customizing everything from axis titles to the legend and more!
-
8 minMicrosoft Office lesson 65 CQ
Learn how to create an attractive and easy-to-read budget spreadsheet that calculates financial information to help you or a client track expenses and income.
with Geoff HudsonLearn how to create an attractive and easy-to-read budget spreadsheet that calculates financial information to help you or a client track expenses and income.
-
323 min3-part Microsoft Office course14 CQ
Learn how to create a PowerPoint slideshow as you follow along with a Microsoft certified pro. Gain basic skills, then add transitions as you learn to automate a presentation for continuous play!
with Geoff HudsonLearn how to create a PowerPoint slideshow as you follow along with a Microsoft certified pro. Gain basic skills, then add transitions as you learn to automate a presentation for continuous play!
-
322 min3-part Microsoft Office course12 CQ
In this MS Office Suite course, learn how to navigate Excel spreadsheets and Word documents with useful tips and shortcuts, and how to make an eye-popping PowerPoint presentation efficiently.
with Geoff HudsonIn this MS Office Suite course, learn how to navigate Excel spreadsheets and Word documents with useful tips and shortcuts, and how to make an eye-popping PowerPoint presentation efficiently.
-
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.
-
734 min7-part Negotiating course21 CQ
Asking for a raise is intimidating, but TJ Walker's preparation strategy increases the odds of success! Follow the steps outlined in this course to prepare the strongest possible case for a raise.
with TJ WalkerAsking for a raise is intimidating, but TJ Walker's preparation strategy increases the odds of success! Follow the steps outlined in this course to prepare the strongest possible case for a raise.
-
758 min7-part Management course32 CQ
In this business course, review seven effective engagement habits for managers to increase the level of team engagement and motivation, leading to sustainably high business performance.
with LeaderonomicsIn this business course, review seven effective engagement habits for managers to increase the level of team engagement and motivation, leading to sustainably high business performance.
-
1084 min10-part Management course47 CQ
Want to breathe new life into your company? In this course, count down the top ten unresolved organizational issues in most businesses and organizations that affect their sustainable performance.
with LeaderonomicsWant to breathe new life into your company? In this course, count down the top ten unresolved organizational issues in most businesses and organizations that affect their sustainable performance.
-
953 min9-part Marketing course32 CQ
In this introductory course on marketing, learn professional marketing concepts that will help you come across as knowledgeable and insightful as you seek your first marketing role.
with MeanThatIn this introductory course on marketing, learn professional marketing concepts that will help you come across as knowledgeable and insightful as you seek your first marketing role.
-
13 minFREECareer Growth courseFree7 CQ
In this Conversation, Aaron Skonnard, co-founder and CEO of Pluralsight, explains how and why he started Pluralsight, and shares some of his secrets to success.
with Aaron SkonnardIn this Conversation, Aaron Skonnard, co-founder and CEO of Pluralsight, explains how and why he started Pluralsight, and shares some of his secrets to success.