|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-basics-course/
课程评论：没有评论
**课程名称：Microsoft Excel 基础（簿记与会计）** **课程概述：** 本 Coursera 课程旨在帮助您以最快速度掌握 Microsoft Excel 的基础知识。课程将为您打下坚实的 Excel 使用基础，使您能够将所学技能应用于专业或个人生活。本课程适用于所有版本的 Microsoft Excel，包括 Excel 2007 至 Excel 365。每节课程时长约 3-5 分钟，学习进度完全由您自主掌握。 **学员评价亮点：** * **适合初学者：** 许多学员认为本课程是初学者的绝佳选择，教授了许多提高 Excel 使用效率的小技巧。 * **实用性强：** 学员特别提到学习了如何添加图表和数据透视表，以便轻松总结信息。 * **内容详实易懂：** 课程内容覆盖广泛，讲解清晰、精准，易于理解。 * **重点内容：** SUM 函数、数字格式化、平均值、中位数、众数、计数、SUMIF、VLOOKUP 和 HLOOKUP 等函数被认为是极具帮助的课程内容。 * **学习体验佳：** 学员表示课程易于跟随，可以边看视频边实际操作。 **学习内容（部分）：** * Excel 界面导航 * 文本和数字的输入 * 基本算术运算（加、减、乘、除）及 SUM 函数 * 单元格的更正与移动 * 插入和删除列/行 * 单元格格式化（加粗、字体等） * 使用复制、剪切、粘贴和格式刷快速复制格式 * 使用选择性粘贴（只粘贴值） * 单元格文本换行 * 数字格式化（货币、百分比、小数位） * 条件格式化（用颜色区分数据） * 图表制作（饼图、柱状图等） * 排序和筛选数据 * 使用冻结窗格查看表头 * 打印预览和格式化打印 * SUMIF 函数（根据条件求和） * VLOOKUP 和 HLOOKUP 函数（垂直和水平查找数据） * IF 函数（条件判断） * LEFT 和 RIGHT 函数（提取单元格数据） * 删除重复项 * 快捷键应用 * 绝对值计算 * 数据透视表（数据总结） **课程优势：** * **讲师资质：** 由注册会计师（CPA）、特许会计师（CA）、工商管理硕士（MBA）Calvin K. Lee 讲授，他同时也是约克大学舒立克商学院的优秀讲师。 * **全球学员：** 超过 52,000 名来自 172 个国家的学员参加过其课程。 * **终身访问权：** 终身享受课程内容，并免费获得新课程和更新。 * **丰富经验：** 讲师拥有 15 年簿记与会计经验，并在四大会计师事务所（安永）有过工作经历。 * **多语言字幕：** 提供英语、法语、印地语、简体中文和西班牙语字幕。 * **结业证书：** 完成课程可获得结业证书。 * **满意度保证：** 提供 30 天内不满意可全额退款的保证。 **立即注册，成为 Excel 高手！**
In this course you will learn the basics of Microsoft Excel as quickly as possible. By the end of this course, you will have a solid understanding of how to use basic functions of Microsoft Excel that you can apply to your professional or personal life.You can use any version of Microsoft Excel to take this course, including Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.Each lesson is around 3-5 minutes, and you can learn at your own pace.WHAT STUDENTS SAY ABOUT THIS COURSE:- "This is such a great course for beginners. It taught me so many new tricks to use Excel more easily." - Nora A.- "I enjoyed all the lessons. I felt like each one had at least one thing that I could take away from. I really enjoyed learning how to add charts and pivot tables to my spreadsheets for an easy summary of information. The sound quality was good. The instructor was clear and precise. The information was presented in a way that was easy to understand and also covered a vast amount of information. Definitely glad that I took this course. Would take another course provided by him, hands down." - Brittany A.- "Sum function, formatting numbers, mean, median, mode, and count, Sumif, VLookup and HLookup were the most helpful lessons for me. They taught me new lessons that will help me in the future. The lessons were very easy to follow. I would have Excel open and ready to input the same criteria when the video started, and could pause where I needed to do the exercises on my own." - B. AlvarezYOU WILL LEARN:Navigating around Microsoft ExcelEntering text and numbersAdding numbers (SUM function), subtracting, multiplying, and dividingCorrecting cells and moving around cellsInserting columns and rowsAdding and deleting cell format (bold, font, etc.)Using Copy, Cut, Paste, and Format Painter to quickly copy cell formattingPaste Value using Paste SpecialWrap text in a cellFormatting numbers using dollar sign, percentage, decimalsConditional formatting to add colors to make sense of cell dataUsing charts (pie charts, column charts, etc.)Sorting numbersFiltering numbersUsing Freeze Panes to see columns and row headingsPrint Preview options to nicely print your Excel sheetUsing Sumif function to add cells based on criteriaUsing VLookup function to quickly find data in a table vertically Using HLookup function to quickly find data in a table horizontally Using "If" function to test criteriaUsing "Left" and "Right" functions to extract data from a cellRemoving duplicates in a range of dataShortcut keys to quickly select a range of cellsFinding absolute value of positive and negative numbersPivot Tables to summarize your dataAnd much more!WHY THIS COURSE?Taught by a CPA, CA, MBA - Calvin K. LeeCalvin is a top-rated instructor at Schulich School of Business at York UniversityOver 52,000+ students from 172 countries enrolled in his coursesLifetime access to this course, and you receive new lessons and updates for FREE.He has 15 years of experience in bookkeeping & accountingHe has worked in a Big 4 accounting firm (Ernst & Young)Subtitles (captions) available in English, French, Hindi, Simplified Chinese, and SpanishCertificate of Completion availableI guarantee you will learn Excel. If you aren't absolutely satisfied, I'll refund your money with a 30-day money-back guaranteeREGISTER FOR THIS COURSE NOW!
