Microsoft Excel 2007 Beginners
Training
In
Description
-
Type
Training
-
Duration
1 Day
Learn how to manage, edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is. Suitable for: Suitable for people who want to learn the basics of Excel.
Reviews
Course programme
Learn how to manage, edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is.Microsoft Excel 2007 Training Course (Beginners) Outline
Exploring the Excel Environment
- Explore the User Interface
- Explore the Ribbon
- Obtain Help
- Customize the Quick Access Toolbar
Working with an Excel Worksheet
- Navigate in Excel
- Select and Enter Data
- Save a Workbook
Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create a Mixed Reference
Formatting a Worksheet
- Convert Text to Columns
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Align Cell Contents
- Find and Replace Formats
- Apply AutoFormat
- Apply Cell Styles
- Apply Themes
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Printing Workbook Contents
- Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Customizing Layout
- Split a Worksheet
- Arrange Windows
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
Microsoft Excel 2007 Beginners