Excel Basics Tutorial (Black Magic Cube)

Author: Wang Xinli
Publisher:
Publish Date: 2004-11-01
Features: This book is suitable for readers who are not very familiar with Excel to learn and use, and can also serve as a primary training textbook as well as a reference book for statisticians and financial professionals. Excel is an applied software and also the most popular spreadsheet software today. This book introduces the operations and usage methods of the Excel software in a step-by-step manner. The first five chapters use their space to introduce the basic functions and operation methods of Excel. Chapter 6 explains how to calculate data in Excel. Chapter 7 discusses various techniques for analyzing data using Excel, focusing on frequently used functions in practical work such as sorting, filtering, subtotals, and pivot tables. Chapter 8 covers the creation and use of graphics and charts, where the use of graphics and charts makes the relationships between numbers clearer and more explicit, facilitating various analytical tasks. Chapter 9 primarily introduces the application of Excel on the Web, focusing on topics such as setting up hyperlinks in Excel and how to exchange data with the network. Each chapter of this book includes an extra-reading section for readers who are interested in further learning, and corresponding exercises are provided at the end of each chapter to check your understanding at any time. This book emphasizes explaining knowledge points with examples, with almost every point accompanied by an example. This book is suitable for readers who are not very familiar with Excel to learn and use. It can also serve as a primary training textbook as well as a reference book for statisticians and financial professionals.