Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Engineering Interactive Dashboards
Rating: 4.6 out of 5(29 ratings)
1,236 students

Microsoft Excel Engineering Interactive Dashboards

Spreadsheet Engineering
Created byManish Narayan
Last updated 6/2022
English
English [Auto],

What you'll learn

  • Transform Excel into an engineering tool that will help solve real world problems in various industries
  • Gain knowledge in Excel and Visual Basic for Applications (VBA)
  • Create Structured Spreadsheet Designs
  • Develop VBA Functions and Sub Procedures
  • Expand the role of spreadsheets to improve processes
  • Utilize Excel Engineering for Optimization and Uncertainty Analysis
  • Introduce UserForms and User Controls for overall Project Control

Course content

2 sections • 10 lectures • 51m total length

  • Source Data6:38

    Discover how to build interactive dashboards in Excel from diverse source data, and use the interactive dashboard source data workbook alongside naming the data range as source_data.

  • Revenue Map6:17

    Create a revenue map in Excel by building a pivot table, mapping revenue by state, and linking a map chart to the pivot data with a slicer.

  • Revenue History4:46

    Create a revenue history with a pivot table and pivot chart to display revenue over time by transaction date, with year, quarter, and month breakdown.

  • Damage Count2:21

    Create a damage count donut chart by building a pivot table from the source data, counting damaged versus new shipments, and presenting a clean dashboard chart with a legend.

  • Purchase Waterfall4:06

    Build a purchase method waterfall chart in the interactive dashboard by using a pivot table to count revenue by method (mobile app, store, website) and show the grand total.

  • Product Rating Bar3:05

    Build a product rating bar in Excel by creating a pivot table from source data, counting ratings, and displaying a 100% stacked pivot chart of product categories by rating.

Requirements

  • Must have Microsoft Office Excel installed

Description

Transform Microsoft Excel into a Spreadsheet Engineering environment!

Are you a student or professional in the field of engineering, finance, management, or science and have not been able to utilize Excel to its fullest potential to setup, model and solve real-world problems? Don't worry as THIS IS THE COURSE FOR YOU! 

Microsoft Excel is everywhere, at your home, university campus, or even at the workplace, but most users only utilize the basic functionality, rely on unstructured worksheets, and forget about the powerful tools that Excel is built upon.

In my course, I will teach you how to transform Excel into a spreadsheet engineering environment making use of structured worksheet designs, Visual Basic for Applications ("VBA"), complex spreadsheet function combinations, and best practices that will not only make your life easier when dealing with information/data but allow you to tackle those real-world problems whether at home, school, or in the professional field.

Interactive Dashboards will allow you to design and present real-world reporting dashboards by bringing your data to life! Interactive controls allow clients and users of your dashboard to easily slice and filter data through custom controls.

Take this course and show the world your transition from Excel User to Excel Engineer! 

Who this course is for:

  • Students, Adults, Professionals, Educators

Report abuse