Excel basic teaching ~ take you to know the excel table

Chencang River Valley 2021-05-04 16:12:41
excel basic teaching know excel


EXCEL Basic teaching ~ Let me introduce you to Excel form


Hello everyone , I'm Menghai , Today, I'm going to teach you some office skills , Hope that through systematic learning , We can improve the office efficiency as much as possible , Save time to do what you like .Excel It's the most common office tool in our work , Whether you're an office worker , Or financial workers , Or planning statisticians , As long as you're not ready to put someone else to work ,Excel Forms are office tools that must be learned . In view of the copyright issue , Many big companies are not allowed to use Microsoft Office Of , Therefore, the following explanations are based on WPS As a template .WPS As domestic free software , It's no less powerful than Microsoft Office, And the design is more in line with the usage habits of Chinese people . Don't talk much , Let's go straight to the point .1、 We install the software through WPS Download good software from the official website , It can be used directly after installation , Generally, an icon will appear on the desktop after installation , As shown in the figure :

EXCEL Basic teaching ~ Let me introduce you to Excel form


This icon is a comprehensive shortcut icon , Whether it's Excel、Word still PPT Presentation , Can be opened through this icon , This is better than Microsoft Office Some advantages .2、 Create a new workbook first, let's create a new one , Right click on the desktop , In new, select new XLS A worksheet or XLSX Worksheet ,XLS The worksheet is 97-2003 edition ,XLSX The worksheet is a new version , What's basically common now is XLSX Format sheet . The icon on the new desktop is as shown in the figure :

EXCEL Basic teaching ~ Let me introduce you to Excel form


3、 Distribution of workbooks and worksheets double click the left mouse button to open this workbook ,Excel The form page is right in front of us , The page is shown in the figure below :

EXCEL Basic teaching ~ Let me introduce you to Excel form


We can see , A new workbook has three blank worksheets , This can be added or deleted according to your own needs .4. Introduction to tools for worksheets (1) Above the table is the toolbar , Below the toolbar are tool options , Include start 、 Insert 、 The page layout 、 The formula 、 data 、 Review 、 View 、 Development tools, a few tags . There are many different tools under each tag .(2) There are several separate icons on the left side of the toolbar , We can open it and see that this is “ Customize the Quick Access Toolbar ”, Generally we can print 、 Print preview 、 Save and other common tools that are not in the toolbar are added here . The custom toolbar can be set through the drop-down arrow , It can also be in “ file ”-“ Options ” Set in .(3) On the left side of the table 1、2、3、4 Such numbers are line marks , Represents the first line of the table ; Upper side A、B、C、D Such letters are column marks , Represents the column of the table .(4) The bottom of the table is called the status bar , You can set the state to be displayed by yourself .(5) There is also one on the top left of the table “ file ” And the drop-down arrow , This is the overall setting item of the worksheet , It also includes some of the tools we just mentioned 、 For example, convert to PDF、 preservation 、 Save as and so on .(6) The top of the worksheet , There is also a search box behind the toolbar , Is a more practical function , We can use this search box to search for functions that are not easy to find , There are also some videos about functions . I'll show you the specific location through a picture , You can open your own software for comparison .

EXCEL Basic teaching ~ Let me introduce you to Excel form


Okay , That's all for today's talk , Want to learn more intuitively , Please pay attention to the author , Watch the video tutorial with the same name . tip : The version used by the author is wps2019 edition , Use Microsoft office My friends may differ in a few details .

版权声明
本文为[Chencang River Valley]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/05/20210504160733765H.html

  1. 四个office办公软件,你如何选择?
  2. Browser "psoriasis" overwhelming how to do? How to block rogue advertisements
  3. How do you choose four office software?
  4. 优秀领导力之员工的自我实现
  5. Self realization of excellent leadership staff
  6. 高三模拟试卷惊现“神仙字体”,让阅卷老师赞不绝口,不忍心扣分
  7. The third mock exam paper is "the font of the gods", which makes the marking teacher praise and cannot bear the deduction.
  8. 头条号百家号企鹅号大鱼号概要分析介绍想做自媒体的朋友可以看看
  9. 微信公众号运营经验分享
  10. Headline No. Baijia No. Penguin No. big fish No. brief analysis and introduction. If you want to be a friend of we media, you can have a look
  11. 自媒体运营经验浅析
  12. 企鹅号App更新发布,九大模块升级全面助力内容创作
  13. WeChat official account sharing experience
  14. Analysis on the operation experience of we media
  15. Penguin app update and release, nine modules upgrade, fully help content creation
  16. 想快速玩转CAD?基础学习教程+CAD插件大全,简单安装即用
  17. Want to play CAD quickly? Basic learning course + CAD plug-in complete, easy to install and use
  18. seo要如何使自己融入工作中
  19. How to integrate SEO into work
  20. 男主管劝女下属接受大领导骚扰:女下属拒绝后还想让人事开除她
  21. 单位以“调岗”逼退,员工如何应对?
  22. Male supervisor persuades female subordinates to accept big leader's harassment: female subordinates want to dismiss her after refusing
  23. How to deal with the situation that the company forces the employees to retreat by "post adjustment"?
  24. 4省份上调最低工资标准,多地也在酝酿……你家那里涨了吗?
  25. “五一”首日 ?郑州各汽车站发送旅客13.9万?加班1147班
  26. Four provinces raise the minimum wage standard, many places are also brewing... Did your family raise it?
  27. The first day of May Day? Zhengzhou bus stations send 139000 passengers? 1147 overtime shifts
  28. 影响网站关键词排名的10个因素
  29. Ten factors influencing website keyword ranking
  30. 4月30日新闻早知道丨昨夜今晨·热点不容错过
  31. News on April 30: last night and this morning
  32. 怎么成为淘宝直播基地?干货来了
  33. How to become a live base of Taobao? Here comes the dry goods
  34. 火币、币安、OKEx,数字货币交易所三巨头究竟选哪家?
  35. 5个步骤带你入门FPGA设计流程
  36. Which of the three big digital currency exchanges, Huo coin, coin security and okex?
  37. Five steps to get you started with FPGA design process
  38. 吸粉引流:评价引流高级玩法,全套分享:
  39. 国家开发银行:将延期披露2020年年度报告
  40. Powder suction drainage: evaluate the advanced play of drainage, share the whole set:
  41. China Development Bank: to delay the disclosure of 2020 Annual Report
  42. 世界十大凶犬——比特犬的由来与反思
  43. The origin and reflection of bitdog
  44. 新手怎样玩转抖音直播?
  45. How do novice players play tiktok live?
  46. 教你用虚拟机安装系统,让一台电脑变成“多台电脑”
  47. Teach you to use virtual machine to install system, let a computer become "multiple computers"
  48. Illustrator冷知识:图案功能的神奇用法
  49. c#—基础拾遗(1) 面向对象
  50. Cold knowledge of illustrator: Magical use of pattern function
  51. C - basic information (1) object oriented
  52. 新媒体怎么玩,一张图教会你!(含脚本)
  53. New media how to play, a picture to teach you( (including script)
  54. 会声会影预览窗口放大视频去视频右上角的logo水印
  55. In the preview window, enlarge the video and remove the logo watermark in the upper right corner of the video
  56. 万象更新,百舸争流丨百度百家号争流沙龙媒体对话,探讨视频时代创作新洞察
  57. 运营头条号,入门避坑指南
  58. Baidu Baijia salon media dialogue to explore new insights of creation in the video Era
  59. Operation headline, entry Guide
  60. KOL、KOC或已过时,KOS正当火?