How to convert numbers into words.

How to convert numbers into words.

Here is the explanation to convert the numbers into words with images or screenshots.

Question: How can we convert any numeric number into words in MS excel?

Answer:  There is no option yet to use this thing as a function or formula in MS Excel, However, we have to install this function as a custom function ourselves in Microsoft excel. So how are we going to do it, let us explore here now?

NOTE: We have to do it through macro code then we will be able to install this custom function in MS excel.

Let’s start now.

Firstly we have to open an MS Excel spreadsheet and press 2 keys together at the same time (ALT+F11)

Then it will open up a new dialogue box under the name “Microsoft Visual Basic For Applications”

Let us check this dialogue box in the image here first below.

Now we can clearly see this image and under the INSERT button, we have to find out MODULE and click on that. Once we click on that then there is a small empty box will open up, also we can see that box in the image above.

Here we have to paste a “MACRO CODE” which will create a custom function or formula in our spreadsheet we will be able to use this function easily which will help us to convert any numeric number into words in MS excel.

NOTE: This macro code is available here which could be easily taken. 

(https://drive.google.com/file/d/1ZWN4SHgm973jUFGVYEjFDcN1_CwCbQg8/view)

After putting this macro code here in the empty box then we can minimize it and simply go to our actual excel sheet that we opened first of all when we started. Here we have to go to the “FILE” menu and click “SAVE AS” and save this file.

Make sure we will save this file under the “EXCEL MACRO ENABLED WORDBOOK” with any desired name.

Now we saved this file and will open this again and type this formula or function which will help us to convert numbers into words.

This function is as follows as below. =SpellNumber(SelectedNumber’sCell)

Let us check it here In the attached screenshot below.

So now we have seen here, this has been solved easily but here again, we will explore it like how we applied this function in MS excel after putting this “MACRO CODE”

Question: How we can use this customer function?

Answer: Now we can open an MS Excel spreadsheet and let's suppose we put a number like any number like “450” in “E8 cell” as we can check in the image also.

In another cell which is “F8”, we have to apply this function so let us start now. Let us put a =SpellNumber(E8) and hit enter. That is it. If we do apply this custom function now then we will have numbers into words.

Here we have seen this was quite easy to make a custom function in MS excel through a “MACRO CODE”.

Nowadays this feature is the most helpful and required in all fields where we work in excel. Along with this, we can also explore our knowledge with other functions which are mostly used as features such as Vlookup, PivotTable, etc.

Vlookup - In its least complex structure, the VLOOKUP work says: =VLOOKUP(What you need to look into, where you need to search for it, the segment number in the range containing the incentive to restore, return an Approximate or Exact match – demonstrated as 1/TRUE, or 0/FALSE).

Hlookup - HLOOKUP represents Horizontal Lookup and can be utilized to recover data from a table via scanning a line for the coordinating information and submitting from the comparing part. While VLOOKUP looks for the incentive in a section, HLOOKUP looks for the incentive in succession.

Trim Function - The Microsoft Excel TRIM capacity restores a booking incentive with the main and following spaces eliminated. You can likewise utilize the TRIM capacity to eliminate unused spaces between words in a string. The TRIM capacity is a basic capacity in Excel that is ordered as a String/Text Function.

Sum Function - The Microsoft Excel SUM work includes all numbers in the scope of cells and returns the outcome. The SUM work is a perfect capacity in Excel that is ordered as a Math/Trig Function. It tends to be utilized as a worksheet work (WS) in Excel.

Data Validation Function - You can use data validation to secure such data or the features that customers go into a cell. One of the most broadly considered data validation uses is to make a drop-down summary.

Conditional Formatting - 

1). First, you need to select a cell where you want to put a condition or apply a conditional formula. 

2). Click the conditional formatting tab above and you will find many ways to use it.

3). Here you have all options like Highlight cell rule, Top-bottom rules, etc. 

4). You can use any conditional formatting rule from the options we have here.

5). Here you can also use a new rule for text functions, let's suppose you want to put any condition on the text then it also can be done easily here by using this conditional formatting function. You have also an option to highlight any numbers or texts that you have in cells.

6). Even you can also put any condition here by using it on dates as well.

7). Here you also have the option to select the duplicate values which can be coloured or highlighted easily by using this function rule of conditional formatting. 

8) You can use this function in multiple ways as it has many features, The topmost features it has that we are discussing here such as highlighting duplicate values, values in percentages, values from top to bottom, values from bottom to top, selecting texts alphabetically or etc.

There are many things to learn in ms excel but we need to explore our knowledge base about it if we want then we have multiple functions to use as features or functions in ms excel.

Exporting data from excel to word

Data Transfer From Excel To Microsoft word- MS Word is amazing to use in terms of making any table or handling any data in it but what about if we want to transfer any data from excel to word? of course we have many ways to do it. So here we will explore how can we transfer data from excel to word without any software. we can simply transfer any excel data to word.

Data Transfer:- Nowadays people think that data transfer is a little tough task because they are not aware of it that how to do it however some people do that easily if they have knowledge about it. Now the challenge is, How can we go ahead and transfer this data or any work data from ms excel to word? For this, there is an absolute full explanation below about it. let us go through it now.

Also, it needs words in the way that if we want to make any changes in ms word, that change must be updated automatically in Microsoft excel also. 

Process:- First of all to transfer any data from ms excel to ms word, we need to open our excel spreadsheet where the data we have and also open ms word there we need to transfer the data then copy all data and then go to ms word file and do click paste special. 

Once this option gets clicked we will have this page coming up. look at below the image.

Data Transfer from MS Excel to MS Word

But make sure both files must be saved already because it does not perform or work in unsaved files. so before doing it, please check both files (excel and word) must be saved already then it will only work. 

Now please check the image carefully. here we will click this option that we have on the left side of this image named PASTE LINK. After clicking it now again we got a few options in the box right-hand side which you easily see in the image below.

Data Transfer from excel to word.

Now per the image, we have above, there are 2 options to save this file.

1). PASTE

2). PASTE THE LINK

we have these 2 options to perform in different ways for different conditions.

Nut Now we have to use the 2nd option which is PASTE LINK once we click this button then we get again these many options like:- 

1). Microsoft excel worksheet object - The Worksheet object is an individual from the Worksheet selection. The Worksheets selection contains all the Worksheet objects in an exercise manual.

2). Formatted text (RTF) - Windows Metafile (WMF) is a picture document design initially intended for Microsoft Windows during the 1990s. The first Windows Metafile design was not gadget autonomous (however could be made all the more so with arrangement headers) and may contain both vector illustrations and bitmap parts. It acts likewise to SVG documents. WMF records were later supplanted by Enhanced Metafiles (EMF documents) which accommodated gadget autonomy.

3). Unformatted Text - If we copy any file from word to any other word document then it might raise an issue then simply use PASTE SPECIAL and click this option to solve.

4). Pictures (Windows Metafiles) - It stands for an image file format that was basically invented by Microsoft windows in 1990.

5). Bitmap - Bitmap works like a memory organization that stores digital images.

6). Word Hyperlink - it can be added to any picture.

7). HTML Format - It stands for HyperText Markup Language. 

8). Unformatted Unicode text - It keeps the content as same in only text format. let support if you need to copy something in text format and want to paste that somewhere so we can select this option in PASTE SPECIAL and it will keep the only text as in content.

Here we have to select this particular option Microsoft Excel Worksheet Object and now hit OK. Now you will see in the video that we have transferred the data from ms excel to ms word successfully. Now the question is what is the benefit of it? 

Question:- Do we have to click only that option Microsoft Excel Worksheet Object only?

Answer:- Yes. We have to click only this option which is Microsoft Excel Worksheet Object and we have done the same here too. Because now whatever changes would be made in that ms excel file those changes will automatically be updated thereby click the update link option. 

this option will come on on ms word file document by doing the right click of the mouse and selecting the option update link or file and changes would be updated successfully.

 

That s all now we have learned how to transfer the data from ms excel to ms word. it has the only benefit that changes also would be made in that MS word made if any were done in the previous ms excel file.

The other features also we have which we have seen above. we can use these features for different scenarios. 

1). Microsoft excel worksheet object - A Worksheet is a collection of cells composed in rows and columns. Every worksheet contains 1048576 lines and 16384 segments and fills in as a big size of the table that permits you to arrange data. Commonly, an exercise manual contains a few worksheets with related substances and just each of the worksheets is dynamic in turn.

2). Formatted text (RTF) - RTF stands for Rich Texts Format. we use this file for creating formatted text files.

3). Unformatted Text - This is a file that does not have a proper format.

4). Pictures (Windows Metafiles)- Windows Metafile ( WMF) is a picture document design initially intended for Microsoft Windows during the 1990s. The first Windows Metafile design was not gadget-independent (however could be made all the more so with arrangement headers) and may contain both vector illustrations and bitmap parts. It acts likewise to SVG documents. 

WMF records were later supplanted by Enhanced Metafiles (EMF documents) which accommodated gadgets independently.

5). Bitmap - 

6). Word Hyperlink

7). HTML Format

8). Unformatted Unicode text

              

How to create feedback form using Google apps.

Feedback Form

Google Forms – It is a kind of tool which helps us to get information from users online in an easy way, it could be used on Google spreadsheets too which is progressively useful to get to any gathered information or data effectively. Clients can put their data, for example, pictures, sound, recordings, and documents in inaccessible arrangements like PDF, MS Word, and so on. 

Requirements

The first requirement is to create this feedback or survey form or collect any kind of information from users or anyone through Google a Google account is a must. We simply have to create first all a G-mail account which we usually use for accessing emails and any other documents for sharing or any professional work.

Preview

Before sending it to someone or after creating this form, we have a choice to check it as a preview on the top right corner, and we can make some changes in settings as per our choice like if we want to give access or option to make changes after submitting this form then we can give that to the user who will be receiving it.

Feedback Form

Google Drive

Once we click this DRIVE then we will have these options appeared such as Google Docs, Google Slides, Google Apps, and many more. For better understanding let us check the images below and that what all options would be found hereafter by clicking this Google Drive.

Google Forms

So after clicking this MORE we will have Google Forms in again we have 2 options Blank form and from a template so let us click this 1^st option for creating this form.

All Ready Now

Presently we have a stage where we can create any feedback form online and further can go and make some changes too which is called the edit tab.

Survey Forms

Themes Changes

So now here we can simply go and create this Google online format free of cost and collect any information from anybody online.

So now, for example, we made this form by the name of audici and just below it we can start to make this form without any issues, We wrote the first option as Name and 2^nd one could be created in that same way by clicking that + symbol.

 

Now as we can see in this image above that we have many options to use. Look at the right corner at the top, we got 3 dots that we can click and find many more features in it. Let us go through them first.

1). Undo

2). Make a copy

3). Move to bin

4). Get prefilled link

5). Print

6). Add Collaborators

7). Script editor

8). Add-ons

9). Preferences

Undo – Let's suppose we did some work in this form and we check that later and decide that the last was better than the one that we made now, so in this case, we can Click “undo” and this will again make changes in the forms that we had before, means we will have the same work that we wanted to get back.

Make a copy – This option is a good one here in that we get to make a copy of this form which means we have the option to save this form as a copy in our drive or in anywhere on the computer. Look at the image below.

 

Here we have these options to perform like

1). My Drive

2). Computer

3). Shared with me

4). Starred 

That we can use them to save or make a copy in with these options.

Move to the bin – If we click this button will delete the work we did in the form but then we get another screen also which will show 2 options as 

1). TAKE OUT OF BIN

2). GO TO THE FORMS HOME SCREEN.

 As we can understand with their names that all we can do to use these options so we can use these options to delete the form but still, we have a choice to come out of the bin or go to the forms home screen.

Get pre-filled link – This link can be used by any other user, He or she can click this link to check this form online.

Print -  This button gives us the option to take a print of this form from here but make sure the printer must be attached to the computer to take a print otherwise this feature will not work at all.

Add collaborators – This option is amazing here, it means the form we are making, can be shared by other users also at the same time with their emails and links, we have also an option to make them an editor which means they can also make changes in this form as we are giving them permission to work or edit this form on. Let us check in the picture below that what image will appear after clicking this Add collaborates.

 

In this image, we can see in the right top corner a symbol which can be used as a function for settings. If we click this button setting then it shows us the next screen where get this image. Check it up first below.

It clearly shows that the editors we made can change the permissions and share it with others, People who can see this form, can download this form and take prints.

Script editor – This feature is a development platform that makes it fast and better in n easy way. This option is for coding editing that will be on the Google server.

Add-ons – Google provides many add-ons that can work with forms here 

1). G-suite,

2). Form notifications,

3). Form ranger and etc. 

Preference – This button works as a setting in the form that can allow collecting email addresses and etc.

We can create this kind of form for getting any information from any user online. When users will send this form back to us after filling it then it will have appeared in only the same Gmail account G DRIVE as RESPONSE which we already have with QUESTION in the top centre.

What is Shrinkage in bpo

What is the Shrinkage formula?

Shrinkage Formula in bpo – Shrinkage is an estimation of anything that removes an agent from their duty in terms of working in the call centre. Various elective definitions are broadly similar in concept. Let us talk about one of many alternative ways here.

1). Shrinkage is the thing that takes agents away from their productive hours.

2). Shrinkage is a kind of loss to the call centre.

Now let us learn here first and get to know what kind of shrinkage are there in call centres or we can say how many types of shrinkage are there in the call centres.

1). Internal Shrinkage

2). External Shrinkage

Question: What is Internal Shrinkage?

Answer: let us check all the types of Shrinkage mentioned below.

1). Team Meeting

2). One to ones

3). Unplanned Leaves

4). Training

5). System Downtime

Let us read about them in detail below with complete definitions.

Team Meetings – These happen in the call centre when TL (Team Leader) OR Supervisor spends time in taking a team meeting to discuss the assigned target like how to achieve it and a feedback sharing of any team member in the meeting.

One-to-one – it happens when a TL(Team Leader) takes a session with any team member is a person in the office, in this session, TL talks about the agent’s work performance, breaks and etc.

Unplanned Breaks - Unplanned breaks mean that any agent takes unplanned breaks that mean the break he or she takes is not permitted by his or her TL like smoking or having tea or coffee etc.

Training – Training is also a part of shrinkage when TL or manager takes a meeting for a team that, time gets spent is called shrinkage.

System Downtime – System downtime is the thing that happens in the call centre like the internet not working or maybe system or other technical issues.

Question: What is External Shrinkage?

Answer:  Let us go through these all types of external shrinkage in detail below.

1). Absenteeism

2). Holiday

3). Sickness

4). Lateness

Let us check them in detail below with a proper definition or explanation.

Absenteeism – It means if an agent is not available on the floor in the call centre during productive hours, for any reason like sick leave or any. That is called absenteeism which comes in external shrinkage in the call centres.

Holiday – Holiday is a day when a call centre provides a day when agents do not have to come to the office but if we talk about it in terms of any call centre then it also comes in the category of external shrinkage.  

Sickness – Sickness is an external shrinkage that means if an agent is taking a sick leave, Productivity might get suffered in the call centre

Lateness – If anybody comes late on the floor then of course productivity gets suffered just because of lateness which is also a part of external shrinkage.

Now we will learn here the basic thing that we are supposed to start now about shrinkage that how works in call centres.

Before we learn about it, let us check one more thing which is more important in the call centre which is AHT.

AHT- Average Handling Time

AHT Definition: It covers the whole time when the agent starts talking to customers on the phone till the call ends including talk time and holds the time that is called AHT in the call centres.

Now we will discuss here in detail how we calculate this as a function in excel or like how can we calculate in percentage?

Shrinkage Formula - It can be simply defined as the time for which people or employees are paid and they are not available to work or handle calls In any company or call centre, BPOs. It can be defined in 2 ways as Planned events, Unplanned events. If we would like to calculate the formula in ms excel that how to find out the Shrinkage rate then we simply have to do an addition of (Planned + Unplanned) events. That is basically called Shrinkage Formula which usually has more importance in BPOs nowadays.

It is basically absenteeism which could be defined in 2 ways here.

1). Planned Events or Planned Leaves

Team meetings, Breaks (Lunch, Tea or whatever like smoking and etc.), Coaching sessions or maybe any other activity in the office during shift timing are called Planned Events. It is known as absenteeism means any agent or employee is on leave but he or she already informed about it his or her supervisor or reporting manager that he or she will not become on any particular day or any date and that is called Planned leave.  

2). Unplanned Events or Unplanned Leave

It is like if an employee or any agent is taking much n more breaks during shift timing like the total time is 1 hour that could be used in paid hours but if it goes more than that then it will hamper the productivity and is called unplanned shrinkage OR If any agent or employee does not come to office without any prior intimation then it is called Unplanned leave. 

Shrinkage formula   = (Planned Leaves + Unplanned Leaves)

Now look at here how to find out Planned & Unplanned leaves first and then we have to do an addition of both terms in Ms excel & that s all.

Planned Leaves = Planned Leaves/Total agents*100

Unplanned Leaves = Unplanned Leaves/Total agents*100

Now let us calculate it here.

For Example:-  Planned Leaves Formula

Number of agents on Planned leaves =3

Total Agents = 40

So the formula will be like as = 3/40*100

Means Planned Shrinkage =  7.5

For Example:- The unplanned Leaves Formula

Number of agents on unplanned leave = 2

Total Agents = 40

So the formula will be like as = 2/40*100

Means Unplanned Shrinkage = 5

Now we have to find out SHRINKAGE = (Planned Leaves + Unplanned Leaves)

                       Total Shrinkage rate is    = (7.5 +5) = 12.5

That s the way to calculate in Ms Excel and another source to learn is a video which is uploaded here below. Please watch and learn.

            

How to lookup pictures in excel

Pictures lookup in excel

How to lookup pictures in excel- There are many functions to lookup values from a list like Vlookup, Lookup, Index/match, and Xlookup but still these functions cannot fetch any pictures from a list. Only lookup pictures in excel can work to lookup images.

Only the picture lookup function can be used to look up images or pictures in the workbook or excel sheet as per the names or whatever would be the dependent cell-like text or any number.

For Example:- 

Let's suppose we have a team that plays cricket and we have to maintain their data on excel, basically we have to look up their pictures as per their names in excel.

Like if we enter the name of any player in excel then his image must appear in the cell but unfortunately, it would not be possible from any inbuilt functions in excel.

Here we have to use a function called “Picture Lookup in Excel”.

To use this term we need to use the index match function for this work and data validation too if required.

Let us understand first what is Index match and how we would use it in picture lookup.

Index Match - Index-Match formula is basically a function which is the combination of two functions in excel.

Data Validation – we can use this data validation function to make the INDEX function more attractive and beautiful. It helps to validate any particular thing in excel.

Let suppose we have a column that consists of a list of numbers like 10,20,30,40,50 and in another column, we have text data in cells like A, B, C, D, and E and what we need is to do here, We want to validate this data such as if anybody comes in this excel file, cannot make any changes in numbers or text, we can put a data validation in the data like numbers and text cannot be changed also a pop-up may appear that “DO NOT MAKE ANY CHANGES”

That statement also can appear by using data validation in this workbook.

For a better understanding, we can watch a video here for the data validation function.

Now we learned about these 2 functions above Index Match and Data Validation so it is going to be pretty easy to understand the “Picture lookup function” here.

To work on it we need a few simple steps and can use it easily.

1). First, we have to select the cell where we want to put any value through want to check pictures and give it any name.

 

2). Go to the FORMULA tab and click the NAME MANAGER tab in it then we will have a small window open which will look like the image attached below, In this window, we have to give the name which has been asked to give above and here we have to put an INDEX MATCH the formula which will help us to get pictures lookup.

 

3). After clicking this FORMULA tab the window which will open will be looked like the image attached below.

 

How to lookup pictures in excel

This window has been opened now and looks at this cell K3 (this formula will be placed). Here we will put a formula of INDEX MATCH and cell L3 will have pictures displayed against the value in cell K3.

4). Look at this image will be looked like after putting a formula here for INDEX MATCH.

This window has been opened now and look at this cell K3 (this formula will be placed). Here we will put a formula of INDEX MATCH and cell L3 will have pictures displayed against the value in cell K3.

4). Look at this image will be looked like after putting a formula here for INDEX MATCH.

How to lookup pictures in excel

5). This formula has been placed in an empty place which is displayed as REFERS TO and makes sure first we have been aware of how this function works.
 

6). Let us click this cell L3 and here we have to paste a picture from cell G2 through PASTE SPECIAL (LINKED PICTURE) so that it will be linked with a formula which we put in cell K3.

Now click this picture in cell L3 and change its name from $g$2 to CUSTOMER ID name which we have given already or could be directly selected and hit enter now both cells have been linked with each other and now whatever the pictures have been attached or placed in data will be shown in L3 against value.

7). So now we can get pictures in cell L3 again with cell K3 value.

If we want to create a drop-down list here then it is also possible through the data validation tab in data and a drop-down list will be created easily now.

This data validation function makes this index function more attractive again.

Here we can use a data validation function like we can put a condition in the datasheet. Let's suppose we have got this column here that consists of a list of numbers which we saw in the video also, we can create a data validation like only numbers will appear in a list and no text can be added in this column.

We can also put any pop-up message that can appear if anybody will try to make any changes in the datasheet. This pop message can be any time such as professional or funny. Such as you are not allowed to make changes here or do not make any changes, changes cannot be done here.

That means it can be any pop-up message that we want to write and put up here. Now as we used this Picture lookup function in the datasheet or a workbook, here this column with customer id is linked with the image that we have in cells. If we make any changes in the images in the datasheet will also perform in the data that we made to look up pictures or images as per the customer id.

The conclusion is if want to use this function to look up the images or pictures then we must know other functions to use index-match and data validation also.

There are many functions you may like.

1). Hlookup Function

2). “If” Function

3). “And” function

4). “Conditional Formatting” Function

5). “Left” and “Right” Function 

6). “Sum” and “SumIF” Functions