|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2013-beginner-training-fast-and-simple/
课程评论：没有评论
课程名称：微软Excel：初学者的数据分析 课程概述：想学习Excel但觉得没有时间？或者担心Excel会太复杂？又或者你已经尝试过，但被繁琐的培训材料弄得无从下手？这里有一个快速简便的方法来学习Microsoft Excel 2013/2016，并且在两个半小时内完成。 你好，我是Brian Jackson，想要用快速和简单的方法教你Excel，重点关注在简单电子表格中最常用的功能。我们将从基础知识开始： - 启动、停止和保存文件，以及窗口和菜单的使用 - 为单元格分配值并进行算术运算 - 了解相对和绝对单元格引用及范围 - 常用数学函数：SUM、AVERAGE、MIN、MAX和COUNT - 编辑列、行和单元格 - 格式化列、行和单元格 这仅仅需要六课就能掌握基础知识，学习结束后有一个简单的棒球电子表格作为示例。 在接下来的部分中，我们将深入学习一些可以让你的电子表格更出色的高级技巧： - 处理工作表和工作簿 - 冻结行和列 - 使用函数 - 日期函数用于制作月度预测 - 排序 - 条件格式化 - 图表和图形 - 格式化和打印报告 课程结束时还有两个示例项目，制作书籍收入和Udemy评价跟踪的电子表格。 你准备好学习Excel了吗？如果准备好了，就跟随我一起以快速和简单的方法学习Excel吧！---Brian
Want to learn Excel but you're afraid you don't have the time?Or maybe you're worried that Excel will be too complicated.Then again, maybe you already tried but got bogged down wading through hours of detailed training material.Learn Microsoft Excel 2013/2016 the Fast and Simple WayMaybe it's time you tried the fast and simple approach to learning Excel.and do it all in under 2 1/2 hours.Hi, my name is Brian Jackson and I'd like to teach you Excel the fast and simple way, by focusing on the features of the program most commonly used in simple spreadsheets. We'll begin with the basics:Starting, Stopping, Saving, Windows and MenusAssigning Values to Cells & Performing Arithmetic OperationsRelative and Absolute Cell References and RangesCommon Math Functions: SUM, AVERAGE, MIN, MAX & COUNTEditing Columns, Rows and CellsFormatting Columns, Rows and CellsThat's all it takes is 6 lessons to learn the basics, then the section concludes with a super simple sample baseball spreadsheet.Go Beyond the Basics to Add Some PolishIn the following section you'll learn more advanced techniques which you can use to make your spreadsheets shine:Working with Worksheets and WorkbooksFreezing Rows and ColumnsFunctionsUsing Date Functions to Make Monthly ProjectionsSortingConditional FormattingCharts and GraphsFormatting and Printing ReportsThe course concludes with 2 sample projects in which we construct book revenue and Udemy review tracking spreadsheets.Are You Finally Ready to Learn Excel?If you're ready then come along with me and let me teach you Excel the fast and simple way...--Brian
