Very Easy: Efficient Excel for the Office
Tags
Summary
Very Easy: Efficient Excel for the Office is a title in the "Very Easy" series from China Machine Press, compiled by Chuangrui Culture, running about 240 pages with an accompanying instructional CD. Built around Excel 2010, it proceeds step by step from getting to know the software to building tables, entering data, organizing and formatting, calculating and analyzing, and presenting results graphically, aimed at the everyday spreadsheet tasks office workers most often face and most urgently need to solve. In structure, the book explains one concept per page or two-page spread: each section focuses on a single operation or a single annoying problem, first presenting the scenario and then walking through it in numbered steps with interface screenshots, so readers need not start at page one but can jump straight to the page they need and find an answer within a minute or two. The early chapters begin with installing Excel 2010 and creating workbooks, then cover customizing the Ribbon and Quick Access Toolbar, adding, deleting, hiding, and showing workbooks and worksheets, merging cells, and adjusting row height and column width; there follows data entry and organization, including number, date, and time formats, bulk filling, Paste Special, Find and Replace, and Go To; then formatting techniques such as fonts, borders, shading, cell styles, and table styles; and finally working with pictures and shapes, SmartArt diagrams, common functions, sorting and filtering, charts, and PivotTables. The book is aimed at office staff from complete beginners to elementary level, seeking to make learning easy and doing enjoyable; it suits self-study by secretaries, administrative staff, finance and HR staff, and marketing staff, and can also serve as an introductory Excel textbook for computer training classes.
Editor's review
很多Excel入门书的问题不是内容不够多，而是“翻不到、学不完”——厚厚一本从头读到尾，读者早就失去了耐心。这本《非常Easy:Excel高效办公》抓住了办公族的真实处境：没时间系统学习，只想立刻把手上那张表做出来。 于是全书采用了非常务实的设计：一页或两页只说清一个知识点，配以分步骤讲解和界面图示，目录本身就是一份“问题索引”。预算表要加边框、身份证号老是变成科学计数法、想把每个部门的人数画成图——翻到对应页面，跟着点几下就能完成。这种“按需查阅”的编写思路，比线性讲授更适合在职学习。 内容覆盖也较为完整，从认识Excel 2010、工作表与单元格的基本操作，到数据输入、整理、美化，再到图片图形与SmartArt的应用，基本走完了办公表格从无到有的全流程。随书附带的光盘提供了与书中案例配套的素材和模板，边看边练更容易形成手感。 需要提醒的是，本书以Excel 2010为操作环境，界面布局与后续版本已有差异，新一代用户阅读时需自行对照功能位置。不过表格制作的底层逻辑没有变，作为低成本、可随时翻查的案头手册，它依然适合放在办公桌上备用。
Who it's for
A good fit for
- 刚入职、需要独立做报表的行政、文秘与人事岗位新人
- Excel只会打字、不会用格式和函数的零基础办公人员
- 希望把表格做得更规范的财务、销售、技术人员
- 各类电脑培训班中需要一本随查随用的Excel入门教材的学员
Not a good fit for
- 需要学习Power Query、动态数组等现代数据分析技能的中高级用户
- 追求函数嵌套、VBA自动化或数据建模深度内容的专业读者
- 使用Excel 2019、Microsoft 365等新版本、要求界面完全对应的读者
Reading tips
- 先浏览目录，把自己工作中最急的一张表挑出来，直接跳到对应小节边读边做。
- 配合随书光盘中的案例文件同步操作，每学一个知识点就回到自己的实际报表里试一遍。
- 准备一个“问题本”，遇到不会的操作先按目录检索，再补充记录在本子里形成个人速查表。
- 在新版本Excel中练习时，留意功能区位置的变化，重点掌握操作逻辑而非按钮坐标。
About the publisher
China Machine Press
China · Founded in 1950
In addition to science and technology and professional publishing, the books in our catalog from China Machine Press also reflect a sustained focus on psychology, computing, management, finance and economics, and social sciences. In psychology, the catalog includes works by C. G. Jung and introductions to analytical psychology, as well as applied topics such as stress and health, and addiction and healing. In computing, it features Structure and Interpretation of Computer Programs (JavaScript Edition). Management and finance titles include Administrative Behavior (4th Edition), The Price of Inequality (Collector's Edition), and This Time Is Different: Eight Centuries of Financial Folly (Commemorative Edition). In the philosophy and history of science, there is The Worldview: The Third Edition. Relevant authors include C. G. Jung, William McGuire, Sonu Shamdasani, and Gabor Maté. Public information is limited; the above summarizes the publisher's profile based solely on the books in our catalog.
Contents
- Preface
- Chapter 1 Getting Started with Excel 2010
- Installing Excel 2010
- Quickly Creating and Saving a Blank Workbook
- Creating Workbooks from Sample Templates
- Changing Interface and Gridline Colors Freely
- Customizing the Quick Access Toolbar
- Customizing the Ribbon as You Like
- Getting Help from Excel Help Files
- Chapter 2 Basic Operations on Workbooks, Worksheets, and Cells
- Changing the View for a Single Workbook
- Changing the View for Multiple Workbooks
- Splitting and Freezing Windows
- Converting Excel 2010 Workbooks to Earlier Versions
- Renaming and Color-Coding Worksheets for Emphasis
- Adding or Deleting Worksheets as Needed
- Hiding or Showing Important Worksheets
- Moving or Copying Worksheets
- Inserting Rows and Columns to Add Missing Data
- Merging and Splitting Cells for Neater, More Professional Tables
- Adjusting Row Height and Column Width
- Hiding or Showing Important Cell Content
- Chapter 3 Entering Data in Worksheets
- Entering Text in the Formula Bar and in Cells
- Entering Various Types of Numbers
- Entering Dates and Times
- Inserting Symbols
- Inserting Comments for Cells Needing Special Notes
- Adding Pinyin Guides for Hard-to-Read Chinese Characters
- Filling Data in Various Ways
- Using Entry Tricks to Save Time
- Chapter 4 Organizing Data Entered in Worksheets
- Applying Number Formats to Improve Readability
- Customizing Number Formats to Different Requirements
- Changing Text-Type Number Formats for Simple Calculations
- Copying and Pasting Cells and Ranges to Save Entry Time
- Moving Cells and Ranges to Correct Entry Errors
- Pasting Only Values
- Transposing Data from Rows to Columns
- Finding and Replacing Ordinary Characters
FAQ
这本书讲的是哪个版本的Excel？
全书以Excel 2010为操作环境编写。书中的功能在新版Excel中大多仍然存在，只是按钮位置和界面略有差异，读者可以借助搜索框或“帮助”找到对应命令。
零基础、从来没做过表格能看懂吗？
可以。本书从Excel的安装、创建工作簿和认识界面讲起，所有操作都按步骤配图说明，一页或两页只讲一个知识点，是专为初学者和办公新手设计的入门读物。
书里包含光盘吗？内容是什么？
该书出版时随书附带一张教学光盘，提供与书中案例配套的素材文件、模板和操作演示，具体内容以随书实物为准；购买二手书时需注意附件可能缺失。
这本书和“Excel行政与文秘高效办公”有什么区别？
两者同属机械工业出版社“非常Easy”系列，作者同为创锐文化，但内容侧重不同：本书讲Excel的通用操作与表格制作，后者则围绕行政与文秘的具体业务场景展开。
读完这本能达到什么水平？
可以独立完成日常办公表格的创建、录入、格式化、筛选排序、函数计算与图表呈现，达到熟练办公的初级到中级水平；若需进阶数据分析，还需继续学习函数与数据透视表专题。
Comments
Find this book
This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.
