{ "item_title" : "Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide", "item_author" : [" C. J. Benton "], "item_description" : "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 guideUpdated 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 IncludedIn 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 Poundor Euro .Part 1 - Excel(R) Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY, NOW, & NETWORKDAYS SUMIF, AVERAGEIF, COUNTIF, & COUNTIFSPart 2 - Introduction to Pivot Tables How to create a Pivot Table report Formatting Pivot Table results Adding Pivot ChartsPart 3 - Excel(R) Features Data Sorting Conditional Formatting & Filtering Data Validation Text-To-Columns Formula TracePart 4 - Text Functions LEN & TRIM CONCATE (CONCATENATE) & MID PROPER, UPPER, & LOWERPart 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) ", "item_img_path" : "https://covers4.booksamillion.com/covers/bam/1/54/650/024/1546500243_b.jpg", "price_data" : { "retail_price" : "10.99", "online_price" : "10.99", "our_price" : "10.99", "club_price" : "10.99", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }

Overview

Customers Also Bought

Details