Oregon Health & Science University
CWE Center: Microsoft Excel 2007 (Advanced) (CWEC:Ex07-L3)
This is a 3-part series. You must be able to attend all three parts of this series to register.
The Microsoft Excel 2007 Advanced Class is designed for users who are keen to extend their understanding and knowledge of the software and have significant experience with it.
Participants will receive Labyrinth Learning Excel 2007 Level III manual and learn the following skills:
•Working with Tables
•Creating Financial Functions
•Creating a Table
•Using Data Analysis Tools
•Understanding Structured References
•Using 3-D Cell References in Formulas
•Using Enhanced Sorting and Filtering
•Introducing Lookup Functions
•Using the Outline Feature
•Creating Formulas with the IF Function
•Using Criteria IF Functions
•Auditing Formula Errors
•Recording Macros & Macro Security
•Working with Grouped Worksheets
•Consolidating Worksheet Data
•Assigning Macros to Keys & Buttons
•Working with Conditional Formatting
•Using Data Tables and Trendlines
There are no instructor-led classes available for this course.
There is no self-paced learning available for this course.
Copyright © 2014