Skip to main content

MS Excel

MS Excel

What is MS Excel?

MS Excel stands for Microsoft Excel. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot table, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as industry standard for spreadsheets. MS Excel is a part of  Microsoft Office.
       There are many MS Excel  version shows on the official site of ms excel on internet like Excel 2002, Excel 2003, Excel 2007, Excel 2010, Excel 2013  and  Excel 2016 but the latest version of the MS Excel is MS Excel 2016(Excel 2016 Version 16.0).
       All the versions of MS Excel have their own specific function.
*Do you know: Microsoft released the first version of Excel for the Macintosh on September 30 1985, and the first Windows version was 2.05 in November 1987.

Basic Information:

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in number rows and letter-named columns to organize the data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensinal graphical display. It allows sectioning of data to view it dependencies on various factors for different perspectives (using pivot table and the scenario manager). It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the result back to the spreadsheet. It has also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet for the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface. An Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report PowerPoint slide show, and e-mail these presentations on  a regular basis to a list of participants. Excel was not designed to be used as a database.
      Microsoft allows for a number of optional command-line switches to control the manner in which Excel Starts.

Function and features of Ms Excel:

In MS Excel, the starting of any program may contains many of different features by which we can do our work easier, simpler, faster and give a new way or we can say direction to our work with new features of that program. All the program have a different features in its own and as well as MS Excel also may contains various features of working procedure and criteria of its own. As we make any app, program or any function for our use, we first add some useful features it and after we add more additional features to it and doing our program update by adding more various features to it. Similarly, MS Excel was first made in 1993, the first version is Excel 5. Nowadays, MS Excel is become a totally upgraded app for the users and the top upgraded form is Excel 2016. Excel 2016 has 484 functions of these, 360 existed prior to Excel 2010. Microsoft classifies these function in 14 categories of the 484 current functions, 386 maybe called from VBA as methods of the objects "WorksheetFunction" and 44 have the same names as VBA functions.

What is VBA?

VBA stands for Visual Basic for Application. The Windows version of Excel supports programming through Microsoft's Visual Basic for Application (VBA), which is a dialect of Visual Basic. Programming with VBA allows spreadsheet manipulation that is awkward or impossible with standard spreadsheet techniques.
     VBA was removed from Mac Excel 2008, as the developers did not believe that a timely release would porting the VBA engine natively to Mac OS X. VBA was restored in the next version, Mac Excel 2011, although the build lacks support for ActiveX objects, impacting some high level developer tools.
    A common and easy way to generate VBA code is by using the Macro Recorded. The Macro Recorder records actions of the user and generates VBA code in the form  of  a macro.The macros can also be linked to different trigger types like keyboard shortcuts, a command button or a graphic. The VBA code of the macro can also be edited in the VBE. Certain features such as loop functions and screen prompt by their own properties, and some graphical display items, cannot be recorded but must be entered into the VBA module directly by the programmer. 
    Macro Recorded code may not be compatible with Excel versions. Come code that is used in Excel 2010 cannot be used in Excel 2003. Making a Macro that changes the cell colours and making changes to other aspects of cells may not be backward compatible. 

History

The first version of Excel supported end user programming of macros (automation of repetitive tasks) and user defined functions ( extension of Excel's built--in function library). In early versions of Excel these programs were written in a macro language whose statements has formula syntax and resided in the cells of special purpose macro sheets. XLM was the default macro language for Excel though Excel 4.0. Beginning with version 5.0 Excel recorded macros in VBA by default but with the version 5.0 XLM recording was still allowed as an option. After 5.0 version, all that version are discontinued. All versions of Excel, including Excel 2010 are capable  of running an XLM macro, though Microsoft discourages their use.

Charts

Excel supports charts, graphs or  histograms generated from specified groups of cells. The generated graphic component can either be linked within the current sheet, or added as a separate object.
   These displays are dynamically updated if the content of cells change. For example, let us suppose that we want a important design requirements are displayed visually; then, in response to a user's change in trial values for parameters, the curves describing the design change shape, and their points of intersection shift, assisting the selection of the best design.
https://en.wikipedia.org/wiki/Microsoft_Excel#/media/File:Excel_chart.PNG



ms excel charts





Data storage and communication:


Number of rows and columns


As we know above, for the first edition of excel there are many version of Excel up to 7.0 had a limitation in  the size of their data sets of 16k (16,384) rows. Version 8.0 to Version 11.0 contains 64k (65,536) rows and 256 columns. Version 12.0 have 1M (1 048 576) rows and 16384 columns.

Versions

Earlier History
    Microsoft originally marketed a spreadsheet program called Multiplan in 1982. Multiplan became very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronize with the Macintosh version 2.2) in November 1987. Lotus was slow to bring 1-2-3 to Windows and by the early 1990s Excel had started to outsell 1-2-3 and helped Microsoft achieve its position as a leading PC software developer. This accomplishment solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft maintained its advantage with regular new releases, every two years or so.

Year
Name
Version
1987
Excel 2
2.0
1990
Excel 3
3.0
1992
Excel 4
4.0
1993
Excel 5
5.0
1995
Excel 95
7.0
1997
Excel 97
8.0
2000
Excel 2000
9.0
2002
Excel 2002
10.0
2003
Excel 2003
11.0
2007
Excel 2007
12.0
2010
Excel 2010
14.0
2013
Excel 2013
15.0
2016
Excel 2016
16.0


Click here to get the exam datesheet and schedule time table of csjm 2019

Labels:

Comments

Post a Comment

