| |
Ability Spreadsheet
Description Ability Spreadsheet is the perfect tool for managing all your numerical data, whether business accounts, home finances, complicated calculations or homework problems. To help you make sense of your figures, Ability has incorporated all the essential features users would expect from their spreadsheet, as well as a range of advanced features – some of them unique to Ability Spreadsheet – to make working with numerical data as easy and clear as it gets:
industry-standard look and feel multi-sheet workbooks connected by cross-sheet formulas to help you organise and connect your data each workbook can contain up to 255 worksheets of 256 columns by 65,536 rows labour-saving tools such as AutoSum, AutoStats, AutoSpell, and AutoList over 240 predefined functions, grouped into useful categories: mathematical, financial, trigonometric, logical, statistical, date and time, text, and document information Microsoft Excel compatibility Recent Folders and Recent Files sidecar menus to make finding files and folders quick and easy a PDF Creator to create PDF copies of your spreadsheets – these can then be emailed
a comprehensive range of charts, with 41 styles grouped into 11 categories: Column, Bar, Line, Pie, XYScatter, Area, Financial Stocks, Strata, Radar, Bubble and Vector headers and footers row and column freezing to preserve the display of titles (on-screen and at print time) user-definable page breaks Print-to-fit auto-scaling spreadsheet templates to enable you to use your specially designed spreadsheets again and again advanced cell formatting, including merging and splitting of cells, cell comment boxes, double-line cell borders, and custom format styles tool tips to display cell formulas hyperlinks to call up web pages Macros - use VBScript, OLE automation and programmable forms browsing and editing of database files, including Microsoft Access files, from the spreadsheet by using unique database functions
live sharing of data between database and spreadsheet through unique Edit Source option: allows database data to be modified from spreadsheet and spreadsheet data to be modified from database without your having to locate and open the remote file querying of database fields inserted into spreadsheet: apply sorts, selections, column orders and queries created in database, or create your own directly in spreadsheet insert text-effects using WriteFX (as in Ability Write) cells can be formatted for fonts, borders and colours directly from the toolbars multiple non-sequential cell selection, allowing quick and flexible formatting of selected areas of the spreadsheet SQL querying to extract data from many standard databases
|
|