Nonprofit Management Solutions
|
|
HomeAbout UsWorkshopsConsultingResources Special Programs Contact Us    
 Registration Information
 Click Here To Register
 
 
 
 
Course Categories:
Self-Guided Supervisory Skills
Organizational & Leadership Development
Human Resource Development
Fund Resource Development
Financial Management
Marketing & Public Relations
Technology & Computer Applications
Institute for Collaborative Partnerships
Technology

All Workshops
 
 
 
 
 
View Past Classes
 
View Calendar of Workshops
 
Trainers
 
Locations

Class Description

Course Name: Excel: Advanced
Course Category: Technology & Computer Applications
Class Date: 11/9/2017
Class Start Time: 9:15 AM
Class End Time: 1:15 PM
Public Price: $140.00
Member Price: $115.00
Sweet Deal: $85.00
Trainer: Rodney Greek
Location: Brandman University
   
Course Overview: Before attending the Advanced Excel class, you should know how to: *Use the Insert Function tool *Select multiple non adjacent columns *Run a sub-total on data *Assign and understand the difference between a relative and absolute cell reference *Create a formula that references cells in different worksheets *Select multiple worksheets and perform a task once for all of the selected sheets *Apply filtering to a data set. *Display formulas versus formula results *Create a data table *Use Data Validation to create dropdown lists This interactive workshop will help you become the Excel guru in your office! Participants will: 1) Customize and protect worksheets. 2) Merge a database. 3) Use the function wizard. 4) Discover the power of using absolute vs. relative values. 5) Nest functions and formulas inside other functions and formulas. 6) Use Pivot Tables to manipulate and report data. 7) Program Macros to speed up tasks. 8) Create formulas that reference other worksheets and workbooks. 9) Manage links between workbooks. 10) Learn more about advanced functions. Prerequisite: Intermediate Excel or knowledge of Excel is recommended. NOTE: If you would like to save copies of the examples used, please bring a flash drive to the workshop. Before attending the Advanced Excel class, you should know how to: Use the Insert Function tool Select multiple non adjacent columns Run a sub-total on data Assign and understand the difference between a relative and absolute cell reference Create a formula that references cells in different worksheets Select multiple worksheets and perform a task once for all of the selected sheets Apply filtering to a data set. Display formulas versus formula results Create a data table Use Data Validation to create dropdown lists.