Skip to content

Advanced Excel


Adult Programs / Professional Development -
Adult Online Professional & Personal Development 2021-2022

Advanced Excel contains tools that can help you prepare your worksheets accurately, examine your data for authentication, and find answers to your most difficult questions. Learn required business functions along with tools required to analyze data efficiently within the workplace. Save time by protecting your valuable data. Discover how to attractively visualize your data into meaningful information with confidence. 

This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. 

Class Details

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

For more information, visit our question and answer page - Click Here.

John Rutledge

LERN 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.

 November 2021 
SuMTuWThFSa
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
 
 
 
 
 
 
 
 
 
 
CERT20C2

  Learning Resources Network, Inc , John Rutledge


Virtual Class
Sun-Sat, Nov 1 - Nov 26
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

$ 195.00
single course