What is Microsoft Excel

Microsoft Excel is a advertising spreadsheet remedy scrivened and dispensed by Microsoft for Microsoft Windows and Mac OS X. It features planning, graphing tools, axis tables, and a instruction planning language called Visual Standard for Applications. It has been a rattling widely applied spreadsheet for these platforms, especially since variant 5 in 1993, and it has almost completely replaced Lotus 1-2-3 as the manufacture textbook for spreadsheets. Surpass forms line of Microsoft Staff. The latest versions are 2010 for Microsoft Windows and 2011 for Mac OS X.

Microsoft Excel has the first features of all spreadsheets, using a electrode of cells laid in numbered rows and letter-named columns to initiate data manipulations like arithmetic dealing. It has a fire of supplied functions to resolution statistical, subject and financial needs. In element, it can show collection as bloodline graphs, histograms and charts, and with a really small three-dimensional graphical presentation. It allows sectioning of aggregation to scene its dependencies on different factors from antithetical perspectives (using parader tables and the scenario manager). And it has a programming panorama, Visual Standard for Applications, allowing the soul to state a nationwide show of denotive methods, for ideal, for determination reckoning equations of mathematical physics, and then reportage the results backward to the spreadsheet. hold group (DSS), via a custom-designed human interface, for warning, a hold instrument, or in generalised, as a system slave that asks the soul questions and provides answers and reports.In a more elucidate discernment, an Surpass program can automatically crown international databases and measure instruments using an update schedule, psychoanalyse the results, kind a Show papers or Commonwealth Part slideway exhibit, and e-mail these presentations on a daily component to a move of participants.

Stupid post, isn't it? I owe that to an article spinning software. But for understandable Excel Formulas tutorials, just visit eXcelFormulas.me

ROUNDOWN excel function - formula to remove the timestamp in an excel cell

This is in relation to the post on http://exceltutorials.tumblr.com/ entitled Formula to remove TIMESTAMPS in excel. The excel tutorial tells how to use the INT function to remove the time in a cell that contains both date and time. That tutorial works but there is also another way to achieve the same result.

As implied in the said article, the date is the whole number and the time is the decimal. ROUND DOWN function can be used in the same manner as the INT one. But unlike the latter, you have to specify the number of decimal figures to be left.  The syntax for the RoundDown function is:

RoundDown( number, num_digits )
number is the number to round down (which refers to the cell reference)
num_digits is the number of decimals to round the number to

So if cell A1 is  7/31/2011 1:26 or 40755.06 if in number format, the formula to remove the decimal figures/timestamp is =rounddown(A1,0) . By using 0, you're telling excel that there should not be any decimal.

This is just my first. There are more easy-to-follow excel tutorials to come.

This blog is listed in linked words.com under Microsoft Excel