Popular posts from this blog

Gmail account

Gmail Account Hello friends, Welcome to Techworlds , today I am going to tell you that "How do we make Gmail account?" and "Why gmail account is necessary in now-a-days?" , So friends lets start the learning  that how we make gmail account and why this account is necessary. ( Click here to make your own gmail account ) Gmail  Description of Gmail      Dear Users, We only use the service of Microsoft named as Gmail  which is stands for Google mail  service. Gmail  is first published, started or we can say in simple language made by "Paul Buchhiet"  atmost 14 years ago on the date 1 April, 2004. Gmail started as al limited beta release on 1 April, 2004. and ended its testing phase on July 7, 2009. Gmail  is a free email service developed by Google. User can access Gmail on the web and using third-party programs that synchronize email content through POP or IMAP protocols. Interesting Facts about Gmail       Users do you know, at launch, G
Post a Comment
Read more

Gmail Account in Hindi

Gmail account kaise bnaye Hello dosto,     " techWorlds " me apka swagat hai aur mai apka swagat bde hi swag k sath krta hu, dosto aaj hm ye sikhenge ki hm gmail ya google mail account kaise bnate hai. Ques:-  Kya aap jante hai ki hm gmail account kyu bnate hai? Ans:- Hum apna gmail (google) account apne messages, information, docs ya apne improtant files ya pics ( images, jpg file, etc.) ko secret tarike se bhejne k liye use krte hai. Dosto kya apko pta hai ki gmail account ko Paul Buchhiet   ne karib 14 years  pehle   1 April, 2004  ko bnaya tha jo ki ek secretly apne messages dusro tk convey(pahuchane) k liye use kiya jata tha. Agar apme ya hmme se koe computer ki languages k bare me janta hai ki apps, programs ya phir application kaise bnaye ya taiyar kiye jate hai, to wo Javascript k bare me bhi jarur janta hoga. To mai apko btata chalu ki Gmail ek aisa application hai jiska backend Javascript  se aur other area Ajax  nam ki language se bnaya gya hai, jise ki koe b
Post a Comment
Read more

MS Paint

MS Paint Microsoft Paint (A Paintbrush) is a simple raster graphics editor that has been included with all versions of Microsoft Windows. The program opens and saves files in Windows bitmap (BMP) , JPEG, GIF, PNG and single-page TIFF formats. The program can be in color mode or two-color black-and-white,but there is no gray scale mode. For its simplicity and that it is included with Windows, it rapidly became one of the most used applications in the early versions of Windows, introducing many to painting on a computer for the first time. It is still widely used  for simple image manipulation tasrks.    In July 2017, Microsoft added Paint to the list of deprecated Windows features, meaning that it will not be developed further and might be removed in the future. It will, however, be made available in the Microsoft Store for free.    In Windows 10, Paint can be found in the Start menu under Windows Accessories, or one can type "mspaint" in the Run dialog box ( Windows K
Post a Comment
Read more

MS Word

MS Word What is MS Word?         MS Word  stands for Microsoft Office Word. Microsoft Word (or simply  Word ) is a word processor developed by  Microsoft.  It was first released on October 25, 1983. The name of ms word at that time was Multi-Tool Word for Xenix system. Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), Apple Macintosh running the Classic Mac OS (1985), Microsoft Windows (1989), OS/2 (1989), Microsoft Windows(1989). SCO Unix (1994), and macOS (formerly OS X; 2001). In  Word  there are also many version from the beginning of the word page from the beginning. There are many versions like  Word 97 / word 98 / Word 2000 / Word 2002 /  Word 2003 / Microsoft word 2007 /  Word 2010 / Word 2013 / Word 2016 /  Word 2019.  The latest updated version of the  Microsoft office word   is   Word 2019.       Commercial versions of  Word are licensed as a standalone product or as a component of Microsoft Office, Windows RT
Post a Comment
Read more

CSJM University exam datesheet for 2019

Date Sheet of  CSJM University For 2019:   For more updates subscribe our page and go to the official website of CSJM University( www.csjmuniversity.org  /  www.kanpurunversity.org ) Date Sheet (Click Here To Download) To Download this date sheet follow the simple step: Method 1. 1.  Click the right mouse button on the image. 2.  Now a dialogue box will appears. 3.  Click on the " Open in new window ". The image will appears in new window. 4.  Now click the right mouse button, a dialogue box will appear, and select the         " Save as image   " option. 5.  The image is downloaded successfully. Method 2. 1.  Click on the " caption " of the image, a page will appear, 2.  Click to right mouse button and Click to " save as image.. " Click here for the download in video process from this site. Click here to download the exam date sheet::::: CSJM 2019, the date sheet is being announced by the csjm university for 2
Post a Comment
Read more

How To make a gmail account

How To make a gmail account  Hello Users,    Welcome to " Techworlds ",  Today we are discussing about how to make the gmail account or google account. Ques:- Did you know why we make gmail account? Ans:- We make gmail(google) account to send our messages, information, docs and our important files or pictures(images, jpg file, etc.) secretly. The gmail account was first developed by Paul Buchhiet  in about 14 years ago at 1 April, 2004 which was secretly message serving application. If we know anything about the languages of making application, then we came to know that the backend of the email is made by JavaScript  and others are by   Ajax  which was very easy to use and anyone can easily handle or mail to any one privately and confidently.   Do you know gmail is now-a-days is became a very essential part of network communication and which is a very truthful part  of the IT and Communication technology. Do you now  there are about 1.4 billion  of people in the c
Post a Comment
Read more