Save for later

Creating a Basic Dashboard in Excel 2016

Master Excel 2016,

Learn easy-to-implement techniques that can help you quickly create a visual representation of your data to inform your decision making. In this brief course, Curt Frye walks through the basics of creating a dashboard in Excel. Curt begins with a primer on using PivotTables—one of the most powerful data analysis tools in Excel. He also shares how to define conditional formats and summarize your data with sparklines and charts. Plus, he shows how to set up your dashboard worksheet, link data to cells and shapes, maximize your screen space by hiding rows, and modify the Excel program window to meet your needs.
    Get Details and Enroll Now

    OpenCourser is an affiliate partner of LinkedIn Learning and may earn a commission when you buy through our links.

    Get a Reminder

    Send to:
    Rating Not enough ratings
    Length 1h 31m
    Starts On Demand (Start anytime)
    Cost $29/month (Access to entire library- free trial available)
    From LinkedIn Learning
    Instructor Curt Frye
    Download Videos Only via the LinkedIn Learning mobile app
    Language English
    Subjects Business
    Tags Business Spreadsheets

    Get a Reminder

    Send to:

    Similar Courses

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile.

    Dashboard Coordinator/Administrative Specialist $43k

    Data 2 $50k

    BI Universe/Reports/Dashboard Developer $64k

    Excel Reporting Developer $68k

    Techniques (General) Engineer $70k

    Adjunct Professor of Digital Media Techniques and Computer Graphic Design $70k

    Excel/Access DTS Developers $78k

    Excel VBA Developer $82k

    Excel/Access DTS Developer $83k

    Tutor - Accounting/ Excel /ESL $87k

    Data Analyst, Data Warehousing $93k

    Data Administrator / Data Modeler $108k

    Write a review

    Your opinion matters. Tell us what you think.

    Rating Not enough ratings
    Length 1h 31m
    Starts On Demand (Start anytime)
    Cost $29/month (Access to entire library- free trial available)
    From LinkedIn Learning
    Instructor Curt Frye
    Download Videos Only via the LinkedIn Learning mobile app
    Language English
    Subjects Business
    Tags Business Spreadsheets

    Similar Courses

    Sorted by relevance

    Like this course?

    Here's what to do next:

    • Save this course for later
    • Get more details from the course provider
    • Enroll in this course
    Enroll Now