Microsoft Excel Step-by-step Training Guid Bundle, Paperback by Benton, C. J....

Description: Microsoft Excel Step-by-step Training Guid Bundle, Paperback by Benton, C. J., ISBN 1518628753, ISBN-13 9781518628757, Like New Used, Free shipping in the US 3 books in 1 a consolidation of thres 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. Th bundle is organized 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 FundamentalsSUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGEMIN & MAX TODAY & NETWORKDAYSSUMIF Part 2 – Pivot Tables & DashboardsOrganize and summarize dataFormat resultsInsert Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesRank resultsInsert calculated fieldsHow to create and update a basic Dashboard using Pivot Table data Part 3 – Excel® FeaturesData SortingFormula TraceText-To-ColumnsConditional Formatting & Filtering Part 4 – Text FunctionsLEN & TRIMCONCATENATE & MIDPROPER, UPPER, & LOWER Part 5 – Logic FormulasIFNested IF Part 6 – The VLOOKUP FormulaWhat the VLOOKUP formula does The parts of a VLOOKUP formula Detailed examples on how to use the VLOOKUP formulaIncorporating the IFERROR functionality into your VLOOKUP formula How to apply the VLOOKUP formula across multiple tabs & workbooksHow to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error

Price: 33.68 USD

Location: Jessup, Maryland

End Time: 2024-12-02T02:33:40.000Z

Shipping Cost: 0 USD