Excel 2016: Advanced Formulas and Functions.
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2016.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
1/28/201612:00:00AM
Participants/Performers
Presenter: Dennis Taylor
Description
Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
Description
Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
Taylor, D. (2016). Excel 2016: Advanced Formulas and Functions . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Taylor, Dennis. 2016. Excel 2016: Advanced Formulas and Functions. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Taylor, Dennis. Excel 2016: Advanced Formulas and Functions linkedin.com, 2016.
MLA Citation, 9th Edition (style guide)Taylor, Dennis. Excel 2016: Advanced Formulas and Functions linkedin.com, 2016.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.