The Microsoft Excel Step-By-Step Training Guide Book Bundle (The Microsoft Excel Step-By-Step Training Guide Series) (Volume 4)
Book Details
Author(s)C.J. Benton
ISBN / ASIN1518628753
ISBN-139781518628757
AvailabilityUsually ships in 24 hours
Sales Rank1,945,119
MarketplaceUnited States 🇺🇸
Description
3 books in 1 a consolidation of three books in the Microsoft® Excel® Step-By-Step Training Guide Series 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
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 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 Fundamentals
Part 2 – Pivot Tables & Dashboards
Part 3 – Excel® Features
Part 4 – Text Functions
Part 5 – Logic Formulas
Part 6 – The VLOOKUP Formula
More Books by C.J. Benton
