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 Formulas

Course Summary

Excel vlookup and pivot training. by Jay Dhruv.


  • +

    Course Syllabus

      • Promo
    • Introduction to Excel
      • Introduction to Excel
      • Quick demo of Excel - basic functions
    • Excel 2013 - Cloud storage and skydrive
      • Introduction to cloud & skydrive
    • Excel Versions over the years
      • Versions of excel program
      • Program objectives - Excel menu
    • Excel Features
      • Excel spreadsheet menu features .
    • Excel Reference
      • Workbook worksheet explained.
      • Keyboard shortcuts for excel
      • Data formats
      • Autocorrect & column width
      • Spellcheck and Thesauras
    • Formulas and Functions
      • 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 Charting
      • 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
      • Absolute reference - sheet naming
      • Autofill - sheet reference - find and replace
      • split windows
      • Freeze panes + what if analysis
    • What If & Goal seek
      • What if analysis - goal seek function.
      • conditional formatting
    • Vlookup & pivot
      • Vlookup -
      • Excel model- pivot example
      • Vlookup theory
      • Concatenate
      • Concatenate demo.
      • user feedback
    • Excel Formulas and Functions
      • All is functions
      • Importing data
      • Importing data.
      • Maths functions
      • Maths functions - contd.
      • Averageif
      • is functions
      • ISNA function & error handling.
      • Vlookup +
    • Excel 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.
      • 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