Excel: Consolidating & Linking Data in Excel Workbooks

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