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

Vlookup secrets

Course Summary

Excel vlookup, formulas for 2007, 2010, 2013. all versions covered


  • +

    Course Syllabus

      • Promo
    • Promo
      • Introduction to Excel
      • Quick demo of Excel - basic functions
    • Excel Skydrive cloud storage
      • Introduction to cloud & skydrive
    • Excel 2007 to 2013
      • Versions of excel program
      • Program objectives - Excel menu
      • Excel spreadsheet menu features
    • Features
      • Workbook worksheet explained
      • Keyboard shortcuts for excel
      • 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
    • Excel Formulas
      • Managing and analyzing a workbook - objectives - features -Abso ref - sheet name
    • Cell reference
      • Absolute reference - sheet naming
      • Autofill - sheet reference - find and replace
      • split windows
      • Freeze panes + what if analysis
      • What if analysis - goal seek function
      • conditional formatting
    • Vlookup
      • Vlookup
      • Excel model- pivot example
      • Vlookup theory
      • Concatenate
      • Concatenate demo
      • user feedback
      • All is functions
      • Importing data
      • Importing data
      • Maths functions
      • Maths functions - contd.
      • Averageif
      • Conclusion


Course Fee:
USD 19

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