Before classifying and summarizing in Excel, the data must be "sorted" to ensure that the categories based on the classification are in continuous positions without gaps between them; the general uses of Excel include accounting, budgeting, and accounting. Orders and sales, reporting, plan tracking, using calendars, and more.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2003 version, Dell G3 computer.
Related learning recommendations: excel tutorial
You must first perform a "sort" operation on the fields used as the basis for classification to ensure that the categories based on the classification are in continuous positions, between No gaps occur.
General uses of Excel include: accounting, budgeting, billing and sales, reporting, plan tracking, using calendars, etc.
A large number of formula functions in Excel can be applied and selected. Using Microsoft Excel, you can perform calculations, analyze information and manage data information lists and data charts in spreadsheets or web pages. You can implement many convenient functions, with Convenience to users.
The above is the detailed content of What operations must be performed on the data before subtotaling in excel?. For more information, please follow other related articles on the PHP Chinese website!