【Office-Excel】Excel的快速上手使用。

工欲善其事,必先利其器。

我应该要从office系列软件的安装和配置开始来讲,但是我不用什么wps之类的软件。免费的东西不能说都不好用,但毕竟是个商业软件,所以我很不喜欢,不过随后会讲如何去掉wps的广告。所以本节请大家自行安装和使用,有问题可以留言联系。【重点:在微软平台,微软自身开发的应用软件兼容性特别高】

本节课程所需:

软件:Excel2016(基于office2016)

系统:windows10,向下兼容到win7 sp1。我用的是win10的64位专业版

环境:如下图。起码要有一个Microsoft Visual C++ 2008。也就是vc9(x64)。

2.png

制作表格

首先我们新建文件,依据不同的场景,使用以下不同的方法。

第一种办法

在桌面,或者文件夹里使用鼠标右键,点击新建(除了磁盘根目录)。

这是在文件夹里新建的显示,我们点击Microsoft Excel工作表,然后就可以双击打开并编辑了。4.png

这是在磁盘根目录里新建的情况。

【注意:这是错误的】,按了右键是不会有新建任何项目的选项。3.png

第二种办法

打开Excel2016,点击新建空白工作簿。因为我们要逐步了解excel的表格生成机制,所以前期不建议使用现成的这种类似模板的东西。

5.png

初识Excel面板

我们把下图整张图叫做excel的工作区。

excel的工作区包括了:窗口栏,菜单栏,工具栏,属性栏,主工作区,其他。

窗口栏:

窗口栏的左侧是excel表格的快捷操作工具,默认是四个按钮(保存、撤销返回上一步,回到下一步,快速工具)。

窗口栏的中间是excel文件名,如果在高强度的工作中,有成百上千个表格,在文件夹里面我们要进行区分,所以必须要给不同的名字,甚至建立(部门→分类→年→月→日,多重分级)。所以命名是至关重要的,不要为图省事,使用默认的文件名。当然默认的就是工作簿1,在保存的时候,一定要起一个名字便于区分。【注意:通过给文件夹和文件的合理命名,避免麻烦】

菜单栏:

不同的菜单栏是有不同的工具和属性。是要进行不同种类的操作,是大范围的。包括文件的存储(存储、另存为、打印、新建等);外部的插入(数据、表格、图片、形状、以及文本、统计等);一些公式(以数学,财务,逻辑为基础和扩展的);数据(涉及到动态的,目前用不上);审阅(对整体表格的调整和修改,比如繁体转简体,简体转繁体,翻译,使用批注,工作簿共享和保护等);视图(对整体主工作区的排列布局上的调整以及宏的使用)。

工具栏:

工具栏,就是各种工具,因为表格是一块一块的,每一块里面都有内容,所以工具栏就是针对这些内容,进行操作的。比如常用的针对单元格的复制粘贴剪切、对齐;针对字体的大小、字体、颜色、背景色、样式、单元格格式;针对内容的查找替换。

属性栏:

属性栏,就是做细节上的调整。基本是都是在下拉列表里面

主工作区:

其他:

6.png

【Office-Excel】Excel的快速上手使用。》有17个想法

  1. Hello! Quick question that’s completely off topic. Do you
    know how to make your site mobile friendly? My weblog looks weird
    when viewing from my iphone. I’m trying to
    find a theme or plugin that might be able to correct
    this problem. If you have any recommendations,
    please share. Thanks!

  2. Thank you, I’ve just been searching for info approximately this subject for ages and yours is the best I’ve came upon till
    now. But, what concerning the conclusion? Are you certain in regards to the source?

  3. Hi, I do believe your blog could be having browser compatibility problems.

    Whenever I look at your website in Safari, it looks fine
    but when opening in I.E., it has some overlapping issues.
    I simply wanted to provide you with a quick heads up!
    Besides that, excellent website!

  4. Fantastic beat ! I wish to apprentice even as you amend your
    website, how can i subscribe for a blog site? The account
    helped me a applicable deal. I have been a little bit acquainted of this your broadcast
    offered brilliant clear concept

  5. Hi! I realize this is kind of off-topic however I had to ask.
    Does running a well-established website such as yours require a large amount of work?
    I am brand new to operating a blog but I do write in my diary everyday.
    I’d like to start a blog so I will be able to share my personal experience and feelings online.
    Please let me know if you have any ideas or tips for brand new aspiring bloggers.
    Thankyou!

  6. Pretty section of content. I just stumbled upon your website and in accession capital to assert that I acquire
    actually enjoyed account your blog posts. Any way I will be subscribing to
    your feeds and even I achievement you access consistently quickly.

  7. Thanks for your marvelous posting! I truly enjoyed reading it, you happen to be a great author.I will
    be sure to bookmark your blog and will eventually come back later in life.
    I want to encourage you continue your great job, have a nice afternoon!

  8. We absolutely love your blog and find most of your post’s to be what precisely I’m looking for.
    Would you offer guest writers to write content for yourself?
    I wouldn’t mind producing a post or elaborating on a few of the subjects you write with regards to here.
    Again, awesome site!

  9. What i don’t realize is in truth how you are now not
    really much more smartly-appreciated than you might be now.
    You’re so intelligent. You realize thus considerably
    with regards to this matter, made me in my
    opinion imagine it from so many varied angles. Its like men and women are
    not interested until it’s something to do with Lady gaga!
    Your individual stuffs nice. Always deal with it up!

发表评论

电子邮件地址不会被公开。 必填项已用*标注

答案 : *
17 − 14 =