- Course info
- Course resources
In this Microsoft skills training, Simona Millham covers fundamental to advanced spreadsheet skills. Learners who are new to using Microsoft Excel will benefit from working through this course from the beginning, while experienced learners may find it more advantageous to jump into the Nuggets they find most valuable.
After completing this Excel 2016 training, you'll know how to use number formats, data visualization, PivotTables, What-If Analysis, forecasting, and 3D maps. With real-world examples taken from a business environment, this Excel 2016 training covers a range of fundamental and advanced spreadsheet skills.
For anyone with technical and non-technical professionals on their 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 2016: What You Need to Know
For any technical and non-technical professionals looking to improve their proficiency with productivity tools, this Microsoft course covers topics such as:
- Basics of creating a spreadsheet in Excel
- Data visualization and charts
- Working with Excel lists
- Interactive Reports with Power View
- Excel forecasting
- Adding graphics to worksheets
- Introduction to Excel macros
Who Should Take Excel 2016 Training?
This Excel 2016 training is considered foundational-level Microsoft training, which means it was designed for technical and non-technical professionals with no Excel experience. That said, even the most advanced Excel users will still learn something they didn’t know from this training.
Productivity tools user training. Microsoft Excel skills are useful in non-technical settings, for example, to keep track of and analyze information in business settings. This Microsoft training offers real-world examples from a business perspective that can be useful to non-technical professionals. Non-technical professionals will learn how to navigate the software, create functions and charts in Excel, and share and collaborate spreadsheets.
New or aspiring IT professionals. Mastery of data analysis and visualization is valuable to professionals in any aspect of IT. Whether in technical or non-technical contexts, success for the rest of your career could hinge on your ability to navigate and understand large amounts of data, and then display it meaningfully. Being a master of your own technical career is great, but be sure to also invest in your abilities as an office professional with this Excel training.
Experienced IT professionals. As you become more experienced in the IT world, you may find that your job responsibilities gradually drift away from technical aspects and more toward data analysis, summary and presentation. If you’re not fully confident with navigating large amounts of data in spreadsheets, this training can help prepare you to use Excel in all the technical and non-technical aspects of your job.