+ View more
Course overview
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 different features including creating a new spreadsheet,
working with basic formulas and functions, making a spreadsheet look
professional and presentable, and saving and printing a spreadsheet.
This course
is based on a combination of theory and practical hands-on training.
Theory + Practical Application Scenarios + Hands-On Training = Outstanding Results
What will I learn?
- Getting 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.
- Working 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.
- Modifying 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.
- Printing 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.
- Managing Large Workbooks. This lesson will teach students how to format worksheet tabs, manage worksheets and, manage the view of worksheets and workbooks.
- Customizing 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.
Requirements
- This course assumes 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 for this course
8 Lessons
00:00:00 Hours
Getting Started.
3 Lessons
00:00:00 Hours
-
Getting to Know Excel
.
-
Creating Workbooks
.
-
Getting Help in Excel 365
.
Working with Data.
5 Lessons
00:00:00 Hours
-
A Closer Look at Formulas
.
-
Using Formulas and Functions
.
-
Working with Data.
.
-
Working with Rows and Columns
.
-
Sorting and Filtering Data
.
Modifying a Worksheet.
0 Lessons
00:00:00 Hours
Printing Workbook Contents.
0 Lessons
00:00:00 Hours
Managing Large Workbooks.
0 Lessons
00:00:00 Hours
Customizing the Excel Environment.
0 Lessons
00:00:00 Hours
+ View more
Other related courses
About instructor
William Wingson - Total Corporate Learning
Director of Training
Student feedback
Write a public review