Excel Advanced Functions and Formulas
This course is designed for office users who would like to focus on Excel advanced functions and formulas for intricate calculations or worksheet setup. If you have a good working experience of Excel but wish to set up a more complex worksheet, this course is for you. Those who are totally new to Excel should take our Excel Beginner & Intermediate courses first.
Prerequisites: Skills learned in our Excel Beginner & Intermediate courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Software Version: Microsoft Excel 2013/2016/2019/O365
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Advanced Functions and Formulas
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements
Course Outline
What is covered in the course?
- Linking several worksheets to create a summary
- Working with Structured References
- Linking several workbooks to create a summary
- Working with Array Formulas
- Function IF nested
- Function AND nested
- Function OR nested
- Function NOT
- Function OFFSET
- Function INDIRECT
- Function SUMIFS
- Function COUNTIFS
- Database Function DSUM
- Database Function DCOUNT
- Database Function DAVERAGE