Using Solver in Excel 2016 смотреть онлайн

Check out the full course at https://www.knowledgecity.com/en/library/CMP1126/course/excel-2016-advanced. In the 2016 Advanced Solver video, you can learn how to check the Solver “add-in” function to make sure the app is loaded and ready to perform. You will find the application under the Data menu, all the way to the right. Use Excel’s Solver to solve “what if” problems. Figure out investment returns, budgets, how many products to order, or other difficult statistical computations. This short video will show you how.

Course Lessons

Welcome

Introduction
Overview
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
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
Data Analysis Tools
Overview
Using Goal Seek
Using Solver
Using Scenario Manager
Using data tables
Data Management Features
Overview
Sorting data
Using filters
Splitting data into multiple columns
Using Flash Fill
Removing duplicate records
Using validation tools
Working with Lists
Overview
Query Data with Database Functions
Outline and Subtotal Data
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 PivotCharts
Introduction to Macros
Overview
Understanding and creating Macros
Running and editing a macro
Security and Sharing
Overview
Unlocking cells and protecting worksheets
Protecting workbooks
Assigning passwords to workbooks
Sharing workbooks
Tracking changes
Conclusion

https://www.knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance.

Subscribe to our YouTube Channel: https://www.youtube.com/user/knowledgeocity?sub_confirmation=1

Check our Blog: https://goo.gl/q47XKK

Connect with KnowledgeCity!
Twitter: https://goo.gl/wToC6s
Facebook: https://goo.gl/3eMEq9
LinkedIn: https://goo.gl/vg1aXt
Google+: https://goo.gl/Gjkffm