Easy Excel 🔰 Progress Chart in Cells

← Easy Excel time saving technique (@ oharu _ work)

Thank you for watching 😊

🎙️ Sound Ali Recommended

How to make a progress bar inside a cell with just a function without using a graph ✨

Functions to use are here

👇

Please copy and use! = REPT ("■," ROUND (C310,0)) & REPT ("□," 10-ROUND (C310,0))

Progress rate is included in C3

A combination of the REPT function (repeating characters) and the ROUND function (rounding)! The number of black squares and shaded squares is calculated and displayed together.

💡 [How to use symbols and tips for using them in formulas]

* How to display symbols: Just enter "shiku" and convert! (■, □,, etc., please use your favorite design)

* Formula rules: When you want to use characters or symbols in a formula, it is an absolute rule of Excel to always enclose both ends with "" (double quotation). Without this,# NAMEBe careful because it will be an error ⚠️

💡 What is the UNICHAR function?

This function that appeared in the video telop is a technique that calls a specific symbol by specifying "character code (fixed number)."

Of course, you can create the same by converting it to "shiku" as usual and entering it directly into the formula like "■."

🖥️ 🍎 [Notes on the difference between Windows and Mac]

Symbols called by the UNICHAR function may have slightly different designs depending on your OS (Windows or Mac) and the font you have set, or some symbols may not be supported and may become garbled (□, blank, etc.). If it does not appear well on your computer, please try using the method of directly entering "■" or "□" without thinking about it!

💡 [Supplement]

In this day and age, there are likely to be sharp comments such as "Don't make progress management with Excel!"

(You are really right 😂)

We hope that you can refer to it as an "example of an idea / expression" that combines and visualizes multiple functions!

So that you can look back at any time later, it is convenient to [Save] from the "ribbon mark" in the lower right 🔖

* It may not work depending on the version or specification

Next time, we will make your daily life easier.

i will deliver it, so please save it and look back

*********************************************

Make some free time /

Mac 17 years | Windows 3 years

We are sending the struggle story of Excel de beginner 🔰.

Please like and follow me if you like

▶️ _ work

Please feel free to DM and comment

********************************************* "

Excel Time Shortening Easy Excel Excel beginner # excel _ beginner