Computer Applications   

Master the skills and develop the knowledge you need to increase your financial awareness, while taking your Excel skills to add time-saving functions to your repertoire.

Introduction to Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. By the time you're done, you'll be using Excel like a professional.

Intermediate Microsoft Excel 2016

Take your Excel skills to the next level! In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. So get ready for six action-packed weeks that will make you an Excel expert!

Accounting Fundamentals

Demand for accounting professionals currently exceeds supply. If you're interested in increasing your financial awareness and accountability while also gaining a marketable skill, this course is for you. You'll learn the basics of double-entry bookkeeping, while also learning how to analyze and record financial transactions, as well as prepare various financial reports at the end of the fiscal period. Accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities will be discussed. We'll cover all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period.

Accounting Fundamentals II

While it is true that accounting professionals are scarce, those with corporate accounting experience are even more rare. This course will build on the knowledge you gained in our Accounting Fundamentals course to provide you with a solid understanding of corporate accounting practices. You'll be able to analyze transactions and prepare various corporate financial reports. You'll also gain practical experience working with dividends, plant assets, depreciation, accrued revenue and expenses, retained earnings, stockholders' equity, and more.

Please complete the courses in the bundle two months apart to avoid overlapping. Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Excel 2016 (not included in enrollment)

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the skills and develop the knowledge you need to increase your financial awareness, while taking your Excel skills to add time-saving functions to your repertoire.

1. Introduction to Microsoft Excel 2016
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
2. Intermediate Microsoft Excel 2016
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. PivotTables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Accounting Fundamentals
   1. Account Classifications, Account Titles, T Accounts, and the Accounting Equation
   2. General Ledger Accounts and the Balance Sheet
   3. Journalizing Transactions and Posting to the General Ledger
   4. Journalizing and Posting Cash and Charge Purchases and Payments on Account
   5. Journalizing and Posting Cash and Charge Sales and Cash Received on Account
   6. Payroll and Various Deductions
   7. Banking Services and Reports
   8. Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable
   9. End-Of-Year Worksheet
   10. End-Of-Year Financial Reports
   11. Journalizing and Posting Adjusting Entries
   12. Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance
4. Accounting Fundamentals II
   1. Accounts Payable
   2. Accounts Receivable
   3. Uncollectible Accounts Receivable
   4. Plant Assets and Depreciation
   5. Notes Payable and Notes Receivable
   6. Accrued Income and Accrued Expenses
   7. Dividends and Starting the Year-End Worksheet
   8. Complete Year-End Worksheet With Adjustments
   9. End-Of-Fiscal-Period Financial Reports
   10. Adjusting and Closing Entries and Post Closing Trial Balance
   11. Preparing a Payroll
   12. Preparing Federal Tax Deposits and Year-End Tax Reports

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Nancy Koenig

Nancy Koenig is an experienced industry professional with over 40 years in the workforce, including decades in finance. Nancy has worked in various finance roles in banking, insurance, and a hospital billing office. For the last 27 years of her career, she was an administrative assistant at a technical school, which involved running and overseeing the entire budget, amongst other duties. Nancy has also held part-time jobs as a bookkeeper for an auto parts store and a cable company, where she used QuickBooks computerized software. Over the past several years, she has also co-taught the Accounting Fundamentals and Accounting Fundamentals II courses with Charlene Messier.

The online course suite will help you master fundamental accounting skills and learn Microsoft Excel 2019.

Learning Excel is an important first step toward an accounting career. As the most widely-used spreadsheet software, Microsoft Excel is used by accountants to analyze data, create reports, and prepare forecasts. This online accounting course suite will teach you fundamental accounting skills, while training you to use Microsoft Excel 2019.

Introduction to Microsoft Excel 2019:

Become proficient in using Microsoft Excel 2019 (now available through Office 365) and discover how to create worksheets, workbooks, charts, and graphs quickly and efficiently.

Intermediate Microsoft Excel 2019:

Take your Microsoft Excel 2019 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.

Accounting Fundamentals:

Gain a marketable new skill by learning the basics of double-entry bookkeeping, financial reporting, and more.

Accounting Fundamentals II:

