The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features

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
• SUMIFPart 2 – Introduction to Pivot Tables
• How to create a basic Pivot Table
• Formatting Pivot Table results
• Inserting Pivot ChartsPart 3 – Excel® Features
• Data Sorting
• Formula Trace
• Text-To-Columns
• Conditional Formatting & FilteringPart 4 – Text Functions
• LEN & TRIM
• CONCATENATE & MID
• PROPER, UPPER, & LOWERPart 5 – Logic & Lookup Formulas
• IF
• Nested IF

VLOOKUPImagine 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®!