|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-comprehensive/
课程评论：没有评论
课程名称：学习微软Excel - 综合性Excel课程 课程概述：这是一门综合性的Excel课程，涵盖了关于微软Excel的所有知识。从基础知识到最先进的功能，完成本课程后，你将能够以专家水平使用Microsoft Excel。初学者可以从基础开始，逐步学习以达到精通的程度；中级用户可以根据需要加入课程以提高技能；高级用户也可以直接选择所需部分以实现精通。该课程由畅销的Udemy作者、微软认证教育者、微软Office专家、资深大学教授及Udemy讲师合作开发，旨在帮助学生快速掌握Microsoft Excel。 课程亮点包括： - 学会在Excel中导航 - 学会输入和编辑Excel中的数据 - 调整数据和信息的显示方式 - 使用点按法快速轻松编写公式 - 理解相对引用、绝对引用和混合引用的使用 - 创建强大的计算公式 - 使用文档功能，全面掌握每个函数 - 可视化数据：图表、趋势线、迷你图、组合图表 - 使用排序、分类汇总和筛选等Excel数据工具 - 冻结列和行，使用冻结窗格 - 从Excel数据中去除重复项 - 转置数据 - 使用数据透视表和数据透视图表来处理数据 - 格式化工作表，包括条件格式化 - 使用宏自动化Excel任务，节省时间 - 将Excel与Word集成 - 在Excel中使用密码保护你的工作 - 学习Excel的技巧、秘密和快捷键 - 使用打印和共享功能 - 从网络获取数据 - 创建强大的随机数据生成器 - 执行“情景分析”如目标查找、情形和数据表 - 使用多窗口、选择窗格、校对和翻译工具 - 打印工作表，并将其格式化为多种格式，包括PDF - 利用数据模型创建数据关系 - 进行数据连接和添加 - 使用3D地图和创建记录的场景 - 使用VBA编程Microsoft Excel - 下载课程中使用的所有Excel项目文件 本Excel培训课程被描述为“有趣”、“令人惊叹”以及“改变生活的”，将彻底改变你处理数字的方式。亲自尝试这个课程，看看你能多快、多容易地掌握Microsoft Excel。
This is the Comprehensive Excel Course.This course covers everything there is to know about Microsoft Excel.From the fundamentals, to the most advanced features, after taking this class you will be able to use Microsoft Excel at an expert level.Beginners can begin right at the beginning, then work their way through the course to achieve mastery. Intermediate users can join the course where needed to forward their skills. Advanced users can also drop into sections they need to achieve mastery.You can learn Excel quickly if it is taught correctly. Developed by a …Best-selling Udemy authorMicrosoft Certified EducatorMicrosoft Office Specialist ExpertTenured College ProfessorUdemy Instructor Partner… this course has been designed and perfected to make it easy for you to master Microsoft Excel. Here are highlights of what you will learn in this course:Learn to navigate around ExcelLearn to enter and edit data in ExcelLearn to adjust the way data and information are displayed in ExcelLearn to write formulas quickly and easily with the point-and-click methodLearn to use relative, absolute, and mixed references in ExcelLearn to create powerful calculations with Excel functionsLearn to use documentation so that you can work with every functionLearn to visually represent your data: charts, trendlines, sparklines, combo chartsLearn to use Excel data tools like sorting, subtotaling, and filteringLearn to "freeze columns and rows" with freeze panes in ExcelLearn to remove duplicates from data in ExcelLearn to "transpose data" - switching the columns and rows in ExcelLearn to use Excel to leverage data with Pivot Tables & Pivot ChartsLearn to format worksheets including conditional formattingLearn to automate Excel tasks with time-saving macrosLearn to integrate Microsoft Excel with Microsoft WordLearn to use passwords in Excel to protect your work in multiple scenariosLearn tips and tricks about Excel, as well as Excel secrets and shortcutsLearn to use printing and sharing in ExcelLearn to harvest data from the webLearn to create powerful random data generatorsLearn to use freeze panes, sorting, filtering, & advanced filteringLearn to "what if" sensitivity analysis such as goal seek, scenarios, & data tablesLearn to use multiple windows, selection panes, proofing, & translating toolsLearn to print your worksheets with various formatting to various formats including PDFLearn to use pivot tables, slicers, timelines, & pivot chartsLearn to apply styles, themes, stats, accessibility, watch & calculation optionsLearn to use get & transform and the power query editorLearn to use the data model and to create relationships between your dataLearn to work with data joins and to append dataLearn to use 3D maps and to create recorded scenesLearn to program Microsoft Excel with VBA (Visual Basic for Applications)Download all of the Excel project files that are used in the videosDescribed as "fun," "amazing," and "life changing," this Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can master Microsoft Excel.
