Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Excel 2016 Advanced
Maximize your productivity with the advanced features of Excel.Preview the first lesson free — get full access to all 56 lessons.
Advanced Provider : Lori Robinson 9 chapters · 56 Lessons · 3h 16m in Arabic, English, Spanish
Course Description
Microsoft Excel 2016 provides users with far more than software for organizing their data. In fact, this iteration of Microsoft's spreadsheet software allows users to truly take their data management and analysis to the next level. After completing this comprehensive Microsoft Excel 2016 eLearning platform, users will be proficient with the advanced techniques that put the basic Excel functions into overdrive.
What You'll Learn
- Apply statistical, logical, text, and date and time functions to analyze data
- Calculate loan payments, present value, loan payoff, interest rate, and principal and interest
- Test conditions using IF, IFS, and IF functions with relational operators
- Look up data with VLOOKUP for approximate and exact matches, plus INDEX/MATCH and COUNTIF functions
- Perform what-if analysis using Goal Seek, Solver, Scenario Manager, and data tables
- Work with ranges, control automatic calculations, and copy formula values
Key Takeaways
- Excel 2016 lets users take data management and analysis beyond basic organizing, into advanced techniques.
- The course covers financial calculations including loan payments, present value, loan payoff, interest rate, and principal and interest.
- Lookup and reference techniques include VLOOKUP for approximate and exact data, INDEX/MATCH, and the COUNTIF family of functions.
- What-if analysis tools taught include Goal Seek, Solver, Scenario Manager, and data tables.
- Completing this course makes users proficient with advanced techniques that put basic Excel functions into overdrive.
Frequently Asked Questions
Who is this course for?
It is for users who want to move beyond basic Excel and become proficient with advanced Microsoft Excel 2016 techniques for data management and analysis.
What topics does this course cover?
It covers statistical, logical, text, and date and time functions; financial calculations such as loan payments, present value, payoff, interest rate, and principal and interest; conditional logic with IF, IFS, and relational operators; lookups with VLOOKUP, INDEX/MATCH, and COUNTIF; and what-if analysis with Goal Seek, Solver, Scenario Manager, and data tables.
What skills will I gain from this course?
You will build skills in Microsoft Excel, spreadsheets, Excel Services, ExcelPackage, and toward Microsoft Office Specialist (MOS) - Excel and Microsoft Office Specialist Master.
What will I be able to do after completing it?
After completing this comprehensive Microsoft Excel 2016 eLearning platform, you will be proficient with the advanced techniques that put the basic Excel functions into overdrive.
