Excel Efficient Office: Functions and Charts

Author: Shenlong Studio
Publisher:
Publish Date: 2006-02-01
Features: This book is primarily written for office workers to achieve efficient office work. It comprehensively introduces methods for using functions and charts in Excel to complete various statistical, calculation, analysis, and summarization tasks from a fresh perspective, offering strong practicality and operability. The book is divided into 19 chapters, covering fundamental knowledge of Excel functions, typical applications of date and time functions, typical applications of mathematical and trigonometric functions, typical applications of lookup and reference functions, typical applications of statistical functions, typical applications of financial functions, typical applications of logical functions, typical applications of text functions, typical applications of database functions, typical applications of information functions, typical applications of engineering functions, basic knowledge of charts, chart editing, typical applications of bar charts and column charts, typical applications of line charts and XY scatter plots, typical applications of pie charts and doughnut charts, typical applications of other charts, pivot tables and pivot charts, comprehensive applications of functions and charts, and advanced chart techniques as an appendix. The book fully considers the practical needs of office workers, including "Tips and Tricks" to help readers avoid detours during learning and "Example Expansions" to meet the diverse needs of different users. Whether you are a beginner or have some foundation, you can easily use Excel to solve various office problems by studying this book. The book is suitable for office workers, students of economics and management in higher vocational and technical schools, and can also serve as a training textbook for short-term efficient office training courses.