In this foundational Microsoft skills training, Simona Millham prepares technical and non-technical professionals to learn about Excel formulas and operations.
Excel is a mainstay in most office settings. In this training, Simona will teach you to master this powerful data analysis tool. She starts with the basics and progresses to functionality that you didn't even know existed. Even if you think you’ve been using Excel for a while, you’ve probably only been scratching the surface.
While this Excel training isn't necessarily mapped to a Microsoft exam, it's valuable productivity training for both technical and non-technical professionals.
After finishing this Excel training, you'll know the fundamentals of functions, chart types, conditional formatting, pivot tables, and what-if analysis. You'll also gain an understanding of advanced topics, such as Power Query, Power Pivot, and Power View.
For anyone who leads a technology team, this Microsoft training can be used to onboard new technical and non-technical professionals, curated into individual or team training plans, or as a Microsoft reference resource.
Excel 2019: What You Need to Know
This Excel 2019 training has videos that cover topics such as:
- Introduction to Microsoft Excel 2019
- Creating functions in Excel
- Charts, graphs, and other data visualizations
- Collaboration and file-sharing tools
- What-If Analysis
- Power Pivot
- Macros/VBA
Who Should Take Excel 2019 Training?
This Excel 2019 training is considered foundational-level Microsoft training, which means it was designed for technical and non-technical professionals with no Excel experience at all.
Productivity tools user training. It’s a fact of contemporary business life that many and most non-technical professionals use spreadsheets every day. Typically, they’re expected to figure out Excel’s functionality and capabilities on their own. This training is made to illustrate what Excel is capable of, how to do it, and why it’ll supercharge your existing job responsibilities.
New or aspiring IT professionals. If you’re just starting out on your IT career, be prepared to navigate a lot of data. In every aspect of system, network or security administration, data analysis can be incredibly slow and tedious if you don’t understand the tools available to you. Take this course to gain insight into Excel functionality — you’ll be prepared for navigating and processing any data your job throws at you.
Experienced IT professionals. There’s no shame in admitting a mere patchwork familiarity with Excel — even if you’ve been using it for years. Many IT professionals figure out functions and capabilities of Excel as they go along, but how can you be sure you’re not missing out on functionality that could save you hundreds of hours if you never get trained in Excel? 3D mapping of data, mastering pivot tables and Power Pivot, automating analysis with macros: if you don’t feel like a master of these tools, this training is for you.