Excel 365 Part 5 – Worksheets

It is important to know how to create a New Sheet within a Workbook (or file). Worksheets are oftentimes referred to as Sheets. It is valuable to be able to easily manipulate Rows and Columns which are located on the top and left side of the interface. Also, there are many ways to manipulate and adjust Large Worksheets, as well.Show more

Video Series Part 5 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch5.mp4

Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.

If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326

Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 5 - Worksheets (Sheets)

Chapter Contents:
Section 1: Worksheet (Sheet) Tabs
In this section, we will explore how to manipulate Sheets located on the bottom of the interface. The following concepts will be covered: Insert Sheet, Delete Sheet, Rename, Move, Copy, Move/Copy To Workbook, Tab Color, Hide Sheet, Unhide Sheet, Navigation Arrows, View Navigation, Select Multiple, and Select Sheets.

Section 2: Column And Row Manipulation
It is valuable to be able to easily manipulate Rows and Columns which are located on the top and left side of the interface. Here, we will explore how to manipulate Columns and Rows. The following concepts will be covered: Insert Row/Column, Delete Row/Column, Clear Contents, Select Rows/Columns, Manual Row/Column Width, Row/Column Width, Evenly Space Columns / Rows, Hide/ Column Or Row, Unhide Column Or Row.

Section 3: Large Worksheets (Sheets)
In this section, we will explore different techniques to manage Large Documents. The following concepts will be covered: Freeze Panes, Split, Hide Columns, View Side-By-Side, Reset Window Position, View Two Sheets Side-By-Side, Switch Windows, Hide Workbook, Create Data List Outline, and Clear Outline.

This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.