Slicers in Pivot Table - Quickly Filter Data
Excel Solutions - Basic and Advanced
by
2y ago
 If you are using pivot table reports for management or even for your own analysis and, you are not using Slicer then, you are not fully utilizing the pivot table report. In this article I will discuss about slicers in pivot table. How to insert slicer, how to customize slicer, where and when you need to use slicer. We can use slicer both in Pivot tables and Tables. But what is slicer? Slicer is a tool which provides buttons, that you can click to filter tables, or PivotTables. Slicers are a powerful new way to filter pivot table data. It's very easy to add Slicer in your pivot table. Let ..read more
Visit website
End Date of The Month : EOMONTH Function
Excel Solutions - Basic and Advanced
by
3y ago
Suppose we have to get the number of days from a certain days given few months and at the day will be end of the last month. Like the image below. EOMONTH Function If we break our problem,             1.  We need the end date of the month or the last date of the month             2.     The last month will be current month and the number of months provided.             3.     Next step is to get the ..read more
Visit website
Free Macro to Send emails with Attachments
Excel Solutions - Basic and Advanced
by
4y ago
Hello Friends, No discussion on Excel today (!), rather I am giving you one FREE MACRO developed by me to send bulk mails which can be downloaded from the link below this article. Auto Mailer Macro Free Why I made this Excel Macro or Excel VBA Code ? Recently I needed to send few mails with recipient’s data, I thought I could use Mail Merge to get the job done. Yes, it is done but “How to mark ‘CC’ ?”. I didn’t find it. I Google it, nope, no help. So, I thought I could use Excel Macro (VBA) to get the job done. Three hours it took to complete this macro using which I can send b ..read more
Visit website
Excel Formula To Calculate Age in Years Months and Days On a Specific or Current Date
Excel Solutions - Basic and Advanced
by
4y ago
Hello Friends, As promised in this article I will show you the process to calculate the exact age in Days, Months and Years from two given dates be it current date or any specific date. I will use DATEDIF function to get the age in year, month & day. Ifyou need to know about this function please click hear to know how thisfunction works. Just to recall I would like to quote from my own article, "Please note, DATEDIF function is not like other functions, Excel will not help opening function argument box to be filled with data but if you provide all the data in correct ..read more
Visit website
DATEDIF Function
Excel Solutions - Basic and Advanced
by
5y ago
Today I will discuss about DATEDIF function which is very helpful function when dealing with Dates. In next article we will use DATEDIF function to get the actual age on a given date as well as on current date. Therefore, this function is very important function. DATEDIF function returns the difference between two date values, based on the interval specified. Please note, DATEDIF function is not like other functions, Excel will not help opening function argument box to be filled with data but if you provide all the data in correct order, it will help you a lot in future. Le ..read more
Visit website
RAND Function - Generate Random 'Decimal' Numbers In Excel
Excel Solutions - Basic and Advanced
by
5y ago
In my last article I discussed about how to generate RANDOM numbers in Microsoft Excel which is very easy using the function RANDBETWEEN. You type the function in excel and provide the Bottom and Top number (as lower and upper limit) and you get the Random numbers. But if you notice carefully all these randomly generated numbers are integer type numbers, therefore, in this article I will discuss with you how to generate Decimal Random Numbers. One solution is to divide the output of RANDBETWEEN numbers by 10, 100 or 1000, i.e., in multiple of 10. But the problem is the integer part of these n ..read more
Visit website
RANDBETWEEN Function
Excel Solutions - Basic and Advanced
by
5y ago
In this article I will discuss about RANDBETWEEN Function which returns a new random number but these numbers get changed each time your spreadsheet . What is meant by 'spreadsheet recalculates' ? Every time you enter something or rectify your formula or data spreadsheet gets refreshed. This can better be understood after using this function. So RANDBETWEEN Function generates random numbers between the specified ranges. Description: The Microsoft Excel RANDBETWEEN function returns a random number that is between a bottom and top range. You need to specify TOP and BOTTOM numbers. Syntax ..read more
Visit website
MROUND Function
Excel Solutions - Basic and Advanced
by
5y ago
We have discussed CEILING & FLOOR function with significance, in this article we will discuss about MROUND function to round a number to a given numbers' multiplication. Description : The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple. Syntax : =MROUND (number, multiple)Arguments : number - Its a number that should be rounded up or down.multiple - Its a number which is used as 'multiple' when rounding. Few Things to Remember : 1.   MROUND rounds up, away from zero. 2.   The roundin ..read more
Visit website

Follow Excel Solutions - Basic and Advanced on FeedSpot

Continue with Google
Continue with Apple
OR