EXCEL: FIXING BROKEN DATA LISTS
PART 2
Date: Tuesday, January 14, 2025
Time: 11 a.m. – Noon
Registration deadline: 1/7/25.
This class will continue to expand on what we learned in Part 1. We will learn shortcuts to cleaning up data lists that aren’t layed out correctly. Rather than retyping the list to create good reports, you will learn the built-in tools to automatically adjust the layout.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
MEDLEY OF MICROSOFT
PART 1: USING EXCEL IN WORD DOCUMENTS
Date: Tuesday, February 18, 2025
Time: 11 a.m. – Noon
Registration deadline: 2/11/25.
This course teaches how to integrate Excel with Word, focusing on four key methods for displaying Excel worksheets in Word documents: static snapshots, picture insertions, embedded worksheets, and linked workbooks. Participants will learn to use Mail Merge for creating form letters and labels from Excel data, and master hyperlink functionality connect to any application or file.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
MEDLEY OF MICROSOFT
PART 2: OUTLOOK & EXCEL
Date: Tuesday, February 25, 2025
Time: 11 a.m. – Noon
Registration deadline: 2/18/25.
This course demonstrates how to use Excel contact lists to create personalized mass emails through Word. Participants will learn to merge Excel data into Word form letters, automatically customizing salutations and content for each recipient, creating a professional and individualized communication system at no additional cost.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
BLUEBEAM POP-UP
PART 1: PRODUCT OVERVIEW
Date: Tuesday, March 4, 2025
Time: 11 a.m. – Noon
Registration deadline: 2/25/25.
If you’re self-taught, you might not be aware of the many powerful features of this software program. This class will help participants streamline workflows by introducing tool sets, dynamic fill measurements, comprehensive markup management, thumbnails and page label creation, visual search, the stapler function and the collaboration tools of Studio and Project.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
BLUEBEAM POP-UP
PART 2: THE TREASURE CHEST OF BLUEBEAM, TOOL CHESTS
Date: Tuesday, March 18, 2025
Time: 11 a.m. – Noon
Registration deadline: 3/11/25.
Tool Chests allow you to store your frequently used customized markups and measurements. Learn how easy it is to create and save multiple types of markups, create a dynamic legend that counts each markup and share custom tool chests so your markups are consistent across all drawings. Topics covered during this session include: custom tools, scaling the toolset, sequencing markups, attaching tools to layers and sharing toolsets.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
EXCEL CUSTOM LISTS AND FORMULAS
PART 1
Date: Tuesday, April 15, 2025
Time: 11 a.m. – Noon
Registration deadline: 4/8/25.
In Part 1 of this two-part series we will learn the best way to manage lists of information in Excel. After formatting the list as a table, we will expand our knowledge of making our list more usable. Some formulas that are commonly used with data lists will be explained.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
EXCEL CUSTOM LISTS AND FORMULAS
PART 2
Date: Tuesday, April 29, 2025
Time: 11 a.m. – Noon
Registration deadline: 4/22/25.
After mastering how to work with a formatted table, we’ll take the next step by learning how to create reports from a table. This session will explain how to create a formatted table that will easily set filters and display subtotals based on those filters. Students will also learn to build dynamic Pivot table reports.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
WORD TIPS FOR NON-WORD USERS
PART 1
Date: Tuesday, May 6, 2025
Time: 11 a.m. – Noon
Registration deadline: 4/28/25.
Word has some built-in features to help eliminate the stress of formatting a document. With this session, you will learn how to save blocks of text, navigate through large documents more quickly, create columns in under a minute, tricks behind setting tabs, inserting Excel workbooks and more.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
WORD TIPS FOR NON-WORD USERS
PART 2
Date: Tuesday, May 20, 2025
Time: 11 a.m. – Noon
Registration deadline: 5/13/25.
Part 2 is designed to expand on the knowledge and lessons learned from the first session. By the end, participants will become more comfortable and efficient using Word.
To register, call or email Laurie: Laurie@SMACNAGreaterChicago.org or 708-544-7007.
Member Benefit Free 2-Hour Tech Help
Ginnie Floraday will remotely help individual companies work through any specific computer/software needs. Classes can include up to 25 participants, be customized for new hires or internal promotions and can be recorded for future use. This is an annual benefit - schedule yours by emailing gfloraday@comcast.net.