Advanced Excel

ID : 10501

We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.
Agenda
Unit 1 - Advanced Functions Used To Make Business Decisions
Applying multiple criteria to functions
Using And criteria
Using Or criteria
Using And and Or and Not criteria
Advanced Logical functions
Using If -Then control statements
Implementing If functions with Aggregate functions
Unit 2 - Functions Used to Make Financial Decisions
Learning basic financial functions
Applying functions to perform loan calculations
Computing loan payments
Computing interest rate
Computing number of payment periods
Computing present value of a loan
Working with additional functions
Unit 3 - Applying Different Scenarios Using Excel Data Tools
Understanding Different What-If Analysis Tools
Performing What-If Analysis to see how data changes outcomes in formulas
Using Scenario Manager
Using Data Tables
Using Goal Seek
Applying rules to manage cell data
Implement validation rules to avoid invalid entries
Entering validation rules
Avoiding duplicate data entries
Unit 4 - Powerful Tools Used to Complete Data Implementation and Analysis
Exporting and Importing Data into Workbook
Protecting a workbook
Making improved business decisions using pivot tables
Creating an Excel Dashboard to visually display relevant data