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:20260330T083000
DTEND;TZID=America/Regina:20260330T120000
DTSTAMP:20260309T212309Z
CREATED:20260227T234347Z
LAST-MODIFIED:20260309T212309Z
UID:10000075-1774859400-1774872000@blackatlastraining.com
SUMMARY:Microsoft Excel: Data Analysis With PivotTables
DESCRIPTION:Microsoft Excel: Data Analysis With PivotTables				\n				\n				\n				\n					\n		\n	Mar 30\, 2026 @ 8:30am to 12:00pm	\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					This event has passed. \n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 0.5 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									Advances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze\, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. 								\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\nPreparing Data and Creating PivotTables\n\n\n\nPrepare Data\n\n\n\nCreate a PivotTable from a Local Data Source\n\n\n\nCreate a PivotTable from Multiple Local Data Sources\n\n\n\nCreate a PivotTable from an External Data Source\n\n\n02\nAnalyzing Data by Using PivotTables\n\n\n\nSummarize PivotTable Data\n\n\n\nOrganize PivotTable Data\n\n\n\nFilter PivotTable Data\n\n\n\nFormat a PivotTable\n\n\n\nRefresh and Change PivotTable Data\n\n\n03\nWorking with PivotCharts\n\n\n\nCreate a PivotChart\n\n\n\nManipulate PivotChart Data\n\n\n\nFormat a PivotChart\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									Not applicable. 								\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. What version of Microsoft 365 does this course prepare me for?\n\n\n\nThis course assumes that you have a Microsoft 365 Business subscription. If you are using a home version\, please be aware that there may be discrepancies between the features demonstrated in the course and those available in your version. \nYou can review the different subscription plans by clicking here. \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		Seats are no longer available
URL:https://blackatlastraining.com/calendar/2026-03-30-microsoft-excel-data-analysis-with-pivottables/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Excel: Data Analysis With PivotTables,Microsoft Office
ORGANIZER;CN="Black Atlas Training":MAILTO:hello@blackatlastraining.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Regina:20260227T083000
DTEND;TZID=America/Regina:20260227T120000
DTSTAMP:20260119T043339Z
CREATED:20251116T032124Z
LAST-MODIFIED:20260119T043339Z
UID:10000029-1772181000-1772193600@blackatlastraining.com
SUMMARY:Microsoft Excel: Data Analysis With PivotTables
DESCRIPTION:Microsoft Excel: Data Analysis With PivotTables				\n				\n				\n				\n					\n		\n	Mar 30\, 2026 @ 8:30am to 12:00pm	\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					This event has passed. \n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 0.5 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									Advances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze\, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. 								\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\nPreparing Data and Creating PivotTables\n\n\n\nPrepare Data\n\n\n\nCreate a PivotTable from a Local Data Source\n\n\n\nCreate a PivotTable from Multiple Local Data Sources\n\n\n\nCreate a PivotTable from an External Data Source\n\n\n02\nAnalyzing Data by Using PivotTables\n\n\n\nSummarize PivotTable Data\n\n\n\nOrganize PivotTable Data\n\n\n\nFilter PivotTable Data\n\n\n\nFormat a PivotTable\n\n\n\nRefresh and Change PivotTable Data\n\n\n03\nWorking with PivotCharts\n\n\n\nCreate a PivotChart\n\n\n\nManipulate PivotChart Data\n\n\n\nFormat a PivotChart\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									Not applicable. 								\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. What version of Microsoft 365 does this course prepare me for?\n\n\n\nThis course assumes that you have a Microsoft 365 Business subscription. If you are using a home version\, please be aware that there may be discrepancies between the features demonstrated in the course and those available in your version. \nYou can review the different subscription plans by clicking here. \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		Seats are no longer available
URL:https://blackatlastraining.com/calendar/2026-02-27-microsoft-excel-data-analysis-with-pivottables/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Excel: Data Analysis With PivotTables,Microsoft Office
END:VEVENT
END:VCALENDAR