Colleges and Universities
Digital Technology
Learning Sites
Books & Publishers
ITI 494 Microsoft Word and Excel Foundations
Week 2 - Session IV Overview
Chapter 1: Fundamentals
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.
Chapter 2: Creating worksheets
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.
- Open and Enter data in a Workbook.
- Enter data and About Excel Data Types.
- Perform Calculations using Formulas.
- Special Formulas call Funcations.
- How to Move and Copy Data.
- Insert functions.
- Relative and Absolute Cell Referencing.
Session IV – Microsoft® Office Excel 2021/365 Level 1
Chapter 1: Fundamentals
- Module A: Getting around
- Module B: Workbook basics
Chapter 2: Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
Class Presentations, Exercise & Solution Set Files
| Session | Chapter | PowerPoint Presentation | Exercise Files | Solution Set Files |
| IV | Chapters: 1 & 2 |  (Not Available) |
 |
|