Close All file on a single click in Excel 2013 and 2016

Excel Tutorial

Close All file on a single click in Excel 2016

In Excel 2013 & 2016 All the excel files open in separate window so it's not possible to close all the opened file at once. This is by default, there is no option to close all excel workbook/files at once in version 2013 & 2016.
Previous version of Excel workbook/file opened in one window and we can easily have closed all the files just using the Alt+F4. Excel 2013 each excel file open on separate window and continue in 2016 version.
For example, if we have 10 files open we must close all the files separately or hit the Alt+F4 command 10 times.

Excel Healthcare KPI Dashboard

Health KPI dashboard template is our first attempt to develop computer graphics style dashboard using Excel infogaphics male and female elements.

Using of SUMIFS function in Excel

SUMIFS function

Adds the cells in a range that meet multiple criteria. For example, if you want to sum the numbers in the range A1:A9 only if the corresponding numbers in B1:B9 are greater than zero (0) and the corresponding numbers in C1:C9 are less than 10, you can use the following formula:

=SUMIFS(A1:A9, B1:B9,"=A*", C1:C9,1)

Microsoft Excel 2013 Short Cut Keys: Alt + WJ (100% Zoom of Excel Sheet View)

100% Zoom of Excel Sheet View

Microsoft Excel 2013 Short Cut Keys:  Alt + W+J 
Hit the Alt key. Then type WJ (one key at a time).


Filter the Data
Zoom your documents 100%. Excel sheet view in actual 100% view.

raj-excel.blgospot.com

Change Negative Numbers to Positive in Excel

When you need to change the negative numbers to positive or vice versa numbers.

This Quick tricks you can easily change all the negative numbers to positive numbers.

Automatically update ranking list in Excel

Auto update the ranking list in Microsoft Excel using of INDEX(), MATCH() and LARGE() function

How to link update automatically in Excel 2013 without any notification when file open

Often when we link one workbook with another workbook and when we close and re-open the linked workbook a message appear on screen (see below snapshot)