Shulou(Shulou.com)11/24 Report--

Hello, everyone!

I am Chang Xiaoan, a classmate who likes to eat snacks and learn Excel.

In the company introduction, we often see large and complex organization charts, such as the following ↓↓↓

This kind of organization chart is also very common, showing not only the departmental distribution of the company, but also the breakdown of products.

Guess how the above picture is made.

At first glance, it seems to be made up of many small squares and lines, and then enter the text.

It seems to take a lot of time.

.

In fact, if I told you that it could be done in a minute with Excel, would you want to learn?

Hurry up and follow in Xiao an's footsteps. Let's watch the video below.

Procedure: ❶ first pastes all the organization names into Excel, and then selects them and copies them.

❷ clicks the [insert] tab-"Smartart"-Select the first one in the hierarchy, deletes the blank text, and finally [Ctrl+V] pastes all the organizations.

PS.Smartart function PPT, Word also have ❸ to adjust the level with the [Tab] key, press [Tab] to lower one level (press the wrong backspace), and you can change the style under the "Design" tab.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan planner: video team Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.