Colleges and Universities
Digital Technology
Learning Sites
Books & Publishers
ITI 490 Virtual Office Management
Week 3 - Session 5 - MS Excel Part II
In this beginner-level course you will be introduced to the fundamentals of Excel. We will cover the Excel interface, then goes into how to create new workbooks, add and format numbers and text, work with basic formulas and functions, and leverage key features such as AutoFill, which allows you to quickly fill new cells using existing cells where there is a pattern. He shows you how to freeze columns and rows, insert charts, use Copilot to generate AI-powered insights, quickly share your spreadsheets with others, and more.
Lesson Objectives
- Summarize the use of Excel for creating charts and graphs to visualize data trends.
- Outline the procedures for managing and manipulating the structure of workbooks, including columns, rows, and sheets.
- Apply formatting to text and numerical data to enhance readability and presentation of the workbook.
- Utilize the AutoFill feature in Excel and relative cell addressing to efficiently enter and replicate data.
Session 4 Outline - MS Excel Part II
- Adjusting Page Layout & Printing
- Charting
- Adjusting Worksheet Views
- Multiple Worksheets and Workbooks
- Data Management Features
- Security and Sharing
Class Presentations, Exercise & Solution Set Files
| Session | Chapter | PowerPoint Presentation | Exercise Files | Solution Set Files |
| 4 | Session 4 - MS Excel Part II |  |
 |