by C.J. Benton- Length: 133 pages
- Edition: 1
- Language: English
- Length: 133 pages
- Edition: 1
- Language: English
Description
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®!