X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
Excel2016_Frequently_Used_Formulas_Functions.jpg

Excel 2016 for PC - Frequently Used Formulas and Functions

Indian : Rs.3835
International : $59
INTRODUCTION
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.
OBJECTIVE
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.
CONTENT
A. Getting Started & What’s New
  • What you’ll learn
  • TEXTJOIN
  • IFS
  • MAXIFS and MINIFS

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
  • CONCATENATE (CONCAT) 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
LENGTH
1 hr 24 min
Frequently Asked Questions


traingtoatalcrse.png

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

Our Partners

×