MS Excel Level 3

Register Now →

Course Details

This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time through macros, data validation, and more. This class is a segue into our more focused courses for individual advanced Excel topics.  

Prerequisites: The course requires that you have successfully completed Excel I and II (or had more than six months using the software and are familiar with the concepts presented in Excel I and II).

Contents:

• Logical functions 
• Conditional functions 
• Financial functions 
• Text functions 
• Date functions 
• Lookup functions 
• Data Validation 
• PivotTables 
• Running and recording a macro 

Note: This course will be taught using the windows operating system environment

Ready to Advance Your Career?

Join professionals across the Carolinas who trust Catapult for professional development.

Register Now →