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








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

Comments

Popular posts from this blog

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 calculation on  2018 are …

Gmail Account in Hindi

Gmail account kaise bnayeHello 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 bhi person ekdm…

Gmail account

Gmail AccountHello 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)
 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, Gmail had an initial storage capacity off…

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)
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 2019 exams of B.A.(I, II, III), B.Sc.(I, II, III), B.Com.(I,II,III), B. Lib., B.Sc. Biotech., M.Com.(I, II), M…

Computer Facts

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)
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.."


Fun with Computer

What is a Computer?

“Computer is an electronic machine made up of various devices that is used to generate meaningful information from raw data.” In general the easiest definition of computer is that “The computer is that electronic device which makes our work easier, with…

MS PowerPoint

MS PowerPointWhat is MS PowerPoint Presentation?
MS PowerPoint presentation  is stands for Microsoft PowerPoint Presentation.Microsoft PowerPoint  (or simply PowerPoint) is a presentation program, created by Robert Gaskins and Dennis Austin at a software company named Forethought.  It was released on April 20, 1987, initially for Macintosh computers only. Microsoft acquired PowerPoint for $14 million three months after it appeared. This was the first Microsoft's Significant acquisition. PowerPoint became a component of the Microsoft Office suite, first offered in 1989 for Macintosh and in 1990 for Windows. The First  beginning of PowerPoint is PowerPoint 4.0 (1994). From 1994, there are many latest updated version we get seen by which there are some few latest updated MS PowerPoint's are PowerPoint Mobile 2016for Android  / PowerPoint 2016 for Macintosh /  PowerPoint Mobile 2016 /  PowerPoint Mobile 2016 iOS /  PowerPoint 2016 for Windows /  PowerPoint 2016 for Windows Store.
St…