Linking and Consolidating Data in Excel Workbooks
Date and Time
Friday Mar 24, 2023
1:00 PM - 2:00 PM CDT
Friday, March 24 | 1 – 2 p.m.
Location
Live Zoom
Fees/Admission
$20
Contact Information
Illinois Small Business Development
and International Trade Center
College of Lake County
(847) 543-2033
Send Email
Description
This 1-hour virtual workshop is part of our Virtual Power Course series. Cathy will teach you how to consolidate and link your Excel data to combine information from multiple workbooks and worksheets. Get the big picture of your data!
Topics include:
• Creating Linked Cells
• Grouping Worksheets
• Understanding 3-D References
• Using 3-D References in Summary Functions
• Naming Cells
• Creating External Reference Formulas
• Editing Links
• Consolidating Data
