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 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
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
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 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
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
