Learn Excel 2003 (Illustrated Example Series)

Author: Zhang Boyong, Zhang Weizhen
Publisher:
Publish Date: 2005-07-01
Features:
· In-depth analysis of design processes, concepts, and techniques!
· Example creation process derived from goals, complete knowledge!
· Extensive learning and application tips, broad application!
· Real-life and workplace examples, practical learning!
This book provides a detailed description of comprehensive Excel functions and application techniques, carefully planning multiple thematic examples to fully understand data entry, analysis, statistics, filtering, and other operations, quickly completing tasks such as project plans and pivot charts. The content is in-depth, the knowledge is complete, and the practicality is strong, making it suitable for individuals with computer basics to learn.
· Income and expenditure statement Weekly/Monthly income and expenditure statement / Establish income and expenditure calculation formulas /
· Family property statistics table Household property total filtering list / Household management automatic operation /
· Stock trading information automatic acquisition and update Daily price table / Advanced filtering stock information /
· Performance completion plan and progress tracking table / Performance and return comparison analysis table /
· Information automatic tracking and feedback system Design department performance formulas / Information feedback system /
· Satisfaction survey table Satisfaction survey table / Transparent survey table /
· Project planning and tracking – Automated Gantt chart Project arrangement table / Foldable Gantt chart / Automatic generation of Gantt chart time axis /
·//
formula design / The secret of automated/