Description
Learn in a classroom environment with your peers, virtually with an instructor online.
Course Length: 1 day
Target Audience: General
Create, Open and Save Workbooks
• What is Excel?
• Create a New Blank Workbook
• Create a Workbook From a Template
• Open Excel Files
• Get Help
• Save Workbooks
• Navigate a Workbook
Explore the User Interface
• Backstage View*
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs
Work with Data
• Enter, Edit and Delete Data
• Data Selection Methods
• Use Autofill and Autocomplete
• Cut, Copy, Paste and Paste Special
• Resize Columns and Rows
• Insert and Delete Columns, Rows, Cells
• Use Undo, Redo and Repeat
• Spellcheck and AutoCorrect
• Use Find, Replace and Go To
• Use Basic Functions
• Use SmartTags and Options Buttons
• Add, Edit, and Remove Comments
Format A Workbook
• Format Using the Home Ribbon
• Format Using the Mini-Toolbar
• Format Using Dialog Boxes
• Use and Modify Conditional Formatting
• Use the Format Painter
• Create and Modify Styles
• Add, Name, Move, Delete and Color Sheets
Charts
• Create and Format a Chart
• Modify Chart Layout and Structure
• Change Chart Types, Options, Location and
• Data Source
• Save a Chart as a Template
Printing and Viewing A Workbook
• Use the View Ribbon
• Split and Freeze
• Manage Multiple Windows
• Use Page Layout, Print Preview and Basic
• Print Options
• Add Headers and Footers
Customize
• Customize the Quick Access Toolbar
• Show/Hide the Ribbon
