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.