State Employees: Training Classes for ND State Employees
Excel 2010 Module 2
Prerequisite
Basic computer skills - use of mouse, keyboard, and understanding of Windows.
Lesson 1: Working with Multiple Worksheets
- About Working with Multiple Worksheets
- Organizing Multiple Worksheets
- Renaming Worksheet Tabs
- Coloring Worksheet Tabs
- Consolidating Data from Multiple Worksheets
Lesson 2: Adjusting the Screen Display
- Adjusting the Display of Workbooks and Worksheets
- Working with Multiple Workbooks
- Splitting and Freezing Worksheet Panes
- Adjusting the Zoom Setting
- Displaying and Hiding Toolbars
Lesson 3: Working with Advanced Functions
- The Function Wizard
- Using the NOW Function
- Using the DATE Function
- Using the HLOOKUP and VLOOKUP Functions
- Using the IF Function
- Using the PMT Function
Lesson 4: Using Advanced Formatting Features
- Creating Custom Number Formats
- Using Conditional Formatting
- Formatting Graphics
- Formatting Diagrams
- Grouping and Outlining Data
Lesson 5: Using Advanced Print Options
- Controlling the Appearance of Printed Pages
- Adjusting Page Scaling and Orientation
- Changing Margin Widths
- Creating Headers and Footers
- Inserting Page Breaks
- Setting Print Areas
- Printing Repeating Rows and Columns
- Controlling the Display of Cell Error Messages
- Printing Multiple Worksheets
- Printing Entire Workbooks
Lesson 6: Filtering Data and Using Comments
- Filtering Data
- Working with Comments
Lesson 7: Naming Worksheet Ranges and Formulas
- Working with Names
- Naming Ranges
- Using Range Names in Formulas
- Creating Three-Dimensional References
- Naming Formulas
- Deleting Range Names
Lesson 8: Working with Charts
- Introduction to Charts
- Creating Charts
- Moving and Resizing Charts
- Formatting Charts
- Changing Chart Types
- Editing Chart Data
- Printing Charts
Lesson 9: Protecting Data
- Introduction to Protecting Data
- Protecting Workbooks
- Protecting Worksheets
- Protecting Cells
- Protecting Ranges
- Hiding Data
- Assigning Passwords to Workbooks
Lesson 10: Using Basic Integration and Web Features
- Importing Data from Text Files
- Importing Data from Microsoft Word 2003
- Creating and Modifying Hyperlinks
- Exporting Excel Data to Microsoft Word 2003
- Saving Worksheets and Workbooks as Web Pages
- Publishing Worksheets and Workbooks to the Web
