Sunday, September 27, 2015

ZERO COST, web based system for Sales, Support, Feedback etc



Are you still using PLEASE CALL BACK THIS CUSTOMER yellow slips system in your office? Are you losing customer or sales because of missing yellow slips?

You can easily create in a very short time, a simple, ZERO COST, web based system for Sales, Support, Feedback etc

1) Login in to your Google account and create your customised Google Form according to your company's requirement. Ask everyone in the office to bookmark  this form in their desktop browser / mobile phone.

2) Now anyone in the office can pick up a customer call and type the details in the form in their desktop / mobile phone.
The details reflects immediately in the connected spreadsheet.

3) The connected spreadsheet can be viewed/edited (according to the rights you assigned) by any employee or the whole department (even when they are away) . They are empowered to support the customer without the yellow slip system.

Monday, October 20, 2014

Word - Tutorial 4 - Printing

After you type a document, spell checked and formatted, you can print the document.

Use File, Print


Set the options as you wish and click Print

Word - Tutorial 3 - Tables

You can create table quickly in Word.


  • Create a New Document.
  • Click on Insert tab.
  • Click Table.
  • Drag to create a table of size 4 rows with 3 columns.




Type the text.
After typing in one cell, to move to the next cell, press Tab key in the keyboard.



You can format the table in the same way you have learnt in Tutorial 2. 

Word - Tutorial 2 - Formatting Documents

Open the document Letter to Joanna.
Save as Try Formatting.

You can format the text as you wish.

Before formatting you have to select the text.

You can easily select text by dragging the mouse over the text. But there is an easy way.

To select current sentence
CTRL + click anywhere in the sentence.

Easy ways to select

  • Move the mouse arrow to the left margin till you get a slanted arrow facing right.
  • Click once, the current line will be selected.
  • Click twice, the current paragraph will be selected. 
  • Click thrice, the whole document will be selected.


Formatting Text
Formatting your document is fun and easy. Follow these steps.
Select a text, click on one of these icons to see how it works.
Select another text and click on another icon till you become familiar with all.





Select one or more paragraphs of text and click on one of these icons to see how it works.


Do not worry if your document becomes messy.
Your original text is under Letter to Joanna,  which you can open if you want.


Word - Tutorial 1 - Typing a document

This tutorial series assumes that you are
  • familiar with Windows software, know how to type.
  • beginner to Microsoft Word.
  • not afraid of making mistakes during learning.



Start Word and type the following text. While typing if you see red colour underline below some words, it is OK.


----------------------
Dear Joanna,

I have started learning Microsoft Word today. This is the first appliation that is used widely in the corporate world. After learning Word, I have planned to learn Excel, PowerPoint and Access.

Excel is spreadsheet software used for Calcuations, Analysis and for drawing Charts.

PowerPoint is presentation software which will be very useful for sales, training peple of our company.

Finally Access is a database which will help to maintain and retrieve the enormous data our company has.


Thank You.

Sincerely


Helen
-----------------------

Saving your document.
  • Use File, Save
  • Select the location where you want to save
  • Type the file name as Letter to Joanna
  • Click Save 








Spelling Check
Wherever you have red colour line the software thinks that you may have spelling error. 
Let us spell check the document.
  • Place the pointer at the beginning of the document.
  • Click Review Tab
  • Click Spelling & Grammer




If the highlighted word has correct spelling, click Ignore All to tell the software that it has no errors.

If the highlighted word has spelling errors, choose the correct suggestion and click Change All.

Save the file after spelling checking is completed.

Excel – Tutorial 5 – Printing


What you want to Print?
To print a chart:  Select the chart
To print few cells:  Select the cells you want to print
To print the entire spreadsheet: Do not select anything


Go to File, Print





You can change all print setting from Page Setup.




Once completed, Click OK.

Excel – Tutorial 4 – Charts

Type the following and save as Charts.





Now we want to draw a column chart for all three months:

  • Select from A1 to D3
  • Click on Insert Tab
  • Choose Column Chart
  • Choose 2-D column






You will get a chart as follows. Use the Layout tab to format the chart as you wish.




View our EasyElearn video on how to draw and format charts.