|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-microsoft-excel-and-google-sheets/
课程评论：没有评论
课程名称：使用 Microsoft Excel 和 Google Sheets 进行数据分析 课程概述：热烈欢迎参加由 Uplatz 提供的 "使用 Microsoft Excel 和 Google Sheets 进行数据分析" 课程。Microsoft Excel 是当今快节奏商业环境中最受欢迎的工具之一，几乎每个职业和各个行业（包括制造、金融、物流、酒店、医疗和工程等）都在使用。它能够帮助您以行和列的形式处理数字、执行计算、分析数据并制作出色的图表。Google Sheets 是 Google 提供的一款免费的在线电子表格程序，是 G Suite 软件应用程序的一部分。只需要一个 Google 账号和浏览器，即可访问 Google Sheets 的强大功能。您将学习如何快速创建 Google 电子表格、存储数字和信息、格式化和设计报告，并实时与他人协作。 Uplatz 提供的这个综合课程包括 Microsoft Excel 和 Google Sheets 的培训，这两款是最强大、最受欢迎的电子表格程序。该课程的独特之处在于帮助您同时掌握 MS Excel 和 Google Sheets，从而利用各自的最佳功能，以最佳方式进行数据分析。通过这个综合培训，您将获得成为任何领域成功分析师/顾问所需的知识。 从创建电子表格和撰写报告到商业智能分析，此培训将帮助您处理、分析和分享业务关键的信息。培训的主要目标包括：快速轻松地组织和操作 Excel 数据；利用 Excel 中的众多工具和函数提高工作效率；增强自信，承担更多工作责任；全面了解如何创建 Google Sheet 并填充数据；构建公式、动态函数、VLOOKUP、HLOOKUP、数据透视表、图表和图形；充分利用 Google Sheets 中的函数，如 Google 翻译。 通过 Uplatz 的这个综合培训，您将掌握 Microsoft Excel 和 Google Sheets，以应对需要强大分析和数据处理技能的工作申请。 课程大纲： - Microsoft Excel 课程内容： - Excel 入门 - 数据输入 - 字体和对齐 - 剪切、粘贴、格式刷 - 快捷键使用 - 主菜单和剪贴板 - 文件菜单 - 排序和筛选 - 各类公式：一般、金融、逻辑、文本、日期和时间、统计、数组等 - 动态公式 - VLOOKUP 和 HLOOKUP - 数据透视表 - 图表与图形 - Google Sheets 课程内容： - 菜单选项：文件、编辑、视图、插入、格式、数据等 - 数据输入和筛选 - 数值函数 - 文本函数 - 数据函数 - 图表和条件格式 - 数据透视表 - 保存、分享与协作 通过参加本课程，将为您提升数据分析技能打下坚实的基础，助力您在职业生涯中更进一步。
A warm welcome to the Data Analysis with Microsoft Excel & Google Sheets course by Uplatz.Microsoft Excel is one of the most popular tools used in today's fast paced business environment. It is used in almost every job role, across a huge range of industries including manufacturing, finance, logistics, hospitality, healthcare and engineering. It enables you to work with numbers in rows and columns, perform calculations, analyze data and produce superb charts.Google Sheets is a free online spreadsheet program provided by Google and is part of their G Suite software applications. All you need to access the power of Google sheets is a google account and a browser. Learn how to quickly create a google spreadsheet, store numbers and information, format and design a report and also collaborate with others in real time.Uplatz provides this bundled course including Microsoft Excel training and Google Sheets training, the two most powerful and popular spreadsheet programs. The unique feature of this course is to help you get trained on both MS Excel and Google Sheets so that you will be able to leverage the best features of each and conduct data analysis in the best possible manner. This MS Excel and Google Sheets bundled training will equip you with the knowledge required to become a successful analyst/consultant in any domain.From creating spreadsheets and writing reports to business intelligence analysis, this training will help you to process, analyse and share business critical information.The primary objectives of this training include providing you skills to - Organize and manipulate your Excel data quickly and easilyWork more efficiently by utilizing the many tools and functions available in ExcelBe more confident so that you can take on more responsibility in your job roleGain a comprehensive knowledge of how to create a Google Sheet and fill it with dataBuild formulas, dynamic functions, vlookup, hlookup, pivot tables, charts & graphsHarness the power of functions such as Google Translate in Google SheetsThis bundled training by Uplatz will help you apply for jobs that require strong analytical and data crunching skills by mastering Microsoft Excel and Google Sheets.Microsoft Excel course curriculumIntroduction to Microsoft ExcelKey in DataFont and AlignmentCut, Paste, Format PainterCtrl + KeysHome Tab and ClipboardFile TabSorting & FilteringFormulas - General, Financial, Logical, Text, Date & Time, Statistical, Array, moreDynamic FormulasVLookup & HLookupPivot TablesCharts & GraphsGoogle Sheets course curriculumIntroductionMenu Options - FileMenu Options - EditMenu Options - ViewMenu Options - InsertMenu Options - FormatMenu Options - Data and moreEntering Data and FilteringFunctions - Numeric FunctionFunctions - Text FunctionFunctions - Data FunctionsCharts and Conditional FormattingPivot TablesSaving, Sharing, Collaboration