Learn the high demand accounting skills needed at small-to-medium sized businesses.

Please complete the courses in the bundle two months apart to avoid overlapping. Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Excel 2019 (desktop version) Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

As the most widely used spreadsheet software, Microsoft Excel is used by accountants to analyze data, create reports, and prepare forecasts. The Accounting with MS Excel 2019 Suite will help you gain basic accounting skills while training you to effectively use Microsoft Excel 2019. Discover how to create and use worksheets, charts, graphs, and more advanced features of Excel as you learn the double-entry bookkeeping, financial reporting, and other accounting fundamentals used in small to mid-sized companies.

1. Accounting Fundamentals
   1. Account Classifications, Account Titles, T Accounts, and the Accounting Equation
   2. General Ledger Accounts and the Balance Sheet
   3. Journalizing Transactions and Posting to the General Ledger
   4. Journalizing and Posting Cash and Charge Purchases and Payments on Account
   5. Journalizing and Posting Cash and Charge Sales and Cash Received on Account
   6. Payroll and Various Deductions
   7. Banking Services and Reports
   8. Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable
   9. End-Of-Year Worksheet
   10. End-Of-Year Financial Reports
   11. Journalizing and Posting Adjusting Entries
   12. Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance
2. Accounting Fundamentals II
   1. Accounts Payable
   2. Accounts Receivable
   3. Uncollectible Accounts Receivable
   4. Plant Assets and Depreciation
   5. Notes Payable and Notes Receivable
   6. Accrued Income and Accrued Expenses
   7. Dividends and Starting the Year-End Worksheet
   8. Complete Year-End Worksheet With Adjustments
   9. End-Of-Fiscal-Period Financial Reports
   10. Adjusting and Closing Entries and Post Closing Trial Balance
   11. Preparing a Payroll
   12. Preparing Federal Tax Deposits and Year-End Tax Reports
3. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
4. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Nancy Koenig

Nancy Koenig is an experienced industry professional with over 40 years in the workforce, including decades in finance. Nancy has worked in various finance roles in banking, insurance, and a hospital billing office. For the last 27 years of her career, she was an administrative assistant at a technical school, which involved running and overseeing the entire budget, amongst other duties. Nancy has also held part-time jobs as a bookkeeper for an auto parts store and a cable company, where she used QuickBooks computerized software. Over the past several years, she has also co-taught the Accounting Fundamentals and Accounting Fundamentals II courses with Charlene Messier.

Get a comprehensive overview of Microsoft Excel 2019 and improve your understanding of data.

Gain the skills and knowledge you need to start analyzing, tracking and managing data with Microsoft Excel 2019. You will learn how to use, collect, and apply data to real-life problems with charts, numbers and graphs.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Advanced Microsoft Excel 2019

In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Introduction to Statistics

Improve your understanding of data and learn how to develop graphs and charts. With real-world applications and easy-to-understand examples drawn from business, health care, sports, education, and politics, this course provides the skills and knowledge you need to start analyzing data.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Excel 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• (Please note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.)

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

The Microsoft Excel 2019 and Statistics Suite will give you the tools and knowledge you need to collect, analyze, track, and manage data in the context of practical, real-world applications. Discover dozens of shortcuts and tricks to become more efficient and master more advanced techniques with hands-on exercises that can help you analyze data and create professional-looking reports.

1. Advanced Microsoft Excel 2019
   1. Customizing Excel
   2. Table Management
   3. Data Validation
   4. Custom Controls
   5. Conditional Formatting
   6. Consolidating and Outlining
   7. Excel Functions and Nesting
   8. Import External Data
   9. Data Tables
   10. What-If Analysis Tools
   11. Advanced PivotTables
   12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
4. Introduction to Statistics
   1. What Is Statistics, Anyway?
   2. Quantitative Data: From Averages to Z-Scores
   3. Displaying Quantitative Data: Dots, Plots, and Histograms
   4. Displaying Qualitative Data: Percentages, Charts, and Graphs
   5. Is There a Link? Scatterplots and Correlation
   6. Linear Regression: How Can You Predict the Future?
   7. What's the Chance of That? Probability Concepts
   8. Probability Models: What's Normal?
   9. The Key to Inference: Sampling Distributions
   10. How Certain Are You? Confidence Intervals for Proportions
   11. Trial by Data: Testing Hypotheses About Proportions
   12. Inference About Means

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Kathy Van Pelt

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Ben Sellers

