MBA Distance learning

✔ I am Interested in This Course.

I agree to be Contacted

Sample Certificate


Indian : Rs.3835
International : $59
In this Excel 2016 for PC – Frequently Used Formulas & Functions training, we’ll cover how to set up formulas to ensure you’re using all the features Microsoft® Excel® 2016 has to offer.
From using common formulas such as SUM, AVERAGE and IF, to more complicated formulas such as NESTED IF functions, this Excel 2016 for PC – Frequently Used Formulas & Functions series presented by Dan Fanella, PhD, will teach you the common uses for a variety of formulas in Excel. Additionally, we’ll cover how to alter formulas and check for errors.
A. Getting Started & What’s New
  • What you’ll learn
  • IFS

B. Formulas
  • SUM function
  • AVERAGE function
  • COUNT function
  • DATE and NOW functions
  • DAYS function
  • MATCH function
  • TRANSPOSE function
  • ROUND function
  • AND function
  • OR function
  • IF function
  • NESTED function
  • COUNTIF function
  • SUMIF function
  • VLOOKUP function
  • HLOOKUP function
  • Text to columns

C. Linking and Consolidating Worksheets
  • Create a link formula within the same workbook
  • Create a link formula to another workbook
  • Consolidate values from multiple workbooks
  • Consolidate worksheet values within a function
  • Absolute links vs. relative links
  • Consolidate command with multiple sheets
  • Consolidate command with multiple workbooks
  • Open a workbook with external reference formulas
  • Break links to external references

D. Auditing & Error Checking
  • Display formulas
  • Identify precedent cells
  • Identify dependent cells
  • Check for errors
  • Evaluate a formula
1 hr 24 min
Frequently Asked Questions


Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Featured Universities

Our Partners