ONCE1165 - Advanced Excel

Course Description

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. 

This 4-Week, self-paced Online course (no Live meetings) is offered through partnership with LERN/UGotClass. This course has a start and end date.  Registration stays open for the first full week of class. 

Course Outline

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

Notes

This course can be taken as part of the “Certificate in Mastering Excel”

Certificate in Mastering Excel | Temple University

• ONCE1163 (Mastering MS Excel)
• ONCE1164 (Intermediate Excel)
• ONCE1165 (Advanced Excel)

Cancellation, Withdrawal and Refund Policy

A participant who withdraws from a non-credit course, in writing, up to one-week prior to the starting date of the course, will receive a refund, minus a $25 withdrawal fee; for all certificate programs the withdrawal fee is $50. For courses costing $75 or less, the withdrawal fee is $10 per course. No refunds will be given after that time. E-mail your withdrawal request to: ncce@temple.edu. Please note that if you do not officially withdrawal from a course and you do not attend the course, you are still responsible for payment. Temple University reserves the right to cancel a course for any reason. If the course is cancelled, you will be notified, and your entire tuition will be refunded.

For more information contact us at ncce@temple.edu or 267-468-8500.

Applies Towards the Following Certificates

• Certificate in Mastering Excel : Certificate in Mastering Excel