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

Screenshots
Excel 2016: Managing Multiple Worksheets and Workbooks


Download link:


Links are Interchangeable - No Password - Single Extraction
loading...

Add comment

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

    • bowtiesmilelaughingblushsmileyrelaxedsmirk
      heart_eyeskissing_heartkissing_closed_eyesflushedrelievedsatisfiedgrin
      winkstuck_out_tongue_winking_eyestuck_out_tongue_closed_eyesgrinningkissingstuck_out_tonguesleeping
      worriedfrowninganguishedopen_mouthgrimacingconfusedhushed
      expressionlessunamusedsweat_smilesweatdisappointed_relievedwearypensive
      disappointedconfoundedfearfulcold_sweatperseverecrysob
      joyastonishedscreamtired_faceangryragetriumph
      sleepyyummasksunglassesdizzy_faceimpsmiling_imp
      neutral_faceno_mouthinnocent
reload, if the code cannot be seen

Comments 0