|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-2019-advanced/
课程评论：没有评论
**课程名称：**Mastering Excel 2019 - Advanced **课程概述：** 本课程旨在帮助您掌握世界上最流行的数据组织和分析工具——Excel。学成后，您将获得一项在现代商业环境中极为实用且有价值的技能，能够从组织列表、创建多层次交互式报告，到解答诸如投资回报率(ROI)、预算分配、费用跟踪等关键业务问题。本课程是您成为Excel专家的第一步。 **课程内容涵盖：** * Excel用户界面的导航 * 创建和保存工作簿 * 选择和输入数据 * 执行计算（使用公式和函数） * 数据格式化（包括单元格样式和条件格式） * 管理多个工作表（添加、删除、重命名、重新排序、复制、颜色编码） * 使用打印布局选项、分页符、页眉和页脚控制打印格式 * 利用视图功能进行工作簿和工作表比较，或保存自定义视图 * 通过添加功能区选项卡组和修改快速访问工具栏来定制Excel **课程目标：** 学完本课程后，您将能够独立创建自己的工作簿并进行数据分析。 **课程特点：** * 超过四小时的高清内容，采用“独特引人入胜”的TM Bigger Brains教师-学习者教学风格。 **课程最终目标：** 能够熟练运用Excel来创建工作簿和分析您的数据。
Learn how to use the world's most popular software tool for organizing and analyzing data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders-from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.This is our most requested training course!Topics covered include:Navigating the interfaceCreating and saving workbooksSelecting and entering dataPerforming calculationsFormatting dataManaging multiple worksheetsCustomizing your optionsObjectives. You will be able to:Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering dataPerform calculations using formulas and functionsInsert and delete rows and columnsApply formatting to text, numbers, and cells including using Cell Styles and Conditional FormattingControl how your worksheets print using Page Layout options, Page Breaks, and Headers and FootersManage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheetsUse View features to compare workbooks, compare worksheets, or save Custom ViewsCustomize Excel by adding Groups to the Ribbon and modifying the Quick Access ToolbarCourse Goal: By the end of this course, you will be able to use to create your own workbooks and analyze your data.Learn how to use the world's most popular software tool for organizing and analyzing data.Over four hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
