Example Learn EXCEL2003

Author: 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 for practical learning!
This book thoroughly details the comprehensive functions and application techniques of Excel, carefully planning multiple thematic examples to help you 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 book is highly practical, making it suitable for individuals with computer basics.
· Income and expenditure statement Weekly/Monthly income and expenditure statement / Establish income and expenditure calculation formulas /
· Family property statistics table Total household property 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 return system design department performance formulas / Information return system /
· Satisfaction survey table Satisfaction survey table / Transparent survey table /
· Project planning and tracking — Automated Gantt chart Project schedule table / Foldable Gantt chart / Automatic generation of Gantt chart time axis /
· Perpetual calendar Perpetual calendar formula design / The secret of automating the perpetual calendar /