|
Provided by: MicroTrain Microsoft Office Excel Level 1Computer |
 |
Training
Provided by MicroTrain
For superior Microsoft Office Excel Level 1 training in the heart of Chicago, MicroTrain is your educational connection. Our instructor led one day class will save you time learning Excel level 1 and get you up to speed fast. Microtrain only uses professional trainers in our state of the art comfortable class rooms. Please check out our schedule at www. microtrain. net
If you're charged with finding the Excel training class for your company's professionals, MicroTrain is the only name you need. Contact a representative today at 888-737-8512 to set up a personal consultation on your company's specific computer training needs and they'll point you in the right direction. They'll guide you through their many options that will take your company forward simply and affordably. Give MicroTrain a call today.
Related Software Programs or Products: Microsoft Office Excel
Related Awards, Degrees or Certifications: Microsoft Office Specialist
|
|
||||||||||
Microsoft Office Excel Level 1
Chapter One: The Fundamentals
Lesson 1 1: Starting Excel
Lesson 1 2: What's New in Excel 2003?
Lesson 1 3: Understanding the Excel Program Screen
Lesson 1 4: Using Menus
Lesson 1 5: Using Toolbars and Creating a New Workbook
Lesson 1 6: Filling Out Dialog Boxes
Lesson 1 7: Keystroke and Right Mouse Button Shortcuts
Lesson 1 8: Opening a Workbook
Lesson 1 9: Saving a Workbook
Lesson 1 10: Moving the Cell Pointer
Lesson 1 11: Navigating a Worksheet
Lesson 1 12: Entering Labels in a Worksheet
Lesson 1 13: Entering Values in a Worksheet and Selecting a Cell Range
Lesson 1 14: Calculating Value Totals with AutoSum
Lesson 1 15: Entering Formulas
Lesson 1 16: Using AutoFill
Lesson 1 17: Previewing and Printing a Worksheet
Lesson 1 18: Getting Help
Lesson 1 19: Changing the Office Assistant and Using the "What's This" Button
Lesson 1 20: Closing a Workbook and Exiting Excel
Chapter Two: Editing a Worksheett
Lesson 2 1: Entering Date Values and using AutoComplete
Lesson 2 2: Editing, Clearing, and Replacing Cell Contents
Lesson 2 3: Cutting, Copying, and Pasting Cells
Lesson 2 4: Moving and Copying Cells with Drag and Drop
Lesson 2 5: Collecting and Pasting Multiple Items
Lesson 2 6: Working with Absolute and Relative Cell References
Lesson 2 7: Using the Paste Special Command
Lesson 2 8: Inserting and Deleting Cells, Rows, and Columns
Lesson 2 9: Using Undo, Redo, and Repeat
Lesson 2 10: Checking Your Spelling
Lesson 2 11: Finding and Replacing Information
Lesson 2 12: Advanced Printing Options
Lesson 2 13: File Management
Lesson 2 14: Inserting Cell Comments
Lesson 2 15: Understanding Smart Tags
Lesson 2 16: Recovering Your Workbooks
Chapter Three: Formatting a Worksheet
Lesson 3 1: Formatting Fonts with the Formatting Toolbar
Lesson 3 2: Formatting Values
Lesson 3 3: Adjusting Row Height and Column Width
Lesson 3 4: Changing Cell Alignment
Lesson 3 5: Adding Borders
Lesson 3 6: Applying Colors and Patterns
Lesson 3 7: Using the Format Painter
Lesson 3 8: Using AutoFormat
Lesson 3 9: Creating a Custom Number Format
Lesson 3 10: Creating, Applying, and Modifying a Style
Lesson 3 11: Formatting Cells with Conditional Formatting
Lesson 3 12: Merging Cells, Rotating Text, and using AutoFit
Lesson 3 13: Finding and Replacing Formatting
Chapter Four: Managing Your Workbooks
Lesson 4 1: Switching Between Sheets in a Workbook
Lesson 4 2: Inserting and Deleting Worksheets
Lesson 4 3: Renaming and Moving Worksheets
Lesson 4 4: Working with Several Workbooks and Windows
Lesson 4 5: Splitting and Freezing a Window
Lesson 4 6: Referencing External Data
Lesson 4 7: Creating Headers, Footers, and Page Numbers
Lesson 4 8: Specifying a Print Area and Controlling Page Breaks
Lesson 4 9: Adjusting Page Margins and Orientation
Lesson 4 10: Adding Print Titles and Gridlines
Lesson 4 11: Changing the Paper Size and Print Scale
Lesson 4 12: Protecting a Worksheet
Lesson 4 13: Hiding Columns, Rows and Sheets
Lesson 4 14: Viewing a Worksheet and Comparing Workbooks Side by Side
Lesson 4 15: Saving a Custom View
Lesson 4 16: Working with Templates
Lesson 4 17: Consolidating Worksheets
Lesson 1 1: Starting Excel
Lesson 1 2: What's New in Excel 2003?
Lesson 1 3: Understanding the Excel Program Screen
Lesson 1 4: Using Menus
Lesson 1 5: Using Toolbars and Creating a New Workbook
Lesson 1 6: Filling Out Dialog Boxes
Lesson 1 7: Keystroke and Right Mouse Button Shortcuts
Lesson 1 8: Opening a Workbook
Lesson 1 9: Saving a Workbook
Lesson 1 10: Moving the Cell Pointer
Lesson 1 11: Navigating a Worksheet
Lesson 1 12: Entering Labels in a Worksheet
Lesson 1 13: Entering Values in a Worksheet and Selecting a Cell Range
Lesson 1 14: Calculating Value Totals with AutoSum
Lesson 1 15: Entering Formulas
Lesson 1 16: Using AutoFill
Lesson 1 17: Previewing and Printing a Worksheet
Lesson 1 18: Getting Help
Lesson 1 19: Changing the Office Assistant and Using the "What's This" Button
Lesson 1 20: Closing a Workbook and Exiting Excel
Chapter Two: Editing a Worksheett
Lesson 2 1: Entering Date Values and using AutoComplete
Lesson 2 2: Editing, Clearing, and Replacing Cell Contents
Lesson 2 3: Cutting, Copying, and Pasting Cells
Lesson 2 4: Moving and Copying Cells with Drag and Drop
Lesson 2 5: Collecting and Pasting Multiple Items
Lesson 2 6: Working with Absolute and Relative Cell References
Lesson 2 7: Using the Paste Special Command
Lesson 2 8: Inserting and Deleting Cells, Rows, and Columns
Lesson 2 9: Using Undo, Redo, and Repeat
Lesson 2 10: Checking Your Spelling
Lesson 2 11: Finding and Replacing Information
Lesson 2 12: Advanced Printing Options
Lesson 2 13: File Management
Lesson 2 14: Inserting Cell Comments
Lesson 2 15: Understanding Smart Tags
Lesson 2 16: Recovering Your Workbooks
Chapter Three: Formatting a Worksheet
Lesson 3 1: Formatting Fonts with the Formatting Toolbar
Lesson 3 2: Formatting Values
Lesson 3 3: Adjusting Row Height and Column Width
Lesson 3 4: Changing Cell Alignment
Lesson 3 5: Adding Borders
Lesson 3 6: Applying Colors and Patterns
Lesson 3 7: Using the Format Painter
Lesson 3 8: Using AutoFormat
Lesson 3 9: Creating a Custom Number Format
Lesson 3 10: Creating, Applying, and Modifying a Style
Lesson 3 11: Formatting Cells with Conditional Formatting
Lesson 3 12: Merging Cells, Rotating Text, and using AutoFit
Lesson 3 13: Finding and Replacing Formatting
Chapter Four: Managing Your Workbooks
Lesson 4 1: Switching Between Sheets in a Workbook
Lesson 4 2: Inserting and Deleting Worksheets
Lesson 4 3: Renaming and Moving Worksheets
Lesson 4 4: Working with Several Workbooks and Windows
Lesson 4 5: Splitting and Freezing a Window
Lesson 4 6: Referencing External Data
Lesson 4 7: Creating Headers, Footers, and Page Numbers
Lesson 4 8: Specifying a Print Area and Controlling Page Breaks
Lesson 4 9: Adjusting Page Margins and Orientation
Lesson 4 10: Adding Print Titles and Gridlines
Lesson 4 11: Changing the Paper Size and Print Scale
Lesson 4 12: Protecting a Worksheet
Lesson 4 13: Hiding Columns, Rows and Sheets
Lesson 4 14: Viewing a Worksheet and Comparing Workbooks Side by Side
Lesson 4 15: Saving a Custom View
Lesson 4 16: Working with Templates
Lesson 4 17: Consolidating Worksheets
About The Training Provider: MicroTrain
MicroTrain - MicroTrain core business is training. We offer courses ranging from a one day application courses to advanced Project Management training. We are an Microsoft Gold Partner for Learning Solutions, CompTIA member, Red Hat Partner, IBM Reseller, Global Partner and PMI Global Registered Education Provider. MicroTrain also provides computer room rentals.
