Excel Advanced Functions and Formulas
O365/2021/2019/2016
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.
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 IFS
- 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