Level Up Your Microsoft Excel Skills

The combination of Microsoft Excel's Power Query and Power Pivot features can be highly effective. This brief course demonstrates a seamless workflow, guiding users through utilizing Power Query to select, prepare, and cleanse data, and then employing Power Pivot to create a data model, build relationships, and implement calculations and measures. Practical real-world scenarios are explored in the final chapter to enhance proficiency in working with Power Query and Power Pivot.

Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. Oz provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge. This course delves into various formulas, including XLOOKUP/VLOOKUP, INDEX, counting and statistical functions, text functions, and date/time, array, math, and information functions. It guides viewers in seamlessly incorporating Excel's potent formulas and functions into practical situations. The course concludes with challenges designed to test and reinforce your newfound knowledge.

Microsoft introduced dynamic arrays, a new set of functions in Excel that revolutionize spreadsheet functionality. Dynamic arrays enable users to generate multiple results with a single formula, streamlining the spreadsheet-building process, reducing errors, and enhancing efficiency. It guides you through the innovative calculation engine and the seven dynamic array functions: UNIQUE, SORT, SORTBY, SEQUENCE, FILTER, RANDARRAY, and SINGLE. The course provides practical applications for each function, demonstrating real-world uses.

VBA enables the automation of routine tasks in Excel and is surprisingly accessible to learn. This course provides a comprehensive introduction to the Visual Basic for Applications programming language, covering the creation of subroutines and functions, exploring the Excel object model, and demonstrating programming techniques with real-world examples.

Explore advanced formatting techniques beyond font colors and graphs in this course. Covering text, number, and date formatting, working with images and shapes, advanced conditional formatting, print optimization, and formatting tips for tables, slicers, charts, and graphs, it delves into enhancing the overall work environment in Excel for a more pleasant experience.