Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide

<b><h3><font>In just a few short hours, learn the 30 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!</font></h3></b> <br /><p> <b>Updated for Excel® 2016</b> this book offers easy to follow examples with <b>screenshots</b> demonstrating how to use the 30 most common <i>basic</i> and <i>intermediate</i> Microsoft® Excel® formulas & features. The book is organized into <b>5 step-by-step sections</b>, allowing you to grow your knowledge of Excel® at your own pace: <br /></p> <b>****Exercise Files Included!****</b><br /><p></p>In addition to the following, this book also includes sections on <b>Excel® keyboard shortcuts</b> and how to change the currency symbol, for example to the <b>British Pound £</b> or <b>Euro €</b>.<br /><p></p><b><u>Part 1 - Excel® Formula Fundamentals</u></b> <br /><p></p><li>SUM, SUBTRACTION, MULTIPLICATION, & DIVISION <br /></li><li>AVERAGE <br /></li><li>MIN & MAX <br /></li><li>TODAY, NOW, & NETWORKDAYS <br /></li><li>SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS <br /><p> <br /><b><u>Part 2 – Introduction to Pivot Tables</u></b> <br /></p></li><li>How to create a Pivot Table report <br /></li><li>Formatting Pivot Table results <br /></li><li>Adding Pivot Charts <br /><p> <br /><b><u>Part 3 – Excel® Features</u></b> <br /></p></li><li>Data Sorting <br /></li><li>Conditional Formatting & Filtering <br /></li><li>Data Validation <br /></li><li>Text-To-Columns <br /></li><li>Formula Trace <br /><p> <br /><b><u>Part 4 – Text Functions</u></b> <br /></p></li><li>LEN & TRIM <br /></li><li>CONCATE (CONCATENATE) & MID <br /></li><li>PROPER, UPPER, & LOWER <br /><p> <br /><b><u>Part 5 – Logic & Lookup Formulas</u></b> <br /></p></li><li>IF <br /></li><li>AND <br /></li><li>VLOOKUP <br /><p>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® Excel®!</p></li>