Learn the 25 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!
This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft® Excel® formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel® at your own pace:
****Excel v2016 is now available, with 5 bonus formulas included****
Part 1 - Excel® Formula Fundamentals
SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGEMIN & MAX TODAY & NETWORKDAYSSUMIF Part 2 – Introduction to Pivot Tables
How to create a basic Pivot TableFormatting Pivot Table resultsInserting Pivot ChartsPart 3 – Excel® Features
Data SortingFormula TraceText-To-ColumnsConditional Formatting & FilteringPart 4 – Text Functions
LEN & TRIMCONCATENATE & MIDPROPER, UPPER, & LOWERPart 5 – Logic & Lookup Formulas
IFNested IFVLOOKUPImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft® Excel®!
Book 1 in The Microsoft Excel Step-By-Step Training Guide Series
Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & FeaturesBook 2 - The Step-By-Step Guide To Pivot Tables & Introduction To DashboardsBook 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft ExcelBook 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle
Learn the 25 most common Microsoft® Excel® Formulas & Features quickly and easily with this detailed step-by-step guide!
This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft® Excel® formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel® at your own pace:
****Excel v2016 is now available, with 5 bonus formulas included****
Part 1 - Excel® Formula Fundamentals
SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY & NETWORKDAYS SUMIF Part 2 – Introduction to Pivot Tables
How to create a basic Pivot Table Formatting Pivot Table results Inserting Pivot Charts 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 & Lookup Formulas
IF Nested IF 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 of Microsoft® Excel®!
Book 1 in The Microsoft Excel Step-By-Step Training Guide Series
Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features Book 2 - The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards Book 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel Book 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle