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

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

Related Posts:

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