Excel 365 eLearning Bundle Course

Excel 365: Beginner – 4:46 hours

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. This course gives an introduction to Excel via the Office 365 Suite. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. This course has an assessment which may be required for a certificate to be generated.

Course Objectives:
• Learn the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets
• Enter data, format spreadsheets, manipulate columns and rows, add headers and footers
• Use page setup options to prepare them for printing
• Handle large worksheets or multiple workbooks
• Use styles and themes, and insert various graphic objects
• Learn the options for proofing your workbooks

Excel 365: Intermediate – 4:31 hours

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. This course has an assessment which may be required for a certificate to be generated.

Course Objectives:
• Learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables
• Apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines
• Understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features

Excel 365: Advanced – 4:20 hours

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel’s many collaboration features and import and export data to and from their workbooks. This course has an assessment which may be required for a certificate to be generated.

Course Objectives:
• Understand advanced concepts and formulas and collaboration features of Excel 365
• Learn functions such as SUMIF, AVERAGEIF, and COUNTIF
• Explore advanced lookup functions, and complex logical and text functions
• Experiment with auditing formulas and error checking
• Use the What-If Analysis tools
• Learn the options for worksheet and workbook protection
• Review advanced use of PivotTables and PowerPivot add-in
• Learn to ensure data integrity in worksheets and workbooks