|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-in-hindi-basic-to-super-advanced-updated/
课程评论:没有评论
课程名称:学习微软高级Excel(印地语)顶级Excel技巧 课程概述: “微软Excel专业课程”是一个全面的在线培训项目,分为三个级别,涵盖了丰富的主题,包含18个教程视频,时长为1.5小时。课程包括了许多在其他中级/高级在线项目中常被忽视的主题。可观看演示预览讲座以了解区别。主要内容包括:与MATCH()结合使用的VLOOKUP()、HLOOKUP();结合多个数组和两个MATCH()的INDEX();SUMIF()与SUMIFS()的用法;在使用过滤器时的SUM()与SUBTOTAL();隐藏文本分列技巧;INDIRECT()和OFFSET()的应用;数据透视表计算自动求和、计数、百分比和生成分组数据标题的技巧;强大的“定位-特殊”与Ctrl+Enter组合键;使用通配符字符的“查找和替换”;数据清理的组合技巧;基于公式的条件格式化;注释中插入图片等众多技巧。 主讲讲师:CA. Rishabh Pugalia,Excel Next创始人。他是一位合格的特许会计师,曾在KPMG和J.P. Morgan工作,已经培训了超过5500名专业人士,并在多年来通过各种论坛、实验、解决问题的挑战和培训互动中积累了数百个小技巧并融入到本在线课程中。此外,他还为之一家“四大”会计师事务所进行过100多场研讨会,参与者来自多个部门和领域,所获得的见解也经过精心整合到课程中。 课程评价: “这课程非常有帮助,无论是在节省时间、提升演示技巧还是学习新功能方面。视频让你有一对一的关注感。此外,他们通过电子邮件不断分享新技巧的做法也非常值得赞赏。”——阿伦达蒂·雷查乌德里,金融专业人士,印度。 重要信息: - 课程以印地语授课 - 注册后,您将获得无限制的终身访问权限! - 您将即时免费访问我对课程的任何更新。 - 我会对课程中的任何问题或建议提供全力支持。 - 课程包含指导实践的工作表,方便立即练习。 - 24/7随时访问所有视频,可以随时在线学习。 - 提供30天退款保证(我们希望您100%满意)。 如果您已阅读到这里,下一步就是加入这门课程。投资1.5小时,获得终身的微软Excel“忍者”资格!
"Microsoft Excel for Professionals" is a comprehensive online training program. It is divided in 3 Levels and covers exhaustive list of topics. There are 18 tutorial videos and the duration is 1.5 hrs. Topics often ignored in other intermediate/advanced online programs have been included. Watch Demo Preview Lectures to find the difference. VLOOKUP() with MATCH()HLOOKUP() with MATCH()INDEX() with multiple arrays & two MATCH()SUMIF() vs. SUMIFS()SUM() vs. SUBTOTAL() while using FilterHidden Text-to-Columns tricksApplications of INDIRECT() and OFFSET()Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headingsPower of "GO TO - Special" along with Ctrl+EnterUsing "Find and Replace" with wildcard charactersCombo techniques for Data cleaningFormula-based Conditional formattingInserting Picture in Comments.and the list of such tricks is very long Instructor: CA. Rishabh Pugalia, Founder, Excel Next So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who - Is a qualified Chartered AccountantHas worked with KPMG and J.P. MorganHas trained 5,500+ professionals (Apr 2010 - June 2014) in face-to-face training programsHas incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction And by the way he has conducted more than 100 (hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program. ---------------------------------------------------------- "The courses are really helpful whether in terms of saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda" by Arundhati Raychaudhuri, Finance Professional, India ---------------------------------------------------------- Important information before you join: It's in HINDI languageOnce enrolled, you have unlimited, lifetime access to the course!You will have instant and free access to any updates I'll add to the course.I will give you my full support regarding any issues or suggestions related to the course.Guided practice - over worksheets included for immediate practiceAccess to all videos 24 x 7 - learn online from anywhereA 30-day money back guarantee (we want you to be 100% satisfied) --------------------------------------------------------- If you have read this far, next action is JOINING this course. Invest 1.5 hrs. for a benefit of lifetime Ninja status on Microsoft Excel!