|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-microsoft-excel-2016-course-beginner-to-expert/
课程评论:没有评论
**Microsoft Excel 2016 零基础到专家全方位课程 (共18小时)** 本课程是为期18小时的Microsoft Excel 2016深度培训,涵盖从基础操作到高级技巧。课程分为两个部分: **第一部分:Excel 2016 基础入门 (9小时)** * **目标:** 帮助零基础学员掌握Excel 2016的核心功能。 * **内容:** * Excel 2016的安装与新特性介绍 * 触摸屏操作、打开工作簿、使用帮助中心 * 个性化设置Excel选项 * Ribbons和工具栏的使用 * 数据输入与编辑 * 备份与恢复 * 填充与序列 * 打印项目 * 公式与函数 * 数据排序与筛选 * 创建图表与图形 * **特色:** * 从零开始,循序渐进 * 提供32个视频章节和9个练习文件 * 完成可获得Excel 2016基础知识 **第二部分:Excel 2016 高级进阶 (9小时)** * **目标:** 帮助学员掌握制作复杂电子表格和数据分析的技巧。 * **内容:** * 创建专业的图表与图形 * 数据可视化:Sparklines、数据条 * 图表中的趋势、关系与差异分析 * 深入了解数据格式工具 * Pivot Tables(数据透视表) * Bubble Charts(气泡图)、Radar Charts(雷达图)等高级图表 * **特色:** * 教授创建彩色图表、数据分析报表 * 提供练习文件、演示文件 * 可选测验和完成证书 **课程亮点:** * 共计18小时高质量视频教程 * 超过100个独立视频讲座 * 提供练习文件,帮助学员实践 * 提供演示文件,供学员参考 * 提供打印版课程讲稿,方便笔记 * 完成课程可获得证书 * 更新于2017年6月,提供课程字幕 **学员评价:** * 学员表示课程内容清晰易懂,学到了新知识。 * 讲师专业、清晰、简洁,学习过程愉快。 * 课程内容实用,物超所值。 **Simon Sez IT 另有提供:** * Microsoft PowerPoint, Word, Project, Outlook * QuickBooks, Photoshop Elements * Web Development Languages 等多种软件课程。 **搜索 "Simon Sez IT" 可查看其所有课程及课程捆绑包。**
Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Practice along using exercise files Watch and learn with demo project files Progresses logically from beginning with an easy intro to advanced topics Learn to Create Charts and Graphs This bundle includes: 2 complete courses 18 hours of video tutorials Over 100 individual video lectures Exercise files to practice what you learned Demo files used by the trainer Printable course transcriptions to follow along and take notesCertificate of completion Contents and Overview for the 9-Hour Excel 2016 Beginner Course This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user. It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them. You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016. Contents and Overview for the 9-Hour Excel 2016 Advanced Course Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 - Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class. Your expert instructor will begin the course by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more. Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course. * Includes quizzes, exercise files, demo files and certificate of completion.** Updated June 2017. Course transcripts now available.Here's what our students are saying…"I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know:-)." - Tomáš Seiner"The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!"- Ontavus Thomas"Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir"- Jessica HenryDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.