Create Dynamic INTERACTIVE Dashboards in Excel [No Coding needed]

Опубликовано: 04 Декабрь 2022
на канале: Nicos Paphitis

983

This tutorial is focused around an educators grade book and covers everything from the basics of Excel to creating a grade book and finally making the grade book interactive. The concepts learnt can be implemented in any kind of spreadsheet.
If you are familiar with basic functions in Excel then use the timestamps to jump ahead or go to: 29:49 where i start building my grade book as a table
40:08 generating the Slicer and adding the chart.
-------------------------------------------------------------------------------------
The file used in this tutorial is available below.
0:00 Intro
1:07 Demonstrating the difference of a basic grade book and an interactive dashboard

Learning Excel basics
6:06 Learning the Excel basics (Active cell, formula bar, constants, variables, what are functions)
9:01 Basic functions (Sum, Max, Min Average)
11:57 Relative and absolute references
17:09 IF function explained
21:30 Vlookup (vertical lookup) function explained
25:08 Count functions (Count, CountA, CountIF)

Creating a dynamic interactive gradebook
28:33 Converting the data to a Table

29:49 Using the formulas learnt to generate the grade book
35:47 Understanding that function results remain the same when data is filtered.
36:47 Creating an interactive Slicer
40:08 Creating a dynamic chart
42:51 Adding another category to the chart
44:18 Changing the chart Maximum and Minimum axis bounds

Access the file used in the tutorial:
https://thejuniorschool-my.sharepoint...