Microsoft Excel Introduction
Hands-On Course 522 – 1 Day
Course Requirements
Learners must be confident using a mouse and keyboard.
What You Will Learn
In particular you will be able to:
- Get working with Microsoft Excel efficiently and effectively
- Optimize your worksheets by creating and using formulas
- Modify worksheets to manipulate and edit data
- Format and style worksheets to get more impact from data
- Produce printed workbooks
About This Course: This course will provide you with the foundational Excel knowledge and skills necessary for business today. As you apply the robust functionality that’s part of Excel to your organization’s raw data, you will be able to gain a level of insight into that data that would have been almost impossible years ago. Excel helps you organize, calculate, analyze, revise, amend, and present your data in ways that will help you and the decision makers in your organization steer forward in the right direction.
- Identify the Elements of the Excel Interface
- Create a Basic Worksheet
- Use the Help System
Performing Calculations
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
Modifying a Worksheet
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search for and Replace Data
- Spell Check a Worksheet
Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
Printing Workbook Contents
- Define the Basic Page Layout for a Workbook
- Refine the Page Layout and Apply Print Options
Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
Customizing the Excel Environment
- Customize General and Language Options
- Customize Formula Options
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Functionality of Excel by Enabling Add-Ins
- Customize Advanced and Trust Center Options