|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-all-students-professionals/
课程评论：没有评论
Microsoft Excel - 从基础到高级 本课程旨在帮助您全面掌握Microsoft Excel，涵盖从基础功能到高级应用的广泛内容。课程采用快速讲解的教学方式，节省您的宝贵时间，并通过最简单、最准确、最易懂的示例，详细解释各种函数和公式。 课程内容包括： * Excel基础：行与列的操作（隐藏/取消隐藏、删除）、单元格与单元格区域、单元格拖拽、工作簿中的工作表数量、不同标签页与功能区、快速访问工具栏、名称框和公式栏、Excel导航、保存与另存为。 * BODMAS法则在Excel中的应用（适用与否）。 * 常用与高级函数：LEFT, RIGHT, MID, CONCATENATE, NOW, TODAY, EOMONTH, NETWORKDAYS, NETWORKDAYSINTL, WORKDAY, SUBTOTAL, MOD, QUOTIENT, IFERROR, SFERROR, 各种错误提示与警报, LOOKUP, HLOOKUP, VLOOKUP, SUMPRODUCT, SUM(Array), PMT, PPMT, IPMT, FV, NPV, IRR, XNPV, XIRR, SUM, AVERAGE, MIN, MAX, COUNT, IF, IF AND, IF OR, IF NOT, NESTED IF, INDEX & MATCH 结合 Vlookup, MAX, Array (Ctrl + Shift + Enter) 等，以及多个函数的组合应用。 * 实操应用：计算美国、印度和英国税收抵免。 * 图表应用：各种Excel图表的介绍，以及普通表格/图表与数据透视表/图表的区别。 * Excel快捷键：提高日常工作效率。 本课程期待您的加入，一起探索Excel的强大功能。
This course contains the basics to advance the learning of Excel. The quick explanation technique in video saves a lot of time, it has various functions & formulas explained in the easiest, most accurate & most comprehensible examples.This course explains what are rows & columns how to hide/unhide & delete them, cell & range of cells & how to drag cells, how many spreadsheets in one Excel workbook, different Tabs & Ribbons, what is the Quick Access Toolbar, Name Box & Formula Bar, how to navigate Excel & how to save & save As. Applying BODMAS in Excel, learn when it will be applicable & when not.In this course, you will get to learn the basics & advanced usage of functions like LEFT, RIGHT, MID, CONCATENATE, NOW, TODAY, EOMONTH, NETWORKDAYS, NETWORKDAYSINTL, WORKDAY, SUBTOTAL, MOD & QUOTIENT, IFERROR, List of Errors & Various Error Alerts, LOOKUP, HLOOKUP, HLOOKUP, SUMPRODUCT, SUM(Array)VLOOKUP, PMT, PPMT, IPMT, FV, NPV & IRR, XNPV & XIRR, SUM, AVERAGE, MIN, MAX, COUNT, IF, IF AND, IF OR, IF NOT, NESTED IF, INDEX & MATCH with Vlookup, MAX, Array (Ctrl + Shift + Enter) & many more with a combination of two or more functions. I also explained how to calculate your income tax liability, considering the slab rates for USA, India & UK. This course will explain variously charts available in Excel, it also explains the distinction between normal table/chart & Pivot table/chart. The explanation of various shortcuts available in Excel will speed up our day to day work. I am looking forward to you, subscribing to the course.
