|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2016-essential-training/
课程评论：没有评论
课程名称：Excel 2016 基础培训 课程概述：本课程由Excel专家Sam Parulekar主讲，旨在帮助学习者掌握Excel这一全球最流行且功能强大的电子表格程序。课程内容涵盖数据输入与组织、简单函数计算、多个工作表的操作、数据和单元格格式化，以及图表和数据透视表的构建。课程还介绍了IF、VLOOKUP和COUNTIF函数的强大功能，目标寻求、求解器及其他数据分析工具，以及使用宏自动化任务。本课程以简单、逐步的方式教学，适合初学者，并提供示例文件供实践练习。 课程收益：完成本课程后，学员将能够熟练使用Excel进行数据分析，并以可视化的形式展示数据。 背景或经验要求：本课程不要求学员具备任何Excel背景，完全从零开始，使学员对Excel感到舒适。 适合人群：本课程适合数据录入员、MIS执行人员、MIS分析师、数据分析师、业务分析师，以及任何希望录入和维护数据的人士。特别适合学生、家庭主妇和教师。同时也包含宏和邮件合并等高级选项。 课程帮助：本课程能够帮助学员组织数据并进行财务分析，适用于各类商业职能，从小型企业到大型公司。主要帮助的领域包括： - 数据录入 - 数据管理 - 会计 - 财务分析 - 图表制作 - 编程入门 - 时间管理 - 任务管理 - 财务建模 - 客户关系管理（CRM） - 几乎所有需要组织的信息！
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Sam Parulekar. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.This is a very easy to learn course as it is taught in a simple step by step manner. Example files have been provided for practice.WIIFM (What's in it for me?)By the end of this course you would be able to comfortably work in excel, do data analysis and be able to present your data in a presentable format.Background or Experience requirements.This course does not expect any previous background of Excel. It starts from scratch and makes you comfortable with Excel.Who should do this course?This course is ideal for Data Entry Operators, MIS Executives, MIS Analyst, Data Analyst, Business Analyst any person who wants to enter and maintain his data.Ideal for Students, Home Makers and Teachers as well.Contains advance options like Introduction to Macros and Mail merge as well.How can this course help you?This course can help you to organize data and perform financial analysis. It can be used across all business functions and at companies from small to large.The main areas where this course can help you would include:Data entryData managementAccountingFinancial analysisCharting and graphingIntroduction to programmingTime managementTask managementFinancial modelingCustomer relationship management (CRM)Almost anything that needs to be organized!
