Excel Introduction

Course Description:

The Excel 365 Introduction course guides student through the new features and standard operations in Excel 365.

The class will cover the following topics:

• Navigating the Excel 365 interface
• Entering data
• Using Formulas
• Working with Constant values and Formulas
• Formatting Worksheets
• Modifying Columns and Row
• Editing Workbooks and Printing Worksheets

This class is ideal for students who are new to Excel or are upgrading from a previous version of Excel, such as Excel 2019 or Excel 2016.

Getting Started with Excel
Starting Excel
Opening a Workbook
Understanding the Display Screen
Using the Ribbon
Using the Quick Access Toolbar
Using the Status Bar
Exploring the File Tab
Managing Open Workbooks
Using Excel Help

Entering Data
Moving the Cell Pointer
Selecting a Range of Cells
Create a New Workbook
Inserting, Renaming, and Deleting Worksheets
Entering Constant Values
Saving a Workbook
Editing Cell Contents
Clearing Cell Contents
Working with Undo and Redo
Closing a Workbook

Using Formulas
Entering Formulas
Using Autofill
Using the SUM Function
Summing Columns or Rows Automatically
Using Statistical Functions
Using the Range Finder
Using Formula Error Checking

Working with Constant Values and Formulas
Copying and Pasting Constant Values and Formulas
Moving and Pasting Constant Values and Formulas
Using Collect and Paste
Using AutoFill

Formatting Worksheets
Formatting Numbers
Changing the Font Format
Aligning Cell Contents
Merging Cells
Adding Borders
Applying Cell Styles

Modifying Columns and Rows
Changing Column Width and Row Height
Inserting and Deleting Columns or Rows
Hiding Columns or Rows

Editing Workbooks
Working with AutoCorrect
Checking Spelling
Using Find and Replace

Printing Worksheets
Using Print Preview
Working with Print Settings
Using Page Setup Tools
Working in Page Layout View
Create a Header and Footer
Using Page Break Preview
Printing a Worksheet
Exiting Excel

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation