BUILDING INTERACTIVE DASHBOARDS USING MICROSOFT EXCEL

0
(0 Reviews)

Duration 1 h 23 m 32 s

Price

$ 6 Buy now
BUILDING INTERACTIVE DASHBOARDS USING MICROSOFT EXCEL

About Course

This course is about understanding the process of creating an interactive dashboard using Microsoft Excel. This includes data collection methods, data formatting and method creation, charting and creating charts and creating tables and merging them into your own interactive dashboard. It will also cover using the right charts and a bit of theory.

This course is for students who are familiar with Excel. It's not a beginner. If you're familiar with creating tables, formatting, and basic formulas, this course is for you. If you are into Excel, it is recommended that you familiarize yourself with the program before you can get started on this course.

This course will help you (L): Not only to learn) what creating a dashboard really means Apart from the tips and tricks learned in Excel, how to present data correctly, what the sheet make error-proof results It helps, yourself and to convey to customers and/or colleagues.

You will need Microsoft Excel 2010 or older in time for this course There is one small feature that will be discussed that is only available in Windows versions.

Course content

videoIntroduction1 m 36 s Start
videoClass Outline2 m 9 s Start
videoLesson 1: Breaking Down an Interactive Dashboard4 m 57 s Start
videoLesson 2: Data Sourcing12 m 27 s Start
videoLesson 3: Structuring Data7 m 47 s Start
videoLesson 4: Pivots & Charts25 m 1 s Start
videoLesson 5: Putting the dashboard together13 m 59 s Start
videoLesson 6: Making the dashboard interactive5 m 43 s Start
videoLesson 7: Branding & Formatting9 m 53 s Start
ubaid

ubaid

Course Instructor

0
(0 Reviews)
See more