 |
Excel Workbooks, Formulas and Functions Onsite Group Training Course |
Course Description: The Excel 365 Workbooks, Formulas and Functions course is perfect for those who are responsible for managing and creating large worksheets and models in Excel and have Excel Introduction skills mastered.
The following topics will be covered in this course:
- Viewing, Renaming, and Color-coding Worksheets
- Using 3-D References
- Creating and Using an Absolute Named Range
- Using Financial Functions
- Creating a Forecast Sheet
- Protecting Workbooks and Worksheets
- Creating Scenarios
- Using Table Lookup Functions (VLookup & HLookup).
- Discuss your team's educational needs with a BCS representative.
- Schedule class date(s) that fit your team's availabilty.
- Professional Trainer will conduct the class at your facility or online.
- We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
- You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
- Usually a two-week lead time to schedule a class.
- Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
- 1 Hour Lunch Break, and Two 15-minute Break
- A Professional Instructor will come to your office and train your students
- Up to 6 students can attend the class for the flat rate course price of $1800/day
- Additional students can be added for $125/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
- A Professional Instructor will come to your office and train your students
- Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
- Additional students can be added for $100/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
- A Professional Instructor will come to your office and train your students
- Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
- Additional students can be added for $75/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Excel Workbooks, Formulas and Functions - Course Syllabus
Warning: include(oisyllabus/onlc-excel19-4.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(oisyllabus/onlc-excel19-4.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(): Failed opening 'oisyllabus/onlc-excel19-4.php.php' for inclusion (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
How On-Site Training Works
How On-Site Training Works
On-Site excel Training Packages
Small Group Package (up to 6 students)
Total Cost for 6 students: $1800/day (Flat Rate)
Medium Group Package (up to 12 students)
Total Cost for 12 students: $2500/day (Flat Rate)
Large Group Package (up to 18 students)
Total Cost for 18 students: $3100/day (Flat Rate)
Related On-Site Training Courses
excel Self Paced On-Demand Courses
On-Site Training Request
Please complete the information request form below, and one of our representatives will contact you within one business day.
"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)
