Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Unit 42 - Spreadsheet Modelling
Transcript of Unit 42 - Spreadsheet Modelling
Saving a file for use with an older version of Excel
To save a file for use with an older version of Excel, choose File . Save As. In the Save As dialog box, select one of the following from the Save as Type drop-down:
•Excel 97-2003 Workbook (*.xls): If the file will be used by someone who has Excel 97, Excel 2000, Excel 2002, or Excel 2003.
•Microsoft Excel 5.0/95 Workbook (*.xls): If the file will be used by someone who has Excel 5 or Excel 95. CSV A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form. When saving an data in a CSV file, the cells are separated by commas, and a new line denotes the beginning of a new line in the spreadsheet. XML Extensible Markup Language (XML)
XML (Extensible Markup Language) stores data in a structured text format.
A specification developed by the W3C. XML allows programmers to create their own personalised tags. As such, .XML documents are exceptionally portable across different systems. Formatting (or style information) for .XML documents can be achieved by using .CSS.
XML files are actually Zip-compressed text files. If you rename one of these files to have a ZIP extension, you’ll be able to examine the contents using any of several zip file utilities — including the Zip file support built into Windows. Taking a look at the innards of an Excel workbook is an interesting exercise for curious-minded users. HTML HyperText Markup Language
With the advent of MS 365 and most MS office tools being online HTML and XML are important formats you should be aware of. Four of the Office 2010 applications are available in online versions: Excel, Word, PowerPoint, and OneNote. You can run these applications from within your Web browser. What is the difference between
Excel, SPSS, Minitab, g-sheet, Lotus 1-2-3 and XML? This format is just another text file. Text files are perhaps the most flexible and most basic format to save data because the majority of applications and operating systems will be able to read them. This is due to the .txt file format consists very little formatting Txt This popular format will enable the user to export the spreadsheet as an Adobe Acrobat® portable document format file, to be read with the freely downloadable Adobe Acrobat Reader® application. Pdf