#MICROSOFT EXCEL DATA ANALYSIS 2013 WINDOWS 8#

It will extend your Excel experience to the web browser, now we can open the Excel Workbook online on your web browsers and work with workbooks directly. Microsoft Office OnlineĮxcel Online is new interface created from Excel 2013. We can develop Excel Add-in to re-use the macros whenever we need them. xlam Excel File Format: This is Excel add-in File format, we can develop the Excel workbook with most useful macros and save it as Excel Add-in.

So that we can use it again when we need the same format of the template. xltx Excel File Format: This is Excel Template File format, we can create spreadsheet with all required formats and save it as Excel Template. The default file format (.xlsx) does not save the Macros. xlsm Excel File Format: This is Excel Macro File format, we need to save the Excel file with Macros in. This is the normal spreadsheet to save the data, formulas and not Macros.

xlsx Excel File Format: This is the default Excel File format, when we save the file in 2013 version of Excel. Here are the most commonly use Excel File format. Files Format of Excel 2013 :įrom 2013 version of Excel, Microsoft maintained the same file formats of Excel 20. And Open workbooks can be Limited by available memory and system resources of the user. So, we can enter the data in maximum of 1,048,576 records and We can have maximum of 16,384 Fields in Excel 2013. No change in number of Rows and Columns of Microsoft Excel spreadsheets. 2013 version of Excel is not MUI (Multi User Interface) and it is SUI (Single User Interface), i.e One workbook in One Window.

#MICROSOFT EXCEL DATA ANALYSIS 2013 WINDOWS 8#

Flat application look like Windows 8 and 10 suits, Flash fill, Recommended charts and Quick Format Tools for Charts, Instant Data Analysis, now slicers can be used for filtering the pivot table data. Microsoft introduced many new features in 2013 version of Excel.

Microsoft excel data analysis 2013