ProfBurnett.com - Master a Skill / Learn for Life

ITI 494 Microsoft Word and Excel Foundations

Session 5 – Microsoft® Office Excel® 2019: Part 1

  • Lesson 3: Modifying a Worksheet
  • Lesson 4: Formatting a Worksheet

Session Outline

Lesson 3: Modifying a Worksheet

From time to time, you'll need to make changes to your worksheets and workbooks. What if the changes you need to make go beyond simply re-entering a formula or updating a value? What if you need to add a whole new column or row to your worksheet? What if that column or row is in the middle of existing data? Also, what if you discover you've made the same mistake over and over? Or, what if you need to check your spelling throughout all worksheets in a workbook? Microsoft® Office Excel® 2019 provides you with a wide variety of options for making significant changes like these to your worksheets. Understanding how this functionality works will help you keep your documents updated without throwing away all of the valuable work you've already done.

Lesson 4: Formatting a Worksheet

Large worksheets with thousands, or perhaps millions, of data entries can be difficult to read. This can be especially true if you're working with a variety of data types, such as text, dollar amounts, percentages, and more. You may need to organize your data according to department, region, job role, or other important distinctions. And some data is simply more important than other data, and should stand out even at first glance. Fortunately, Microsoft® Office Excel® 2019 allows you to present data in a wide variety of formats that can suit your specific needs. Understanding how to use and, perhaps more importantly, when and why to use these formatting options, will help you make your worksheets easy to read, professional in their appearance, and more useful.

Lesson Objectives

  • Insert, delete, and adjust cells, columns, and rows.
  • Search for and replace data.
  • Check the spelling in a worksheet.
  • Apply text formats.
  • Apply number formats.
  • Align cell contents.
  • Apply styles and themes.
  • Apply basic conditional formatting.
  • Create and use templates.

Class Presentation Files

Class Exercises

  1. Download zip file from Profburnett.com class website to the c: drive.
  2. Exercise Zip File
  3. Unzip file to c: drive
  4. Exercise files will be in new folder

Addtional Course Material

Microsoft Office Word 2019: Part 1

Microsoft Office Word 2019: Part 1
Access Key(s) for enrollment in the subscription: APU6DOP3RW
URL: https://lochoice.com

eBook - Microsoft Office Word 2019: Part 1 - Student Edition

eBook - Microsoft Office Word 2019: Part 1 - Instructor Edition


Microsoft® Office Excel® 2019: Part 1

Microsoft Office Excel 2019: Part 1
Access Key(s) for enrollment in the subscription: APICKTLZFH
URL: https://lochoice.com

eBook - Microsoft® Office Excel® 2019: Part 1 - Student Edition

eBook - Microsoft® Office Excel® 2019: Part 1 - Instructor Edition

Colleges and Universities