In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft. You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines.
In this Advanced AutoCAD 2013 training course, expert author Brian Benton will teach you more advanced features and concepts that you can apply to your CAD drawings, allowing you to complete more complex projects. This course is aimed towards the student that already has a basic working knowledge of AutoCAD, or has completed the Learning AutoCAD 2013 course from Infinite Skills.
In this Advanced SolidWorks training course, trainer Matt Lombard takes you beyond the basic techniques and tools in SolidWorks 2013 and shows you how to take your SolidWorks skills to the next level. This tutorial is designed for users that already have a basic understanding of SolidWorks, or have already taken the Learning SolidWorks 2013 course from Infinite Skills.
In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but Guy breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners video training.
In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners Excel 2010 tutorial by delving even deeper into this powerful spreadsheet software. Microsoft Excel 2010 is much more than a quick way to add up numbers. In this video based tutorial, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.