|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-ultimate-microsoft-excel-training-bundle/
课程评论：没有评论
课程名称：终极微软Excel 2010与2013培训包 课程概述：几乎每个人在工作中都需要使用微软Excel，而2010和2013是最受欢迎和强大的版本。掌握Excel不仅能显著提高个人效率，还能给老板留下深刻印象。我们的终极微软Excel培训包包含为2010和2013版准备的基础和高级课程，帮助您无论使用哪一版本的软件都能游刃有余。本培训包包含：33小时的视频教程，超过200个独立的视频讲座，4个测验和165个试题，结业证书。 培训包包含的课程： 1. **微软Excel 2013初级/中级培训**：在这10小时的在线培训中，您将轻松创建Excel电子表格。专家讲师将介绍Excel 2013的功能，从基本操作开始，教授数据输入与格式化技巧，进而教您如何利用函数和公式进行计算，制作精美的图表和图形，并进行在线发布，最后帮助您分析和审核工作表，以防数据错误的发生。 2. **微软Excel 2013高级课程**：该课程将以图表基本知识开场，然后深入探讨Excel的详细格式工具及其在财务信息图表中的应用。您将学习如何处理趋势、关系和差异，并使用数据可视化工具如Sparklines和数据条，课程还涵盖了数据透视表、气泡图、雷达图等内容。 3. **微软Excel 2010基础课程**：专业讲师将介绍Excel 2010的基本功能，从创建文件到编辑现有文档，管理行列数据，以及首次引入公式。接着将学习工作簿的格式设置，并创建吸引人的图表示来展示工作。最后，您将掌握数据排序与筛选、文件链接以及一些高级公式的使用。 4. **微软Excel 2010高级课程**：本课程教您如何让异常数据突出，以便利用数据改进操作。您将深入了解Excel工具，包括创建实时图表、Sparklines、色标和图标集的设置。学习如何结合数据透视表和数据透视图，以便更容易理解数据之间的关系。 用户反馈： ★★★★★ "我喜欢这种细分为小块的课程，讲座简短且相关，易于跟随。" - 安德莉亚·莱维特 ★★★★★ "许多实用的小技巧，适合日常用户！" - 艾莉森·达格斯 ★★★★★ "我现在是一名业务分析师，我的晋升直接归功于您的课程。我对Excel更加熟练和自信。谢谢您，西蒙。" - 丹尼尔·文提 注意：所有视频均为高清，观看时建议放大并开启HD设置。
Just about everyone will find themselves having to use Microsoft Excel at work at one point or another, and 2010 and 2013 are two of the most popular, and powerful, versions around. That means that everyone could benefit from devoting some time to mastering the program, as Excel mastery can not only have a huge impact on your own productivity, but can look hugely impressive to your boss. With our Ultimate Microsoft Excel Training Bundle you'll find basic and advanced courses for both Microsoft Excel 2010 and 2013 so that you're ready to go, no matter what version of the software you're faced with. This bundle includes: 33 hours of video tutorials Over 200 individual video lectures 4 quizzes with 165 test questions Certificate of completion Courses included with this bundle: Microsoft Excel 2013 Beginners/Intermediate Training During this 10-hour Online Excel 2013 Training, you'll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you'll discover how to enter and format data in the quickest manner possible. Next you'll be introduced to the power of Excel's functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you'll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise. Learn Microsoft Excel 2013 - Advanced Your expert instructor will kick the course off 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 graphing and charting financial information. Next, you'll explore the roles played by trends, relationships, and differences 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. Learn Microsoft Excel 2010 Our professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. Next you'll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You'll then move onto sorting and filtering data, linking multiple files, and, finally, working with some more advanced formulas. Learn Microsoft Excel 2010 - Advanced Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. Excel's tools are covered in depth which includes discussions on and are setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. You can move columns and rows to understand how the numbers relate more easily than ever before. Where else can you find so many extra tools to help you gain advanced skills in Excel? So start learning today. What People Are Saying: ★★★★★ "I love how this is broken down into bite sized chunks & the lectures are short & relevant, easy to follow." -Andrea Levett ★★★★★ "Many great tips and tricks - even for the daily user!" -Allison Daggs★★★★★ "I am now a business analyst and I attribute my promotion directly to your courses. I'm much more savvy and confident with Excel. Thanks Simon."-Daniel Venti Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
