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
MAXIFS and MINIFS
DATE and NOW functions
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
Identify precedent cells
Identify dependent cells
Check for errors
Evaluate a formula
1 hr 24 min
Frequently Asked Questions
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.