Excel Tips & Tricks

01/01/2017

Wish You a Great, Prosperous, Blissful, Healthy, Bright, Delightful, Energetic and Extremely Happy, HAPPY NEW YEAR 2017 to all followers.

25/06/2016

|| Excel Options Button Personalize and Start up Options ||

Excel Options button setting, you can play around with some great features which allow you to write your own user name, changing the background and office theme that you love. And you can also write your own user name to annotate the workbooks that you created.
http://excellovers.com/excel-options-button-personalize-start-up-options.html

Excel Options button allows you to change the background, theme, and you can also write your own user name to annotate the workbooks that you created.

20/06/2016

|| Excel Options General: When creating new workbooks ||

http://excellovers.com/excel-options-when-creating-new-workbooks.html

Excel Options General, This tutorial describes a basic setting of how you want to control your Excel when you open / create a new workbook.

14/06/2016

|| How To Access Excel Options In Microsoft Excel 2013 ||

In this tutorial we are going to learn about Excel Options of Excel 2013, The Excel Options are probably the most important feature in Microsoft Excel for certain interns of setting out, the super way that you work, and set your own settings. If you are new to Excel you might lose what settings to be set and making a decision about, but don’t worry, I am going to take you through step by step.

http://excellovers.com/access-excel-options-microsoft-excel-2013.html

The Excel Options are probably the most important feature in Microsoft Excel for certain interns of setting out and the super way that you work,

07/06/2016

|| Excel Ribbon File Tab Beginner’s Tips ||

In this tutorial, I am going to show you step by step of Excel Ribbon File Tab, depending on the version of Excel you are using, the following screen may look completely different than yours. The Microsoft has changed the looks wildly from Excel 2003, 2007, 2010, 2013 and finally now 2016. In this tutorial, I am using Office 2013, but overall the layout is still the same no matter what version you are currently on.
http://excellovers.com/excel-ribbon-file-tab-beginners-tips.html #

In this tutorial, you can learn step by step of Excel Ribbon File Tab Options, No matter what version you are currently using, It applies to all versions.

13/04/2016

|| Excel Date Function With Example Formulas ||

The Excel DATE function combines three different numbers into a date format, i.g. MM/DD/YY. If your date is contained in a three different columns, then this function can help you to combine them into one.
A couple of interesting things you need to know while using the DATE function in Excel, it can handle the funny numbers like 0 and greater than 31. If you look into the calendar there are no days like 0 or 32, 33, 34 and so on, and the same thing for the month the numbers should be 1-12, you have to be very careful when you are typing in the day and month in the formula. Yes, you are right, even the kids know how many days and months in the calendar. 😉 Even though sometimes we all make mistakes isn’t it? http://excellovers.com/excel-date-function-example-formulas.html #

The Excel DATE function combines three different numbers into a date format, i.g. MM/DD/YY. A couple of interesting things you need to know about DATE fun..

05/04/2016

|| Excel COUPDAYBS Function With Example Formulas ||

The Excel COUPDAYBS function returns the number of the days from the beginning of the coupon period to the settlement date. Always remember that the BS stands for (Beginning of the coupon period to the Settlement date).
Note: The date should be entered by using the DATE function or the date cells for should be formatted as date otherwise you may end up with an errors in formula.

You can also enter the serial number without separator (,) for the date but again you will have to format the cell into date formatting, Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and April 5, 2016 is serial number 42465 because it is 42,465 days after January 1, 1900.
http://excellovers.com/excel-coupdaybs-function-example-formulas.html

The Excel COUPDAYBS function returns the number of the days from the beginning of the coupon period to the settlement date. Always remember that the BS stands for (Beginning of the coupon period to the Settlement date). Note: The date should be entered by using the DATE function or the date cells fo…

19/03/2016

|| Excel COUNTIFS Function ||

The Excel COUNTIFS function counts the number of cells specified by a given set of conditions or criteria. The COUNTIFS function works almost in the same way as the SUMIF and SUMIFS functions. The COUNTIF and COUNTIFS functions extend the abilities of basic count formulas in Excel. It works in Excel 2007 or later versions of Microsoft Excel. http://excellovers.com/excel-countifs-function-example-formulas.html

The Excel COUNTIFS function counts the number of cells specified by a given set of conditions or criteria. The COUNTIFS function works almost in the same way as the SUMIF and SUMIFS functions. The COUNTIF and COUNTIFS functions extend the abilities of basic count formulas in Excel. It works in Excel…

12/03/2016

The Excel SUM function totals the values one or more ranges on a worksheet, the range can be on the same worksheet the function appears on or on another worksheet.

If you want to total more than one ranges, you can separate the individual ranges with comma “,” in this way you can add many ranges as you want to total many separate values as you need.
http://excellovers.com/excel-sum-function-example-formulas.html

The Excel SUM function totals the values one or more from ranges on a worksheet, the range can be on the same worksheet the function appears on or on another worksheet. If you want to total more than one ranges, you can separate the individual ranges with comma “,” in this way you can add many range…

03/03/2016

The Excel COUNTIF function is one of the statistical function, which counts the number of cells that meet criteria within the selected range.

Please, note that Excel COUNTIF function does not directly support data or ranges based on the color, background color or cell formatting. To do this you will have to create a UDFs (User Defined Functions) using the VBA Visual Basic Application, I will write the contents in the near future to teach you how to create your own UDFs in Excel.

http://excellovers.com/excel-countif-function-example-formulas.html

This tutorial explains the formulas, syntax and usage of the Excel COUNTIF function with many examples syntax =COUNTIF(range,criteria)

26/02/2016

The Excel COUNTBLANK function counts an empty cell in a specified range of cells. It can be used in any Excel data where you want to count those blank cells. Please note that sometimes it includes the cells with formulas which return “” (empty text) in COUNTBLANK function, if it does then you need to turn off the iterative calculation. But in Excel 2013 I don’t see any errors at all, it runs well either on or off.
Here is the steps to turn off the iterative calculation.

http://excellovers.com/excel-countblank-function-with-example-formulas.html

This tutorial explains the formulas, syntax and usage of the Excel COUNTBLANK function, It counts an empty cells in a specified range of cells in Excel.