BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Mechanical Contractors Association of Kansas City - ECPv6.17.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Mechanical Contractors Association of Kansas City
X-ORIGINAL-URL:https://mcakc.org
X-WR-CALDESC:Events for Mechanical Contractors Association of Kansas City
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20250309T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20251102T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20260308T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20261101T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20270314T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20271107T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260813T133000
DTEND;TZID=UTC:20260813T160000
DTSTAMP:20260812T225831Z
CREATED:20260606T062447Z
LAST-MODIFIED:20260812T225831Z
UID:10000294-1786627800-1786636800@mcakc.org
SUMMARY:Kansas Sales & Compensating Use Tax for Construction Contractors
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Signatory Contractors and Associate Member companies may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n \nThis presentation by the Kansas Department of Revenue specifically targets construction contractors and subcontractors.  The workshop covers how sales tax applies  to materials and labor\, project exemption certificates\, sales tax returns\, and billing. \nCost: FREE to employees of Signatory Contractors and Associate Members. \nThis seminar has been approved by the Contractor Licensing Review Board of Johnson County.\nApproved for: ‘Non-Code’ Credit. \nCEU: 0.25\n \n \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/kansas-sales-compensating-use-tax-for-construction-contractors-jccc-4/
LOCATION:12345 College Blvd.\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20260828T080000
DTEND;TZID=America/Chicago:20260828T170000
DTSTAMP:20260812T225830Z
CREATED:20260629T143540Z
LAST-MODIFIED:20260812T225830Z
UID:10000321-1787904000-1787936400@mcakc.org
SUMMARY:Excel Fundamentals - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nStart your adventure with tools and features of Microsoft Excel. Upon completion you can enter\, edit and format data. Manage workbooks\, link worksheets and create basic functions to calculate data. Design and edit charts. Organize large amounts of data with freeze panes\, sorting and data filtering tools. Introduction to Microsoft Office – Common features in Microsoft Office Apps \nTopics Covered include:\n \n\nIntroduction to Excel Worksheets – Entering and Editing Data\, Formatting Cells\, Numbers and Dates\, Autofill\, Navigation Methods\nRearranging Data – Working with Rows\, Cells and Columns\nManaging Multiple Worksheets – Insert and Delete\, Cell Reference\, Edit Multiple Sheets and One Time\nFunctions in Formulas – AutoSum\, SUM\, AVERAGE\, COUNT\, MAX and MIN\nData Visualization and Images – Create\, Edit using Chart Tools\, Add Images\nOrganizing Large Amounts of Data – Sorting\, Filters\, Freeze Panes\n\nInstructor:  \nCary Short \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-fundamentals-jccc-3/
LOCATION:RC\, Regnier Center\, 250\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20260917T133000
DTEND;TZID=America/Chicago:20260917T160000
DTSTAMP:20260812T225829Z
CREATED:20260629T143539Z
LAST-MODIFIED:20260812T225829Z
UID:10000320-1789651800-1789660800@mcakc.org
SUMMARY:Kansas Sales & Compensating Use Tax for Construction Contractors
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Signatory Contractors and Associate Member companies may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n \nThis presentation by the Kansas Department of Revenue specifically targets construction contractors and subcontractors.  The workshop covers how sales tax applies  to materials and labor\, project exemption certificates\, sales tax returns\, and billing. \nCost: FREE to employees of Signatory Contractors and Associate Members. \nThis seminar has been approved by the Contractor Licensing Review Board of Johnson County.\nApproved for: ‘Non-Code’ Credit. \nCEU: 0.25 \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/kansas-sales-compensating-use-tax-for-construction-contractors-3/
LOCATION:12345 College Blvd.\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20260921T173000
DTEND;TZID=America/Chicago:20260923T210000
DTSTAMP:20260812T225829Z
CREATED:20260629T143539Z
LAST-MODIFIED:20260812T225829Z
UID:10000319-1790011800-1790197200@mcakc.org
SUMMARY:Excel Fundamentals - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nSeptember 21 & 23\, 2026\n5:30 PM – 9:00 PM \nStart your adventure with tools and features of Microsoft Excel. Upon completion you can enter\, edit and format data. Manage workbooks\, link worksheets and create basic functions to calculate data. Design and edit charts. Organize large amounts of data with freeze panes\, sorting and data filtering tools. Introduction to Microsoft Office – Common features in Microsoft Office Apps \nTopics Covered include:\n \n\nIntroduction to Excel Worksheets – Entering and Editing Data\, Formatting Cells\, Numbers and Dates\, Autofill\, Navigation Methods\nRearranging Data – Working with Rows\, Cells and Columns\nManaging Multiple Worksheets – Insert and Delete\, Cell Reference\, Edit Multiple Sheets and One Time\nFunctions in Formulas – AutoSum\, SUM\, AVERAGE\, COUNT\, MAX and MIN\nData Visualization and Images – Create\, Edit using Chart Tools\, Add Images\nOrganizing Large Amounts of Data – Sorting\, Filters\, Freeze Panes\n\nInstructor:  \nCary Short \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-fundamentals-jccc-2/
LOCATION:RC\, Regnier Center\, 250\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20261016T080000
DTEND;TZID=America/Chicago:20261016T170000
DTSTAMP:20260812T225828Z
CREATED:20260629T143538Z
LAST-MODIFIED:20260812T225828Z
UID:10000313-1792137600-1792170000@mcakc.org
SUMMARY:Excel Fundamentals - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nGet ready for interactive learning. Focus on complex examples from the textbook to reinforce your skills. You’ll have access to additional exercises to use on your own for practice or certification prep. Expand your Excel knowledge with an in-depth look at conditional formatting\, analysis functions\, vlookup\, outlines\, and subtotals. \nMeets Core and Expert objectives to complete Microsoft Office Specialist Certification. For questions about voucher purchase and certification exams\, contact Regnier Testing Center on JCCC main campus. \nPrerequisite: Excel Fundamentals or the ability to create a basic formula on your own \nnstructor: Cary Short \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-fundamentals-jccc/
LOCATION:RC\, Regnier Center\, 250\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20261016T080000
DTEND;TZID=America/Chicago:20261016T170000
DTSTAMP:20260812T225832Z
CREATED:20260730T110119Z
LAST-MODIFIED:20260812T225832Z
UID:10000329-1792137600-1792170000@mcakc.org
SUMMARY:Excel Intermediate - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nOctober 16\, 2026\n8:00 AM – 5:00 PM \nGet ready for interactive learning. Focus on complex examples from the textbook to reinforce your skills. You’ll have access to additional exercises to use on your own for practice or certification prep. Expand your Excel knowledge with an in-depth look at conditional formatting\, analysis functions\, vlookup\, outlines\, and subtotals. \nMeets Core and Expert objectives to complete Microsoft Office Specialist Certification. For questions about voucher purchase and certification exams\, contact Regnier Testing Center on JCCC main campus. \nPrerequisite: Excel Fundamentals or the ability to create a basic formula on your own \nInstructor: Cary Short \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-intermediate-jccc/
LOCATION:RC\, Regnier Center\, 250\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20261020T133000
DTEND;TZID=America/Chicago:20261020T160000
DTSTAMP:20260812T225827Z
CREATED:20260629T143537Z
LAST-MODIFIED:20260812T225827Z
UID:10000312-1792503000-1792512000@mcakc.org
SUMMARY:Kansas Sales & Compensating Use Tax for Construction Contractors
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Signatory Contractors and Associate Member companies may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n \nThis presentation by the Kansas Department of Revenue specifically targets construction contractors and subcontractors.  The workshop covers how sales tax applies  to materials and labor\, project exemption certificates\, sales tax returns\, and billing. \nCost: FREE to employees of Signatory Contractors and Associate Members. \nThis seminar has been approved by the Contractor Licensing Review Board of Johnson County.\nApproved for: ‘Non-Code’ Credit. \nCEU: 0.25 \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/kansas-sales-compensating-use-tax-for-construction-contractors-2/
LOCATION:12345 College Blvd.\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20261026T173000
DTEND;TZID=America/Chicago:20261028T210000
DTSTAMP:20260812T225827Z
CREATED:20260629T143537Z
LAST-MODIFIED:20260812T225827Z
UID:10000310-1793035800-1793221200@mcakc.org
SUMMARY:Excel Fundamentals - Live Online - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nLive Online\nOctober 26 & 28\, 2026 \n5:30 PM – 9:00 PM \nStart your adventure with tools and features of Microsoft Excel. Upon completion you can enter\, edit and format data. Manage workbooks\, link worksheets and create basic functions to calculate data. Design and edit charts. Organize large amounts of data with freeze panes\, sorting and data filtering tools. Introduction to Microsoft Office – Common features in Microsoft Office Apps \nTopics Covered include:\n \n\nIntroduction to Excel Worksheets – Entering and Editing Data\, Formatting Cells\, Numbers and Dates\, Autofill\, Navigation Methods\nRearranging Data – Working with Rows\, Cells and Columns\nManaging Multiple Worksheets – Insert and Delete\, Cell Reference\, Edit Multiple Sheets and One Time\nFunctions in Formulas – AutoSum\, SUM\, AVERAGE\, COUNT\, MAX and MIN\nData Visualization and Images – Create\, Edit using Chart Tools\, Add Images\nOrganizing Large Amounts of Data – Sorting\, Filters\, Freeze Panes\n\nInstructor:  \nSteve Hultgren \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-fundamentals-live-online-jccc-2/
LOCATION:Live Online\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20261113T080000
DTEND;TZID=America/Chicago:20261113T170000
DTSTAMP:20260812T225832Z
CREATED:20260730T110119Z
LAST-MODIFIED:20260812T225832Z
UID:10000328-1794556800-1794589200@mcakc.org
SUMMARY:Excel Advanced - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nNovember 13\, 2026\n8:00 AM – 5:00 PM \nNot your typical course! Focus on complex examples from your textbook to reinforce your skills. You’ll have access to additional exercises to use on your own for practice or certification prep. Dive into tables\, pivot tables\, pivot charts\, macros\, and data management. \nPrerequisite: Excel Fundamentals or equivalent experience \nInstructor: Cary Short \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-advanced-jccc/
LOCATION:RC\, Regnier Center\, 250\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261116T173000
DTEND;TZID=UTC:20261118T210000
DTSTAMP:20260812T225826Z
CREATED:20260618T160051Z
LAST-MODIFIED:20260812T225826Z
UID:10000303-1794850200-1795035600@mcakc.org
SUMMARY:Excel Fundamentals - Live Online - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nLive Online\nNovember 16 & 18\, 2026 \n5:30 PM – 9:00 PM \nStart your adventure with tools and features of Microsoft Excel. Upon completion you can enter\, edit and format data. Manage workbooks\, link worksheets and create basic functions to calculate data. Design and edit charts. Organize large amounts of data with freeze panes\, sorting and data filtering tools. Introduction to Microsoft Office – Common features in Microsoft Office Apps \nTopics Covered include:\n \n\nIntroduction to Excel Worksheets – Entering and Editing Data\, Formatting Cells\, Numbers and Dates\, Autofill\, Navigation Methods\nRearranging Data – Working with Rows\, Cells and Columns\nManaging Multiple Worksheets – Insert and Delete\, Cell Reference\, Edit Multiple Sheets and One Time\nFunctions in Formulas – AutoSum\, SUM\, AVERAGE\, COUNT\, MAX and MIN\nData Visualization and Images – Create\, Edit using Chart Tools\, Add Images\nOrganizing Large Amounts of Data – Sorting\, Filters\, Freeze Panes\n\nInstructor:  \nSteve Hultgren \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-fundamentals-live-online-jccc/
LOCATION:Live Online\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261130T073000
DTEND;TZID=UTC:20261202T210000
DTSTAMP:20260812T225826Z
CREATED:20260618T160051Z
LAST-MODIFIED:20260812T225826Z
UID:10000302-1796023800-1796245200@mcakc.org
SUMMARY:Excel Intermediate - Live Online - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nLive Online\nNovember 30 & December 2\, 2026 \n5:30 PM – 9:00 PM \nGet ready for interactive learning. Focus on complex examples from the textbook to reinforce your skills. You’ll have access to additional exercises to use on your own for practice or certification prep. Expand your Excel knowledge with an in-depth look at conditional formatting\, analysis functions\, vlookup\, outlines\, and subtotals. \nMeets Core and Expert objectives to complete Microsoft Office Specialist Certification. For questions about voucher purchase and certification exams\, contact Regnier Testing Center on JCCC main campus. \nPrerequisite: Excel Fundamentals or the ability to create a basic formula on your own \nInstructor: Steve Hultgren \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-intermediate-live-online-jccc/
LOCATION:Live Online\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261201T180000
DTEND;TZID=UTC:20261210T210000
DTSTAMP:20260812T225826Z
CREATED:20260426T064849Z
LAST-MODIFIED:20260812T225826Z
UID:10000288-1796148000-1796936400@mcakc.org
SUMMARY:Bluebeam Live Online
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Signatory Contractors and Associate Member companies may attend this course at a discounted rate through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n \nDecember 1 – 10\, 2026\nTuesdays & Thursdays (4 evening sessions)\n6:00 – 9:00 pm \nStart with managing the User Interface to discover the powerful redline and markup capabilities housed within Bluebeam Revu\, including Revu’s cloud-based collaboration functionality\, Bluebeam Studio. Learn from a local industry professional with real-world examples of how Bluebeam has been used by local firms\, big and small\, to save time\, money\, and errors. \nCourseware: If you are using a Mac or do not have Bluebeam\, you will receive instructions for access to a virtual software program where you can participate in class without having a Bluebeam account. \nThis is a component of the Design and Modeling Essentials for 2D and 3D Certificate. \nCost:\n$150 for employees of MCAKC Member Contractors Signatory to Locals 8 & 533.\n$250 for Non-Members Signatory to Locals 8 & 533.\n$250 for Associate Members. \nThis seminar will cover the following topics: \n \n\n1. Introduction\, Profiles\, and User Interface\n\nIntroduction to Bluebeam\nBluebeam Company\nBluebeam Administrator & Preferences\nAdministrative Functions\nProfiles\nDocument Navigation\n\n2. Tools\, Redlining\, and Estimating\n\nTools\nTool Chest\nTool Sets\nMarkup List\nEstimating and Measuring Tools\n\n3. Bluebeam Studio & PDF Layering\n\nStudio Sessions\nStudio Projects\nStudio Prime & Studio API\nLayers\nSpaces\nDocument Comparisons\n\n4. Document Management\, 3D PDF\, and Forms\n\nBatch Functions\nDigital Slip Sheeting\nSets\nTags\n3D PDF\nPDF Forms\n\nCEU: 1.2 \nInstructor: Doug Duncan \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/bluebeam-live-online-jccc/
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261207T173000
DTEND;TZID=UTC:20261209T210000
DTSTAMP:20260812T225825Z
CREATED:20260618T160051Z
LAST-MODIFIED:20260812T225825Z
UID:10000301-1796664600-1796850000@mcakc.org
SUMMARY:Excel Advanced - Live Online - JCCC
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Member Contractors Signatory to Locals 8 & 533 may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n\nLive Online\nDecember 7 & 9\, 2026 \n5:30 PM – 9:00 PM \nNot your typical course! Focus on complex examples from your textbook to reinforce your skills. You’ll have access to additional exercises to use on your own for practice or certification prep. Dive into tables\, pivot tables\, pivot charts\, macros\, and data management. \nPrerequisite: Excel Fundamentals or equivalent experience \nMeets Core and Expert objectives to complete Microsoft Office Specialist Certification. For questions about voucher purchase and certification exams\, contact Regnier Testing Center on JCCC main campus. \nInstructor: Steve Hultgren \nCost: Free for employees of MCAKC Member Contractors Signatory to Locals 8 & 533. \nCEU: 0.7 \nComplete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW! \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/excel-advanced-live-online-jccc/
LOCATION:Live Online\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261210T133000
DTEND;TZID=UTC:20261210T160000
DTSTAMP:20260812T225825Z
CREATED:20260618T160051Z
LAST-MODIFIED:20260812T225825Z
UID:10000300-1796909400-1796918400@mcakc.org
SUMMARY:Kansas Sales & Compensating Use Tax for Construction Contractors
DESCRIPTION:Registration Information \n\nEmployees of MCAKC Signatory Contractors and Associate Member companies may attend this course at no cost through MCAKC. \nMCAKC registers participants directly with JCCC. Click the button below to request registration.\n \nThis presentation by the Kansas Department of Revenue specifically targets construction contractors and subcontractors.  The workshop covers how sales tax applies  to materials and labor\, project exemption certificates\, sales tax returns\, and billing. \nCost: FREE to employees of Signatory Contractors and Associate Members. \nThis seminar has been approved by the Contractor Licensing Review Board of Johnson County.\nApproved for: ‘Non-Code’ Credit. \nCEU: 0.25\n \n \n\nRegistration\, Cancellation & Attendance Policy\nThe following policies apply to JCCC Continuing Education courses registered through MCAKC. \nCancellation Policy\nCancellation requests must be received at least four (4) business days prior to the first day of class by email at learn@mcakc.org or by phone at 913-948-9200. \nRegistrants who do not cancel within the required timeframe and do not attend (“No Shows”) may be charged the full registration cost incurred by MCAKC. \nTransfer Policy\nRegistrations may be transferred to a another course offering or class date. Transfer requests must be submitted in writing at least four (4) business days prior to the first day of the originally scheduled course. \nA $50 transfer fee will apply to all approved transfer requests.
URL:https://mcakc.org/event/kansas-sales-compensating-use-tax-for-construction-contractors/
LOCATION:12345 College Blvd.\, Overland Park\, 66210\, US
CATEGORIES:JCCC Seminar
ATTACH;FMTTYPE=image/png:https://mcakc.org/wp-content/uploads/2026/06/calendar_icon.png
END:VEVENT
END:VCALENDAR