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

Learn Microsoft Excel 2010

Course Summary

Impress your colleagues and wow your boss with our Microsoft Excel 2010 Beginners course.


  • +

    Course Syllabus

    • Introduction to Excel
      • Introduction and Overview of Excel 2010 Course
      • Overview of the Excel Window
      • Working with the Mouse
      • Excel Options
    • Creating a New Workbook
      • Entering Text and Numbers
      • Creating Basic Formulas
      • Relative References
      • Order of Operations
      • Working with Ranges
    • Saving Workbooks
      • Working with Save and Save As Commands
      • File Extensions
    • Navigating Workbooks
      • Opening a File
      • Working with Larger Files
      • Freeze Panes Options
      • Split Screen Option
    • Printing
      • Page Setup Options
      • Headers and Footers
      • Print Titles
      • Comments
      • Fit to print on one page
      • Printing Workbooks
    • Working with Rows, Columns, and Cells
      • Adding and Deleting Rows, Columns, and Cells
      • Changing Column and Row Widths
    • Moving Data
      • Cut, Copy and Paste
      • Copying Formulas
    • Formulas and Functions
      • Overview of Formulas
      • Create Formulas using Functions - Part 1
      • Create Formulas using Functions - Part 2
      • Absolute Values
    • Working with Worksheets
      • Adding, Deleting and Renaming Sheets
      • Additional Sheet Tab Options
      • 3-D Formulas
    • Formatting Worksheets
      • Course Review
      • Cell Formatting
      • Number Formatting
      • Borders and Shading
      • Format as Table
      • Using Styles
      • Using Format Painter
      • Protecting Sheets
      • Fill Handle and Custom Lists
    • Charts
      • Creating Charts
      • Types of Charts
      • Editing Charts
      • Using Graphics to Enhance Charts
    • Working with Names
      • Creating Range Names
      • Managing Names
      • Using Names in Formulas
    • Sorting and Filtering
      • Removing Duplicates
      • Sort Data
      • Filter Data
      • Advanced Filters
    • Outlining and Subtotaling
      • Creating an Outline - Part 1
      • Creating an Outline - Part 2
      • Subtotals
    • Working with Views
      • New Window Option
      • Arrange File Options
      • Creating a Workspace
      • Custom Views
      • Scenarios
    • Linking Files
      • Creating Formulas between Files
      • Working with Links
    • Advanced Formula Creation
      • IF Statement
      • VLookups
      • Consolidating Data
      • Data Validation
      • Formula Auditing
    • Additional Excel Features
      • Comments
      • Goal Seeker
      • Text to Columns Option
      • Watch Window
    • Conclusion
      • Closing Video
    • Assessment Test
      • Excel 2010 Quiz


Course Fee:
USD 97

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

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