
Microsoft excel class boston intermediate manual#
Each student will also receive a full course manual with tips, tricks and shortcuts as well as sample and exercise files. During this hands-on course, students will practice their skills and have the opportunity to ask questions and interact with the instructor. Students will also create pivot tables to summarize list or database data and will create simple macros to automate repetitive tasks.

Using Excel data, charts will be generated and formatted and then a chart template will be created to save time. Students will review strategies to manage list or database data using filtering, sorting, subtotalling and validations. Links will be created and managed between worksheets, workbooks and other programs. Students will learn shortcuts to enter common functions as well as Excel key concepts and then move on to powerful conditional functions and tools including IF, SUMIF, COUNTIF, VLOOKUP and conditional formatting. This Microsoft Excel course is designed for users who want to move to the next level and focus on core competencies in Excel. Contact us at more information including savings for custom group training.

Some courses are also held at an alternate downtown Toronto location.Ĭustom training: This course may be delivered at your site or ours as an instructor-led virtual classroom or in-person solution. In-person classroom courses: Our instructor-led, live classroom (in-person) courses are held in downtown Toronto at 18 King Street East, Suite 1400, Toronto, Ontario, Canada. Students will be sent a virtual classroom invitation prior to the course. Virtual classroom courses: Our instructor-led virtual classroom courses are delivered in a virtual classroom environment. Timing: Public scheduled courses run from 9:00 am to 4:00 pm (Eastern Time). Microsoft ® Excel ® Versions: 2013 | 2016 | 2019 | 2021 | 365 (Windows)ĭelivery Methods (Instructor-led): In-person (Live classroom) | Virtual classroomĬourse Dates: June 13/14, 2023 (Virtual classroom or In-person) | July 19/20, 2023 (Virtual classroom or In-person) | View scheduleĬourse Fee: $495 CAD per person + HST (Virtual classroom), $545 CAD per person + HST (Bring your own device for in-person courses) or $595 CAD per person + HST (Avantix Learning provides device for in-person courses)*
Microsoft excel class boston intermediate series#
Microsoft Excel: Intermediate / Advanced Microsoft Excel Training Series | Level 2 Course Details
