Excel Charts World - Fashion IT Life Show (2007 Edition)

Author: Wang Wei
Publisher:
Publish Date: 2007-01-01
Features: The book is divided into the following 9 chapters. Chapter 1 introduces the methods and skills for entering typical data into Excel worksheets, laying a solid foundation for further learning the powerful functions of Excel 2007. Chapter 2 covers the settings for cell formats in tables and some overall operations on worksheets. Chapter 3 discusses data analysis and management, including sorting, categorizing, summarizing, filtering, and consolidating large datasets. Chapter 4 explains how to create charts, draw graphics, insert images, and add artistic text. Chapter 5 introduces Excel's calculation functions, including the use of functions and methods for editing formulas. Chapter 6 covers techniques for protecting worksheets and data, such as adding and removing workbook protection passwords, setting passwords for opening files, and adding or removing worksheet protection passwords. Chapter 7 discusses advanced operations in Excel 2007, including the use of forms and macros. Chapter 8 provides tips for printing worksheets, including setting paper sizes and print ranges. Chapter 9 presents several comprehensive application examples, such as retrieving data from the internet, visually analyzing price trends, and calculating bonus rates.