BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Black Atlas Training - ECPv6.17.4//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Black Atlas Training
X-ORIGINAL-URL:https://blackatlastraining.com
X-WR-CALDESC:Events for Black Atlas Training
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Regina
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Regina:20260911T083000
DTEND;TZID=America/Regina:20260911T163000
DTSTAMP:20260704T200237Z
CREATED:20260704T200100Z
LAST-MODIFIED:20260704T200237Z
UID:10000171-1789115400-1789144200@blackatlastraining.com
SUMMARY:Microsoft Excel: Advanced
DESCRIPTION:Microsoft Excel: Advanced				\n				\n				\n				\n					\n		\n	Nov 19\, 2026 @ 8:30am to 4:30pm	\n\n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n																														\n				\n				\n				\n							\n						\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 1 Day\nDifficulty: Advanced								\n				\n				\n				\n					Join us for this course\nRegister Now				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n					Course Overview				\n				\n				\n				\n									Clearly\, you use Excel a lot in your role. Otherwise\, you wouldn’t be interested in this course. By now\, you’re already familiar with Microsoft Office Excel\, its functions and formulas\, a lot of its features and functionality\, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently\, work in collaboration with others to deliver actionable organizational intelligence\, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration\, you have also likely encountered your fair share of issues and challenges. You’re too busy\, though\, to waste time scouring over workbooks to resolve issues or to perform repetitive\, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do. This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel Novice and Microsoft Office Excel Intermediate courses to help you get the most of your Excel experience. The ability to collaborate with colleagues\, automate complex or repetitive tasks\, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you\, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. 								\n				\n				\n				\n					Prerequisites				\n				\n				\n				\n									You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice and Excel Intermediate. 								\n				\n				\n				\n					What You Will Learn				\n				\n				\n				\n					\n\n01\nWorking with Multiple Worksheets and Workbooks\n\n\n\nUse Links and External References\n\n\n\nUse 3-D References\n\n\n\nConsolidate Data\n\n\n02\nSharing and Protecting Workbooks\n\n\n\nCollaborate on a Workbook\n\n\n\nProtect Worksheets and Workbooks\n\n\n03\nAutomating Workbook Functionality\n\n\n\nApply Data Validation\n\n\n\nSearch for Invalid Data and Formulas with Errors\n\n\n\nWork with Macros\n\n\n04\nUsing Lookup Functions\, Dynamic Arrays\, and Formula Auditing\n\n\n\nUse Lookup Functions\n\n\n\nUse Dynamic Arrays and Dynamic Array Functions\n\n\n\nTrace Cells\n\n\n\nWatch and Evaluate Formulas\n\n\n05\nForecasting Data\n\n\n\nDetermine Potential Outcomes Using Data Tables\n\n\n\nDetermine Potential Outcomes Using Scenarios\n\n\n\nUse the Goal Seek Feature\n\n\n\nForecast Data Trends\n\n\n06\nCreating Sparklines and Mapping Data\n\n\n\nCreate Sparklines\n\n\n\nMap Data\n\n				\n				\n				\n				\n					Included With The Course				\n				\n				\n				\n					\n\n\nProfessional textbook (physical and digital)\n\n\n\nUnused copy of any files referenced throughout the textbook.\n\n\n\nCertificate of completion signed by the instructor.\n\n				\n				\n				\n				\n					Associated Certifications				\n				\n				\n				\n									This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate: Exam MO-200 and Excel Expert: Exam MO-201 certifications. 								\n				\n				\n				\n					Frequently Asked Questions				\n				\n				\n				\n									We understand that you may have questions\, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page\, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority\, and we’re committed to making sure you have all the information necessary for a seamless experience. 								\n				\n				\n				\n					\n\n\n\n01. I use Excel everyday\, should I still start with the Excel Novice course?\n\n\nWe strongly recommend starting at the Novice course. Even students who are already proficient with Excel often discover new techniques and time-saving shortcuts that enhance their workflow. However\, if you review the course outline above and feel confident in your understanding of all the topics covered\, you may be well-prepared to begin with the Intermediate course.\n\n\n\n\n				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n					Registration				\n				\n				\n				\n									Use the registration form below to register attendees for this course. Once you are registered we will be in touch to coordinate payment. We look forward to seeing you! 								\n				\n				\n				\n							\n	\n\n		\n		\n		\n\n		\n\n\n		\n\n\n\n	Seats\n\n		\n	\n	\n		The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.	\n\n\n		\n\n	\n		\n				Microsoft Excel: Advanced	\n\n\n\n	\n		\n		\n				\n					$\n					395.00\n				\n						\n\n\n	\n\n\n	\n	\n\n\n	\n\n\n	\n						\n	Decrease ticket quantity for Microsoft Excel: Advanced\n	-\n				\n\n	\n		Quantity	\n	\n\n					\n	Increase ticket quantity for Microsoft Excel: Advanced\n	+\n			\n\n	\n		\n	\n\n\n		\n\n	\n	\n	\n		Seats:	\n	0\n\n\n	\n	\n		Total:	\n	\n		\n				\n					$\n					0.00\n				\n				\n\n\n	\n	Reserve Seat(s)
URL:https://blackatlastraining.com/calendar/2026-09-11-microsoft-excel-advanced/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Excel: Advanced,Microsoft Office
ORGANIZER;CN="Black Atlas Training":MAILTO:hello@blackatlastraining.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Regina:20261007T083000
DTEND;TZID=America/Regina:20261007T163000
DTSTAMP:20260821T004212Z
CREATED:20260818T132947Z
LAST-MODIFIED:20260821T004212Z
UID:10000188-1791361800-1791390600@blackatlastraining.com
SUMMARY:Microsoft Excel: Advanced
DESCRIPTION:Microsoft Excel: Advanced				\n				\n				\n				\n					\n		\n	Nov 19\, 2026 @ 8:30am to 4:30pm	\n\n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n																														\n				\n				\n				\n							\n						\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 1 Day\nDifficulty: Advanced								\n				\n				\n				\n					Join us for this course\nRegister Now				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n					Course Overview				\n				\n				\n				\n									Clearly\, you use Excel a lot in your role. Otherwise\, you wouldn’t be interested in this course. By now\, you’re already familiar with Microsoft Office Excel\, its functions and formulas\, a lot of its features and functionality\, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently\, work in collaboration with others to deliver actionable organizational intelligence\, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration\, you have also likely encountered your fair share of issues and challenges. You’re too busy\, though\, to waste time scouring over workbooks to resolve issues or to perform repetitive\, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do. This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel Novice and Microsoft Office Excel Intermediate courses to help you get the most of your Excel experience. The ability to collaborate with colleagues\, automate complex or repetitive tasks\, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you\, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. 								\n				\n				\n				\n					Prerequisites				\n				\n				\n				\n									You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice and Excel Intermediate. 								\n				\n				\n				\n					What You Will Learn				\n				\n				\n				\n					\n\n01\nWorking with Multiple Worksheets and Workbooks\n\n\n\nUse Links and External References\n\n\n\nUse 3-D References\n\n\n\nConsolidate Data\n\n\n02\nSharing and Protecting Workbooks\n\n\n\nCollaborate on a Workbook\n\n\n\nProtect Worksheets and Workbooks\n\n\n03\nAutomating Workbook Functionality\n\n\n\nApply Data Validation\n\n\n\nSearch for Invalid Data and Formulas with Errors\n\n\n\nWork with Macros\n\n\n04\nUsing Lookup Functions\, Dynamic Arrays\, and Formula Auditing\n\n\n\nUse Lookup Functions\n\n\n\nUse Dynamic Arrays and Dynamic Array Functions\n\n\n\nTrace Cells\n\n\n\nWatch and Evaluate Formulas\n\n\n05\nForecasting Data\n\n\n\nDetermine Potential Outcomes Using Data Tables\n\n\n\nDetermine Potential Outcomes Using Scenarios\n\n\n\nUse the Goal Seek Feature\n\n\n\nForecast Data Trends\n\n\n06\nCreating Sparklines and Mapping Data\n\n\n\nCreate Sparklines\n\n\n\nMap Data\n\n				\n				\n				\n				\n					Included With The Course				\n				\n				\n				\n					\n\n\nProfessional textbook (physical and digital)\n\n\n\nUnused copy of any files referenced throughout the textbook.\n\n\n\nCertificate of completion signed by the instructor.\n\n				\n				\n				\n				\n					Associated Certifications				\n				\n				\n				\n									This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate: Exam MO-200 and Excel Expert: Exam MO-201 certifications. 								\n				\n				\n				\n					Frequently Asked Questions				\n				\n				\n				\n									We understand that you may have questions\, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page\, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority\, and we’re committed to making sure you have all the information necessary for a seamless experience. 								\n				\n				\n				\n					\n\n\n\n01. I use Excel everyday\, should I still start with the Excel Novice course?\n\n\nWe strongly recommend starting at the Novice course. Even students who are already proficient with Excel often discover new techniques and time-saving shortcuts that enhance their workflow. However\, if you review the course outline above and feel confident in your understanding of all the topics covered\, you may be well-prepared to begin with the Intermediate course.\n\n\n\n\n				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n					Registration				\n				\n				\n				\n									Use the registration form below to register attendees for this course. Once you are registered we will be in touch to coordinate payment. We look forward to seeing you! 								\n				\n				\n				\n							\n	\n\n		\n		\n		\n\n		\n\n\n		\n\n\n\n	Seats\n\n		\n	\n	\n		The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.	\n\n\n		\n\n	\n		\n				Microsoft Excel: Advanced	\n\n\n\n	\n		\n		\n				\n					$\n					395.00\n				\n						\n\n\n	\n\n\n	\n	\n\n\n	\n\n\n	\n						\n	Decrease ticket quantity for Microsoft Excel: Advanced\n	-\n				\n\n	\n		Quantity	\n	\n\n					\n	Increase ticket quantity for Microsoft Excel: Advanced\n	+\n			\n\n	\n		\n	\n\n\n		\n\n	\n	\n	\n		Seats:	\n	0\n\n\n	\n	\n		Total:	\n	\n		\n				\n					$\n					0.00\n				\n				\n\n\n	\n	Reserve Seat(s)
URL:https://blackatlastraining.com/calendar/2026-10-07-microsoft-excel-advanced/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Excel: Advanced,Microsoft Office
ORGANIZER;CN="Black Atlas Training":MAILTO:hello@blackatlastraining.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Regina:20261119T083000
DTEND;TZID=America/Regina:20261119T163000
DTSTAMP:20260819T134140Z
CREATED:20260819T134019Z
LAST-MODIFIED:20260819T134140Z
UID:10000191-1795077000-1795105800@blackatlastraining.com
SUMMARY:Microsoft Excel: Advanced
DESCRIPTION:Microsoft Excel: Advanced				\n				\n				\n				\n					\n		\n	Nov 19\, 2026 @ 8:30am to 4:30pm	\n\n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n																														\n				\n				\n				\n							\n						\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 1 Day\nDifficulty: Advanced								\n				\n				\n				\n					Join us for this course\nRegister Now				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n					Course Overview				\n				\n				\n				\n									Clearly\, you use Excel a lot in your role. Otherwise\, you wouldn’t be interested in this course. By now\, you’re already familiar with Microsoft Office Excel\, its functions and formulas\, a lot of its features and functionality\, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently\, work in collaboration with others to deliver actionable organizational intelligence\, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration\, you have also likely encountered your fair share of issues and challenges. You’re too busy\, though\, to waste time scouring over workbooks to resolve issues or to perform repetitive\, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do. This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel Novice and Microsoft Office Excel Intermediate courses to help you get the most of your Excel experience. The ability to collaborate with colleagues\, automate complex or repetitive tasks\, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you\, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. 								\n				\n				\n				\n					Prerequisites				\n				\n				\n				\n									You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice and Excel Intermediate. 								\n				\n				\n				\n					What You Will Learn				\n				\n				\n				\n					\n\n01\nWorking with Multiple Worksheets and Workbooks\n\n\n\nUse Links and External References\n\n\n\nUse 3-D References\n\n\n\nConsolidate Data\n\n\n02\nSharing and Protecting Workbooks\n\n\n\nCollaborate on a Workbook\n\n\n\nProtect Worksheets and Workbooks\n\n\n03\nAutomating Workbook Functionality\n\n\n\nApply Data Validation\n\n\n\nSearch for Invalid Data and Formulas with Errors\n\n\n\nWork with Macros\n\n\n04\nUsing Lookup Functions\, Dynamic Arrays\, and Formula Auditing\n\n\n\nUse Lookup Functions\n\n\n\nUse Dynamic Arrays and Dynamic Array Functions\n\n\n\nTrace Cells\n\n\n\nWatch and Evaluate Formulas\n\n\n05\nForecasting Data\n\n\n\nDetermine Potential Outcomes Using Data Tables\n\n\n\nDetermine Potential Outcomes Using Scenarios\n\n\n\nUse the Goal Seek Feature\n\n\n\nForecast Data Trends\n\n\n06\nCreating Sparklines and Mapping Data\n\n\n\nCreate Sparklines\n\n\n\nMap Data\n\n				\n				\n				\n				\n					Included With The Course				\n				\n				\n				\n					\n\n\nProfessional textbook (physical and digital)\n\n\n\nUnused copy of any files referenced throughout the textbook.\n\n\n\nCertificate of completion signed by the instructor.\n\n				\n				\n				\n				\n					Associated Certifications				\n				\n				\n				\n									This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate: Exam MO-200 and Excel Expert: Exam MO-201 certifications. 								\n				\n				\n				\n					Frequently Asked Questions				\n				\n				\n				\n									We understand that you may have questions\, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page\, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority\, and we’re committed to making sure you have all the information necessary for a seamless experience. 								\n				\n				\n				\n					\n\n\n\n01. I use Excel everyday\, should I still start with the Excel Novice course?\n\n\nWe strongly recommend starting at the Novice course. Even students who are already proficient with Excel often discover new techniques and time-saving shortcuts that enhance their workflow. However\, if you review the course outline above and feel confident in your understanding of all the topics covered\, you may be well-prepared to begin with the Intermediate course.\n\n\n\n\n				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n					Registration				\n				\n				\n				\n									Use the registration form below to register attendees for this course. Once you are registered we will be in touch to coordinate payment. We look forward to seeing you! 								\n				\n				\n				\n							\n	\n\n		\n		\n		\n\n		\n\n\n		\n\n\n\n	Seats\n\n		\n	\n	\n		The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.	\n\n\n		\n\n	\n		\n				Microsoft Excel: Advanced	\n\n\n\n	\n		\n		\n				\n					$\n					395.00\n				\n						\n\n\n	\n\n\n	\n	\n\n\n	\n\n\n	\n						\n	Decrease ticket quantity for Microsoft Excel: Advanced\n	-\n				\n\n	\n		Quantity	\n	\n\n					\n	Increase ticket quantity for Microsoft Excel: Advanced\n	+\n			\n\n	\n		\n	\n\n\n		\n\n	\n	\n	\n		Seats:	\n	0\n\n\n	\n	\n		Total:	\n	\n		\n				\n					$\n					0.00\n				\n				\n\n\n	\n	Reserve Seat(s)
URL:https://blackatlastraining.com/calendar/2026-11-19-microsoft-excel-advanced/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Excel: Advanced,Microsoft Office
ORGANIZER;CN="Black Atlas Training":MAILTO:hello@blackatlastraining.com
END:VEVENT
END:VCALENDAR