Ben Sellers has more than 17 years of teaching experience both online and in the traditional classroom. He has taught college students, working professionals, adult learners, and K-12 students. He has also taught a wide variety of students in the medical field, including lab technicians, nurses, pharmacists, and aspiring physicians. Sellers holds undergraduate and graduate degrees in the mathematical sciences and has worked as a mathematical and statistical consultant.

This course bundle will introduce you to Microsoft Office Excel 2019 and teach you its intermediate and advanced features. Whether you're new to Excel or need a refresher, the Microsoft Excel 2019 Series bundle will help you master this longstanding spreadsheet software.

Introduction to Microsoft Excel 2019

This course focuses on the fundamentals of Excel 2019. You will first learn how to quickly and efficiently create fully formatted worksheets. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course.

Intermediate Microsoft Excel 2019

This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Advanced Microsoft Excel 2019

This course will help you make the most of your investment in Microsoft Excel 2019. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Excel 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• *Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This course bundle will introduce you to Microsoft Office Excel 2019 and teach you its intermediate and advanced features. Whether you're new to Excel or need a refresher, the Microsoft Excel 2019 Series bundle will help you master this longstanding spreadsheet software.

1. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. 3-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. PivotTables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Advanced Microsoft Excel 2019
   1. Customizing Excel
   2. Table Management
   3. Data Validation
   4. Custom Controls
   5. Conditional Formatting
   6. Consolidating and Outlining
   7. Excel Functions and Nesting
   8. Import External Data
   9. Data Tables
   10. What-If Analysis Tools
   11. Advanced PivotTables
   12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $5 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Learn the basic and intermediate functions of Microsoft Excel 2019 and Microsoft Access 2019.

Microsoft Excel 2019 and Microsoft Access 2019 are two of the most used programs to track and manage data sets. This course will teach you how use Microsoft Excel 2019 and Microsoft Access 2019.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Introduction to Microsoft Access 2019

Build, edit, and maintain databases in Microsoft Access 2019 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Intermediate Microsoft Access 2019

Develop a fully functional database in this hands-on Microsoft Access 2019 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Access 2019, 2021 and Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional. Please note: There may be some differences between your version of Access and what you see in the course.
• Microsoft Excel 2019, 2021 and Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional.
• *Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the use of two of the most widely used data management programs in the world when you complete the Microsoft Excel and Access 2019 Suite. Discover dozens of shortcuts and tricks that can help you become more efficient, build a fully functional database, and learn some of the more advanced features that will have you using Microsoft Excel and Access like a pro.

1. Intermediate Microsoft Access 2019
   1. Reviewing Terms and Importing Data
   2. Key Fields and Action Queries
   3. Relationships of the Database Kind
   4. Creating and Modifying Forms
   5. Subforms and the Tab Control
   6. Queries
   7. Query Calculations
   8. Summary Queries
   9. Building Reports That Pinpoint Key Information
   10. Run Reports from a Custom Dialog Box
   11. Using Visual Basic to Automate the Reports Dialog Box
   12. Putting It All Together
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Introduction to Microsoft Access 2019
   1. Getting to Know Access 2019
   2. Controlling Your Access Table Fields
   3. Creating Tables and Relationships
   4. Building Powerful Forms
   5. Adding Versatility to Forms
   6. Interviewing Your Database
   7. Taking Queries to the Next Level
   8. Multi-Table Query Control
   9. Reporting on Your Tables
   10. Creating Query-Based Reports
   11. Mastering Report Design
   12. Automating Your Database With Macros
4. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Laurie Ulrich

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

Ken Cook

Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. He is also co-author of four "Access for Dummies" books.

Learn the basic and intermediate functions of Microsoft Excel 2019 and Microsoft Project 2019.

Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. This course will teach you how use Microsoft Excel 2019 and Microsoft Project 2019.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Advanced Microsoft Excel 2019

