Sign up and get 1-month free of Superhuman Mail with my link https://superhuman.com/kenji Make an interactive student report card in Excel. ๐ DOWNLOAD Free Dataset to Build the Report Card: https://careerprinciples.myflodesk.com/nedywvoh6z In this video we go over how to build a dynamic student report card in Excel. First, we cover how to format the card so it looks professional and stays dynamic with data validation dropdowns. Second, we create some key metrics like average score, or attendance percentage with XLOOKUP. Thirdly, we create a breakdown of the grades by subject. Then we go over the strengths and weaknesses for each student, including their attendance with formulas like MAX, LARGE, or XLOOKUP. Fifth, we go over the teacher's comments, including a dynamic paragraph which changes based on the student. Finally, we create an image using the image formula so the profile picture changes depending on the student selected. LEARN: ๐ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance ๐ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course ๐ All our courses: https://www.careerprinciples.com/all-courses โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ Chapters: 0:00โ -โ Report Formatting 2:22โ - Dynamic Naming 4:25โ - Key Metrics 8:43โ - Subject Breakdown 11:43โ - Strengths & Focus Areas 15:01โ - Subject Breakdown 17:11โ - Teachers Comments 18:38โ - Dynamic Image
Original Description
Sign up and get 1-month free of Superhuman Mail with my link https://superhuman.com/kenji
Make an interactive student report card in Excel.
๐ DOWNLOAD Free Dataset to Build the Report Card: https://careerprinciples.myflodesk.com/nedywvoh6z
In this video we go over how to build a dynamic student report card in Excel. First, we cover how to format the card so it looks professional and stays dynamic with data validation dropdowns. Second, we create some key metrics like average score, or attendance percentage with XLOOKUP.
Thirdly, we create a breakdown of the grades by subject. Then we go over the strengths and weaknesses for each student, including their attendance with formulas like MAX, LARGE, or XLOOKUP. Fifth, we go over the teacher's comments, including a dynamic paragraph which changes based on the student. Finally, we create an image using the image formula so the profile picture changes depending on the student selected.
LEARN:
๐ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
๐ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
๐ All our courses: https://www.careerprinciples.com/all-courses
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
Chapters:
0:00โ -โ Report Formatting
2:22โ - Dynamic Naming
4:25โ - Key Metrics
8:43โ - Subject Breakdown
11:43โ - Strengths & Focus Areas
15:01โ - Subject Breakdown
17:11โ - Teachers Comments
18:38โ - Dynamic Image
DeepCamp AI