Description
Excel Level 1 is a one-day instructor-led class that takes students through the basic concepts and skills needed to be productive and efficient in Microsoft Excel. Providing a thorough introduction to the Excel interface. Then getting into worksheet features that build comfortability using the program. Participants will also learn to use basic formulas and functions while learning to format their data. By the end of this Excel Level 1 course, participants will be able to swiftly create and edit worksheets and workbooks, perform basic formulas and functions. Including how to format, manipulate, print, and protect their data. This course features units on:
Excel Basics
- Navigating/Workbook Basics
Worksheets
- Entering Data
- Entering Basic Formulas & Functions
- SUM, AVERAGE, MIN, MAX, COUNT
- AutoSum Feature
- Cell Reference Types
- Relative, Absolute, Mixed
Formatting
- Text & Number Formatting
- Alignment
- Styles & Themes
- Cell Styles
- Themes
Manipulating Data
- Data Entry Shortcuts
- Fill, Autofill
- Paste Options
- Paste Link, Paste Transpose
- Inserting/Deleting/Hiding Rows & Columns
Protecting Data
- Protection: Worksheet and Workbook
Basic Importing
Output
- Worksheet Windows
- Printing Worksheets
- Saving workbooks in different formats