Newcomer's Guide to Creating and Using Spreadsheets - (Includes CD-ROM)

Author: Shenlong Studio Editors
Publisher:
Publish Date: 2006-03-01
Features: This book is an introductory guide for beginners to learn and use Excel 2003 for comprehensive computer office applications. It primarily uses examples of Excel 2003's comprehensive applications in school and company management to detail the fundamental knowledge, operation methods, and usage steps that beginners must master when using Excel 2003. Additionally, it provides expert-level guidance on common issues beginners often encounter when using spreadsheets for comprehensive applications, helping them avoid detours in the learning process. The book is divided into 14 chapters, covering Excel 2003 basics, creating the "Student Information" worksheet, editing the "Student Information" sheet, beautifying the "Student Information" sheet, managing the "Student Information" sheet, creating the "Sales Performance" sheet, creating and managing the "Payroll" sheet, creating a "Payroll" template, creating the "Monthly Sales Statistics" sheet, creating "Student Grade Charts," creating "Grade Pivot Tables," printing the "Student Information" sheet, and in-depth case studies—establishing and analyzing the "Fixed Asset Report." It also includes other applications of Excel.
Additionally, the accompanying CD-ROM provides over four hours of multimedia teaching demonstrations, more than 50 classic application tips, and over 70 practical templates. The book fully considers the practical needs of beginners. Readers who have "no idea at all" about spreadsheets can easily master spreadsheet creation and complete comprehensive computer office applications through this book. It is suitable for beginners of Excel 2003 software, office personnel in various companies, and can also serve as a training textbook for short-term Excel 2003 spreadsheet creation workshops.