School Management Dashboard using Microsoft Excel with changing images dynamically | Tutorial #1
School Management Dashboard using Microsoft Excel with changing images dynamically | Tutorial #1
Download our Templates / Get Free Datasets
Visit our online store https://www.other-levels.com
Contact us for business:
Comment down below
Customer services https://www.other-levels.com
Have a question about this dashboard?
Comment down below after joining our channel Membership,
/ @otherlevels
Video Tutorial #2 • School Management Dashboard using Mic…
All our videos / otherlevel’s
0:00, Dashboard Features \u0026 contents Overview
1:24, Database Overview
2:19, Background Design
5:27, Title \u0026 Description
11:20, Buttons Design
25:04, Students and Facult
Playlists
Multiple Dynamic Excel Dashboards • How to build Dynamic \u0026 Interactive Da…
Single Dynamic Excel Dashboard • Excel Real Estate and Property Manage…
Modern Excel Reports • Modern Excel Reports
PowerPoint Slides Playlist • How to Design a Modern Flow Process C…
Copyright © 2023 Other Level’s. All rights reserved.
“Any illegal reproduction of this content in any form will result in immediate action against the person concerned.”
#Excel #Dashboard #School_Dashboard
Content
4.61 -> hello everyone
in this video you will learn how you can create
10.7 -> this school management dashboard using Microsoft
Excel
14.639 -> So let's start
61.47 -> welcome to other levels,
These are the color codes used in the design
65.53 -> and the fonts type are Forte and Abadi.
67.61 -> We used many colors in this design and the
colors used are similar to each other, so
68.61 -> I will show you where the place of each color.
69.61 -> All the elements and images used in this dashboard
are not from sources outside Excel, but rather
74.61 -> from the Excel library
77.03 -> you can get all our templates fully customizable
by visiting our online store.
86.01 -> This is the database which we will build the
report,
90.2 -> In most cases,
Data are coming from different sources and
93.83 -> several departments within the same organization,
So in our designs, we try to use several types
100.67 -> of data and tables,
Once we use a table that contains all the
105.67 -> data,
Sometimes we prefer to be at separate data
108.94 -> tables,
Whether the data is big or small,
112.78 -> In order to teach you something important,
creating beautiful dashboards or reports doesn't
118.87 -> require a specific data model, and you can
always evolve your business into another level
124.17 -> of creativity.
126.189 -> Implementation of the dashboard will be on
unfamiliar steps and must be followed as it
130.89 -> is because I want to preserve the coordination
and overall appearance of the dashboard when
135.78 -> moving between them, so please watch carefully.
138.79 -> At first, open a new sheet tab, we will start
create the first dashboard for (high school).
146.81 -> remove the gridlines and Headings, then insert
a rounded rectangular shape,
185.459 -> We will use PowerPoint to use the combine
feature,
188.85 -> To merge the two shapes together to become
one new shape, because we want to use gradient
193.92 -> colors in it and do not want the color to
be inconsistent
210.31 -> set a line gradient color.
255.819 -> Iin this design, we used many Excel illustrator
designs,
310.18 -> and we will start by searching for the "corners"
328.43 -> insert text boxes, and type the dashboard
title using “Forte” font.
334.349 -> in most of our Templates, we use text boxes
and not writing data in cells for ease of
339.639 -> control and modification of texts.
408.719 -> now We will link each text box to the cell
that contains its correct data on the database
413.699 -> sheet tab,
by typing in the Formula bar "equals sign"
418.709 -> and click on the correct cell and then press
Enter.
508.149 -> Insert bus image from Excel illustrator
534.23 -> Search in Excel photo library for pictures
of kids, but in PNG format to be a picture
539.88 -> without a background.
557.41 -> Change the image color into white color
589.44 -> Insert some image related to school or learning
from Excel illustrator
680.259 -> Now we have reached the stage of designing
the buttons that can be pressed to move between
684.35 -> the dashboards in a creative and beautiful
way.
688.07 -> We will start the design stage first, and
later we will complete the hyperlink settings.
705.029 -> We will need two layers on top of each other,
and start with the layer in the background,
710.29 -> which will be in white color.
1075 -> Search in Excel photo library for pictures
of "light" also in PNG format to be a picture
1081.029 -> without a background.
1121.07 -> A beautiful idea when choosing one of the
dashboards is to show a light shining from
1125.75 -> behind
1179.679 -> Now we will add pictures for all educational
levels.
1340.95 -> If you like a picture and find it suitable,
but it contains a background, you can use
1346.149 -> the feature to remove the background in Excel,
as you will see now.
1395.75 -> We will add an image for each educational
stage, but it will appear only when you click
1400.47 -> on one of the buttons, so and to maintain
general consistency, we will add it now, but
1406.51 -> we will hide it for later use at the appropriate
time.
1458.149 -> perfect!
1507 -> The design of the upper part of the dashboard
is almost finished, and now we will start
1511.88 -> adding main data and charts
1666.049 -> Today we are done with this and we will continue
with the next video.
1670.96 -> I hope to see you well, God bless you all,
bye.
Source: https://www.youtube.com/watch?v=n23l4wx3lqU