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.

One month course; John Rutledge, instructor

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

Question MarkAbout online learning

Online learning is a fun, enjoyable and very productive way to learn. Millions of people are learning online each year. You will engage with the instructor and other participants. You will get to know your instructor and other participants. You may make friends.  It’s easy. It’s fun. 

GearsHow the Course Works

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom.  You will have a password and use your email address and password to gain access.

Once inside the online classroom, here’s what you can expect.

CalendarParticipate when you want

You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.
There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.

ChecklistWhat you will do

For each Unit, you will:

  • Read the print readings (about 20 pages a week)
  • Have the option of accessing the online readings
  • Listen to the audio presentation for the Unit and view the slides
  • Have the option of taking a self-quiz to see how much you have learned
  • Engage in written online discussion with your instructor and other participants

For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

DiscussionDiscussion

The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night.

Your instructor will log into the Discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.

We encourage you to make 2-3 comments each week to maximize your learning and enjoyment of the course.

It’s easy. It’s fun.

Next offering(s):

Advanced Excel
April 2 - 27, 2018

Intermediate Excel
March 5 - 30, 2018

Mastering Microsoft Excel
February 5 - March 2, 2018

Add Certificate To Cart
$495.00 USD
$195 USD

Ave. hours 16, 1.6 CEUs/ILUs

About Your Instructor

 

With over 25 years’ experience in the IT field, John Rutledge has a BA in Psychology and a Diploma in Computer Programming as well as having received numerous certifications and awards.  He holds a Microsoft Office Master Certification and has a globally-recognized ICDL (International Computer Driver’s License) certification as well.  John was the Manager of a Technical Support Desk for a multinational for several years.  Prior to that, he held roles as Project Lead on a national software implementation project, Systems Analyst and Programmer Analyst.  Currently the owner of an IT Consultancy firm, John works regularly with businesses of all sizes to assist them in understanding and managing their data.
 
Directional ArrowsCourse Objectives

Upon successful completion of this course, students will be able to:
  • Understand and apply logical functions to their data in the worksheet.
  • Demonstrate the need to learn and apply financial functions to data.
  • Create data rules to determine types of data entered into a cell.
  • Demonstrate working knowledge on how entered data can effect formulas and influence business decisions.
  • Determine how to protect data in the workbook.
  • Make effective business decisions by using a variety of data analysis tools
  • Design a visual interface in spreadsheet to view relevant information.
 

Puzzle PiecesCourse Outcomes

At the end of the course:
 

  • The student will learn different condition types and know to how to apply it to Excel functions.
  • The student will make accurate business conclusions derived from various financial functions and calculations.
  • The student will understand cause and effect circumstances by changing data and how it can influence business decisions.
  • The students will be able to apply different data scenarios to find optimal solutions for proper business decisions.
  • The student will learn a variety of Excel’s most powerful features to analyze data quickly and easily.
Completion Requirements