50 most powerful Excel Functions and Formulas

By Andrei Besedin

EXCEL FORMULAS AND FUNCTIONS
Do you have a business or are you someone who works with a lot of data? I guess you know how it feels to spend most of the hours in a day working on data. Frustrating, I think. Wasting your time by working manually on data is one of the most embarrassing things that can ever happen to you. 
You can use the wasted time to become more productive, spend time with your family and loved ones, and even make more money. All this can be achieved if you can invest in Excel . Even though it might be difficult to learn Excel and it might also require more time, its benefit is countless. If you need to prepare data quickly- you can do it only with the help of a computer Excel program.
For most people today, working Excel knowledge is very important because it opens various doors of opportunity. Taking the advantage of our short read book, you can develop your Excel skills, have an easy breakthrough, and free more of your time. There are many benefits attached to our incredible short read product if well explored. These are:
It saves time. This incredible short read book teaches to use Excel functions in performing heavy financial calculations for your client. Our experience suggests that Excel saves 9 hours out of 10 hours. 
A perfect guide for beginners learning how to use Excel function. It will help you through your classes. 
Instructions on how to use the Excel formula and functions are convenient and easy to learn.
The quality product can be used as a reference guide because it has a good navigation index.
Powerful Excel functions are clearly explained 
You would have the opportunity to get prepared for meetings that are important quickly 
The provided solution is cost-effective as you can get the short read product at a price less than a cup of coffee- A profitable product that will save you 90% of your work time (savings could be more than 1000 USD/month).
No doubt, we admit the fact that this product is not highly detailed. We were focused on providing you with product that saves your money and time. We understand that you are very busy with carrier, family and hobbies. 
Have it in mind that each day you postpone using this product; you get 90% of your work time wasted. Nothing is as exciting as being on the winning side. 
With the 100% risk-free guaranteed by the product you can try it for a full 7 days
That's real... If you are not satisfied, you can visit "Manage your Kindle" page and ask for a complete refund within 7 days.
To free your time and become more productive, click the buy button on the upper right side of the page and obtain your copy of the powerful product in just a single click!
Note: Remember that each day you delay using this product; you deny yourself 90% of your work time. Buy this winning product now! 

• Language: English
• Publisher: Publishdrive
• Release date: Sep 21, 2017

Book preview

Table of Contents

Table of Contents

All Rights Reserved

Chapter 1

Chapter 2

Chapter 3

Chapter 4.

Chapter 5

Chapter 6

Chapter 7

SOME SHORTCUTS

Other Books By Andrei Besedin

All Rights Reserved

Without limiting the rights under copyright reserved under, no part of this publication may be reproduced, stored in or introduced into a retrieval system, or transmitted, in any form, or by any means (electronic, mechanical, photocopying, recording, or otherwise) without the prior written permission of the copyright owner.

Chapter 1

Sum

We all need to pay bills. Suppose you use 10 utilities (rent, electricity, Wi-Fi etc.). And you need to pay bill for that. And now you want to know how much did you spend on that per month. Here excel will save your time. You don’t need to input the numbers 10 times in a calculator.

The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

Syntax 

=SUM (number1, [number2], [number3], ...)

Arguments 

number1 - The first item to sum.

number2 - [optional] The second item to sum.

number3 - [optional] The third item to sum.

Usage notes

Select the numbers you want to add. You can do it individually by clicking each cell or drag them with mouse from top to bottom (shown in this pic).

Hit Enter and you will see the sum.

The keyboard shortcut for sum is (Alt) + (=)

Sumproduct

Suppose you bought 4 products in many quantities. This is time consuming to multiply unit with price and the add them together. Excel has a built in formula for that.

The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products.SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility. Other functions can easily be used inside SUMPRODUCT to extend functionality even further.

Syntax 

=SUMPRODUCT (array1, [array2], ...)

Arguments 

array1 - The first array or range to multiply, then add.

array2 - [optional] The second array or range to multiply, then add.

How to use SUMPRODUCT in Excel:

Select array 1 then multiply with selected array2 and press enter.

How to do this calculation manually:

(3*2) +(5*1.50) +(1*60) +(2*10.5) =94.5

Usage notes 

The SUMPRODUCT function works with arrays, but it doesn't require the normal array syntax (Ctrl + Shift + Enter) to enter. The purpose of the SUMPRODUCT function is to multiply, then sum, arrays. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 arrays can be supplied.

Chapter 2

Vlookup

Vlookup is vertical lookup. Vlookup is used to find something from a vertical list or table. Suppose there are three sales rep. we want to know how much commission they will get If they achieve certain category.

VLOOKUP is an Excel function to look up and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.

Syntax 

=VLOOKUP (value, table, col_index, [range_lookup])

Arguments 

Value - The value to look for in the first column of a table.

Table - The table from which to retrieve a value.

Col_index - The column in the table