Excel Application Window – Knowing Microsoft Excel Interface

After Microsoft Excel 2007, Anew rich look have been given to All MS Office Application with a style of Ribbons replacing drop-down menus and making it pretty easy to use for the End-User. Excel Application Window is divided into different parts as described below: Quick Access Toolbar: Main toolbar in the Excel Sheet, where you… Read More »

What is Excel?

Microsoft Excel is needed in day-to-day Job and is considered as a mandatory skills for Reporting, Presenting data, Analyzing Data, making Dashboards, Summarizing Information, Creating Charts & Tables, etc.   Excel makes your a professional by adding an Extra Skill and increase your value to grow your Career. Excel is an Ocean with 1000s of features… Read More »

TIME Function in Excel, How to use TIME Function in Excel?

Function TIME accepts integer values representing hrs, mins and seconds and returns Excel time. Syntax of TIME function in Excel TIME(hour,minute,second) Example:- TIME(26,0,0) = 02:00:00 TIME(25,12,0) = 01:12:00 Hour Value If hour value is greater than 23 then Excel calculates it by dividing it by 24 and returning the remainder Example: – TIME(25,12,0) returns a value… Read More »

Subtracting between two Dates in Excel, Minus Date from Date

Substracting two dates in Excel gives you the no of days between the given dates. You can Substract or Minus two Dates in Excel using a Today function and the Date function. The Formula calculates the no of days between the current date and the date specified in the DATE function. Substracting Dates Example: =TODAY() – DATE(2016,5,10) Returns… Read More »