Excel in 30 Minutes: Worksheets and Workbooks

Name: Excel in 30 Minutes: Worksheets and Workbooks
Rating: 3.7 (19 reviews)

There are two kinds of people: Those who are masters at Excel, and those who wish they were

Created byBigger Brains

Last updated 4/2025

English

English [Auto],Spanish

What you'll learn

Manage your worksheets including adding, removing, renaming, reordering, copying, and color-coding
Create Custom Views to save display and print settings and easily switch between them
Keep header rows or initial columns visible when scrolling by using Freeze Panes, and use Split to compare different sections of a worksheet
Easily compare or switch between multiple files or sheets
Track important information about a workbook by viewing and adding Workbook Properties

Course content

1 section • 6 lectures • 33m total length

Managing Worksheets, Part 15:16
Learn to manage worksheets by adding, inserting, renaming, and deleting sheets in a workbook. Use the plus sign, right-click insert, or Shift+F11, and rename by right-click or double-click.
Managing Worksheets, Part 27:39
Learn to manage worksheets by rearranging, copying, and moving sheets between workbooks, color coding, and hiding sheets for clean, organized Excel workbooks.
Creating a Custom View3:47
Learn to use Excel's custom views to quickly switch between data layouts by saving views that capture hidden rows and columns, print settings, and filters, then apply them across sheets.
Managing Worksheet Views6:01
learn to keep headings visible while scrolling by using freeze panes for the top row, the first column, or both, and compare sections with a split screen.
Managing Workbook Views6:22
Learn to view and compare multiple workbooks on one screen by tiling windows, arranging all, and using view side by side with optional synchronous scrolling.
Managing Workbook Properties4:14
View and customize workbook properties in the backstage info pane, adding built-in and custom fields like title, tags, client, and approval status to improve search and organization.
Knowledge Check

Requirements

A basic knowledge of Microsoft Excel

Description

Learn to manage multiple worksheets and workbooks and easily view and compare data in Excel 2019or Excel 365—in under 30 minutes!

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our “Excel in 30 Minutes” series can help you get started.

This course is one in a series of ten 30-minute courses.

Topics covered include:

Managing your worksheets by learning to add, remove, rename, reorder, copy, and color-code them
Hiding and unhiding sheets
Creating Custom Views to save display and print settings and easily switch between them
Keeping header rows or initial columns visible when scrolling by using Freeze Panes
Using Split to display two different parts of the same worksheet
Tracking important information about a workbook by viewing and adding Workbook Properties

Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019–Basics” course. High-quality HD content in the “Uniquely Engaging” TMBigger Brains Teacher-Learner style!

Objectives. You will be able to:

Manage your worksheets including adding, removing, renaming, reordering, copying, and color-coding them
Create Custom Views to save display and print settings and easily switch between them
Keep header rows or initial columns visible when scrolling by using Freeze Panes, and use Splitto to compare different sections of a worksheet
Easily compare or switch between multiple files or sheets
Track important information about a workbook by viewing and adding Workbook Properties

Who this course is for:

People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets.