
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
This manual begins with a review of multiple worksheets, 3-D Formulas and Group Mode. Readers will learn to summarize data with the Data Consolidate command and build lookup formulas to link data among workbooks. Templates, protecting formulas, IF statements, PivotTables, Pivot Charts, and an introduction to Excel VBA are also included in this course.
This manual guides users through advanced features of Microsoft Excel 2002, building upon foundational knowledge. The authors, Elizabeth Carpenter and Pamela Adams, detail techniques for managing and analyzing complex data sets. The content covers advanced formula construction, data consolidation, linking workbooks, and leveraging tools like PivotTables and Pivot Charts for insightful data visualization and reporting.
This technical manual is designed for users seeking to deepen their proficiency with Microsoft Excel 2002. The content focuses on practical application and advanced techniques, suggesting it is aimed at individuals who already possess a working knowledge of the software. The inclusion of topics like VBA indicates a target audience interested in automation and more complex data manipulation.
Page Count:
114
Publication Date:
2004-01-01
Publisher:
CPI Training Solutions, Incorporated
ISBN-10:
1581631243
ISBN-13:
9781581631241
No comments yet. Be the first to share your thoughts!