Microsoft Excel multiple worksheets & external data

"In this Microsoft Excel-Managing Multiple Worksheets training course, expert author Erin Olsen teaches you how to manage multiple worksheets in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by preparing...

Full description

Bibliographic Details
Main Author: Olsen, Erin
Format: eBook
Language:English
Published: [Place of publication not identified] InfiniteSkills 2014
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary:"In this Microsoft Excel-Managing Multiple Worksheets training course, expert author Erin Olsen teaches you how to manage multiple worksheets in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by preparing for dispersed data and grouping worksheets. Erin will show you how to properly format multiple worksheets, including creating and applying styles, applying conditional formatting, and creating quick formatting macros. This video tutorial will also teach you how to calculate disperse data, reference and summarize data, and perform data consolidation. Finally, Erin will show you how to bring your data together, edit data links, and create and use Excel views. By the completion of this computer based training course, you will be fully capable of managing multiple worksheets using the tools available in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons."--Resource description page
Item Description:Title from title screen. - Date of publication from resource description page (viewed Feb. 25, 2014)
Physical Description:1 streaming video file (4 hr., 38 min., 10 sec.)