Excel for Mac 2016: Advanced Formulas and Functions

Excel for Mac 2016: Advanced Formulas and Functions

Streaming Video - 2016
Rate this:
Master Excel formulas and functions—once and for all. Get tips for using the most challenging of the 450+ functions in Excel for Mac 2016.
Conquer some of the most daunting features in Microsoft Excel: formulas and functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor presents numerous formulas and functions in Excel and shows how to use them efficiently. The course begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. Dennis then covers how to perform logical tests with the IF, AND, OR, and NOT functions; search and retrieve data with lookup functions (VLOOKUP, MATCH, and INDEX); analyze data with statistical functions; use text functions to clean up worksheets; work with array formulas and functions, and master date and time calculations. Dennis focuses on practical examples that transition effortlessly to real-world scenarios. Start watching to take advantage of the tremendous power offered by Excel formulas and functions.
Publisher: Carpenteria, CA lynda.com, 2016.
Copyright Date: ©2016
Branch Call Number: lynda.com
Characteristics: 1 online resource (streaming video)
Additional Contributors: Lynda.com (Firm)

Opinion

From the critics


Community Activity

Comment

Add a Comment

There are no comments for this title yet.

Age

Add Age Suitability

There are no ages for this title yet.

Summary

Add a Summary

There are no summaries for this title yet.

Notices

Add Notices

There are no notices for this title yet.

Quotes

Add a Quote

There are no quotes for this title yet.

Explore Further

Recommendations

Subject Headings

  Loading...

Find it at WCCLS

  Loading...
[]
[]
To Top