Excel Essentials: Create, Format, and Distribute Like a Pro!

Create, Format, and Distribute Workbooks with Confidence and Efficiency for Better Data Management!

Created byIsáBel .

Last updated 1/2026

English

What you'll learn

Learn how to move, and copy worksheets in the same workbook, or to different workbooks in Microsoft Excel.
Learn how to import data from a delimited text file into your Microsoft Excel workbooks.
Learn how to find the information you need, quickly in your Excel workbooks.
Learn how to insert or remove hyperlinks in your Excel workbooks.
Learn how to use color for better organization.
Change the Margins, Page Orientation, and Page Size of your Microsoft Excel workbooks
Learn how to insert headers and footers into your Microsoft Excel worksheets
Learn the different ways to hide or unhide your worksheets, columns, or rows
Learn how to Customize Toolbars and Change Views
Configuring Workbooks for Distribution

Course content

8 sections • 44 lectures • 1h 45m total length

Introduction0:43
Exercise Files0:25

Creating Workbooks2:33
Learn the different ways to create workbooks in Microsoft Excel 2016.
Adding a Worksheet to an Existing Workbook2:06
Learn the different ways to create worksheets in your Microsoft Excel workbooks.
Copying and Moving a Worksheet4:41
Learn how to move, and copy worksheets in the same workbook, or to different workbooks in Microsoft Excel.
Importing Data From a Text Delimited File4:37
Learn how to import data from a delimited text file into your Microsoft Excel workbooks.
Section Review: Creating and Managing Workbooks and Worksheets0:49
A review of the key points of this section.
Section Quiz
Test Your Skills: Creating and Managing Workbooks and Worksheets0:04
Reinforce what you have learned so far with this Test Your Skills practice.

Searching for Data4:12
Learn how to find the information you need, quickly in your Excel workbooks.
Navigating to a Named Cell, Range, or Element5:07
Learn how named ranges, along with the Go To dialog box, can help you quickly locate important information.
Inserting and Removing Hyperlinks7:37
Learn how to insert or remove hyperlinks in your Excel workbooks.
Section Review: Navigating in Workbooks and Worksheets0:53
A review of the key points of this section.
Section Quiz
Test Your Skills: Navigating in Workbooks and Worksheets0:20
Reinforce what you have learned so far with this Test Your Skills practice.

Changing Worksheet Tab Color1:33
Learn how to change the color of your worksheet tabs for better organization.
Renaming Worksheets0:10
Learn how to rename your worksheets in Microsoft Excel.
Modifying the Page Setup2:40
Change the Margins, Page Orientation, and Page Size of your Microsoft Excel workbooks
Inserting, and Deleting Columns and Rows4:41
Insert and Delete Columns and Rows in your Microsoft Excel worksheets.
Changing Workbook Themes3:51
Themes can add consistency to your Microsoft Excel workbooks. Learn how to create and modify them.
Adjusting Row Height, and Column Width4:37
Learn how to adjust the size of your columns and rows, how to autofit, and how to evenly space.
Inserting Headers, and Footers8:15
Learn how to insert headers and footers into your Microsoft Excel worksheets
Section Review: Formatting Workbooks and Worksheets1:51
A review of the key points of this section.
Section Quiz
Test Your Skills: Formatting Workbooks and Worksheets0:24
Reinforce what you have learned so far with this Test Your Skills practice.

