Advanced Excel 2016 - Online Training - Online Certification Courses

Page 1

Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Buy Now 3 Month Access - $59 6 Month Access - $79 12 Month Access - $99


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Overview/Description Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Target Audience End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Lesson Objectives Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms start the course

*configure Power Pivot and import data into a Microsoft Excel 2016 Workbook *create a PivotTable using Power Pivot in Microsoft Excel 2016


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

*create and populate a PivotTable using Power Pivot in Microsoft Excel 2016 *create a custom number format in Microsoft Excel 2016 *create a custom date and time format in Microsoft Excel 2016 *create a custom accounting format in Microsoft Excel 2016 create a custom fill series in Microsoft Excel 2016


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

*create custom conditional formatting rules in Microsoft Excel 2016 *modify custom conditional formatting rules in Microsoft Excel 2016 *apply complex filtering criteria to data in Microsoft Excel 2016 *use custom formats, filters, and fill series when working with data in Microsoft Excel 2016


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Lesson Objectives Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms start the course *configure Power Pivot and import data into a Microsoft Excel 2016 Workbook *create a PivotTable using Power Pivot in Microsoft Excel 2016


Advanced Excel 2016 - Online Training - Online Certification Courses | E-Learning Center

Follow Us On: http://www.e-learningcenter.com Follow Us On: https://www.facebook.com/elearningcenter1 Follow Us On: https://twitter.com/ELearningCntr Follow Us On: https://instagram.com/elearningcenter


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.