|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-and-microsoft-excel-bundle-2016/
课程评论：没有评论
课程名称：微软Access与Excel精通课程包2016 课程概述： 本课程包含实践练习和终身访问权限。如果您需要对大量数据进行操作并将其转化为有意义的商业决策，那么这个包含四门课程的捆绑包将教您如何在高级水平上使用Access和Excel。我们从每个程序的基础知识开始，然后转向更复杂的功能，例如将数据从Access数据库导入Excel。 课程内容： 1. **Access 2016 初学者** - 学习Access 2016的新功能 - 添加记录、保存和删除数据 - 使用Access设置数据库（桌面或网络） - 探索Ribbon界面及如何使用触控设备 - 创建和处理表单及子表单 - 在Access中排序数据以及运行查询 - 理解Access 2016中的宏工作原理及其应用 - 从外部来源导入数据 2. **Access 2016 高级** - 有效链接外部数据源 - 通过分离前端和后端分割数据库 - 打包应用程序以便分发的选项 - 创建、更新和维护宏 - 探索VBA的使用 - 学习表单和查询的高级选项 3. **Excel 2016 初学者** - 使用鼠标或触控设备开始使用工作簿 - Excel 2016的新特性 - 使用自定义视觉图形或模板创建复杂的图表和图形 - 个性化Excel 2016的使用 - 使用自动填充和快速填充快速输入数据 - 应用主题和单元格样式 - 备份和恢复Excel电子表格的方法 - 格式化日期和数字 4. **Excel 2016 高级** - Excel中的高级图表和图形 - 使用详细格式化工具 - 查找和高级查找功能 - 财务函数，包括计算利息和折旧 - 统计函数 - 连接到外部工作簿和数据集（例如：MS Access和网络） - 使用迷你图和数据条创建惊人的可视化效果 - 掌握PivotTables和Pivot Charts - 场景管理器、目标寻求和求解器 - 高级图表，如表面图、雷达图、气泡图和股票图 课程包含内容： - 四门关于Excel与Access的课程 - 36小时的视频教程 - 超过240个独立视频讲座 - 实践学到的练习文件 - 教师使用的演示文件 - 完成证书 学生评价： 学习者对该课程给予了高度评价，认为内容清晰易懂，结构合理，帮助他们快速掌握Access和Excel的基础和高级知识，并提供了实用的技巧和窍门。 注意：Simon Sez IT还教授多种软件，包括：Microsoft Excel、Microsoft PowerPoint、Microsoft Word、Microsoft Project、Microsoft Outlook、QuickBooks、Photoshop Elements、Web开发语言等等。
**This course includes practice exercises and LIFETIME access**If you need to manipulate large buckets of data and turn them into meaningful business decisions, then this 4-course bundle showing you how to use both Access and Excel to an advanced level is for you.We start with the basics in each program before moving onto more complex functionality such as importing data into Excel from an Access database. Access 2016 BeginnersWhat you'll learn:What's new in Access 2016How to add records, and save and delete data.Using Access to set-up a database (desktop or web).To explore the Ribbon interface and how to work with touch devices.Create and work with forms and sub-forms.Sorting data in MS Access and running queries in Access.How Macros work in Access 2016 and how to use them.How to import data from external sources.Access 2016 AdvancedWhat you'll learn:How to effectively link to other data sources outside of AccessHow to split a database by splitting the frontend and backend.Dive into options for packaging your application for distribution.Learn to create, update and maintain macros.Explore the use of Visual Basic for Applications (VBA).Learn the advanced options for forms and queriesExcel 2016 BeginnersWhat you'll learn:How to get started with workbooks whether using a mouse or touch device.The new and improved features in Excel 2016.How to create sophisticated charts and graphs using custom visuals or templates.How to personalize your use of Excel 2016.To use autofill and flash fill to enter data quickly.How to apply themes and cell styles.Practical methods in which you can backup and recover your Excel spreadsheets.How to format dates and numbersExcel 2016 AdvancedWhat you'll learn:Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek and SolverAdvanced charts such as Surface, Radar, Bubble and Stock ChartsThis bundle includes:4 courses covering Excel & Access 201636 hours of video tutorialsOver 240 individual video lecturesExercise files to practice what you learnedDemo files used by the trainerCertificate of completionHere's what our students are saying…"I took this class as a requirement for a new job. I have never touched access before and I was able to pick it up very quickly with this video. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks. The instructor was very easy to understand and everything was presented at great pace. Since learning how to use access with this class, I have been to create my own database to practice my skills and learn new ones. I would recommend this class to anyone who would like to get a great understanding of access."- Greg Wehner"Time and money well invested! I have been learning by trial and error by myself watching youtube clip. Nevertheless, I never had the impression that I mastered Access or even its basic fundamentals. One day you start to doubt that you may not have the right approach at all. A moment has come to take a break and put the time to learn things well. With this course I feel that I master the basics, but also all the little details very useful that simplifies life. We also learn several tips and tricks to start a project well and avoid getting bogged down later. Above all, I learned a lot of things that I never doubted possible. The instructor is easy to understand and easy to listen to. I devoured the sections without seeing the time pass. In short it is a very complete course and pleasant to follow. I recommend."- Gabriel Beaulieu"Brilliant. Enjoyed it immensely. Learned everything I needed to know."- Brenda BellDid 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!
