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
• The Quick Access Toolbar
• 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
• Quick Access to Cells
• 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
• Headers and Footers
• Page Orientation
• The Print Titles Command
• Scaling Options
• Print Preview
• Outtakes
• Fun with Jennifer

Course Fee:
USD 99

Self-Study

Active

### Workload:

1 - 4 hours / week

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

Related Posts:

## Microsoft Excel

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software