TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Intermediate
Microsoft Other

Excel – Creating Dashboards

Overview
Curriculum

Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need?  This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards.

The ability to easily query and display information from your Excel data is a helpful tool for reporting and decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, Pivot Tables, and Slicers) which will do just that.

If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Barbara Evers walk you through even more useful Excel topics and tools

Curriculum

  • 20 Sections
  • 2h 49m Duration
Expand All
Creating Range Names
    Using Defined Names in a Formula
      Using Specialized Functions, Part 1
        Using Specialized Functions, Part 2
          Applying Data Validation
            Using a Data Form
              Adding Form Controls
                Using Lookup Functions
                  Combining Functions
                    Creating a Chart
                      Formatting and Modifying Charts
                        Dual Axis Charts
                          Forecasting with Trend Lines
                            Creating Chart Templates
                              Creating Sparklines
                                Inserting Pivot Tables
                                  Analyzing Pivot Table Data, Part 1
                                    Analyzing Pivot Table Data, Part 2
                                      Presenting Data with Pivot Charts
                                        Filtering Data with Slicers

                                          Deleting Course Review

                                          Are you sure? You can't restore this back

                                          Course Access

                                          This course is password protected. To access it please enter your password below:

                                          Buy for group

                                          Excel – Creating Dashboards
                                          No groups Found

                                          You don't have any groups yet

                                          Create a group and add group members. Sync Group(s)
                                          Choose Group(s)
                                          Sync Group(s)
                                            Create a new group Go to Checkout