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 for beginners

Course Summary

The complete excel guide of its kind. Learn in detail all aspects of Excel.


  • +

    Course Syllabus

      • Promo Lecture of Excel
    • Introduction to Excel
      • Introduction
      • Quick demo of Excel - basic functions
    • Excel 2013 skydrive
      • Introduction to cloud & skydrive
    • Versions
      • Versions of excel program
      • Program objectives - Excel menu
    • Features
      • Excel spreadsheet menu features
      • Workbook worksheet explained
      • Keyboard shortcuts for excel
    • Data formats
      • Data formats
      • Autocorrect & column width
      • Spellcheck and Thesauras
      • Cell range
      • Formula
      • Day, month year date difference
      • Reference - relative and absolute
      • Function - arguments - Func without arguments
      • Alignment and format painter
      • Row height - Number format - currency
    • Excel Charts
      • Charting - Excel charts - objectives - features
      • Quick style charts - cell - charts - pictures
      • Quick style contd. Cell, themes
      • Chart elements and chart types
      • chart objects - chart element groups - data labels
      • Headers and footers - charting end review
      • Managing and analyzing a workbook - objectives - features -Abso ref - sheet name
    • Referencing
      • Absolute reference - sheet naming
      • Autofill - sheet reference - find and replace
      • split windows
      • Freeze panes + what if analysis
      • conditional formatting
      • Vlookup
      • Excel model- pivot example
      • Vlookup theory
    • Text functions
      • Concatenate
      • Concatenate demo
      • user feedback
      • All is functions
      • Importing data
      • Importing data
      • Maths functions
      • Maths functions
      • Functions contd.
    • If functions
      • Averageif
      • is functions
      • ISNA function & error handling
    • Vlookup
      • Vlookup +
    • Maths functions
      • Function 1
      • Function 2
      • Function 3
      • Function 4
      • Function 5
      • Function 6
      • Function 7
      • Function 8
      • Function 9
      • Function 10
      • Function 11
      • Function 12
    • Pivot
      • Pivot theory explained
      • Pivot demo
      • Conclusion


Course Fee:
USD 9

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