Enroll Course: https://www.udemy.com/course/curso-microsoft-excel-intermedio/
In today’s data-driven world, proficiency in Microsoft Excel is no longer a luxury, but a necessity for professionals across almost every industry. Whether you’re looking to boost your productivity, gain a competitive edge in the job market, or simply manage your data more effectively, an intermediate Excel course is an excellent investment. I recently completed the ‘Curso Microsoft Excel Intermedio (Ver. 2019)’ on Udemy, and I’m excited to share my experience and recommendations.
This course is designed for those who have a basic understanding of Excel and are ready to dive deeper into its powerful features. It covers a vast array of topics, starting with an overview of updates and new features in Excel 2019 and Office 365, including SVG file insertion and chained comments. The instructor provides downloadable files, which are invaluable for hands-on practice.
The core of the course focuses on formulas and functions, which are the backbone of Excel’s analytical capabilities. You’ll get a detailed breakdown of formula analysis, error finding, and even an introduction to leveraging AI like ChatGPT within Excel. The logical functions section is particularly robust, covering conditional statements like IF, IFSET, CHANGE, IFERROR, ISNA, NOT, and the powerful LET function.
For those who need to crunch numbers, the statistical functions module is comprehensive. It covers counting functions (COUNT, COUNTA, COUNTIF, COUNTIFS), MAX, MAXA, MAXIFS, AVERAGE, AVERAGEA, MODE, MEDIAN, TRIMMEAN, COUNTBLANK, RANK.EQ, PERCENTILE.INC/EXC, and QUARTILE.INC/EXC. This section alone can significantly enhance your data analysis skills.
Mathematical and trigonometric functions are also thoroughly explored, with detailed explanations of SUMIF, SUMIFS, SUBTOTAL, AGGREGATE, INT, MOD, SUMPRODUCT, and various rounding functions (ROUND, ROUNDEVEN, ROUNDODD, ROUNDUP, ROUNDDOWN). The practical application of these functions, such as calculating budgets, is highlighted.
Working with text data is made easy with functions like LEFT, RIGHT, UPPER, LOWER, PROPER, LEN, FIND, SEARCH, MID, SUBSTITUTE, REPLACE, CONCATENATE, CONCAT, TEXTJOIN, TRIM, REPT, TEXT, EXACT, CODE, and CHAR. The course also addresses common text errors and how to correct them.
Date and time functions are crucial for many business applications, and this course covers them extensively. You’ll learn about DATE, YEAR, MONTH, DAY, EOMONTH, EDATE, DAYS, NETWORKDAYS, NETWORKDAYS.INTL, ISOWEEKNUM, HOUR, MINUTE, and VALUE. Calculating time differences and working with date systems is made clear.
The search functions module is a game-changer. It delves into MATCH, XMATCH, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, ADDRESS, INDIRECT, OFFSET, HYPERLINK, and CHOOSE. The ability to efficiently find and retrieve data is a key takeaway, with practical examples like creating a sheet index and classifying duplicate values.
Financial functions are not overlooked, with coverage of PMT, IPMT, PPMT, PV, FV, NPER, RATE, DB, SYD, and NPV. These functions are essential for financial planning and analysis.
Information functions like CELL, ISERROR, INFO, IS, N, NA, SHEET, SHEETS, and TYPE are also covered, providing insights into cell properties and error types.
Web functions, specifically the IMAGE function, are introduced, allowing for dynamic image insertion. A particularly exciting addition is the ‘Python in Excel’ module, hinting at the future integration of advanced programming within spreadsheets.
Data validation, consolidation, and outlining are covered, along with cell controls like Checkboxes, enhancing user interaction and data integrity. Collaboration tools such as workbook protection, change tracking, co-authoring, and mail merge with Word are also discussed.
The course culminates with an in-depth exploration of Pivot Tables. From understanding what a Pivot Table is to creating them from scratch, manipulating fields, applying formatting, filtering, grouping, and using calculated fields and items, this section is incredibly thorough. Features like Slicers, Timelines, and Recommended Pivot Tables are also explained, empowering you to analyze large datasets efficiently.
**Recommendation:**
I highly recommend the ‘Curso Microsoft Excel Intermedio (Ver. 2019)’ on Udemy for anyone looking to significantly upgrade their Excel skills. The instructor’s clear explanations, practical examples, and comprehensive syllabus make this course an outstanding resource. It strikes a perfect balance between theoretical knowledge and practical application, ensuring you can confidently use these intermediate to advanced Excel features in your daily work. If you want to become more efficient and productive with Excel, this course is a must-have.
Enroll Course: https://www.udemy.com/course/curso-microsoft-excel-intermedio/