|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tables-and-formulas-with-excel/
课程评论：没有评论
《Excel表格与公式》课程总结 本课程旨在帮助Excel用户全面提升其技能，专注于表格（Tables）、条件格式（Conditional Formatting）和公式（Formulas）的运用。通过易于理解的循序渐进教学和实际操作练习，学员将学会如何更高效地处理Excel电子表格。 **课程内容与产出：** * **表格（Tables）：** * 掌握表格的创建与格式化。 * 学会轻松筛选文本、数字和日期字段。 * 在表格中快速进行求和（Sum）、平均（Average）、计数（Count）、最大值（Max）和最小值（Min）运算。 * 利用切片器（Slicers）简化表格数据筛选。 * **条件格式（Conditional Formatting）：** * 学习应用各种条件格式规则。 * 轻松突出显示前10名数据。 * 掌握数据条（Data Bars）和色阶（Color Scales）的运用。 * 学会应用图标集（Icons）。 * **公式（Formulas）：** * 学习SUMIF、SUMIFS、AVERAGEIF、AVERAGEIFS、COUNTIF和COUNTIFS等函数。 * 掌握日期函数，如Year、Month、WeekDay、NetWorkDays和WorkDay。 * 学习文本函数，如LEFT、MID、RIGHT和TRIM。 * 运用IF函数创建强大的“IF Then”逻辑。 * 学习HLOOKUP和VLOOKUP函数。 **课程要求：** 至少需要Excel 2007版本才能使用表格、条件格式和部分公式功能。 **关于讲师：** 讲师拥有超过20年的培训与管理咨询经验，是Udemy的 Instructor Partner。他专注于帮助业务用户掌握强大的数据转化方法和技术，并熟练运用Microsoft Excel、Microsoft Power BI、Looker Studio（原Google Data Studio）、Amazon QuickSight和ChatGPT进行数据分析。 **学员评价：** 学员普遍认为课程非常有帮助且信息量大，是复习和巩固Excel公式的绝佳选择。讲师教授多种解题方法，有助于建立对复杂公式的深入理解，强烈推荐给希望提升Excel技能的学习者。 **数据分析课程路线图：** 随着人工智能、机器学习和大数据领域的快速发展，数据分析师的需求日益增长。本课程是讲师提供的14门Udemy数据分析课程之一，旨在帮助学员自信地探索数据分析领域，掌握数据解读能力，并驱动智能的数据决策。其他相关课程涵盖Excel、Power BI、Google Sheets、Looker Studio、Amazon QuickSight和ChatGPT等工具。
Are you wanting to learn all there is to know about Tables, Conditional Formatting and Excel formulas? This course is for all Excel users who want to take their Excel skills and capabilities to the next level. Do you want to know how to increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets? This course is easy to follow, with a step-by-step approach and also includes practical activities for you to practice the skills that you have been learnt along the way.COURSE CONTENT AND OUTCOMETablesHow to create and format TablesHow to easily filter data in text, numeric and date fieldsEasily Sum, Average, Count and use Max and Min in your tablesUse Slicers to easily filter Table dataConditional FormattingHow to apply conditional formatting rulesHow to easily highlight the Top 10 Learn to use Data Bars and Color ScalesLearn to apply iconsFormulasLearn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFSLearn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDayLearn Text formulas such as LEFT, MID, RIGHT and TRIMLearn to use the IF formula to create powerful 'IF Then' logicLearn the HLOOKUP and VLOOKUPA minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.ABOUT THE TRAINERI am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.WHAT STUDENTS ARE SAYINGIt is very helpful and informative.Great refresher for formulas which I had forgottenGreat class to brush up on the Excel Equations. The instructor teaches multiple ways to approach the same problem, helping create a foundational understanding for more complex equations down the line. Would highly recommend to anyone looking to upskill!DATA ANALYSIS COURSES ROADMAPThe tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.Microsoft ExcelIntroduction to Analyzing Data with Excel Pivot TablesComplete Introduction to Excel Power PivotComplete Introduction to Excel Power QueryExcel Interactive Dashboards and Data AnalysisComplete Introduction to Business Data AnalysisTables and Formulas with ExcelMicrosoft Power BIComplete Introduction to Microsoft Power BIComplete Introduction to Power BI Query EditorPower BI Master Class-Data Models and DAX FormulasPower BI Master Class - Dashboards and Power BI ServiceGoogleComplete Introduction to Google Sheets Pivot TablesComplete Introduction to Looker Studio (formerly Google Data Studio)Amazon QuickSightComplete Introduction to Amazon QuickSightChatGPTIntroduction to Analyzing Data with ChatGPT