Hiding or Unhiding Worksheets0:32
Learn the different ways to hide or unhide your worksheets.
Hiding or Unhiding Columns and Rows3:01
Learn the different techniques for hiding, and unhiding columns, and rows.
Customizing the Quick Access Toolbar6:36
Add commands that you frequently use to the Quick Access Toolbar, and have them just a click away.
Changing Workbook Views1:02
Switch between three workbook views.
Changing Window Views6:45
Learn three different Views for your Microsoft Excel workbooks.
Changing Magnification1:27
Learn the ways to adjust the magnification of your Microsoft Excel worksheets.
Modifying Workbook Properties3:26
Learn how to add additional properties to your Microsoft Excel workbooks, to categorize them and make them easier to find.
Displaying Formulas0:08
Press CTRL + ` (grave accent, to the left of the 1 key on most keyboards) to display, or hide formulas in your worksheets.
Section Review: Customizing Options and Views for Workbooks and Worksheets3:07
A review of the key points of this section.
Section Quiz
Test Your Skills: Customizing Options and Views for Workbooks and Worksheets0:30
Reinforce what you have learned so far with this Test Your Skills practice.

Setting Print Areas2:07
Learn how to print just a portion of your Microsoft Excel worksheet with Print Areas
Printing All or Part of a Workbook2:24
Learn how to print multiple worksheets, the entire workbook, or a range of selected cells.
Setting the Print Scale2:54
Learn how to adjust the scale of the contents on your worksheet to fit on the number of pages you want.
Repeating Row and Column Headings1:59
One of the most common questions, is how to get your headings to repeat when your worksheet prints. Learn how to here.
Saving Workbooks as Other Formats0:05
You can save your Microsoft Excel file into multiple different formats.
Inspecting Workbooks for Hidden Properties, Accessibility, and Compatibility3:43
Learn how to inspecting your workbooks for hidden information, , check your workbook's accessibility, and compatibility to older versions of Microsoft Excel.
Section Review: Configuring Workbooks for Distribution1:28
A review of the key points of this section.
Section Quiz
Test Your Skills: Configuring Workbooks for Distribution0:16
Reinforce what you have learned so far with this Test Your Skills practice.

Requirements

Participants should have access to a version of Microsoft Excel (2016 or later recommended) on their computer. No prior Excel experience is necessary, but a general understanding of what spreadsheets are and their purpose can be helpful.

Description

Learn what you can do in Microsoft Excel with this course, "Excel Essentials: Create, Format, and Distribute Like a Pro!"

This course is designed for learners at all levels who want to enhance their Excel skills and boost their productivity.

Topics Covered:

Creating and Managing Workbooks and Worksheets
Navigating in Workbooks and Worksheets
Formatting Workbooks and Worksheets
Customizing Options and Views for Workbooks and Worksheets
Configuring Workbooks for Distribution

You’ll start by mastering the fundamentals of creating and managing workbooks and worksheets, gaining confidence in navigating the interface.

As you progress, you’ll learn techniques to make your data visually appealing and easier to interpret.
We’ll also cover how to customize workbook views, helping you present your data in the most effective way.

Finally, you’ll discover how to prepare workbooks for distribution.

By the end of the course, you’ll be equipped with the tools and knowledge to create quality spreadsheets, making you a valuable asset in any workplace. Setting the foundation for greater efficiency and success in your personal and professional projects!

So whether you have little experience in Excel and want to build a solid foundation in creating and managing workbooks and worksheets, or are transitioning to data-driven roles and recognize the importance of Excel proficiency in today’s job market, this quick 2 hour course is for you.

Who this course is for:

This course is designed for those who want to enhance their Excel skills and improve their productivity.
Beginners to Excel, Professionals Seeking Skill Enhancement, Students, Small Business Owners, Career Changers, and Anyone Looking to Improve Efficiency

Excel Essentials: Create, Format, and Distribute Like a Pro!

What you'll learn

Explore related topics

Course content

Start Here2 lectures • 1min

Creating and Managing Workbooks and Worksheets6 lectures • 15min

Navigating in Workbooks and Worksheets5 lectures • 18min

Formatting Workbooks and Worksheets9 lectures • 28min

Customizing Options and Views for Workbooks and Worksheets10 lectures • 27min

Configuring Workbooks for Distribution8 lectures • 15min

Test Your Skills for Sections 2 - 61 lecture • 1min

Course Wrap Up3 lectures • 1min

Requirements

Description

Who this course is for: