BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//NACM Intermountain - ECPv6.15.17.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:NACM Intermountain
X-ORIGINAL-URL:https://www.nacmint.com
X-WR-CALDESC:Events for NACM Intermountain
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20260308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20261101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20270314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20271107T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260310T090000
DTEND;TZID=America/Denver:20260310T130000
DTSTAMP:20260414T233016
CREATED:20251208T161024Z
LAST-MODIFIED:20251230T183947Z
UID:3643-1773133200-1773147600@www.nacmint.com
SUMMARY:Excel Database/List Management
DESCRIPTION:This virtual Microsoft Suite series class taught by Neal Otto will follow the schedule below. Each class must be registered for by emailing steph@nacmint.com; cost per class is $135/pp. The series is a la carte and no one must attend every class. All times are Mountain. \nExcel Database/List Management \nIn this course\, students will explore Excel’s powerful capabilities for database and list management. They’ll gain practical insights into setting up and managing data effectively\, learning key concepts like database setup requirements\, essential terminology\, and data structuring techniques. Through hands-on activities\, students will master sorting\, filtering\, and organizing records\, harness the advantages of Excel data tables\, and discover the potential of Pivot Tables and Pivot Charts for dynamic data analysis and visualization.\nKey Takeaways\n• Upon successful completion\, students will be able to:\n• Understand and apply best practices for setting up an Excel database\n• Sort\, filter\, and organize data in a variety of visually intuitive formats\n• Utilize data tables to streamline data handling and analysis\n• Create and customize Pivot Tables and Pivot Charts for in-depth data insights and trends \nNeal Otto Bio: \n“People work too hard to get simple things done!” quotes Neal Otto\, Jumpstart Computer Training. Neal and Jumpstart believe that technology should reduce waste and help us all get more of the right things done\, faster. Since 1996\, Neal and Jumpstart have helped tens of thousands of individuals improve their use of Microsoft technologies.\nNeal\, a former high school teacher\, is known for his broad knowledge of an extensive array of Microsoft software and his ability to connect with students of all abilities and styles. Given his background\, he can keep audiences engaged and entertained.\nNeal lives in Corvallis Oregon with his sweetheart Shannon. Linus THE Wonder Dog and Cali THE Wonder Dog 2 keep Neal company in his office during webinars. Neal is a long-distance bicyclist and loves to spend any spare time in his shop making sawdust or in the kitchen making bread. Son Nathan is the CFO of Fluke Healthcare; daughter Brynne is self-employed and resides in Bellingham Washington. \n\n\n\n\nSubject\n\n\nStart\n\n\nEnd\n\n\n\n\nExcel Essentials\n\n\nTue 1/27/2026 9 AM\n\n\nTue 1/27/2026 1 PM\n\n\n\n\nExcel Calculations and Charts\n\n\nTue 2/10/2026 9 AM\n\n\nTue 2/10/2026 1 PM\n\n\n\n\nOutlook - Simplify\, Organize\, and Boost Productivity\n\n\nTue 2/24/2026 9 AM\n\n\nTue 2/24/2026 1 PM\n\n\n\n\nExcel Database/List Management\n\n\nTue 3/10/2026 9 AM\n\n\nTue 3/10/2026 1 PM\n\n\n\n\nExcel Get and Transform\n\n\nTue 3/24/2026 9 AM\n\n\nTue 3/24/2026 1 PM\n\n\n\n\nWord for Contracts\, Manuals\, and Other Large Documents\n\n\nTue 4/7/2026 9 AM\n\n\nTue 4/7/2026 1 PM\n\n\n\n\nExcel Conditional Formatting\n\n\nTue 4/21/2026 9 AM\n\n\nTue 4/21/2026 11 AM\n\n\n\n\n 
URL:https://www.nacmint.com/event/excel-database-list-management/
ATTACH;FMTTYPE=image/png:https://www.nacmint.com/wp-content/uploads/2025/12/4.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260324T090000
DTEND;TZID=America/Denver:20260324T130000
DTSTAMP:20260414T233016
CREATED:20251208T161116Z
LAST-MODIFIED:20251230T183923Z
UID:3645-1774342800-1774357200@www.nacmint.com
SUMMARY:Excel Get and Transform
DESCRIPTION:This virtual Microsoft Suite series class taught by Neal Otto will follow the schedule below. Each class must be registered for by emailing steph@nacmint.com; cost per class is $135/pp. The series is a la carte and no one must attend every class. All times are Mountain. \nExcel: Get and Transform (Power Query) \nThis course is designed for advanced Excel users who want to streamline their data preparation process. Are you spending too much time cleaning\, organizing\, and reformatting data before diving into analysis? With Excel’s Get and Transform tools (also known as Power Query)\, you can automate repetitive tasks such as removing unwanted rows or columns\, combining data from multiple sources\, and resolving layout inconsistencies—all without requiring macros or VBA.\nOnce configured\, these transformations can be applied with a single click of the Refresh button\, saving you hours of manual work.\nThe course uses practical examples with data sources like Excel workbooks\, CSV files\, and text files\, but the principles taught are versatile and can be applied to a wide range of data sources.\nKey Takeaways:\n• Learn to create robust query connections to various data sources.\n• Master techniques for cleaning and preparing data for analysis in tools like PivotTables.\n• Combine and consolidate data from multiple datasets into a single\, usable format.\n• Understand how to automate data transformations for consistent and repeatable workflows.\nBy the end of this class\, you’ll have fundamentals to prepare your data for analysis\, letting you focus on insights rather than manual tasks. \nNeal Otto Bio: \n“People work too hard to get simple things done!” quotes Neal Otto\, Jumpstart Computer Training. Neal and Jumpstart believe that technology should reduce waste and help us all get more of the right things done\, faster. Since 1996\, Neal and Jumpstart have helped tens of thousands of individuals improve their use of Microsoft technologies.\nNeal\, a former high school teacher\, is known for his broad knowledge of an extensive array of Microsoft software and his ability to connect with students of all abilities and styles. Given his background\, he can keep audiences engaged and entertained.\nNeal lives in Corvallis Oregon with his sweetheart Shannon. Linus THE Wonder Dog and Cali THE Wonder Dog 2 keep Neal company in his office during webinars. Neal is a long-distance bicyclist and loves to spend any spare time in his shop making sawdust or in the kitchen making bread. Son Nathan is the CFO of Fluke Healthcare; daughter Brynne is self-employed and resides in Bellingham Washington. \n\n\n\n\nSubject\n\n\nStart\n\n\nEnd\n\n\n\n\nExcel Essentials\n\n\nTue 1/27/2026 9 AM\n\n\nTue 1/27/2026 1 PM\n\n\n\n\nExcel Calculations and Charts\n\n\nTue 2/10/2026 9 AM\n\n\nTue 2/10/2026 1 PM\n\n\n\n\nOutlook - Simplify\, Organize\, and Boost Productivity\n\n\nTue 2/24/2026 9 AM\n\n\nTue 2/24/2026 1 PM\n\n\n\n\nExcel Database/List Management\n\n\nTue 3/10/2026 9 AM\n\n\nTue 3/10/2026 1 PM\n\n\n\n\nExcel Get and Transform\n\n\nTue 3/24/2026 9 AM\n\n\nTue 3/24/2026 1 PM\n\n\n\n\nWord for Contracts\, Manuals\, and Other Large Documents\n\n\nTue 4/7/2026 9 AM\n\n\nTue 4/7/2026 1 PM\n\n\n\n\nExcel Conditional Formatting\n\n\nTue 4/21/2026 9 AM\n\n\nTue 4/21/2026 11 AM\n\n\n\n\n 
URL:https://www.nacmint.com/event/excel-get-and-transform/
ATTACH;FMTTYPE=image/png:https://www.nacmint.com/wp-content/uploads/2025/12/5.png
END:VEVENT
END:VCALENDAR