State Employees: Training Classes for ND State Employees
Excel 2010 Module 1
Prerequisite
Basic computer skills - use of mouse, keyboard, and understanding of Windows.
Lesson 1: Introduction to Excel
- Overview of Workbooks and Worksheets
- Starting Excel
- Navigating Worksheets
- Selecting Ranges
- Using Toolbars and Menus
- Quitting Excel
Lesson 2: Creating Workbooks
- About Workbooks
- Opening New Workbooks
- Entering Data
- Editing Data
- Saving and Closing New Workbooks
Lesson 3: Modifying Worksheets
- Introduction to Modifying Worksheets
- Opening Existing Workbooks
- Copying Worksheet Data
- Moving Worksheet Data
- Deleting Worksheet Data
- Saving Existing Workbooks
Lesson 4: Formatting Worksheets
- Introduction to Formatting Worksheets
- Inserting and Deleting Cells
- Inserting and Deleting Rows and Columns
- Adjusting Column Widths and Row Heights
- Hiding and Unhiding Rows and Columns
- Applying Numeric Formats
- Aligning Cell Data
Lesson 5: Printing Worksheets
- Introduction to Printing Worksheets
- Checking Spelling
- Previewing Worksheets
- Previewing Page Breaks
- Printing Worksheets
Lesson 6: Working with Formulas
- About Formulas
- Creating Formulas
- Editing Formulas
- Using Cell References
Lesson 7: Working with Basic Functions
- About Functions
- Using the AutoSum Feature
- Using the AVERAGE Function
- Using the MAX Function
- Using the MIN Function
- Using the Function Wizard
- Using the AutoCalculate Feature
Lesson 8: Enhancing Worksheets
- Introduction to Enhancing Worksheets
- Changing Fonts and Text Attributes
- Merging and Splitting Cells
- Rotating Text in Cells
- Indenting Text in Cells
- Adding and Modifying Borders
- Adding Background Shading
- Working with Graphics
- Working with Diagrams
Lesson 9: Using Templates, Styles, Worksheet Backgrounds and AutoFormats
- About Templates, Styles, Worksheet Backgrounds and AutoFormats
- Creating Workbooks from Templates
- Using Styles
- Adding Worksheet Backgrounds
- Applying AutoFormats
Lesson 10: Finding and Replacing Data
- Introduction to Finding and Replacing Data
- Finding and Opening Existing Workbooks
- Finding and Replacing Text
- Finding and Replacing Numeric Data
- Finding and Replacing Cell Formats
- Using the Research Tool
