The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features
- Length: 133 pages
- Edition: 1
- Language: English
- Publication Date: 2015-08-20
- ISBN-10: B0149F99GW
- Sales Rank: #1072490 (See Top 100 Books)
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®!
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.