|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-advanced
课程评论：没有评论
课程名称：Excel技能提升：高级 概述：电子表格软件是全球工作场所中最常见的软件之一。掌握这一技能将为您的就业竞争力增添重要资产。每天全球有数百万个招聘广告要求具备Excel技能。在数字技能工作快速增长的时代，完成本课程将使您在求职中领先于他人。作为“Excel技能提升”系列课程的最后一部分，本课程将为您成为Excel的高级用户做好准备，这是您朝专业水平发展的最后一步。 课程大纲： 1. 电子表格设计与文档：作为中级Excel用户，您掌握了基础知识。本模块旨在创建和维护准确、灵活、响应迅速且用户友好的电子表格，学习设计灵活并且易于审核的电子表格，构造透明计算，创建友好的导航，以及使用样式、主题和格式化来进一步提升您的表格。 2. 高级公式技巧：Excel通常需要对大量数据进行复杂分析。本模块重点讲解数组公式的使用，能够同时执行多个计算并确保电子表格的准确性，帮助您有效使用和构建数组公式。 3. 数据清理与准备：处理杂乱的数据表？本模块专注于数据清理与准备，您将学习如何使用动态和自动化修正，清理杂乱数据，并通过函数自动化这些过程，确保数据的动态清洁，提升解决方案的效率。 4. 财务函数与日期处理：本模块将财务函数引入Excel知识体系，财务函数广泛应用于商业中。您将学习如何在计算中应用日期公式，制定贷款计划以及使用折旧函数。 5. 高级查找函数：让您的电子表格和工作更自动化是个不错的主意。本模块将在数组功能的基础上，为您展示一系列函数，创建动态查找范围，包括INDIRECT、ADDRESS、OFFSET和INDEX。 6. 构建专业仪表板：本模块将指导您通过构建专业仪表板的步骤，使数据变得有意义并可以作为商业智能使用。您将学习如何通过图表和图形可视化数据、创建数据模型及增加交互性。 7. 期末评估：通过最后的评估，巩固您在课程中所学到的知识和技能。 本课程将使您在Excel技能方面达到专业水平，为您的职业发展铺平道路。
Name:Spreadsheet Design and Documentation
Description:As an intermediate Excel user, you have the basics down. The first module of the Advanced course focusses on creating and maintaining accurate, flexible, responsive and user-friendly spreadsheets. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes and formatting to tie it all up in a nice bow.
Name:Advanced Formula Techniques
Description:Excel often requires you to perform complex analysis on large sets of data. This can be made a lot easier using array formulas, which can perform multiple calculations simultaneously and ensure the accuracy of your spreadsheet. This module covers the use of array formulas, how to build them and use them effectively.
Name:Data Cleaning and Preparation
Description:Been handed a messy spreadsheet? This module focuses on data cleaning and preparation. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically. We will use functions to fix dates, replaces blanks and remove unwanted characters from data – all to help us build an efficient solution that lasts.
Name:Financial Functions and Working with Dates
Description:This module introduces financial functions into our Excel knowledge base. Financial functions are often used in businesses and Excel has a variety of tools to help you with that. This week, you will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.
Name:Advanced Lookup Functions
Description:It is always a good idea to make your spreadsheets (and work!) more automated. Automated lookups can make your work fast and efficient. This module builds on your array capabilities and explores a range of functions to create dynamic lookup ranges – INDIRECT, ADDRESS, OFFSET and INDEX.
Name:Building Professional Dashboards
Description:To bring it home, this module guides you through the steps of building a professional dashboard. Data is meaningless unless it tells a story and can be used as business intelligence. This module will help you set up a dashboard – learn how to visualise data through graphs and charts, create data models, and add interactivity.
Name:Final Assessment
Description:
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading. In this last course of our Specialization Excel Skills for Business you will build on the strong foundations of the first three courses: Essentials, Intermediate I + II. In the Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.
