• COURSES

  • CALENDAR

  • CERTIFICATIONS

  • RESOURCES

  • SERVICES

  • BLOG

  • CONTACT

  • Blog and Sales Related Content

  • Members

  • My Wallet

  • More

    Class Inquiries:  801-561-8511

    0

    Microsoft Office Excel 2016: Data Analysis with Power Pivot

    $150.00Price
    This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
    Class Date
    Request a Date
    • COURSE OUTLINE

    • CANCELLATION POLICY

    • CLASSROOM POLICY

    Microsoft Office Excel 2016: Data Analysis with Power Pivot

    1/2 Day

     

    Description:

    We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

     

    Continuing Education:

    This event is eligible for the following continuing education credits:

    • CEU: 0.35 credits

    • PDU: 3.5 credits

    For more information on Continuing Education credits: http://www.expandlearning.com/continuing-education-and-professional-development.php   

     

    Prerequisites: 

     

    To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following courses:
    Microsoft Office Excel 2016: Part 1 (Basic)
    Microsoft Office Excel 2016: Part 2 (Intermediate)
    Microsoft Office Excel 2016: Data Analysis with PivotTables (recommended)

     

     

    Course Outline

    Lesson 1: Getting Started with Power Pivot

    • Topic A: Enable and Navigate Power Pivot
    • Topic B: Manage Data Relationships

     

    Lesson 2: Visualizing Power Pivot Data

    • Topic A: Create a Power Pivot Report
    • Topic B: Create Calculations in Power Pivot

     

    Lesson 3: Working with Advanced Functionality in Power Pivot

    • Topic A: Create a Key Performance Indicator
    • Topic B: Work with Dates and Time in Power Pivot

     

    Appendix A: Commonly Used DAX Functions

     

    We invite you to attend Microsoft Excel training in Salt Lake City, Utah. Our locally owned and operated West Valley classroom is designed to allow you to get the most out of your Excel class with training delivered by local Excel pros.Attend a Microsoft Excel class in our Salt Lake City, Utah facility and learn to organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. You will also learn to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

    Expand Learning Solutions offers local instructor-led training classes in West Valley, Utah for Excel version 2016, 2013, 2010 and 2007. We offer Excel Basic, Intermediate, and Advanced classes in addition to Excel VBA (Excel Programming with Visual Basic for Applications). ​Expand Learning Solutions, also offers Microsoft Excel Training via live online options and self-paced options.​​​​​​​​

    • facebook
    • Twitter Clean
    • w-googleplus

    © 2015 Expand Learning Solutions

    1455 West 2200 South #103

    Salt Lake City, Utah 84119

    801-561-8511

    Quick Links

    • About Us

    • FAQs

    • Directions

    • Student Reviews

    • Class Evaluation Survey

    • Free Workshop Series Survey

    Popular Now

    • Featured Classes

    • Course Catalog

      • Microsoft​

      • Cisco

    • Certifications