New features and versions of Microsoft Excel

90 / 100
New features and versions of Microsoft Excel

Microsoft features like calculation, graphing tools, macro programming language called visual basic for applications.

All I have to do is enter a formula and pretty much anything I’d ever need to do manually can be done automatically sometimes Excel seems too good to be true and need to merge two sheets with similar data? I can do it.

 Like this all the work I can do it and if you are encounter a situation that you need to manually update your data you are probably missing out on a formula that can do it for you.

Excel is a handy software that can be used to store and organize many data sets using its features and formulas you can also use the tool to make sense of your data for example you could use a spreadsheet to track data and automatically c sums averages and totals.

In the spirit of working more efficiently and avoiding manual work here are a few Excel tricks to get you started with

How to use Excel: Excel

* Executing basic competition in a spreadsheet like adding, separating, multiplying and dividing in a spread sheet

* Adding or deleting single columns, rows and spreadsheet below we will get into how to add things like multiple columns and rows

* Keeping column and row titles visible as you scroll past them in a spreadsheet so that you know what data you are feeling as you move further down the document.

* use conditional formatting to make cells automatically change colour based on data and get the average of numbers in your cells.

Read More  10 successful tips for being Young man

* Split up text information between columns and use these formulas for simple calculations.

New features and versions of Microsoft Excel 1

Microsoft Excel has a battery of supplied functions to answer statistical and financial needs.

Microsoft Excel has the basic features of all spreadsheets using a grid of cells arranged in number the rows and letter name the columns to organize data manipulation like arithmetic operations.

In addition it can display data as line graph and charts with a very limited three-dimensional graphical display so it allows sectioning of data to view its dependencies on various factors for different perspectives and it also has the programming aspect visual basic for applications are loving the user to employ a wide variety of numerical methods.

Each of the rows, columns and the cells can be modified in many ways including the background colour, number of the data format, size, text font, layout etc.

creating a Microsoft Excel spreadsheet that can be downloaded and opened in any spreadsheet program including Microsoft Excel this spreadsheet illustrates some of the capability is of the spreadsheet and functions and follows also allows you to experiment more with a spreadsheet.

There are many reasons that people may use Excel for example someone might use as well to keep track of their expenses.

today there are many different free spreadsheet options that someone could use instead of and even with the available free options Excel remains the most used to spread sheet because of all its available options features and because of many businesses still use the program.

It can also have a variety of interactive features following user interfaces that can completely hide the spreadsheet from the users so the spreadsheet presents itself as a so called application or decision support system.

Read More  Both the chief Ministers have issued 144 injunction orders the rules till March 31

Excel 2016 has 484 functions of these 360 existed prior two Excel 2010 and Microsoft classifies these functions in 14 categories of the 484 current functions, 386 may be called from VBA as methods of the object “Worksheet Function ” and 44 have the same names AS VBA functions.

Password protection:

In Microsoft Excel 95 and earlier versions the password to open is converted to a 16 bit key that can be instantly cracked.

In addition, password-cracking programs can  brute-force attack passwords at a rate of hundreds of thousands of passwords a second , which not only let’s them decrypt a document but also find the original password.

New features and versions of Microsoft Excel 2

Nevertheless the older Excel 97/2000 algorithm is set by the default. Therefore, users who do not change the default settings lack reliable protection of their documents.

In Excel 2010, the strength of the protection by the default was increased two times due to the use of a 100,000-fold SHA1 to convert a password to a key.

Statistical functions and data range:

The accuracy and convenience of statistical tools in Excel has been criticized, as mishandling missing day, as returning incorrect values due  to inept handing of round-off and large numbers, as only selectively updating calculations on a spreadsheet when some cell values are changed and as having a limited set of statistical tools and Microsoft has  announced some of these issues are addressed in Excel 2010.


Excel became the first spreadsheet to allow the user to define the appearance of spreadsheet. It also introduced intelligent cell recomputation,

where only cells can depend on their cell being modified or updated so Excel introduce how to fill the ability to drag and expand the selection box to automatically copy a cell or content two adjacent cells are rows adjusting the copies intelligently by automatically incrementing cell references for contents and Excel also introduced extensive graphing capabilities.

Read More  How to Set your mental and physical Victim well-being to the good


4 thoughts on “New features and versions of Microsoft Excel

  • August 19, 2020 at 1:57 pm

    I want to voice my respect for your kind-heartedness supporting all those that require help on this matter. Your very own commitment to passing the solution throughout turned out to be quite functional and has truly allowed somebody like me to realize their goals. Your amazing warm and friendly information can mean a lot to me and a whole lot more to my mates. Regards; from everyone of us.

  • August 22, 2020 at 4:15 am

    I am only writing to make you understand what a impressive discovery my cousin’s child experienced studying yuor web blog. She learned so many pieces, including how it is like to have a great teaching mindset to get a number of people with ease learn about a number of impossible subject matter. You undoubtedly did more than her desires. Thanks for displaying the necessary, safe, explanatory and in addition unique guidance on your topic to Emily.

    • August 22, 2020 at 11:34 am

      thx sir


Leave a Reply

Your email address will not be published. Required fields are marked *