Course Overview
Welcome to the first part of our Microsoft 365 Excel courseware. Excel is Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.
This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover:
- Getting started with the app
- Working with formulas and functions
- Modifying worksheets
- Printing workbook contents
- Managing workbooks
- Customizing the Excel environment
Note: This course is written for the desktop version of Microsoft 365 Excel.
What you’ll learn
By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, making their spreadsheet look professional and presentable, and saving and printing a spreadsheet.
Requirements
- This manual assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.
Curriculum
- 1 Section
- 6 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Topics6
- 1.1Getting Started In this lesson, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.
- 1.2Working with Data This lesson covers using formulas and functions in a worksheet, working with data, rows and columns and, how to sort and filter data.
- 1.3Modifying a Worksheet Next, students will learn how to format text and cells and, how to align cell contents. Using Find & Select tools and, how to spell check a worksheet are also discussed.
- 1.4Printing Workbook Contents In this lesson, students will learn how to define the basic page layout for a workbook, refine the page layout and, apply print options.
- 1.5Managing Large Workbooks This lesson will teach students how to format worksheet tabs, manage worksheets and, manage the view of worksheets and workbooks.
- 1.6Customizing the Excel Environment In this final lesson, students will learn how to customize general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customize the ribbon and the Quick Access toolbar, enable add-ins and, customize advanced and Trust Center options.
Instructor
