9:06Long-form

Create a 5 Star Rating System in Excel

United KingdomPublished October 3, 2017

Views 143K  |  Likes 749  |  Comments 55
Views#12,064,068Global
Views#320,952United Kingdom

Channel

ComputergagaComputergaga
128K subs•975 videos•Sep 2010

At a glance

Views

143,523

Likes

749

Comments

55

Performance vs. channel

All-time outlier score

Engagement rate

Revenue estimate

Details →

Total (all-time): $100 – $287

Based on estimated $0.7–$2 CPM.

About

In this video, we create a 5 star rating system in Excel using Conditional Formatting. The formula below is used in the video to calculate what star is needed in each cell. =IF($B2*=I$1,1,IF(INT($B2)=I$1-1,MOD($B2,1),0)) Use the greater than sign in place of the asterisk. The asterisk is used as angle brackets are n…

Published
October 3, 2017
Made for kids
No

More features coming

We're working on new analytics and tools. Stay tuned.

How Create a 5 Star Rating System in Excel is doing

It has 143K views in total. It ranks #12,064,068 among tracked YouTube videos by views.

Key facts about Create a 5 Star Rating System in Excel

Total views
143K
Total likes
749
Total comments
55
Published
October 3, 2017
Global rank by views
#12,064,068

Frequently asked questions

How many views does Create a 5 Star Rating System in Excel have?

Create a 5 Star Rating System in Excel has 143,523 views, 749 likes and 55 comments, ranking #12,064,068 among tracked YouTube videos by views.

How accurate are these YouTube video analytics?

View, like, and comment counts come from YouTube's public API and refresh regularly. Growth and revenue figures are estimates built from tracked historical data, so they can differ slightly from what the creator sees privately in YouTube Studio.

What is the outlier score?

How this video's views compare to the channel's usual Shorts or long-form video. A 2x score means double the usual views for that channel, 0.5x means half.

What is engagement rate and how is it calculated?

Likes and comments per view, compared to this channel's typical engagement rate — shown as above or below what's usual for the channel.

How is the revenue estimate calculated?

It's a rough public estimate based on a $0.7–$2.0 CPM (revenue per 1,000 views) applied to view count — not actual creator earnings, which depend on ad rates, audience geography, and monetization settings YouTube doesn't expose publicly.

Is this YouTube video analytics checker free?

Yes. You get 10 free channel and video analytics lookups per 24 hours without an account — logging in, which is also free, removes that limit entirely.