|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hayder-almahdawi-microsoft-excel-from-beginner-to-advanced-level/
课程评论：没有评论
课程名称：微软Excel - 从初学者到高级水平 课程概述：微软Excel使管理层的决策更加便捷，用户可以组织、评估和验证定量数据。Excel电子表格使组织能够轻松可视化数据。通过学习MS Excel，个人也可以提升职业前景。本课程旨在帮助学习者方便地学习和使用MS Excel，并组织数据。本课程将带领您逐步了解Excel的基础知识和高级功能，提供关于该平台上常用功能的快捷技巧。同时，还将介绍数据分析的新方法。即使没有任何基础知识，学习者在完成课程后也能够对Excel电子表格进行高级操作，包括计算、数据分析、维护、创建动态报告以及学习高级Excel公式。 课程结束时，您将能够从头开始撰写强大且优雅的公式，使您能够： - 轻松构建动态工具和Excel仪表板，以过滤、显示和分析您的数据。 - 创建基于公式的Excel格式规则。 - 使用XLOOKUP、INDEX和MATCH函数将来自多个来源的数据集合在一起。 - 操作日期、时间、文本和数组。 - 使用Excel中的单元格公式和函数自动化繁琐的任务（不需要VBA！）。 - 从API实时拉取数据直接到Excel中（天气、股市报价、路线等）。 课程将深入探讨多种Excel公式和函数，包括： - 查找/引用函数 - 统计函数 - 基于公式的格式 - 日期和时间函数 - 逻辑运算符 - 动态数组公式 - 文本函数 - INDIRECT和HYPERLINK - 使用WEBSERVICE和FILTERXML进行网页抓取。 本课程适合所有对Excel有兴趣的学习者，不论他们的背景如何。
Microsoft Excel makes decision-making easy for management by enabling users to organize, evaluate, and validate data that is quantitative. Organizations can easily visualize the data with excel spreadsheets. Individuals can also improve their career prospects by learning how to use MS Excel.This online curated course makes it easy to learn and use MS Excel and organize data using it conveniently. The course helps you walk through the basics and advanced functionalities of Excel. It gives quick hacks to the most common functions used on the platform. It also introduces learners to new ways of data analytics.Even with little to no prior knowledge, learners will be able to conduct advanced operations on Microsoft Excel spreadsheets by the end of the course. That includes calculations, data analysis, maintenance, creating dynamic reports, and learning advanced Excel formulas.By the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to:Easily build dynamic tools & Excel dashboards to filter, display and analyze your data.Create your own formula-based Excel formatting rules.Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions.Manipulate dates, times, text, and arrays.Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!).Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.).We'll dive into a broad range of Excel formulas & functions, including:Lookup/Reference functions.Statistical functions.Formula-based formatting.Date & Time functions.Logical operators.Dynamic Array formulas.Text functions.INDIRECT & HYPERLINK.Web scraping with WEBSERVICE & FILTERXML.
