Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?

Course Feature

Cost

Free
Provider

Youtube
Certificate

Paid Certification
Language

English
Start Date

On-Demand
Learners

No Information
Duration

1.00
Instructor

ExcelIsFun

Add to Favorites

1.5

0 Ratings

This course will teach you how to count unique numbers in a list of numbers using either the FREQUENCY or COUNTIF function. You will learn how to time each function and how to count unique numbers in a list of numbers given one condition. You will also learn how to use unique count formulas for mixed data, mixed data and empty cells, and how to use the tilde (~) to help the formula to see wild cards as non-wild cards (actual characters). Additionally, you will learn how to use the tilde to count unique items including wild cards and empty cells with one condition, and how to use a helper column to count unique items with COUNTIFS and COUNTIF functions. Finally, you will learn how to create a dynamic range for a unique count formula.

Show All

Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?

Go to class

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [May 30th, 2023]

Introduction:
Welcome to the Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function? course! In this course, you will learn how to count unique numbers in a list of numbers using the FREQUENCY or COUNTIF function, time FREQUENCY and COUNTIF, count unique numbers in a list of numbers given one condition, use unique count formulas for mixed data, use unique count formulas for mixed data and empty cells, use the tilde (~) to help formula to see wild cards as non-wild cards (actual characters), use the tilde to count unique items including wild cards and empty cells, use the tilde to count unique items including wild cards and empty cells with one condition, use a helper column to count unique items with COUNTIFS and COUNTIF functions, and create a dynamic range for a unique count formula.

Possible Development Paths:
This course is perfect for anyone looking to develop their Excel skills and become more proficient in data analysis. It is especially useful for those who work in data-driven fields such as finance, accounting, and business analytics. With the knowledge gained from this course, you will be able to quickly and accurately analyze data and make informed decisions.

Related Learning Suggestions:
If you are looking to further develop your Excel skills, you may want to consider taking courses on advanced Excel functions, such as pivot tables, VLOOKUP, and INDEX/MATCH. Additionally, you may want to consider taking courses on data visualization, such as creating charts and graphs in Excel. Finally, you may want to consider taking courses on data analysis, such as using Excel to analyze data sets and create reports.

Show All

Recommended Courses

How to Transcribe and Excel In General Transcription

4.5

Udemy 3 learners

Learn More

This online course, How to Transcribe and Excel In General Transcription, is perfect for both beginners and experts. Learn transcription techniques such as grammar, punctuation, parts of speech and transcribing accented audios. Get certified and stand out among your peers. Plus, you can qualify for an internship with Transcription Certification Institute and get free access to practice tests. With this course, you can start earning $10 to $35 per hour working from home. Invest an hour to find out if you can join the 1000s of transcription companies outsourcing projects all over the world.

Learn Microsoft Excel Charts (Basic to Advanced)

4.5

Udemy 9 learners

Learn More

This online course will teach you how to create amazing charts in Microsoft Excel. You will learn the basics of charting, as well as more advanced techniques. You will gain the skills to create visually appealing charts that will help you to better understand and present data. Join us and become an Excel charting expert!

Data Visualization with Advanced Excel

4.0

Coursera 1,288 learners

Learn More

This course will teach you how to use advanced Excel 2013 functions and PowerPivot to build databases and data models. You'll learn to perform different types of scenario and simulation analysis, and practice these skills with Excel's built-in tools. In the second half, you'll explore core principles of data visualization and dashboarding, and use Excel to create complex graphs and Power View reports. Note: PowerPivot is required to complete some exercises, and MS Excel 2013 is recommended.

Practical Beginner Excel 365

4.5

Udemy 3 learners

Learn More

This course is designed to help beginners get comfortable with Excel 365. It covers the basics of Excel, such as common terms, working with cells, columns and rows, Autofill and Flash Fill options, cutting, copying and pasting, formatting data, setting print options, changing views, inserting tables, charts, and more. By the end of the course, learners will be able to navigate an Excel workbook, enter and format data, set print options, insert objects to a worksheet, and more.