Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720

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 Highline College Mike Girvin excelisfun excel is fun excel fun excel magic Excel Formulas Excel Functions formulas and functions Excel Magic Trick 1720 EMT

Full Transcript

Download Excel File: https://excelisfun.net/files/EMT1720.xlsx Learn how to count numbers between upper and lower limits with a PivotTable and the FREQUENCY Array Function. Learn how the counts can be different with the two methods and why this happens. See the exact categories that each feature uses to count quantitative values between in upper and lower limit. Topics: 1. (00:00) Introduction 2. (00:35) PivotTable Method with Decimals Numbers. 3. (02:11) FREQUENCY Array Function Method with Decimals Numbers. 4. (04:22) Look at each automatic category that is created for counting and see were the values are counted. VERY important to understand why there is a difference between the two methods. 5. (05:15) PivotTable Method with Whole Numbers. Bonus Trick #1. 6. (06:17) Extract records from a PivotTable to verify that the counts are correct! Bonus Trick #2. 7. (06:40) Closing and call out for comments and Video Links

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!