Learn Excel Visually - Excel Advanced Formulae - Data Treatment: Take your Mad Excel Skills to the Next Level! (The 'Learn Excel Visually' Journey Book 5)

Learn Excel Visually - Excel Advanced Formulae – Data Treatment

Take your Mad Excel Skills to the Next Level!.

For those who have followed my series so far, you will have learnt some basic formulae and then developed your skills into intermediate formulae including data tidying and data analysis. By now you have hopefully practiced your Excel formula building skills and already impressed your fellow colleagues, friends or family with your Excel expertise.

This book will take you to the next level. I’m always the first to recommend keeping your Excel spreadsheets simple and the first of half of the book will help you to save time and become more efficient. However sometimes you have to dig a little deeper, the formulae in the second half of this book, what I call the ‘reference’ formulae, will allow you to do some astounding things and will expand how you think of and use Excel.

Formulae covered in this book are:
SUM across worksheets
COUNTIFS/SUMIFS
Name Ranges
TWO-WAY LOOKUP
Reference
OFFSET
OFFSET Validation
Dynamic Name Ranges
INDIRECT
ROW
COLUMN
ADDRESS
INDIRECT / ADDRESS
SUM / INDIRECT / ROW

Scroll up and get your copy of Learn Excel Visually - Excel Advanced Formulae today!