Advanced Excel | Continuing Education - UWM at Washington County

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.

Course length: One month
Number of Hours: 16
Cost: $195
Course start dates: 4/3/23, 6/5/23, 8/7/23, 11/6/23

You may also take this course as part of the Mastering Excel Certificate.

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

Course Detail