Does this system work in other spreadsheet ? Other than Microsoft Excel, there are other spreadsheets under other Office suites, such as Lotus123, OpenOffice, StarOffice, Microsoft Works, etc. The formulas and functions in this book have not been tested in those spreadsheets. However, most probably, you can use this method on other spreadsheet, as long as the other spreadsheet has the formulas, PivotTable operation and Filtering operation capabilities similar to Microsoft Excel. May be there are small variations on how the functions and formula should be constructed or difference in syntax. Most spreadsheets have functions similar to AutoFilter and PivotTable. You can check by opening Excel files using those spreadsheets applications and see whether the formulas are still intact and get the expected results. If not, then the application is not fully compatible with Microsoft Excel.
No comments:
Post a Comment