MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Introduction to Microsoft Excel 2010

### Course Summary

Learn the basics of Microsoft Excel 2010 in this interactive course!

• +

### Course Syllabus

• Class Files
• Creating a Microsoft Excel Workbook
• Starting Microsoft Excel
• The Status Bar
• Closing a Workbook
• Starting Microsoft Excel
• Creating a Microsoft Excel Workbook
• Exercise Solution
• The Ribbon
• Tabs
• Groups and Commands
• The Ribbon Review
• Exploring the Ribbon
• The Backstage View (The File Menu)
• Introduction to the Backstage View
• Opening a Workbook
• Backstage View Review
• Open a Workbook
• Exercise Solution
• New Workbooks and Excel Templates
• Excel Templates Review
• Select, Open and Save a Template Agenda
• Exercise Solution
• Printing Worksheets
• Print a Worksheet
• Exercise Solution
• Getting Help
• Getting Help Review
• Using Help
• Exercise Solution
• Adding Ribbon Commands or Groups
• Placement
• Exercise Solution
• Entering Data in Microsoft Excel Worksheets
• Data Introduction
• Entering Text
• Using AutoComplete
• Entering Data Review
• Entering Text and Using AutoComplete
• Exercise Solution
• Entering Numbers and Dates
• Using the Fill Handle
• Entering Numbers and Dates Review
• Entering Numbers and Dates (Exercise)
• Exercise Solution
• Formatting Microsoft Excel Worksheets
• Formatting Introduction
• Selecting Ranges of Cells
• The Font Group
• Formatting Review
• Working with Font Group Commands
• Exercise Solution
• The Alignment Group
• Alignment Group Review
• Working with Alignment Group Commands
• Exercise Solution
• The Number Group
• Number Group Review
• Working with Number Group Commands
• Exercise Solution
• Using Formulas in Microsoft Excel
• Math Operators and the Order of Operations
• Entering Formulas
• AutoSum (and Other Common Auto-Formulas)
• Copying Formulas and Functions
• Relative and Absolute Cell References
• Formulas Review
• Working with Formulas
• Exercise Solution
• Working with Rows and Columns
• Inserting Rows and Columns
• Deleting Rows and Columns
• Inserting/Deleting Rows and Columns
• Setting Row Height and Column Width
• Hiding and Unhiding Rows and Columns
• Freezing Panes
• Rows and Columns Review
• Working with Rows and Columns
• Exercise Solution
• Editing Worksheets
• Find
• Find and Replace
• Find and Replace Review
• Using Find and Replace
• Exercise Solution
• Using the Clipboard
• Clipboard Review
• Using the Clipboard (Exercise)
• Exercise Solution
• Finalizing Microsoft Excel Worksheets
• Setting Margins and Page Orientation
• Margins and Page Orientation Review
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Print Area Review
• Preparing to Print
• Exercise Solution

Course Fee:
USD 49

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: