Learn different Functions from Microsoft Certified trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Functions explained in most logical and simplest manner
Downloadable exercise files for practical learning
Microsoft Excel 2007/2010/2013
In this Excel Formulas and Functions - In depth video course, Nurture Tech Academy introduces you to the most simplest and logical way to understand most of the Excel functions.
In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with how to write a Formula in Excel and starts with basic formulas like Sum and Count then gradually move to the complex one like IF, IF with And, IF with OR, Nested IF. Then it will cover the whole Lookup Functionality. Financial Functions will be covered there after with Date & Time Functions.
By the completion of this online training course, you will be fully versed, and capable of using most of the Formulas & Functions in Microsoft Excel 2007/2010/2013 in a commercial Environment.
Who this course is for:
Working Professionals & Students
11 sections • 43 lectures • 3h 36m total length
For multiple conditions - SumIFs
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
An Into to Basic Text Functions
Some more Text Functions
Text to Column - A Complex Function
Understanding IF Function
Merging IF with AND Function
Merging IF with OR Function
Creating a chain of IF functions - Using NESTED IF
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
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
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
Nurture Tech Academy was founded in 2009. Its a Microsoft Authorised Testing Centre, providing a blend of instructor-led and online training programs in Basic Excel, Advanced Excel, VBA, Macros, and other MS Office applications. It has a team of Microsoft Certified Trainers who are specialist in their respective fields. All trainers have a 9+ yrs. of training experience.