That's why I also included plenty of exercises - with solutions - that challenge you to apply each of the concepts we cover in the course to a real world problem.īy the end of the course, you'll have mastered all the skills you need to take control of your data - and your time - with Microsoft Excel.
Instead, I tie each piece of functionality back to the types of scenarios where it is most commonly applied, and demonstrate these applications with realistic examples.īut without hands-on practice to reinforce what you've learned, you might as well be binging the latest show on Netflix instead of taking an Excel course.
EXCEL FOR MAC 16.11 CODE
Taking your Pivot Tables to the next level with SlicersĪutomating redundant tasks with Excel MacrosĮditing VBA (Visual Basic for Applications) code for more fine-tuned control of your MacrosĪnd I go way beyond the mere mechanics of how things work you can always go to the documentation for that. Managing "structured" data efficiently with Excel TablesĬondensing large datasets into powerful Business Intelligence using Excel Pivot Tables
Master the essential VLOOKUP function for consolidating and reconciling separate datasetsīest practices for constructing dynamic models with sophisticated controls for varying model inputĪdvanced data visualization techniques, including custom formats, conditional formatting, and - of course! - charts Logical functions like AND, OR, and IF for advanced conditional operations Using functions to perform complex operations on text data Performing "date math" with Excel's vast array of date and time functions
EXCEL FOR MAC 16.11 PROFESSIONAL
Keyboard shortcuts and data entry tricks that will help you swat away those tedious tasks around the office with easeįormatting tips to give your spreadsheets that professional lookįiltering and sorting for rapid insights into your dataĬrunching out calculations and summary statistics with Excel formulas and functions Here's a sneak peek at just some of the things you'll learn: But fortunately, as with so many things, there is a small percentage of Excel's feature set that most people use, most of the time.īecause I want to level up your skills in the shortest time possible, this course is laser-focused on Excel's most useful and powerful features - the ones you'll find yourself going back to, day in and day out. Now to be sure, Excel is one of the most complex applications ever built, and a course that covers all of its features and functionality might last well into the next decade. You'd be amazed at how much many crucial decisions made at the highest levels of companies, or even governments, are made based on data in an Excel spreadsheet.Īnd even better - with the right teaching approach - Excel is actually pretty easy to master. Whether you're an Analyst who works with data for a living, or one of the millions of people in offices all over the world who find themselves spending more time wrestling with spreadsheets than doing their actual job, chances are excellent that you can supercharge your productivity - and decrease your stress - by mastering Microsoft Excel.Įxcel allows us to transform, analyze, summarize, and visualize our data with incredible power and efficiency, making it the ultimate "glue" application without which many organizations would fall apart.
0 kommentar(er)
