picturepicturepicture

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

picture

I just heard an exclamation, "Huh? What's wrong with my Excel sheet? Why does it suddenly look good? " Following the shock, it turned out to be our classmate Xiao Ai. I took a closer look, Xiao Ai, Don't be surprised, you just press a very powerful shortcut key, come, let me tell you about its major functions.
1. One-click beautification
This is easy to understand. As shown in the figure, we click on any cell in the data area, press Ctrl+T, and the [Create Table] window pops up, check [Table contains headers], and then [OK], like this, a The most convenient beautification effect appears. At the same time, in [Table Design], you can also choose different [Table Formats].
picture
2. Autofill formulas
Generally, after writing the formula, we have to copy and fill it, but using the super table, it is automatically filled. Let's see, in the E2 cell to calculate the total amount of each salesperson, after entering the formula, press Enter, the formula will be Fill it up automatically.
picture
3. Automatically expand the data area
This is amazing, especially when doing pivot tables. Usually we add data. The pivot table needs to manually [change the data source], but if it is converted into a super table first, as long as the data is added along the way, Then, this data source will also be updated automatically.
picture
4. Summary row
In the middle of [Table Design], there is [Table Style Options], and there is a [Summary Row], which is also quite powerful. Let's try it, you can sum, average, etc...
picture
5. Beautify design
In addition, there is [Border Row], which refers to the fill color of every row, [Border Column] refers to the fill color of every other column, [First Column] makes the first column bold, [Last Column] can Bold the last column and so on... You can try this yourself.
picture
6. Convert to area
Finally, if you have finished everything, remember, maybe the boss doesn't like auto-expansion and so on, then we can convert this super table into [Table Design]-[Tools]-[Convert to Region] Ordinary form, like this, you won't be afraid that the boss will read it and make so many bells and whistles. As shown in the figure, after the conversion, there will not be so many functions.
picture
That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.
      
     
            
     
   
          
picture
Why choose us, the platform advantage is there
Advantage ①: VIP can learn all tutorials, unlimited learning + supporting material source files + unlimited downloads
Advantage 2: Support WeChat public account + applet + APP + PC website for multi-platform learning
Advantage 3: Support offline viewing, double-speed viewing, allowing you to learn anytime, anywhere
Advantage ④: VIP logo, distinguished status + independent after-sales group answers
picture
picture
★ FAQ ★ 
①Xiao Ai: Can you watch all the courses after buying VIP ?
Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?
Pay attention to the Aizhiqu Education Service Account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!
Computer login to https://www.92zhiqu.com
(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand
Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?
Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?
Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?
kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?
kindness. Both Android and Apple IOS APP support mobile phone offline download
Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?
Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

pictureIf there is anything else you need to consult, please contact WeChat customer service 18074746783
Long press to identify the QR code "Add Customer Service"
picture
pictureClick to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)