Microsoft Excel 2016 Advanced 

Microsoft Excel is the go-to software for data management. By making the user more effective and efficient, Excel sets the standard for spreadsheet software. 

In our Microsoft Excel 2016 Advanced course, you will learn data management and advanced techniques of working with data. 

This course will help you to take the complexity out of formulas by learning to work with power functions, analyze data to make better business decisions by learning to use pivot tables, sort and filter data while identifying trends with advanced data management features, and save time and work more efficiently by utilizing macros. 

​Enhance your data management strategy while improving success and effectiveness with our course in Microsoft Excel 2016 Advanced. ​
Picture
Microsoft Excel 2016 Advanced Course
Course Outline 
1. Working with Functions
  • Overview
  • Using Statistical Functions
  • Calculating Loan Payments
  • Calculating Present Value
  • Calculating Loan Payoff
  • Calculating Interest Rate
  • Calculating Principle & Interest
  • Work with Logical Functions
  • Work with Text Functions
  • Work with Ranges
  • Using Date and Time Functions
  • Controlling Automatic Calculations 
  • Copying Formula Values
2. IF, VLOOKUP, and Power Functions
  • Overview
  • Testing Conditions with IF
  • Using IF functions with relational operators
  • Using the IFS function
  • Using VLOOKUP
  • Getting approximate table data with VLOOKUP
  • Getting exact table data with VLOOKUP
  • Using INDEX/MATCH functions
  • Using the COUNTIF family of functions
3. Data Analysis Tools
  • Overview
  • Using Goal Seek
  • Using Solver
  • Using Scenario Manager
  • Using data tables
​

4. Data Management Features
  • Overview
  • Sorting data
  • Using filters
  • Splitting data into multiple columns
  • Using Flash Fill
  • Removing duplicate records
  • Using validation tools


5. Working with Lists
  • Overview
  • Query Data with Database Functions
  • Outline and Subtotal Data
  6. ​Pivot Tables
  • Overview
  • Creating PivotTables
  • Manipulating PivotTable data
  • Grouping by date and time
  • Grouping by other factors
  • Using slicers to clarify and manipulate fields
  • Using Pivot Charts

7. Introduction to Macros
  • Overview
  • Understanding and creating Macros
  • Running and editing a macro

8. Security and Sharing
  • Overview
  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Sharing workbooks
  • Tracking changes
Conclusion
Course Certification
Picture
​We award every participant who successfully completes our course final exam a Certificate of Completion, acknowledging their participation and completion in one of our courses.
 After completely viewing the course, a Certification Test becomes available to ensure the user’s proficiency in the subject. To successfully complete the test you must score 80% or higher (we allow multiple attempts). Once successfully completed you may save or print your certificate at no extra cost.