Excel® - Formulas
In just a few short hours, learn the 30 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 30 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:
****Exercise Files Included!****
In addition to the following, this book also includes sections on Excel® keyboard shortcuts and how to change the currency symbol, for example to the British Pound £ or Euro €.
Part 1 - Excel® Formula Fundamentals
-
SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
-
AVERAGE
-
MIN & MAX
-
TODAY, NOW, & NETWORKDAYS
-
SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS
Part 2 – Introduction to Pivot Tables
-
How to create a Pivot Table report
-
Formatting Pivot Table results
-
Adding Pivot Charts
Part 3 – Excel® Features
-
Data Sorting
-
Conditional Formatting & Filtering
-
Data Validation
-
Text-To-Columns
-
Formula Trace
Part 4 – Text Functions
-
LEN & TRIM
-
CONCATE (CONCATENATE) & MID
-
PROPER, UPPER, & LOWER
Part 5 – Logic & Lookup Formulas
-
IF
-
AND
-
VLOOKUP
