Ultimate Excel 2016 Bundle (3-Courses: Intro, Interm & Adv)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course Description

Over 200 videos are included in this bundle!

Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes:

  • Excel 2016 Introduction
  • Excel 2016 Intermediate
  • Excel 2016 Advanced

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today.

In the Introduction course, you will learn the fundamentals of Excel and 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.

In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. 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, review advanced use of PivotTables and PowerPivot add-in, 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.

Expected Outcomes

  1. Navigate Excel
  2. Create Workbooks and Use Templates
  3. Work with Formulas
  4. Format worksheet Data
  5. Work with Named ranges
  6. Use Logical and Lookup functions
  7. Filter Data
  8. Work with Graphs
  9. Using IF Statements
  10. Using Worksheet Protection
  11. Work with PivotTables
  12. Use Macros
  13. Collaborate in Excel