|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2013-made-easy/
课程评论：没有评论
课程名称：《完整的Excel 2013初学者课程：通过实践学习》 概述：本课程旨在帮助个人和办公室专业人士掌握Microsoft Excel 2013的各种功能，并实现任务的自动化。课程内容不仅包括针对初学者和中级用户的培训，还有针对希望学习VBA（Visual Basic for Applications）的高级培训，适合那些希望找到实用方法来自动化Excel中重复任务的个人和专业人士。 课程内容与概述： - 通过23小时的视频讲座和3个测验，您将学习到Excel的基础知识，分为三个流行课题： 1. Excel 2013初学者/中级：学习如何创建基本的电子表格并使用公式跟踪开支。 2. Excel 2013高级：学习复杂的公式并对组织的收入和支出模式进行数据分析。 3. Excel VBA：学习如何自动化Excel中耗时的程序。 完成此课程后，您将能够熟练使用Microsoft Excel 2013。课程包含： - 23小时视频教程 - 超过130个独立视频讲座 - 练习文件，帮助您实践所学知识 - 3个可选测验，包含100多个测试问题 - 完成证书 课程包括： 1. **Excel 2013初学者/中级培训**：在10小时的在线培训中，您将轻松创建Excel电子表格，学习如何输入和格式化数据，使用Excel的函数和公式计算数据，并创建漂亮的图表和图形以便于展示。 2. **Excel 2013高级**：在9小时的视频培训中，掌握Excel的高级数据功能，深入了解图表和数据透视表的创建，以及如何使财务信息更具视觉吸引力。 3. **Excel的VBA基础培训**：自动化重复任务的实用工具，课程时长为4小时，您将学习如何使用VBA编写强大的宏，提高工作效率。 学员反馈： 许多学员表示，通过该课程，他们在职场上得到了提升，学会了更有效地使用Excel，尤其是对于初学者来说，课程内容清晰易懂，讲师耐心细致，提供涵盖从基础到高级的完整学习体验。 本课程采用高清格式，建议在HD设置下观看，确保最佳学习体验。
Master the Ins and Outs of Microsoft Excel 2013 and Automate Repetitive TasksContents and OverviewThe course is designed for individuals and office professionals who need to master the capabilities of Microsoft Excel 2013. The course also includes advanced level training for individuals and professionals who are new to VBA (Visual Basic for Applications) and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.Through 23 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.Excel 2013 Advanced: Learn complex formulas and perform data analysis on your organization's revenue and expense patterns.VBA for Excel: Discover how to help automate time-consuming procedures in Excel.When you complete this course, you'll be well on your way to becoming a master with Microsoft Excel 2013. This bundle includes: 23 hours of video tutorialsOver 130 individual video lecturesExercise files to practice what you've learned3 optional quizzes with 100+ test questionsCertificate 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. Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work. Learn Microsoft Excel 2013 - Advanced Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 - 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 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. Essential VBA Training for Excel - Automate Repetitive TasksGreat for automating repetitive tasks and operations that you perform frequently, VBA is a powerful tool to increase your productivity. The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.Find out how to use the VBA editor, VBA syntax, keywords, and comments. Discover how to define and manage variables, set up subroutines, and create functions.Also, find out how to use input boxes and message boxes to interact with end users.Learn practical methods for using macro errors to improve your VBA code.When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently. What people are saying: "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 "Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."- Top Ten Reviews"Generally I wouldn't find this type of course all that interesting. However, I have found in my current job search that it is a necessary part of my tech skill set in which to become proficient. So, I'm very appreciative that courses like this are offered, and taught by an extremely knowledgeable instructor, who explains lessons clearly and offers opportunities to practice the theme which he has just gone over. He was thorough, and not in the least bit condescending, which I can't say for instructors I have had in the past. So, thank you."- Mary Price "This is a fantastic intro to the advanced operations in Excel 2013."- Terril Wright "This is the one....Simon Sez IT has always been my favorite. Excellent contribution by the author. The lectures are informative and engaging. Style of teaching is enterprising."- Jay Dhruv "The best beginners course out there. Very easy to follow, throughout and detailed explanation to each function and step shown in the process. Ideal learning curve for the total Excel newbie like me."- Daniel Salwerowicz "Excellent course. I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good."- Vikram Hegde "Excellent course (VBA course). Absolutely helpful course designed to guide you step by step through basic and advanced VBA code. Very well structured. Instructor sounds calm and competent. Easy to follow the course if you take your time. Exercises are challenging and helpful. Can highly recommend taking this course."- OliverOur videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.
