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 2007 Introduction

Course Summary

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


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Getting Started
      • Understanding the Three Primary Functions of Excel
      • Understanding Spreadsheet Terminology
      • Launching Excel
      • Exploring the Excel Interface
      • Opening a Workbook
      • Examining Formulas
      • Understanding Worksheets
      • Using Zoom
      • Changing Views
      • Navigating Spreadsheets
    • Basic Worksheet Skills
      • Creating a New Workbook
      • Entering Data
      • Selecting Parts of a Workbook
      • Using Multiple Worksheets
      • Using AutoFill
      • Deleting Ranges
      • Using Undo/Redo
      • Deleting a Worksheet
      • Saving a Workbook
    • Creating Formulas
      • Understanding Order of Operations
      • Entering Simple Formulas
      • Using SUM, MAX, and MIN
      • Using AutoSum
      • Using AVERAGE
      • Creating a Formula
      • Working with Date Arithmetic
      • Using AutoCalculate
      • Relative vs. Absolute Cell Adressing
    • Formatting the Worksheet
      • Adjusting Column Width and Row Height
      • Inserting and Deleting Rows and Columns
      • Hiding Rows and Columns
      • Changing Number Formatting
      • Changing Character Formatting
      • Aligning Data
      • Adding Borders and Shading
      • Using Format Painter
      • Using Cell Styles
      • Using Themes
    • Working with Large Worksheets
      • Using Zoom
      • Freezing and Unfreezing Panes
      • Splitting a Window
      • Tiling Multiple Workbooks
      • Using Synchronous Scrolling
    • Using Protection and Comment Boxes
      • Adding and Deleting Comments
      • Locking and Unlocking Cell Ranges
    • Using Page Setup and Printing
      • Using Spell Check
      • Inserting Page Breaks
      • Using Page Break Preview
      • Using Print Preview
      • Changing the Orientation and Margins
      • Working With Print Areas
      • Setting Print Titles
      • Adding Headers and Footers
      • Printing Gridlines and Comments
      • Using the Print Dialog Box
    • 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