Class Outline
This one-day, instructor-led course provides the foundational skills to work in Microsoft® Excel comfortably and productively. After taking this course, you will be able to perform many foundational tasks like creating, formatting, and editing worksheets. You will be able to manipulate, protect and print data and use basic formulas and functions. These skills are a must for anyone who uses Excel in their job.
The training covers these topics:
Excel Basics
- Opening Excel
- Exploring the Excel Environment
- Using the Microsoft Help Feature
- Opening and Viewing a Workbook
- Starting a New Worksheet and Entering Data
- Saving a Workbook
Worksheets
- Using Basic Formulas
- Calculating Data
- Using Basic Formulas
- Updating Formula Results
- Multiplying Cells
- Adding More than Two Cells of Data
- Dividing Cells
- Calculating with Functions
- Using other Functions
- Using Relative Reference
- Using Absolute Reference
Formatting
- Modifying Fonts
- Adding Borders and Colors to Cells
- Using the Format Painter
- Formatting Totals and Percentages
- Formatting Dates
- Formatting Phone Numbers
- Adjusting Cell Alignment
- Using Cell Styles
- Using Themes
Manipulating Data
- Using Autofill
- Cutting and Pasting Data
- Copying and Pasting Data
- Paste Transpose
- Adding Rows and Columns
- Deleting Rows and Columns
Protecting Data
- Protecting the Worksheet
- Protecting the Workbook
Basic Importing and Exporting
- Importing a TXT file
- Exporting to PDF
- Exporting to CSV (Comma Separated Value)
Printing Options
- Printing