Lynda.com Excel 2010 Advanced Formulas and Functions
Author:
Dennis Taylor
Duration (hr:min):
05:05
Released on:
2010
Exercise files:
Software works on:
Windows only
In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course.
Topics include:
- Referencing, copying, updating, and converting formulas
- Using the logical functions and creating compound logic tests
- Searching for and matching data based on specific criteria
- Reconfiguring cell data using text functions
- Calculating dates, times, and days of the week
- Analyzing mathematical and financial data
- Using the power functions, COUNTIFS, SUMIFS, and AVERAGEIFS
- Working with rounding functions
- Returning cell references
More Info:
Cheap Windows Software
- ABBYY
- Ableton
- Abvent
- ACDSee
- Acronis
- Adobe
- AllallSoft
- Altova
- Apex
- Ashampoo
- Autodesk
- AVG Anti-virus
- Bigasoft
- Breeze Systems
- Business
- Camtasia Studio
- CD-DVD Software
- CodeGear
- Corel
- Cyberlink
- EMCO
- FileMaker
- GAMES
- Home & Hobby
- Intuit
- Joboshare
- Lynda Training
- Magix
- MakeMusic Finale
- MathCAD
- Maxon Cinema
- Mediachance
- Microsoft
- Navicat
- Nero
- Nicon
- Nik Software
- Norton Symantec
- Nuance
- O&O Software
- Office and Business software
- onOne Products
- Paragon
- PenSoft
- Phase One
- Photo and Graphic Editors
- Pinnacle
- PrimaSoft
- Quark XPress
- Red Giant
- Rosetta Stone
- Roxio
- SiSoftware Sandra
- Smith Micro
- Sony
- Steinberg
- Toon Boom
- Topaz
- TuneUp Utilities
- Utilites and Programming
- VaySoft
- Video and Audio Editors
- VMware
- WinZip
- Xara
Cheap Macintosh Software
- ABBYY
- AceReader
- Activata
- Adobe
- Apimac
- app4mac
- Apple Macintosh
- Aquafadas
- Autodesk for MAC
- Avid
- CD-DVD Software
- Church
- ClickOnTyler
- Code Line
- Creativebe
- Emulation
- FabFilter
- FileMaker
- GAMES
- Hardcoded Software
- Home & Hobby for MAC
- IK Multimedia
- Intuit for MAC
- Ironic
- iSkysoft
- JS8 Media
- Jumsoft
- KavaSoft
- Koingo
- Limit Point Software
- Lynda Training
- MacX
- MakeMusic Finale for MAC
- Maps
- Mariner
- Maxon Cinema for MAC
- McAfee Anti-virus
- Mesa Dynamics
- Metaobject
- Microsoft for MAC
- Native Instruments
- Navicat
- Norton AntiVirus for MAC
- Nuance for MAC
- Office and Business software for MAC
- Parallels
- Photo and Graphic Editors
- Positive Team
- PSPAudioware
- Public Space
- Quark XPress
- Re:VisionEffects
- Realmac Software
- Red Sweater
- RedGiant
- Rogue Amoeba
- Roni Music
- Rosetta Stone
- Roxio
- Sibelius
- SmileOnMyMac
- StuffIt
- Synium
- The Little App Factory
- Topaz
- Utilites and Programming
- Video and Audio Editors
- VMware
- ZappTek
Secure Shopping
Our mission is to provide our clients with 100% full working retail versions of all OEM programs — no demos or academic versions!
