|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-for-beginners/
课程评论：没有评论
**课程名称：Microsoft Excel 2016 入门：精通核心功能** **课程概述：** 本课程专为从未接触过 Microsoft Excel 的初学者设计，也适合希望从旧版本升级的用户。经验丰富的讲师 Toby 将从安装程序开始，一步步引导您掌握 Excel 2016 的基本操作，直至您能熟练运用高级功能。课程提供可下载的练习文件和测验，确保您理解并巩固所学知识。Simon Sez IT 拥有超过十年的 Excel 教学经验，致力于提供详尽、易于理解的学习内容，不急于求成，确保学员掌握重要概念。课程提供终身访问权限。 **课程亮点：** * **从零开始：** 假设您是 Excel 新手，从安装到创建第一个工作簿、输入数据，都进行详细讲解。 * **Excel 2016 新特性：** 介绍 Excel 2016 的新功能。 * **个性化设置：** 教您如何根据自身需求导航和自定义 Excel 界面。 * **数据输入与编辑：** 掌握数据的录入和编辑技巧。 * **图表与图形：** 学会创建美观的图表和图形。 * **公式与函数：** 理解公式和函数的工作原理，学习 VLOOKUP, IF, SUMIF, COUNTIF 等常用函数。 * **数据管理与分析：** 学习清洁、筛选和排序数据，进行基本的数据分析。 * **数据保护：** 掌握保护和保障 Excel 数据安全的方法。 * **日期与数字格式：** 了解 Excel 如何处理日期和数字格式。 * **填充与闪电填充：** 学习使用填充柄和闪电填充功能。 * **条件格式：** 创建美观的、带有颜色编码的电子表格。 * **安全分享：** 学会安全地共享工作簿。 **课程内容：** 课程从 Excel 的安装开始，采用简单易懂的 1-2-3 步骤方法，让您快速上手 Excel 2016。共包含 32 个章节的视频课程和 9 个练习文件。课程内容涵盖：Ribbons 和 Toolbars 的使用、数据输入与编辑、备份与恢复、填充和序列、打印项目、公式、函数、数据排序与筛选、创建图表等。 **学习体验：** 学员评价普遍较高，认为课程详细、易于遵循，可以暂停、回看，允许按照自己的节奏学习。课程性价比高，能够帮助学员提升工作效率，发现自己对 Excel 潜力的认识。 **更新信息：** * 2017年7月更新，提供英文字幕。 * 2016年2月更新，提供课程文本记录。
**Course includes downloadable project files and quizzes to test your knowledge as well as LIFETIME access**Why Simon Sez IT for Excel?We know Excel. We've been teaching it for over 10 years and your expert instructor Toby has taught thousands of people to learn Microsoft products.We don't rush through content. We take the time to ensure you understand important principles before moving on.Follow along. We provide downloadable practice files so you can practice as you learn.Customer reviewsHere's what our students are saying about us:★★★★★ "I bought the course because I wanted to learn more about the use of Excel to assist me in my job. So far, I am very happy with the instructions. They are very detailed and easy to follow. I am able to pause to make notes and rewind if needed. I have used Excel with basic knowledge of the system, but I feel that when I am done with this course I will be able to create better spreadsheets and documents." -Doris Santangelo ★★★★★ "I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners." -David F. Wilson ★★★★★ "I have been using Excel for some time and this course has shown me just how much I did not know or was unaware of. A terrific learning experience. Thanks for the opportunity!" -Allan Thomson ★★★★★ "I enjoyed to course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you." -John Brown ★★★★★ "Course is well done and since you can go back and review at any time or after the course is done is helpful for us slow learners." -Rick ClarkeMaster Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video CourseLearn to navigate Excel 2016Learn what's new in Excel 2016Learn how to navigate and personalize Excel for your needsLearn to enter and edit dataLearn to create amazing looking charts and graphs from tables of dataLearn how a function and formula worksLearn to protect and secure your data in ExcelLearn how Excel categorizes and handles dates and other number formattingLearn to use the fill handle and flash fillLearn essential Excel formulas such as VLOOKUP, IF, SUMIF, COUNTIF and so many moreLearn to clean, filter and sort your data to perform basic data analysisLearn to create beautiful, color coded spreadsheets using Conditional FormattingLearn how to safely share a workbook.Excel 2016 From The BeginningThis course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer, Toby, will start at the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you'll be using Excel 2016 like a pro with advanced functions. At Simon Sez IT we know Excel and we know learning it can't be rushed, so we take the time to explain how everything works. This is an in-depth introduction to the world's most powerful spreadsheeting software, not a quick walk through. If other Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process.Contents and OverviewThis course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 32 chapters of video lessons and 9 exercise files to gradually become a proficient user. It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We 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. ** Updated July 2017. English close captions added** Updated February 2016. Course transcripts now available.
