ProfBurnett.com - Master a Skill / Learn for Life

ITI 494 Microsoft Word and Excel Foundations

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

  • Lesson 1: Getting Started with Excel 2019
  • Lesson 2: Performing Calculations

Session Outline

Lesson 1: Getting Started with Excel 2019

You want to use Microsoft® Office Excel® 2019 to store and analyze data for your organization, but you're new to Excel and it's hard to know where to begin. In order to take advantage of everything Excel has to offer, you must first understand the "lay of the land." How do you interact with Excel? What, exactly, can it do? How do you get Excel to do these things for you? It is precisely these types of questions this lesson aims to answer.

Like many Microsoft Office applications, Excel has a standard layout that provides you with access to all of the commands, work areas, options, and settings you will need to begin developing and using electronic worksheets in your day-to-day life. Taking the time to become familiar with Excel's layout, its various parts, its commands, and its terminology is a critical first step toward your goal of storing and analyzing organizational data.

Lesson 2: Performing Calculations

The true power of Microsoft® Office Excel® 2019 lies in its ability to help you analyze your organizational data. Excel contains an incredible array of functionality to help you do this, particularly when it comes to working with numerical data. In order to take full advantage of Excel's abilities to quickly, efficiently, and accurately calculate data, you must first understand how Excel "thinks," and how to tell it what to do. In this lesson, you'll do just that.

Lesson Objectives

  • Navigate the Excel user interface.
  • Use Excel commands.
  • Create and save a basic workbook.
  • Enter cell data.
  • Use Excel Help.
  • Create worksheet formulas.
  • Insert functions.
  • Reuse formulas and functions.

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