State of Wyoming A&I Human Resources Division

Calendar Event: EXCEL Level 1

• Location:Emerson Building Room B11
• Start Time:5/14/2012 8:30 AM
• End Time:5/14/2012 4:00 PM
• Description:
  LESSON 1 - EXPLORING EXCEL
  Working with Excel
  Starting Excel
  Using the Interface
  Using the Office Button
  Exploring Excel Options
  Working with Worksheets
  Using the Ribbon
  Hiding the Ribbon
  Customizing the Quick Access Toolbar
  Using the Mini Toolbar
  Customizing the Status Bar
  LESSON 2 - USING BASICWORKBOOK SKILLS
  Selecting a Cell using the Keyboard
  Using KeyTips
  Scrolling using the Mouse
  Using the Scroll Bar Shortcut Menu
  Using the Go To Dialog Box
  Entering Text into Cells
  Entering Numbers into Cells
  Saving a New Workbook
  Closing a Workbook
  Creating a New Workbook
  Using a Template
  Opening an Existing Workbook
  Using Data Entry Shortcuts
  Editing Cell Entries
  Checking Worksheet Spelling
  Creating a New Folder
  Renaming an Existing Workbook
  LESSON 3 - WORKING WITH RANGES
  Using Ranges
  Selecting Ranges with the Mouse
  Selecting Ranges with the Keyboard
  Selecting Non-adjacent Ranges
  Entering Values into a Range
  Using the Auto Fill Feature
  LESSON 4 - CREATING SIMPLE FORMULAS
  Using Formulas
  Entering Formulas
  Using Functions
  Using the AutoSum Button
  Using the AutoSum List
  Using Formula AutoComplete
  Inserting Functions in Formulas
  Editing Functions
  Using the AutoCalculate Featur
  Using Range Borders to Modify Formulas
  Checking Formula Errors
  LESSON 5 - COPYING AND MOVING DATA
  Copying/Cutting and Pasting Data
  Copying and Pasting Formulas
  Using the Paste Options Button
  Using the Paste List
  Using the Clipboard Task Pane
  Creating an Absolute Reference
  Filling Cells
  Using Drag-and-Drop Editing
  Using Undo and Redo
  LESSON 6 - PRINTING
  Previewing a Worksheet
  Printing the Current Worksheet
  Printing a Selected Range
  Printing a Page Range
  Printing Multiple Copies
  LESSON 7 - USING PAGE SETUP
  Setting Margin and Centering Options
  Changing Page Orientation and Paper Size
  Repeating Row and Column Labels
  Scaling a Worksheet
  Changing Page Breaks
  Setting/Removing a Print Area
  Changing Sheet Options
  Creating Headers and Footers
  Using Built-in Headers and Footers
  LESSON 8 - FORMATTING NUMBERS
  Using Number Formats
  Using the Accounting Number Style
  Using the Percent Style
  Using the Comma Style
  Changing Decimal Places
  LESSON 9 - FORMATTING TEXT
  Formatting Cell Text
  Changing an Existing Font
  Modifying the Font Size
  Using Bold and Italics
  Underlining Text
  Changing the Font Color
  Rotating Text in a Cell
  Wrapping Text in a Cell
  Shrinking Text in a Cell
  Changing Cell Alignment
  Changing Text Indentation
  LESSON 10 - FORMATTING CELLS
  Using the Merge and Center Button
  Changing the Vertical Alignment
  Splitting Cells
  Using the Borders Button
  Drawing Cell Borders
  Using the Fill Color Button
  Pasting Formats
  Using the Format Painter Button
  Copying Formats to Non-Adjacent Cells
  Clearing Formats
  Inserting Selected Cells
  Inserting Cut or Copied Cells
  Deleting Selected Cells
  
• Category:Training