Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start 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

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


Unit 42 - Spreadsheet Modelling

Alternative Spreadsheets

Ben Holding

on 27 February 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Unit 42 - Spreadsheet Modelling

Alternative spreadsheets Unit 42 - Spreadsheet Modelling What alternative spreadsheets can you name? Alternative formats Alternative formats: xls, csv, txt, xml, html XLS Excel Binary File Format (.XLS)
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
Full transcript