Excel functions is used to save the time and effort of user. Excel by default comes with numerous functions to meet the requirement of user, sort data, calculate data by formula, manipulate data etc. Count, Countif, Sum and Sumif functions are very useful to handle most of the algebric calculations in an easy way. When you are familiar with those functions you can do most of the difficult calculations in excel with very little effort and time.
Why this book?
This book does not make any assumptions about your knowledge in excel. You do not need any prior knowledge to get benefit from this book. You will be guided step-by-step starting form where to write formulas, how to write, what is the pre-requisite for each function and how to understand the syntax of functions.
Book contain data sheet for all the chapters which teaches how to effectively use the functions. At the end of chapters exercised are provided for practice. You can download the data sheets for free by clicking on the link provided in the first chapter to do the exercises.
What you'll learn?
COUNT Function
COUNTIF Function
SUM Function
SUMIF Function