如果您期待学习和了解Microsoft Excel的基础知识,那么本教程将指导初学者了解您需要了解的所有功能。Excel是许多行业用来制定商业计划、创建财务报告、制作预算报告等的首选应用程序。简而言之,Excel电子表格用于系统化您的工作生活。虽然Excel是一种功能强大的电子表格工具,但可以开始工作,但掌握 Excel可能会很耗时,而且使用Excel电子表格可能需要一些耐心。
(Microsoft Excel Tutorial)Microsoft Excel初学者教程(Beginners)
要打开Microsoft Excel,请单击开始(Start)按钮并向下滚动到Microsoft Office选项下的Excel ;或者只是在搜索框中搜索它。
单击空白工作表(Blank Worksheet)开始。这就是空白工作表(Blank Worksheet)的样子。
您将在工作表顶部的功能区(Ribbon)中看到几个选项卡,例如主页、插入、绘图、页面布局、公式、数据、审阅、视图、帮助和文件。(Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help, and File.)让我们逐一介绍。
1) 主页
主页选项卡是(Home)Microsoft Excel 工作表(Microsoft Excel Worksheet)中的默认选项卡。此选项卡包括剪贴板、字体、对齐方式、数字、样式、单元格和编辑(Clipboard, Font, Alignment, Number, Styles, Cells, and Editing)等部分。
最重要的是字体和对齐(Font and Alignment)方式,您可以从各种可用选项中为文本选择新字体,更改字体的大小和颜色,将内容对齐到左、右或居中,以及将文本对齐到顶部、底部或中间。您可以将文本设置为粗体、斜体以及下划线或双下划线。您可以将边框应用于所选单元格,还可以更改其背景颜色以使其突出。您可以将选定的单元格组合并合并为一个大的单个单元格。
在Wrap Text下,您可以将超长文本换行并放入多行中,以使其正确显示。
在数字(Number )部分,您可以选择单元格的格式,例如数字、货币、日期、时间、百分比、分数等。在样式(Styles)部分,您可以将选定的单元格格式化为具有自己样式的表格,并选择彩色单元格样式以突出显示重要数据或内容。
在单元格(Cells)下,您可以插入或添加新的单元格、行、列和工作表,也可以删除它们。您可以调整行高、列宽、隐藏和取消隐藏行和列、重命名以及移动或复制工作表。在编辑(Editing)部分,您可以查找文本并将其替换为其他内容,对数据进行排序和过滤,并以有效的方式执行各种功能,例如平均值、求和、最大值、最小值等。
阅读(Read):Microsoft Excel 快速工作的省时技巧。
2) 插入
“插入”选项卡包括表格、插图、加载项、图表、导览、迷你图、过滤器、链接、文本和符号。(Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filters, Links, Text, and Symbols.)
在表格(Tables)部分,您可以添加表格来组织、排序、过滤和格式化数据。在插图和图表(Illustrations and Charts)下,您可以从计算机和在线添加图片。您可以添加形状、图标、3D 模型、SmartArt、图表、饼图、地图图表、数据透视图(PivotChart)等。
链接(Links)将允许您在文档中添加超链接,这将使您能够快速访问其他网页和文件。
从文本和符号(Text and Symbols)部分,您可以添加文本框、页眉和页脚、艺术字(WordArt)、签名行、对象、方程式和符号。
3)画
在“绘图(Draw)”选项卡中,您将找到三个组,例如工具、钢笔和转换(Tools, Pens, and Convert)。
您可以添加钢笔、铅笔或荧光笔来绘制形状;而且,如果操作不当,请擦掉墨水。
4) 页面布局
页面布局(Layout)选项卡包含大量与主题、页面设置、排列、缩放以适合和工作表选项(Themes, Page Setup, Arrange, Scale to Fit, and Sheet Options)相关的命令。
在Themes下,您可以更改字体和调色板,并添加不同的效果来更改文档的外观。您可以直接选择一个现成的主题,以使您的文档看起来愉快和有吸引力。
页面设置(Page Setup)组允许您设置和调整页边距大小以及更改文档的页面方向和纸张大小。也可以添加图片作为背景。查看缩放以适合(Scale to Fit)选项以缩小打印输出的宽度或高度以适合特定数量的页面。
阅读(Read):帮助您入门的Microsoft Excel Online 提示和技巧。
5) 公式
在“公式(Formulas)”选项卡下,您将看到诸如函数库、定义名称、公式审计和计算(Function Library, Defined Names, Formula Auditing, and Calculation)等类别。
对于初学者来说,所有这些看起来都非常复杂。因此,您需要了解的基本内容是如何执行求和、平均值等自动求和函数以及如何计算公式。从单元格中选择数据后,单击函数库(Functions Library)中自动求和命令的下拉菜单,然后选择您要执行的函数。在计算(Calculation)类别中,您可以选择自动或手动计算公式。只需(Simply)单击计算选项下的下拉菜单。
6) 数据
在“数据(Data)”选项卡中,您将找到名为“数据工具”、“查询和连接”、“排序和过滤”、“获取和转换数据”、“预测”和“大纲”的不同部分。(Data Tools, Queries and Connections, Sort and Filter, Get and Transform Data, Forecast, and Outline.)
您可以从多个来源(如网络)或任何最近的来源中提取数据。您可以通过设置验证规则来验证数据,并通过选择要检查的列来删除重复项。
7) 审查
Review选项卡包含与Proofing、Accessibility、Insights、Language、Comments、Protect 和 Ink(Proofing, Accessibility, Insights, Language, Comments, Protect, and Ink)相关的命令。
拼写(Spelling)功能将检查文档中的所有拼写错误和语法错误,并要求您进行相应的检查。对于机密或重要信息,可以选择保护您的工作表或工作簿。这可以防止其他人对文档进行任何更改或移动、添加或删除工作表。因此,信息保持安全和完整。
8) 查看
在“视图”(View)选项卡中,您将看到诸如工作簿视图、显示、缩放、窗口和宏(Workbook Views, Show, Zoom, Window, and Macros)等部分。
您可以在普通视图中查看您的文档;或在分页视图中,您可以在其中查看文档在打印时的外观。
9) 帮助
“帮助(Help)”选项卡可帮助您通过使用Microsoft Office 或联系Office 支持代理(Office Support Agent)来获得帮助。您可以通过在线培训了解有关Excel的更多信息。(Excel)您也可以提出建议和反馈。
10) 文件
“文件(File)”选项卡包括用于保存、打印、共享、导出和发布文档的命令。您还可以访问其他Excel选项并对设置进行必要的更改。
通过这种方式,通过使用这些提示和技巧,您可以使您的Excel文档看起来井井有条,并且以一种高效和最方便的方式呈现。
我希望本关于Microsoft Excel的教程对您有所帮助。
现在阅读(Now read):节省时间和加快工作速度的 Microsoft Excel 提示。
Microsoft Excel Tutorial, for Beginners
If you are looking forward to learning and understand the baѕics of Microsoft Excel, then this tutorial will guide beginners through all the features you need to know. Excel is the premiere application used by many industries to frame business plans, create financial reports, produce budget reports, etc. In simple words, Excel spreadsheets are used to systematize your work life. While Excel is a powerful spreadsheet tool, one can ever get to work, mastering Excel can be time-consuming and it would probably require some patience to work with Excel spreadsheets.
Microsoft Excel Tutorial for Beginners
To open Microsoft Excel, click on the Start button and scroll down to Excel under the Microsoft Office option; or simply search for it in the search box.
Click on Blank Worksheet to begin. This is how a Blank Worksheet looks like.
You will see several tabs in the Ribbon at the top of the worksheet such as Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help, and File. Let us go through each one of them.
1) Home
The Home tab is the default tab in the Microsoft Excel Worksheet. This tab includes sections such as Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.
The most important of all is Font and Alignment where you can choose a new font for your text from a variety of options available, change the size and color of the font, align your content to left, right or center, and also align text to top, bottom or middle. You can make your text bold, italicize it as well as underline or double underline it. You can apply borders to the selected cell and also change the background color of the same in order to make it stand out. You can combine and merge the selected cells into one large single cell.
Under Wrap Text, you can wrap and fit in extra long text into multiple lines so that it appears properly.
In the Number section, you can choose the format for your cells such as number, currency, date, time, percentage, fraction, etc. In the Styles section, you can format selected cells to a table with its own style and choose a colorful cell style to highlight important data or content.
Under Cells, you can insert or add new cells, rows, columns, and sheets as well as delete them. You can adjust the row height, column width, hide and unhide rows and columns, rename as well as move or copy sheets. In the Editing section, you can find and replace text with something else, sort and filter your data as well as carry out various functions such as average, sum, max, min, etc. in an efficient manner.
Read: Microsoft Excel time-saving tricks for fast working.
2) Insert
The Insert tab comprises of Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filters, Links, Text, and Symbols.
In the Tables section, you can add a table to organize, sort, filter and format data. Under Illustrations and Charts, you can add pictures from your computer as well as online. You can add shapes, icons, 3D models, SmartArt, charts, pie, map chart, PivotChart, etc.
Links will allow you to add a hyperlink in your document which will give you quick access to other webpages and files.
From the Text and Symbols sections, you can add a text box, a header and a footer, WordArt, signature line, object, equation, and symbol.
3) Draw
In the Draw tab, you will find three groups such as Tools, Pens, and Convert.
You can add a pen, pencil or a highlighter to draw shapes; and also, erase the ink if done wrongly.
4) Page Layout
The Page Layout tab includes a wide number of commands related to Themes, Page Setup, Arrange, Scale to Fit, and Sheet Options.
Under Themes, you can change the font and the color palette, and add different effects to change the look and feel of the document. You can directly choose a ready theme in order to make your document look pleasant and attractive.
The Page Setup group allows you to set and adjust the margin sizes as well as change the page orientation and paper size of the document. A picture as a background can also be added. View the Scale to Fit options to shrink the width or height of your printout to fit a certain number of pages.
Read: Microsoft Excel Online tips and tricks to help you get started.
5) Formulas
Under the Formulas tab, you will categories such as Function Library, Defined Names, Formula Auditing, and Calculation.
For a beginner, all this will look pretty complex. So, the basic things you need to understand are how to perform the auto sum functions like sum, average, etc. and how to calculate formulas. After having selected the data from the cells, click on the dropdown menu of the auto sum command from the Functions Library and then select the function you wish to perform. In the Calculation category, you can choose to calculate the formulas automatically or manually. Simply, click on the dropdown menu under calculation options.
6) Data
In the Data tab, you will find different sections named Data Tools, Queries and Connections, Sort and Filter, Get and Transform Data, Forecast, and Outline.
You can extract data from multiple sources like the web or any recent sources. You can validate the data by setting the rules for validation and remove duplicates by selecting the column that you want to check.
7) Review
The Review tab features commands related to Proofing, Accessibility, Insights, Language, Comments, Protect, and Ink.
The Spelling function will check for all typos and grammatical errors in your document and will ask you to review them accordingly. In case of confidential or important information, there is an option to protect your sheet or workbook. This prevents others to make any changes to the document or move, add or delete sheets. The information thus remains safe and intact.
8) View
In the View tab, you will see sections such as Workbook Views, Show, Zoom, Window, and Macros.
You can see your document in normal view; or in page break view, where you can view how your document will look like when it is printed.
9) Help
The Help tab aids you to get help by using Microsoft office or by contacting an Office Support Agent. You can learn more about Excel by going through online training. You can give suggestions and feedback as well.
10) File
The File tab includes commands to save, print, share, export, and publish the document. You can also access the additional Excel options and make the necessary changes to the settings.
In this way, by using these tips and tricks, you can make your Excel document look well organized and presentable in an efficient and most convenient manner.
I hope this tutorial on Microsoft Excel was helpful.
Now read: Microsoft Excel Tips to Save Time and Work Faster.