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 & Functions - In depth

### Course Summary

Learn to Use right formula at right place

• +

### Course Syllabus

• An Introduction
• An Introduction
• First thing First - How to Write a Formula in Excel
• How to Write a Formula in Excel
• Sum Functions
• Dealing with one condition - Using SumIF
• For multiple conditions - SumIFs
• Count Functions
• Dont use Count!!!! Always use CountA
• Count number of blank entries using CountBlank
• Count with a condition using COUNTIF
• Count with multiple conditions using COUNTIFS
• Text Functions
• An Into to Basic Text Functions
• Some more Text Functions
• Text to Column - A Complex Function
• Logical Functions - If Functionality
• Understanding IF Function
• Merging IF with AND Function
• Merging IF with OR Function
• Creating a chain of IF functions - Using NESTED IF
• Lookup Functionality - Vlookup, Hlookup, Lookup, etc.
• FIRST THING FIRST - REFERENCES IN EXCEL
• Vlookup with False
• Vlookup with True
• Vlookup with Mixed References
• Vlookup with a Condition
• Hlookup with False
• No "V" No "H" just Lookup
• Index and Match - The power of two
• Date & Time Functions
• The Basics of Date & Time Functions
• Understanding how Excel records and stores dates
• Understanding how Excel records and stores time
• Looking at standard date time entry options and acceptable alternatives
• Using instant date time entry
• Using TODAY and NOW functions for dynamic date time entry
• Using Auto Fill to enter date and time series
• Exploring keystroke shortcuts
• Formatting time for hours over 24
• Creating custom date formatting
• Financial Functions
• Calculate an Installment of a loan using PMT Function
• Calculate Interest Per Period Using IPMT
• Calculate Principal per period Using PPMT
• Calculate Rate of Interest if not known
• Calculate the Term of a Loan Using NPER Function
• Calculate the Present Value Using PV Function
• Create a Loan Table Using above Financial Functions
• Calculate Depreciation in Excel
• Misc. Functions
• Misc. Functions
• Conclusion
• Conclusion

Course Fee:
USD 34

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: