From the course: Excel Dashboard Challenges
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Recruitment, part 2 - Microsoft Excel Tutorial
From the course: Excel Dashboard Challenges
Recruitment, part 2
- [Instructor] Welcome to another exciting episode of Excel Dashboard Challenges. I'm Jordan Goldmeier, here to show you some awesome Excel content. I have a really good one here for you today. You may not have seen this technique before, but what I have here is these dashboard component boxes. So you could put these anywhere on your Excel dashboard. You can line them up at the top, you could put them at the side. What I really love about it is that you can change it via slicer. So this is really cool. Let me show you how it's done. So we're going to start at the start button. We're going to add in that all important table. Put your cursor anywhere in that data set, or highlight it like I'm doing here. Go to CTRL+T on your keyboard. That's going to add in a new table, just like that. Remove the banded rows because you feel good about that. And next thing I want to do here is I'm going to add in the total row. So the total row is something we can put at the bottom of the table that's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- 1_21_Learner_Dashboard.zip
- 1_20_Supplier_Dashboard.zip
- 1_19_Lead_Generation.zip
- 1_18_Sales_Target_Challenge.zip
- 1_17_HR_Analytics_Dashboard.zip
- 1_16_Expense_Tracking_Excel_Dashboard.zip
- 1_15_Customer_Churn_Data.zip
- 1_14_Recruitment_Dashboard_2.zip
- 1_13_Recruitment_Dashboard.zip
- 1_12_Product_Performance_Dashboard.zip
- 1_11_Marketing_Campaign.zip
- 1_10_Social_Media_Engagement.zip
- 1_9_Breakeven_Analysis.zip
- 1_8_Website_Traffic_Dashboard.zip
- 1_7_Inventory_Management_Dashboard_Challenge.zip
- 1_6_Funnel_Chart.zip
- 1_5_Survey_Results_Trend_Line.zip
- 1_4_Budget_vs_Actuals.zip
- 1_3_Gantt_Chart.zip
- 1_2_attendance_dashboard.zip
- 1_1_Basic_Sales_Performance_Chart.zip
Contents
-
-
-
(Locked)
Learning and development4m 58s
-
(Locked)
Supplier performance6m 20s
-
(Locked)
Lead generation8m 46s
-
(Locked)
Sales target8m 43s
-
(Locked)
HR10m 24s
-
(Locked)
Expense tracking9m 24s
-
(Locked)
Customer retention4m 52s
-
(Locked)
Recruitment, part 25m 1s
-
(Locked)
Recruitment5m 55s
-
(Locked)
Product performance10m 7s
-
(Locked)
Marketing campaign6m 34s
-
(Locked)
Social media engagement3m 45s
-
(Locked)
Break even analysis4m 29s
-
(Locked)
Website traffic5m 37s
-
(Locked)
Inventory management5m 39s
-
(Locked)
Sales funnel5m 19s
-
(Locked)
Customer satisfaction3m 27s
-
(Locked)
Budget vs. actual6m 30s
-
(Locked)
Project management10m 54s
-
(Locked)
Employee attendance4m 44s
-
Sales performance4m 35s
-
(Locked)