Openoffice print gridlines3/15/2023 ![]() To begin, select all of your data including the column titles. With DataPilot, you can extract this information easily. While this spreadsheet is very informative as it is designed, suppose that you want to calculate the sales total for each rep? ![]() Each line in the spreadsheet contains the product name, the product category, product price, quantity sold, the sales representatives name, and the total sales figure for that product. To see how DataPilot works let’s suppose that you have a spreadsheet that contains sales data for 26 products in a catalog. In order to help you ferret out that hidden information, filter it, and then explore it from a number of angles Calc provides you with a feature called DataPilot, which of course is designed to be emulate Excel’s PivotTable feature. While the object of putting numbers into a spreadsheet is to make it easier to analyze the data, often times important trends or even problems can become buried deep with the numerous rows and columns of a huge spreadsheet. With this in mind, let’s take a look at performing some common Excel tasks in 2.0’s Calc. When it comes to this application, 2.0’s Calc provides you with everything you need and then some. Of course every business generates data of some sort and since the early days of Lotus 1-2-3, business people have been have been entering and manipulating data in electronic spreadsheets. As such, it won’t take nearly as much time as you might think for seasoned Microsoft Office users to train themselves how to use 2.0. Realistically speaking, it will take some time to make the transition as many features and settings are named differently and are in different locations, but the names and locations aren’t too far of a stretch of the imagination and it’s easy to make the connections. Sure the cost difference, several hundred bucks verses free, is very, very attractive! But is that savings going to be eaten away by training costs and lost productivity? Fortunately, the answer is no! 2.0’s cadre of open source developers has spent a great deal of time in an attempt to make the two office suites as alike as possible in both the feature set and more importantly in the user interface. Many folks may be a bit apprehensive about making the switch from Microsoft Office to because of the learning curve. This gallery is also available as a TechRepublic article. ![]() DataPilot provides you with an easy way to ferret out information hidden in a spreadsheet
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |