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 - Basic Excel Course

Course Summary

This MS excel training tutorial teaches you basics of MS Excel 2010 using practical excel case studies


  • +

    Course Syllabus

    • Excel for Beginners - Overview
      • Excel 2010 Beginner - Overview
    • Excel 2010: Getting Started
      • Getting Started - Ribbons & Quick Access Toolbar
      • Getting Started - Surfing Excel & HELP Function
      • Getting Started Quiz
    • Case Study
      • Excel Case Study
      • Excel Case Study Quiz
      • Data Entry in Excel
      • Data Entry Quiz
      • Populating the case study - Download excel sheets
      • Populating the Case Study in Excel
      • Populating the Case Study in Excel Quiz
    • Calculations
      • Calculations Working Files - Download These First
      • Calculations - Addition Subtract Multiply Division
      • Calculations Quiz
    • Formulas
      • Formulas Working Files - Download These First
      • Formulas - SUM MAX MIN AVERAGE
      • Formulas Quiz
    • Formatting
      • Formatting - Number Formats Working Files - Download These First
      • Formatting - Number Formats
      • Formatting - Number Formatting Quiz
      • Formatting (Table) Working Files - Download These First
      • Formatting - Table Formats
      • Formatting - Table Format Quiz
    • Updating a Calculation
      • Updating a Calculation Working Files - Download These First
      • Updating a Calculation
      • Updating a Calculation Quiz
    • Percentages & Absolute References
      • Working Files - Download These First
      • Percentages & Absolute References
      • Percentage and Absolute References Quiz
    • Conditional Formatting
      • Conditional Formatting Working Files - Download These First
      • Conditional Formatting
      • Conditional Formatting Quiz
    • IF Function
      • IF Working Files - Download These First
      • IF function
      • IF Function Quiz
    • COUNTIF and SUMIF
      • COUNTIF Working Files - Download These First
      • COUNTIF Function
      • COUNT IF Quiz
      • SUMIF Working Files - Download These First
      • SUMIF Function
      • SUMIF Function Quiz
    • Charts and Graphs
      • Charts and Graphs Working Files - Download These First
      • Creating Charts and Graphs
      • Charts and Graphs Quiz I
      • Pie Charts Working Files - Download These First
      • Create Pie Charts
      • Charts and Graphs Quiz II
    • Sorts and Filters
      • Sorts Working Files - Download These First
      • Sorts
      • SORT Quiz
      • Filters Working Files - Download These First
      • Filters
      • Filter Quiz
    • Pivot Tables
      • Pivot Table Working Files - Download These First
      • Pivot Tables
      • Pivot Table Quiz
    • Freeze and Split
      • Freeze and Split Working Files - Download These First
      • Freeze and Split
      • Freeze and Split Quiz
    • Presentation
      • Presentation I Working Files - Download These First
      • Presentation - Table Formats
      • Presentation Quiz I
      • Presentation II Working Files - Download These First
      • Presentation - Indents and Formatting Charts
      • Presentation Quiz II
    • Print
      • Printing the Worksheet
      • Printing the Worksheet Quiz
      • Printing - Headers and Titles
      • Print Quiz
    • Shortcuts
      • Excel Shortcuts Working Files - Download These First
      • Shortcuts - Formatting and Navigation
      • Shortcut Part I Quiz
      • Shortcuts - Selection, Data and Formula
      • Shortcut Part II Quiz
    • Common Errors
      • Common Errors
      • Common Error Quiz
    • Concluding Lecture
      • Concluding Lecture


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

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