Filtering: We can Filter the data in Excel.We can sort Ascending or Descending with on or more columns. Sorting: We can sort the data in Excel.We can connect to verity of the data bases and import the data into Excel. Database: We can use Excel as Data base to store the 1 million records.Sparklines: Introduced in Excel 2010, we can insert the light weight charts into the cells.This will be helpful to quickly perform further analysis. We can create the tables in the data in records and fields format. Slicers: Slicers are introduced in Excel 2010, this will helps us to connect the multiple pivot tables and filter the data with buttons.PivotTables: We can use the Summarize the data and create powerful cross tables.Example backgrounds of Worksheets, Shapes and Charts.Įxcel can be used as data base and perform of verity of data operations. Pictures: We can insert any image to enhance the objects.Clip Arts: We can add the ready to use clip arts to convey our message in pictorial representation.SmartArts: We can use the SmartArts to align the data in a creative designs and visually communicate the information.We can draw any shape with the free form feature in Excel. Shapes: We can create verity of shapes to represent the data in shapes and info-graphics.Charts: We can use charts to represent the data in rich visualized graphical representation.We can divide the Main features of the Excel into Graphical, Data Base and Functional Features:Įxcel have verity of the graphical features to represent the data in Charts and pictorial format. Here are the main features of the Microsoft Excel. Microsoft added many features in each release of Excel 2007, 2010, 2013, 2016 and Office Online 365. Excel is the very popular application because of its wide range of features and powerful tools. Here are a few articles I used in my own research to help me better understand how all of this stuff works.Features of Excel made the Excel as most widely using application. There is a lot of good information out there about password encryption and it's actually pretty interesting. If you have sensitive files that were protected in Excel 2010 or earlier you may want to go back and re-protect them in Excel 2013 to obtain this higher level of security for your workbooks. This would place your protection in grave danger as there are a lot of free macros floating around out there that can easily break into an Excel 2010 or 2007 protected file. However, the opposite could happen where you decrease the protection strength of a file by re-protecting an Excel 2013 file inside of Excel 2010. This scenario would obviously work in your favor as Excel 2013 security is much harder to get past. The strength of security depends on which version of Excel you place the protection NOT the version it is created.įor example, if you created a password-protected worksheet in Excel 2007 and then unlocked & re-locked the same spreadsheet in Excel 2013, your worksheet would now have Excel 2013 level password protection (with the longer Hash and Salt Values). While Excel's password security is still relatively simple (from an experienced computer hacker's point of view) to break, there is now a huge gap in the level of security provided by versions of Excel prior to 2013 versus the versions following 2010. This is probably the most important part of this article as it is vital that you understand how secure your workbooks and worksheets are. Understanding How To Control Your Password Protection Strength
The below XML code was inside a workbook where I used the password "SpreadsheetGuru" to protect a blank worksheet. A Hash is the output from a Hash Algorithm (complicated mathematical equation) that turns any user-generated password into a jumbled-up string of (appearingly) meaningless characters. Here's a fun fact: Excel does not actually store the password you input! Like most password protection software out there, the Excel Application stores a string of data called a Hash. I won't go into detail on where to find the password information however I will show you an example of how the code is written in both Excel 2007-2010 and in the more secure Excel 2013 version. Likewise, if you understand how these zipped files are written and organized, you can determine settings, data, and even password information made by the user who created the Excel file. Magically your Excel file is transformed into a bunch of files with lots and lots of computer (OpenXML) code! This is important to know as this is where you can dig into how an Excel file is made up.
Don't believe me? Go to one of your Excel files on your computer and change its extension from.
Many don't know this, but every individual Excel file is really a.
0 kommentar(er)
