The Microsoft Excel Step-By-Step Training Guide Book Bundle - Paperback
$24.28
Skip to product information
SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY & NETWORKDAYS SUMIF 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 Data Sorting Formula Trace Text-To-Columns Conditional Formatting & Filtering LEN & TRIM CONCATENATE & MID PROPER, UPPER, & LOWER IF Nested IF 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
The Microsoft Excel Step-By-Step Training Guide Book Bundle - Paperback
$24.28
by C. J. Benton (Author)
3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) 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(R) Excel(R) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft(R) Excel(R) at your own pace.
In addition to the following, this book bundle also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .
Part 1 - Excel(R) Formula Fundamentals
Part 2 - Pivot Tables & Dashboards
Part 3 - Excel(R) Features
Part 4 - Text Functions
Part 5 - Logic Formulas
Part 6 - The VLOOKUP Formula
Number of Pages: 246
Dimensions: 0.52 x 9.21 x 6.14 IN
Publication Date: October 23, 2015
Details
This product is crafted with quality materials to ensure durability and performance. Designed with your convenience in mind, it seamlessly fits into your everyday life.
Shipping & Returns
We strive to process and ship all orders in a timely manner, working diligently to ensure that your items are on their way to you as soon as possible.
We are committed to ensuring a positive shopping experience for all our customers. If for any reason you wish to return an item, we invite you to reach out to our team for assistance, and we will evaluate every return request with care and consideration.
