Ebook

Ebook 1: Work Smart By Smart Use Of Microsoft Office (Microsoft Excel and Word) 
Price: USD2.99

Ebook 2: Work Smart By Smart Use Of Microsoft Office (Microsoft Excel, Word and PowerPoint)
Price: USD2.99





Introduction

Sometimes when we read a Microsoft Office book, we hope can understand the Microsoft Office

and apply it at our work. But most of the time we may know the powerful of the functions but

may question or not realize how to apply it at our work. In this book, the author will share with

your in each chapter how to work smart by smart use of Microsoft Office (Microsoft Excel and

Word). If you can smart use of the Microsoft Office functions, you can improve your work

efficiency. This book is more focus on how the application of powerful and practical functions of

Microsoft Office and its application to your work.

Special Features of the Book

Picture based book such as comic is easier to digest. Therefore the book uses simplify instruction

and use a lot screen captures for explanation. Pointer is point at screen captures to point out

which area of the screen captures need to pay attention. Even without switch on the computer to

cross check the Microsoft Office tools, the reader also can read anyway, any place because all the

steps is show clearly in screen captures.

Who Is This Book For?

This book is designed to help the entire Microsoft Office user Microsoft Word and Excel to use it

more efficiency. Many Microsoft Office users know how to use Microsoft Office, but may not

realize how to apply, combine or use each Microsoft Office practical function to apply to their

job/study/research. Smart use of Microsoft Office skills can help you increase your work

efficiency.

After many years using of Microsoft Office, helping and observing other Microsoft Office users

resolve their Microsoft Office problems, the author gather all the case study at work to share

with you all. You want to spend 10 years to realize how Microsoft Office can increase your

working efficiency or spend 10 days to read how other people improve their working efficiency.

Even you are the beginner users of Microsoft Office, you will benefit from the book because the

book explain the methods clearly in step by step. You can even save your time to study,

understand of powerful function but may not applicable to you. Smart use of practical functions

of Microsoft Office and its application at your field is much more important!

Microsoft Office Version

This book is using Microsoft Office 2003 in Microsoft Excel, Word throughout the book because

many Microsoft Office users still use Microsoft Office 2003 and below. Even you are using

Microsoft Office 2007 onward, you still can apply it to your work.

 

 

What Does This EBook 1 For?

Here’s what this book covers:

 Chapter 1: “Speed Up Data Entry and Reduce Typing Error” shows you how to speed

up data entry and reduce typing error in fax document, product label, Purchase Order.

You will learn how by selecting the company name in fax document and purchase order,

the selected company’s fax number, telephone number, recipient, will change

automatically. You will learn how by selecting the part number in product label and

purchase order, the selected product’s part name, quantity/box, unit price will change

automatically.

 Chapter 2: “Reduce Time Key In Same Wording, Calculation And Decision Making”

shows you how to reduce time key in same wording with number/text repeatedly in

inspection report, purchase order, evaluation form. You will learn how to make

calculation and decision making automatically base on entered data in these document.

 Chapter 3: “Monitor Data Entry” shows you how to monitor data entry automatically

once the data is entered. You will learn how to set reminder or highlighting for those data

not fulfill your requirement in stead of human reviewing data.

 Chapter 4: “Updating Database Or Master List Automatically” shows you how to link

information from multiple documents into database or master list and update database

automatically whenever the changes make in the documents in Microsoft Excel and

Word.

 Chapter 5: “Combine Data From Different Forms (Users) Into A Form” shows you

how to combine data from different forms (users) whenever receive from their reply by

email and update automatically into your master form. You will learn how to review the

changes make by each recipient.

 

What Does This EBook 2 For?
Here’s what this book covers:

 Chapter 1: “Mail Merge” shows you how to retrieve data from database in preparing


envelope, letter, contract, agreement, quotation and etc. automatically. Changes make in

database will automatically reflect in envelope, letter, contract, agreement, quotation and

etc.

 Chapter 2: “Create Table Of Contents Automatically” shows you how to create and

revise table of contents automatically for long report such as thesis, manual and etc. The

table of content can let you link to the related page automatically.

 Chapter 3: “Data Analysis” shows you how to compile and present a big group of data

such as product defects. You will learn to analysis data in table and chart in different

points of view.

 Chapter 4: “Linking Data From Form To Database” shows you how to duplicate form

such as purchase order, claim, customer complaint, document change notice from a

master document (template) and then update the important information into a database

automatically. The changes make in filled-up form can also update automatically into the

database.

 Chapter 5: “Linking Slide To Other Documents” shows you how to link and open

Microsoft Excel, Word file and other slide when presenting a PowerPoint slide.