Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP

5.0 (1)

33 learners

What you'll learn

This course includes

19.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Excel Microsoft Excel Highline College Mike Girvin excelisfun Michael Girvin Mike excelisfun Girvin Slaying Excel Dragons Excel Magic Tricks Ctrl Shift Enter Mastering Excel Array Formulas Array Formulas Business Analytics

Full Transcript

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn: 1) (00:13) Description of Dynamic Grade Calculator Model 2) (00:51) Create Example Table to enter grading data, with Excel Table feature Dynamic Ranges 3) (02:54) Name Excel Table so that name shows up in formulas. 4) (03:15) Create Formulas to add Total Possible and Your Total Points using Excel Table Formula Nomenclature, also known as Structured References. 5) (03:54) Create Percentage Formula 6) (04:02) Copy and Paste Grade table from a pdf file using Paste Special and Text To Columns feature 7) (07:26) Sort Grade Table Ascending or Smallest to Biggest so that the VLOOKUP Approximate Match formula can work properly. 8) (07:39) VLOOKUP formula to retrieve Decimal Grade based on a Percentage Grade. 9) (09:00) Add new grade data and see that our grading formulas update perfectly!!!! Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Masterclass en Excel Financiero y Conversión de Tasas

Domina Excel Financiero: Transformando tasas y potenciando tus habilidades con sesiones prácticas y efectivas guiadas por el experto Miguel Educador.

⭐ 5.0

18 ratings

0 min

Curso Estadística Descriptiva y Probabilidad con Excel

⭐ 5.0

8 ratings

2.5 hours

Curso: Programación del Excel con VBA

⭐ 4.0

2 ratings

78.5 hours

Excel for HR Full Course

Unlock HR Potential with Masterful Excel Skills! Enhance your HR expertise from beginner to advanced in engaging, in-depth tutorials. Transform data handling and strategic planning with ease and confidence!