Overview

In just a few short hours, learn the 30 most common Microsoft(r) Excel(r) Formulas & Features quickly and easily with this detailed step-by-step guide! Updated for Excel(r) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 most common basic and intermediate Microsoft(r) Excel(r) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(r) at your own pace: Exercise Files Included! In addition to the following, this book also includes sections on Excel(r) keyboard shortcuts and how to change the currency symbol, for example to the British Pound ? or Euro e. Part 1 - Excel(r) Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY, NOW, & NETWORKDAYS SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS Part 2 - Introduction to Pivot Tables How to create a Pivot Table report Formatting Pivot Table results Adding Pivot Charts Part 3 - Excel(r) Features Data Sorting Conditional Formatting & Filtering Data Validation Text-To-Columns Formula Trace Part 4 - Text Functions LEN & TRIM CONCATE (CONCATENATE) & MID PROPER, UPPER, & LOWER Part 5 - Logic & Lookup Formulas IF AND VLOOKUP Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using Microsoft(r) Excel(r)!