The Resource Excel 2007: Advanced Formulas and Functions

Excel 2007: Advanced Formulas and Functions

Label
Excel 2007: Advanced Formulas and Functions
Title
Excel 2007: Advanced Formulas and Functions
Creator
Contributor
Subject
Language
eng
Summary
In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course
Cataloging source
lynda.com
Characteristic
videorecording
http://library.link/vocab/creatorName
Taylor, Dennis
Government publication
government publication level undetermined
PerformerNote
Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado
http://library.link/vocab/relatedWorkOrContributorName
lynda.com (Firm)
Runtime
317
Technique
live action
Label
Excel 2007: Advanced Formulas and Functions
Link
http://www.lynda.com/Excel-2007-tutorials/advanced-formulas-and-functions/56301-2.html?org=normalpl.org&utm_source=marc
Instantiates
Publication
Copyright
Note
11/25/2009
Carrier category
online resource
Carrier MARC source
rdacarrier
Color
multicolored
Content category
two-dimensional moving image
Content type MARC source
rdacontent
Contents
Demystifies some of the most useful and challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use
Control code
LDC_56301
Dimensions
unknown
Media category
computer
Media MARC source
rdamedia
Reformatting quality
access
Sound
sound
Specific material designation
remote
System details
Latest version of the following browsers: Chrome, Safari,Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScriptand cookies must be enabled. A broadband Internet connection
Label
Excel 2007: Advanced Formulas and Functions
Link
http://www.lynda.com/Excel-2007-tutorials/advanced-formulas-and-functions/56301-2.html?org=normalpl.org&utm_source=marc
Publication
Copyright
Note
11/25/2009
Carrier category
online resource
Carrier MARC source
rdacarrier
Color
multicolored
Content category
two-dimensional moving image
Content type MARC source
rdacontent
Contents
Demystifies some of the most useful and challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use
Control code
LDC_56301
Dimensions
unknown
Media category
computer
Media MARC source
rdamedia
Reformatting quality
access
Sound
sound
Specific material designation
remote
System details
Latest version of the following browsers: Chrome, Safari,Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScriptand cookies must be enabled. A broadband Internet connection

Library Locations

    • Normal Public LibraryBorrow it
      206 W College Ave, Normal, IL, 61761, US
      40.5106271 -88.98660749999999
Processing Feedback ...