Outlines

Chapter 1: Office Workspace Basics

Basic Window Elements 
Exploring Microsoft Office Backstage 
Working with the Ribbon 
Customizing the Quick Access Toolbar 
Working with KeyTips 
Using the Status Bar 
Getting Help 

Chapter 2: Introduction to Excel
What is Excel? 
Getting to Know the Excel Window 
Moving the Cell Selector 
Opening a Workbook 
Navigating a Workbook 
Selecting Cells 
Creating Workbooks 
Saving a Workbook 
Closing a Workbook 

Chapter 3: Entering and Editing Data 
Entering Text, Numbers, and Data 
Editing Data 
Using AutoComplete and AutoFill 
Copying Data 
Moving and Clearing Data 
Using Undo and Redo 
Finding and Replacing Data 

Chapter 4: Introduction to Formulas and Functions 
What are Formulas and Functions? 
Entering Formulas 
Entering Functions 
Using the Insert Function Tool 
Using AutoSum 
Copying and Moving Formulas 

Chapter 5: Working with Functions 
Using Statistical Functions 
Using Financial Functions 
Testing Conditions with IF 
Using Date and Time Functions 
Using Linked Values in Formulas 
Copying Formula Values 
Controlling Automatic Calculations 

Chapter 6: Formatting Data 
Introduction to Formatting 
Applying Number Formats 
Applying Font Formats 
Changing Cell Alignment 
Applying Cell Styles 
Copying Formats 
Clearing Formats 
Finding and Replacing Formats 

Chapter 7: Formatting Worksheets 
Inserting and Deleting Rows and Columns 
Inserting and Deleting Cells 
Adjusting Column and Row Sizes 
Hiding Worksheet Components 
Inserting and Deleting Worksheets 
Copying and Moving Worksheets 
Customizing Sheet Tabs 
Adding a Worksheet Background 

Chapter 8: Adding Charts and Graphics 
Creating a Chart 
Enhancing a Chart 
Modifying Chart Data 
Changing Chart Types 
Drawing Shapes 
Inserting Pictures 
Creating SmartArt 

Chapter 9: Viewing and Printing Workbooks 
Changing View Options 
Splitting and Freezing a Worksheet 
Sorting and Filtering Data Info about Slicers 
Customizing the Page Layout 
Adding Headers and Footers 
Modifying Page Breaks 
Previewing and Printing the Worksheet 
Printing Selected Data 

Chapter 10: Managing Workbooks 
Arranging Multiple Workbooks 
Adding Hyperlinks 
Working with Comments 
Saving Workbooks in Different Formats 
Saving a Workbook as a Web Pages
Creating Folders 
E-Mailing a Workbook 

Who Should Attend

• Anyone who has never used Microsoft Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts.

Duration

3 Days