In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Introduction to Microsoft Project 2019/Office 365

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Project 2019 (not included in enrollment).
• Microsoft Excel 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• *Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn how you can use Microsoft Excel 2019 and Microsoft Project 2019 to better manage budgets, schedules, and timelines in the course suite. Discover dozens of shortcuts and tricks that will increase your efficiency; learn to effectively plan, implement, and control projects with schedules, cost trackers, and reports; and master advanced features that will have you using Microsoft Excel and Project like a pro.

1. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Advanced Microsoft Excel 2019
   1. Customizing Excel
   2. Table Management
   3. Data Validation
   4. Custom Controls
   5. Conditional Formatting
   6. Consolidating and Outlining
   7. Excel Functions and Nesting
   8. Import External Data
   9. Data Tables
   10. What-If Analysis Tools
   11. Advanced PivotTables
   12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!
4. Introduction to Microsoft Project 2019/Office 365
   1. Overview of Microsoft Project
   2. Creating a Solid Foundation
   3. Creating and Managing Resources
   4. Defining and Assigning Costs
   5. Project Templates, Security, and Constraints
   6. Working With Views and Managing Information
   7. Fine-Tuning Your Project Plan
   8. Baselines and Tracking
   9. Managing Variances
   10. Closing Your Project
   11. Printing Views
   12. Using and Creating Reports

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Kathy Van Pelt

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Tony Swaim

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

Learn to use the basic features of Microsoft Word 2016, Microsoft Excel 2016, and Microsoft PowerPoint 2016, three of the most fundamental software programs used in educational and professional settings.

Each course within the Value Suite will introduce you to the features and functionality of Microsoft's latest software.

Introduction to Microsoft Word 2016

One of the most basic skills needed in any job is writing reports and letters using Microsoft Word (now available through Office 365). In this course, you'll gain the foundational skills you need to make the most of this powerful program to create professional-looking letters, reports, and documents. You'll learn how to type, edit, and format text, as well as dozens of ways to modify the appearance and content of your documents. You'll explore Word's features, such as spell and grammar checker and the thesaurus, to put a professional polish on your writing. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be ready to use Word confidently at home or on the job.

Introduction to Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. By the time you're done, you'll be using Excel like a professional.

Introduction to Microsoft PowerPoint 2016

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create impressive slide presentations using a variety of slide and layout masters that make global changes to your presentation in a snap. You'll also see how to embellish your slides with color, text, pictures, shapes, WordArt, SmartArt, charts, animation, video, audio, and hyperlinks, and discover how to create a PowerPoint photo album with your digital pictures. In addition, you'll work with PowerPoint Online, the free online version of PowerPoint, and the new Tell Me and Smart Lookup features. Whether you're a beginner or an experienced user, this course will teach you how to turn simple slides into an exciting presentation that will grab and hold your audience's attention.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Word, Excel, and PowerPoint 2016 (desktop versions) Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2016. (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft Word, Excel, and PowerPoint will not work with the full versions of the software taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

An impressive 67.6% of all middle-skill jobs now request a fundamental knowledge of Microsoft Office, and it's the most widely used software among primary, secondary, and post-secondary students. With that, knowing the features and functionality of this software is becoming increasingly important.

• Microsoft Word 2016
• Microsoft Excel 2016
• Microsoft PowerPoint 2016

This Value Suite combines three foundational Microsoft Office 2016 courses, teaching you the ins and outs of:

In this program, you'll learn everything from creating impressive letters and documents, to compelling spreadsheets and tables, to persuasive presentations.

Value Suite bundles are not eligible for partial drops or refunds. Transfers are available to other open sessions. Please refer to your school for additional details regarding drops, transfers, and refunds on Value Suite bundles.

Wallace Wang

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Wallace currently teaches an online iOS App Production course through UC San Diego Extended Studies, focusing on designing apps for the iPhone using SwiftUI and Xcode, emphasizing coding, user interface/experience design, and app marketing. It covers key topics such as the psychology of user interface design, creating prototypes, and effective marketing strategies for the App Store. He has recently provided consulting services for bLinkUp, assisting them with their iOS development projects.

Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.

Kathy Van Pelt

Kathy Van Pelt has been involved in education for many years, teaching and assisting students with microcomputer application courses. Kathy specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. For the past 25 years, she has taught computer courses at a community college, teaching both in the classroom and online. Before that, she spent nine years teaching word processing and business classes at a private business college. She loves being in the ever-evolving educational field, and she's especially excited about the flexibility that online learning offers students.

Some of the world's most widely used software programs are part of the Microsoft Office suite. This course bundle will teach you how to use Word 2019, Excel 2019, and PowerPoint 2019, Office's top business productivity programs. You will learn the basic features of each program and gain skills applicable to most professional settings.

Each course within the Microsoft Office 2019 Value Suite will introduce you to the basic features and functionality of Microsoft's 2019 software.

Introduction to Microsoft Word 2019

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. The Introduction to Microsoft Word 2019 course will teach you the basics of Word, so you can create, format, and organize professional-looking documents. By the time you're done with this hands-on course, you will be able to confidently use this popular word processing software at home or on the job.

Introduction to Microsoft Excel 2019

Introduction to Microsoft Excel 2019 includes new text and images based on the Excel 2019 update. You will learn a number of basic time-saving functions, including how to write basic formulas, design custom charts and graphs, and create three-dimensional workbooks. You will also be introduced Excel 2019's powerful charting capabilities like Quick Analysis and Flash Fill. When you finish the course, you will feel at ease creating worksheets and utilizing Excel's many features.

Introduction to Microsoft PowerPoint 2019/ Office 365

The Introduction to Microsoft PowerPoint 2019/Office 365 course will teach you how to use PowerPoint to create engaging, dynamic presentations. Each lesson includes instructional content, supplementary material, learning assessments, and an assignment to practice your newly acquired skills. With millions of PowerPoint presentations conducted daily, knowing how to effectively use this software is perfect for adding value to your professional profile.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Word, Excel, and PowerPoint 2019 (desktop versions) Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft Word, Excel, and PowerPoint will not work with the full versions of the software taught in this course.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

With more than one billion users worldwide, Microsoft Office remains the world's most popular business productivity software suite. From small businesses to Fortune 500 companies, job recruiters look for candidates that know how to use Microsoft Office's Word, Excel, and PowerPoint programs. Whether you're a beginner or need a refresher, the Microsoft Office 2019 Value Suite will teach you the fundamentals of some of the most widely-used programs in the Microsoft Office family.

This course bundle will introduce you to Microsoft Word 2019, Microsoft Excel 2019, and Microsoft PowerPoint 2019. These programs are used to handle common workplace tasks like word processing and presentation design. Through hands-on activities, you will gain proficiency in each of these programs and build skills that contribute to your organization's success.

1. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
2. Introduction to Microsoft PowerPoint 2019/Office 365
   1. The PowerPoint 2019 Interface
   2. Creating Presentations
   3. Working With Files and Creating and Editing Tables
   4. Creating Professional Presentations
   5. Working With the Images Group
   6. WordArt and the Illustrations Group
   7. All About Charts
   8. Making Global Changes to a Presentation
   9. Creating Links
   10. Applying Animation to Slides, Text, and Objects
   11. Adding Advanced Animation Effects to Text and Objects
   12. Sharing and Saving Your Presentations
3. Introduction to Microsoft Word 2019
   1. Getting Started
   2. Typing and Navigation
   3. File Management
   4. Editing Text
   5. Working With Multiple Documents
   6. Text Formatting and Alignment
   7. Printing
   8. Margins, Tabs, and Page Numbering
   9. Paragraph Formatting
   10. Language Tools
   11. Customizing Word
   12. Making a Word Document Pretty and Organized

Wallace Wang

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Wallace currently teaches an online iOS App Production course through UC San Diego Extended Studies, focusing on designing apps for the iPhone using SwiftUI and Xcode, emphasizing coding, user interface/experience design, and app marketing. It covers key topics such as the psychology of user interface design, creating prototypes, and effective marketing strategies for the App Store. He has recently provided consulting services for bLinkUp, assisting them with their iOS development projects.

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $5 billion. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting.

Tracy Loffer

Tracy Loffer holds a Master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer of students and teachers. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials using Office and Publisher.