Search -
The Microsoft Excel Step-By-Step Training Guide Book Bundle (The Microsoft Excel Step-By-Step Training Guide Series) (Volume 4)
The Microsoft Excel StepByStep Training Guide Book Bundle - The Microsoft Excel Step-By-Step Training Guide Series - Volume 4 Author:C.J. Benton 3 books in 1 a consolidation of three books in the Microsoft® Excel® Step-By-Step Training Guide Series This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft® Excel® formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organi... more »zed into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft® Excel® at your own pace. In addition to the following, this book bundle also includes sections on Excel® keyboard shortcuts and how to change the currency symbol, for example to the British Pound £ or Euro ?. Part 1 - Excel® Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY & NETWORKDAYS SUMIF Part 2 ? Pivot Tables & Dashboards Organize and summarize data Format results Insert Pivot Charts Display averages & percentages Group data into predefined ranges Rank results Insert calculated fields How to create and update a basic Dashboard using Pivot Table data Part 3 ? Excel® Features Data Sorting Formula Trace Text-To-Columns Conditional Formatting & Filtering Part 4 ? Text Functions LEN & TRIM CONCATENATE & MID PROPER, UPPER, & LOWER Part 5 ? Logic Formulas IF Nested IF Part 6 ? The VLOOKUP Formula What the VLOOKUP formula does The parts of a VLOOKUP formula Detailed examples on how to use the VLOOKUP formula Incorporating the IFERROR functionality into your VLOOKUP formula How to apply the VLOOKUP formula across multiple tabs & workbooks How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error« less