Excel 2016: Managing Multiple Worksheets and Workbooks

Excel 2016: Managing Multiple Worksheets and Workbooks
----- Lynda Video Training -----
Size: 277 MB | Duration: 1h 27m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

In this short, task-focused course, learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks. Follow Dennis Taylor as he takes you through how to move, copy, and link data across multiple worksheets. Dennis shares tips for adding, moving, and navigating worksheets and workbooks efficiently. He covers how to implement global changes, create formulas to connect worksheets and calculate data from multiple worksheets, and use PivotTables to summarize data from multiple workbooks.

Topics include:
* Working with different worksheets together
* Copying and moving worksheets within a workbook
* Linking formulas across multiple workbooks
* Changing tab colors and renaming sheets
* Copying, moving, and inserting data on different sheets
* Working with multiple workbooks
* Navigating workbooks
* Getting data from other sheets with 3D formulas

Excel 2016: Managing Multiple Worksheets and Workbooks

Download link:

Links are Interchangeable - No Password - Single Extraction

Add comment

The author will be very pleased to hear feedback about your news.

    • bowtiesmilelaughingblushsmileyrelaxedsmirk
reload, if the code cannot be seen

Comments 0