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

# Excel 2010 for Beginners

### Course Summary

Master Excel basics in this easy to follow, step-by-step course.

• +

### Course Syllabus

• Intro Excel Beginner
• Getting started with Excel 2010
• Introduction
• Open and Close Excel
• The Excel Application Window
• Zoom In and Out
• The Ribbon
• Summary Section 1
• Excel Templates
• Introduction to Help
• The Help Function
• Summary Help
• Expand, Minimize and Move Windows
• Navigating the Worksheet
• Select Elements of a Table
• The General Pane
• The Save Pane
• Best Practices Pane + auto recovery
• Input Numbers, Dates and Text into Cells
• Save in a Different File Type
• Create and Open Workbooks
• Save and Close Workbooks
• Save Options
• Summary Save Options
• Basic Table Editing
• Performing Calculations in an Excel Worksheet - Overview
• Create Formulas in a Worksheet
• The Sum Function
• The Average, Minimum and Maximum Function
• The Count Function
• The Round Function
• Change and Delete Cell Contents
• Relative References
• Absolute References
• Summary Section 2
• Modifying a Worksheet
• Introduction to Basic Table Editing
• The Undo and Redo Commands
• Find and Replace Cells
• Add and Delete New Worksheets
• Column Width and Row Height
• Insert and Delete Columns, Rows and Cells
• Show and Hide Colums and Rows
• Print Worksheets
• Switching between Worksheets
• Copy, Move and Rename Worksheets
• Switch between Open Windows
• Modifying the Appearance of a Worksheet
• Introduction to Basis Cell Formatting
• Font Size and Type
• Bold, Italic and Underline
• Format Painter
• Cell Borders
• Cell Color
• Alignment Options
• Line Break
• The Merge Feature
• Decimals
• Percent
• Insert and Format Time and Date
• Apply Cell Styles
• Summary Section 4
• More Functions
• The Function Wizard
• The IF Function
• The Nested IF Function
• VLOOKUP and HLOOKUP
• Standard Error Message
• Formula Auditing
• Simple Time Calculation
• Work with Date and Time Functions
• Printing Excel Workbooks
• Introduction to Printing
• Page Margins
• Page Breaks
• Page Orientation
• The Print Titles Command
• Scaling Options
• Print Preview
• Outtakes
• Fun with Jennifer

Course Fee:
USD 99

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: