ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Need to keep record of telephone conversions as in sales (https://www.excelbanter.com/charts-charting-excel/19978-need-keep-record-telephone-conversions-sales.html)

tracy

Need to keep record of telephone conversions as in sales
 
I work from home and in sales i need to keep a record of my telephone
conversations, i have outlook which i use but want a excell spreadsheet which
i can see all my calls at once.

Debra Dalgleish

In Excel, create a list of calls.
In row 1, enter the headings, e.g. Data, Start, End, Name, etc.
To enter the date, type: Ctrl + ;
In another column, enter the Start time, by typing: Ctrl + :
When the call ends, enter the end time in a third column,
by typing: Ctrl + :
In additional columns, enter other data about the call, e.g. Person
called, purpose, outcome.



tracy wrote:
I work from home and in sales i need to keep a record of my telephone
conversations, i have outlook which i use but want a excell spreadsheet which
i can see all my calls at once.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com