Guy Vaccaro, an expert in Microsoft Excel Advanced Formulas and Functions, takes you beyond the basics and teaches how to use the advanced functions and formulas in this spreadsheet program from Microsoft. This course is for Excel users who already have basic Excel knowledge. The course will start with a review of the basics, including sum and count syntax and order of function processing. Extended formula usage will be covered with 3D referencing, naming cell and absolute referencing. Guy will then show you how to use VLookup and/or HLookup to find and reference type functions. This computer-based training also covers how to generate random numbers and values, locate data using text functions, and use an array formula for counting unique entries. After completing this course, you will be able to use many of the advanced functions and formulas that Microsoft's powerful spreadsheet software offers. You can follow along with the author through the lessons by downloading working files.
