Course

Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

Skillsoft

Updated Mar 11, 2018

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.

Related learning

Word 2016 Intermediate: Custom List and Table StylesInteractive ⋅ 8 mins

Word 2016 Intermediate: Add Excel Tables and ObjectsInteractive ⋅ 12 mins

Excel 2010 Part 2: Custom Cell FormatsInteractive ⋅ 8 mins

Microsoft Excel 2016 Essentials: Formatting DataCourse ⋅ 54 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Skillsoft GLOBAL

Skillsoft is the global leader in corporate learning, providing the most engaging learner experience and high-quality content. Skillsoft are trusted by the world's leading organizations, including 65 percent of the Fortune 500. Skillsoft's mission is to build beautiful technology and engaging content that drives business impact for today's modern enterprise. Skillsoft provides a comprehensive selection of cloud-based corporate learning content, including courses, videos, books and other resources. Skillsoft's 500,000+ multi-modal courses, videos, authoritative content chapters and micro-learning modules are accessed more than 130 million times every month, in 160 countries and 29 languages. Via the Go1 Content Hub, you can access Skillsoft courses on topics including Business and Management Skills, Leadership Development, Digital Transformation, IT Skills and Certification Training, Productivity and Collaboration Tools and Compliance.