- Course info
- Course resources
In this foundational Microsoft skills training, Simona Millham helps learners understand Excel formulas and operations.
Excel for Office 365 is the subscription version of the popular spreadsheet software. If you are new to Excel, you might want to work through this Excel training from the beginning. However, if you’re comfortable with the basics, follow along with Simona as she teaches you advanced Excel functions like Power Query, Power Pivot, and Power View.
While this Excel training isn't necessarily mapped to a Microsoft exam, it's valuable training for both technical and non-technical professionals.
After finishing this Microsoft 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 data visualization, VBA, and forecasting.
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 for Office 365: What You Need to Know
This Excel for Office 365 training covers Excel formulas and operations topics including:
- Excel basics
- Creating and working with formulas
- Using autofill
- Making graphs and charts
- Collaborative tools
- Advanced tools such as What-If Analysis and Power Pivot
- Using macros to automate worksheets
Who Should Take Excel for Office 365 Training?
This Excel for Office 365 training is considered foundational-level Microsoft training, which means it was designed for technical and non-technical professionals with no Excel experience.
Productivity tools user training. When it comes to using data and turning it into useful analysis, Excel has tools that most people have never even heard of — even professionals who’ve used the program for years. If you’re a non-technical professional and you use spreadsheets for your job, you’ll save yourself tons of time and effort by getting this training in Excel basics. Excel is more than just graphs, charts, formulas and formatting cells, it’s also collaborating and sharing in real-time, and Power Pivot tables — all of which you’ll master after this training.
New or aspiring IT professionals. This Excel for Office 365 training will help novices in both technical and non-technical fields gain insight into the basics of working with spreadsheets, such as formatting cells, writing equations, and learning how to write functions. Newcomers will also learn how to use more advanced functionality such as Power Query and What-If Analyses. Even if you’re brand new to your job, if you’re using spreadsheets and analyzing data, mastering Excel with this training will help prepare you for a more advanced career.
Experienced IT professionals. Experienced technical and non-technical professionals can refresh their memory and deepen their knowledge of Excel tools with this Microsoft training. If you’ve been working in IT for several years, you must’ve noticed that using Excel to masterfully navigate large amounts of data is the hallmark of a professional — this training can help ensure you know Pivot Tables, What-if Analysis, 3D maps and much more.