Calc

Calc is OOo's spreadsheet creation and management tool. It allows newcomers an easy enviroment for starting and data wizards the advanced functionality they want. Calc can be a free replacement for Microsoft's Excel. Now have fun trying to fill up the 17,179,869,184 cells of data you can have in one file!

Calc Interface:

Features

Calc has a great enviroment and advanced functionality here is some of it:

• Intuitive Design - the design of Calc is great, this program works the way your mind does. For example if you only want to type in the first 10 rows, highlight those rows and Calc will know that you only want to type in those rows. Or you have a column of five numbers and you click to the 6^th column. Then you click on the subtotal/sum button of the formula toolbar, Calc will know that you wanted to add those 5 columns and give you your result in that 6^th cell.
  
• Function Wizard (Ctrl+F2) - Calc has about 375 functions, all at your control, providing amazing power! In the function wizard they are seperated in groups such as Financial, Information, Logical and others. What is so great about this is that all of these functions are in the control of any average user, because the in-software help provides information and examples for each one of them. However some of them are so advanced you may still never use them.
• External Data Linking - with this you can pull information off of the internet or your files in order to pull conclusions from data. Futhurmore the spreadsheets can be updated to reflect changes in the the source.

Quick Rundown

• A. - File, has procedures such as Open, Save, Export, Print, and more.
  
• B. - Edit, actions such as Copy, Paste, Undo, Redo, and more are in this menu.
  
• C. - View, all the Toolbars, Viewing modes, and Zooming options are contained here.
• D. - Insert, insert Rows or Columns, Sheets, Charts, Notes, Images, and numerous other things with this menu.
  
• E. - Format, in here you can format everything from the Page to the Cells.
  
• F. - Tools, for Calc this includes stuff like the Goal Seeker, Detective, and Solver, but also includes tools in multiple applications such as Spelling, the Gallery, Macros, and more.
  
• G. - Data, is a menu exclusively for Calc. It contains exclusive procedures for the data in the cells, these procedures include: Filter, Define Range, Sort, Consolidate, Validity, and even more actions.
  
• H. - Window, this window lets you open another window of the same file, and for Calc it also lets you Freeze and Split the cells.
  
• I. - Help, like in every other OOo application this menu contains things for help, such as the in-software help manual.
  
• J. - Number Formats, these buttons let you change the type of number format you are using, for example clicking on the coins/money will change a 5 you typed in into $5.00. Other format types are Percent, Date, Exponential, and Standard.
  
• K. - Formula Bar, this is arguably the most important part of spreadsheet applications, it lets you create simple to complicated formulas to ease the process of calculating and inserting data. A simple formula may be =SUM() which lets you add the cells in the paratheses together.
  
• L. - Simple Formatting & Font Tools, important to anything with text or numbers, it lets you change the font or style of the font.
  
• M. - Sheets, this simple part of the interface lets you move from sheet to sheet. Also double clicking on the sheets lets you rename them, and double clicking where there is no sheet, lets you add a sheet.
  
• N. - Zoom, this slider lets you zoom in and out of the spreadsheet to either see more or less cells. It also shows you the current zoom percent.