Skip to Content
Microsoft Excel - Managing Multiple Worksheets
on-demand course

Microsoft Excel - Managing Multiple Worksheets

with Erin Olsen
February 2014
Beginner to intermediate
4h 35m
English
Infinite Skills

Overview

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Watch now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft Excel 2010

Microsoft Excel 2010

Guy Vaccaro
Using Microsoft Excel 2010

Using Microsoft Excel 2010

Bill Jelen, Tracy Syrstad

Publisher Resources

ISBN: 9781771372060