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

Self-Study

Active