Master advanced Excel techniques: Consolidating data from different workbooks
Linking and consolidating data in Excel workbooks is an important skill for those who use Excel on a regular basis. Our upcoming webinar discusses the Excel consolidate function which lets you select data from its various locations and creates a table to summarize the information for you. The webinar covers the following key areas: · Creating linked cells and grouping worksheets · Using 3-D references in summary functions · Creating external reference formulas Linking and Consolidating Data in Excel Workbooks LEARNING OBJECTIVES We all collect data and store it in multiple workbooks and in multiple worksheets. Summarizing data within a single worksheet is done on a regular basis. But at times you may want to combine data from multiple workbooks and worksheets into a YTD summary or consolidate data from multiple wor...