|
via Udemy |
Go to Course: https://www.udemy.com/course/microsoft-excel-for-mac-2-intermediate-to-expert-advanced/
Certainly! Here's a detailed review and recommendation for the Coursera course "Microsoft Excel for Mac 2: Intermediate to Expert Advanced": --- **Course Review and Recommendation: Microsoft Excel for Mac 2: Intermediate to Expert Advanced** If you're already familiar with the basics of Microsoft Excel and looking to elevate your skills to an advanced level, "Microsoft Excel for Mac 2: Intermediate to Expert Advanced" on Coursera is an excellent choice. This course builds directly on the foundational skills learned in "Microsoft Excel for Mac 1" and prepares you for the official Microsoft Excel Expert exam (77-728). **Overview & Content:** The course covers comprehensive topics essential for mastering Excel at an expert level. You will learn how to manage workbooks, utilize advanced functions, create complex charts and PivotTables, automate tasks, and much more. The curriculum is meticulously divided into modules that make complex concepts approachable, with each sub-topic delivered in concise 5-7 minute lectures. The course duration is approximately 8 hours, making it manageable for busy learners, but it’s recommended to allocate additional time for practice and self-testing. **Strengths:** - **Structured Learning:** The course is well-organized, with clear progression from intermediate to advanced topics. - **Practical Focus:** Emphasis on real-world tasks such as troubleshooting formulas, internationalization, advanced data referencing, and automation, which are highly valuable in professional settings. - **Exam Preparation:** Tailored to cover all exam-relevant topics for the Microsoft Excel Expert certification, making it ideal for those looking to validate their skills. - **Interactive and Supportive:** Small tests after each section reinforce understanding, and the instructor shares insights on best practices, offering a richer learning experience. - **Multilingual Support:** The content is translated into 15 different languages, broadening accessibility. **Reviews:** Learners praise the course for its clarity, structured approach, and the instructor's expertise. Arnold Schwartz notes the course's ease of understanding, while Daniel Sandberg highlights the instructor’s thorough explanations and effective teaching style. Many recommend it as a valuable resource for advancing Excel skills confidently. **Who Should Enroll?** - Individuals aspiring to become Microsoft Office Specialist Experts. - Professionals seeking to enhance or validate their Excel proficiency. - Anyone looking to master advanced Excel functions and features for personal or professional growth. - Users with basic Excel knowledge who want to reach an expert level. **Final Verdict:** This course is a highly recommended stepping stone for anyone serious about excelling in Microsoft Excel, especially those aiming to pass the official Microsoft Excel Expert exam. Its well-structured content, practical focus, and exam-centric approach make it an invaluable resource. **Would I Recommend It?** Absolutely. Whether you are preparing for a certification, advancing your career, or simply want to deepen your Excel knowledge, this course offers comprehensive coverage and practical insights that will serve you well. --- Feel free to reach out if you'd like a personalized learning plan or additional resources to complement this course!
Building on the skills learnt in "Microsoft Excel for Mac 1", here's levels 6-9. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.Reviews"Well thought out and explained in a way which makes it easy to learn & understand." - Arnold Schwartz"This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one" - Daniel SandbergMost people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 9?In this course, learn how to:Manage workbook options and settingsManage Excel workbooks,Manage workbook review,Apply workbook settings, properties and data options, andApply logical and statistical functionsCreate advanced charts and Excel tablesCreate and manage PivotTables,Advanced formatting,Create and manage PivotCharts,Create advanced charts,Apply advanced date and time functionsPreparing for advanced formulasTroubleshoot Excel formulas,Manage and reference defined names,Prepare a workbook for internationalisation and accessibility,Array fornulas.Automation and advanced formulasCreate and modify custom workbook elementsLook up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.This course teaches all the skills that Microsoft want you to know for the Expert exams 77-728 (for Excel 2016 Expert), including those aspects which are PC only (sadly), and will be useful if you wish to take the exam, or which to learn more about Microsoft ExcelThe core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.You should take this course if:you want to learn more about Microsoft Excel, oryou want to learn the Excel skills you need to become a certified Microsoft Office Specialist Expert.Regardless whether you have Excel 2016 or Excel 365 (or even Excel 2011), this course will help you get to an advanced level, and maybe even want you to get more!