Excel 365 in 30 Minutes – Modifying Workbooks & Worksheets (Basics 3 of 10)

In this Bigger Brains course, you’ll learn how to access workbooks from OneDrive or SharePoint, pin frequently used files and folders, and save your work in the right formats for different situations. You’ll explore the AutoSave feature and see how to convert older files to the modern 2021 format.  

Moving into worksheet editing, you’ll learn how to insert and delete cells, columns, and rows—and you’ll see the implications of removing entire columns or rows. You’ll also learn how to adjust row and column size, hide and unhide worksheet content, and manage entire sheets by adding new worksheets and deleting and renaming worksheets. You’ll see how to reorder sheets, create copies within a workbook, move or copy sheets to another workbook, and customize tab colors for staying organized. Designed for users who are comfortable with basic Excel tasks, this course gives you practical tools to maintain and manage your Excel files more effectively and efficiently. 

Topics covered include: 

• Opening a workbook from OneDrive or SharePoint 

• Discussing the Autosave feature 

• Saving a workbook in the appropriate format 

• Converting older versions of workbooks to the 2021 format 

• Inserting and deleting cells, columns, and rows 

• Understanding the implications of deleting a column or row 

• Modifying row/column width and height 

• Hiding and unhiding rows/columns 

• Adding or deleting a worksheet to your workbook 

• Renaming and reordering worksheets 

• Moving or copying a worksheet to another workbook  

• Changing the tab color for a worksheet  

• Hiding or Unhiding a worksheet  

Enjoy award winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.