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 Introduction

Course Summary

All you need to know to unleash the power of Excel spreadsheets


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Getting Started
      • Three Primary Functions of Excel
      • Spreadsheet Terminology
      • Overview of the Excel Screen
      • Navigating a Worksheet
      • Using Zoom
    • Basic Worksheet Skills
      • Creating a New Workbook
      • Entering Data
      • Selecting a Range
      • Selecting Columns, Rows and Non-contiguous Cells
      • Using Worksheets
      • Using AutoFill
      • Deleting a Worksheet
      • Saving a Workbook
    • Creating Formulas
      • Entering a Simple Formula
      • Using Cell Addresses in a Formula
      • Using Simple Functions: SUM
      • Using Autofill with Formulas
      • Using AutoSum
      • Inserting Functions: AVERAGE, MAX, MIN, COUNT
      • Working with Date Arithmetic
      • Date and Currency Formatting
      • Using Clear All
      • Relative v. Absolute Cell Addressing
      • AutoCalculate
    • Editing a Workbook
      • Deleting a Range
      • Using Undo and Redo
      • Using Cut, Copy and Paste
      • Using Paste Options
      • Using the Clipboard Task Pane
      • Using Find and Replace
    • Formatting the Worksheet
      • Inserting and Deleting Columns and Rows
      • Adjusting Column Widths and Row Heights
      • Hiding Rows and Columns
      • Changing Numeric Formats
      • Using the Format Cells Dialog Box
      • Changing Text Formats
      • Aligning Data
      • Using Borders and Shading
      • Using the Format Painter
      • Using Cell Styles
      • Creating New Cell Styles
      • Modifying Cell Styles
      • Using Themes
    • Working with Large Worksheets or Multiple Workbooks
      • Using the Zoom Feature
      • Splitting the Window
      • Freeze and Unfreeze Panes
      • Tiling Multiple Workbooks
      • Synchronous Scrolling
      • Hiding, Maximizing, and Closing Windows
    • Using Protection and Comment Boxes
      • Adding, Hiding, and Deleting Comments
      • Locking and Unlocking Cell Ranges
    • Printing and Page Setup
      • Using Page Break Preview
      • Using Print Preview
      • Changing the Orientation
      • Changing the Margins
      • Adding Headers and Footers
      • Setting Sheet Options
      • Setting Print Titles
      • Working with Print Areas
      • Using the Page Layout Tab
    • Conclusion
      • Conclusion


Course Fee:
USD 30

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

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
Hidden Image Url

Back to Top