Home >Topics >excel >What operations must be performed on the data before subtotaling in excel?

What operations must be performed on the data before subtotaling in excel?

藏色散人
藏色散人Original
2021-01-19 11:02:2364903browse

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.

What operations must be performed on the data before subtotaling in excel?

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.

What operations must be performed on the data before subtotaling in excel?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn