Video description
In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel. You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries. By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.
Product information
- Title: Microsoft Excel - Advanced Formulas And Functions
- Author(s):
- Release date: September 2013
- Publisher(s): Infinite Skills
- ISBN: 9781771371483
You might also like
book
Microsoft Excel 2019 Formulas and Functions, First Edition
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more …
book
Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
Expert Paul McFedries helps you master key Excel tools for building more powerful spreadsheets. Use Excel …
book
Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 …
video
Advanced Microsoft Excel 2010
In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners …