Hi guys, my name is abdul latif from Tana River County for those who remember me, whatsapp group
Admin corhot one today
I have decided to make this
tutorial video
So that I can be able to share a few tips and tricks that can help you achieve some of the data entry jobs within
a very short time, in this video
I want to use a very common example of the Excel assignment that we were given on Thursday evening 26th
October 2018. I hope you guys remember now before we begin
I want to mention a few things that you need to have for you to achieve what I am about to show you
first of all
You need a computer with an active internet connection to the soft copy of the assignment
If you don't have it follow the link in the description below to download it
you can also take a picture using your phone that is if you have the hard copy with you and
Transfer it to your computer
Please make sure that the contents are visible when you are taking a picture using your phone three
You need a PDF viewer or reader software. I recommend Adobe Reader or Acrobat
This doesn't apply for those who will be taking pictures using their phones for those who don't have one
Follow the link in the description below this video to download it. Finally. I need your attention now, let's begin
The assignment is found in the AG or digital program do online workers participant training curriculum 2018 handout on
page 45 for those using a PDF software open the soft copy of the document and scroll down to the table of
content on page two the first item written
digital marketing 1 simply
Double-click on it and it will immediately take you to where it's located in the document when you do that
This is what you will have a table and some instructions here. We can see a title worksheet data management one
Individual assignment and next we have some instructions that we need to follow
It reads open Excel and enter table one below into Excel put the variable names in the first row of your Excel spreadsheet
Is there in table one this exercise should take you less than 30 minutes?
So basically what we are told here is to enter the data contained in table one as it is
into an Excel worksheet
This means you will have to enter data
One-by-one in each cell of the Excel worksheet to the end for those who are slow in typing
It might take you more than 30 minutes to do
so and for those who are good in typing you will have to really struggle to make sure that you finish on time and make
Sure, you don't have any errors doing this can be really tiresome and time-consuming
Since the table on the document is an embedded image
That means it's not editable so that you can copy and paste the contents into Excel
This is it now
Let me show you how to break the ice within a very short time
less energy and with no
Errors kindly if you have taken a picture of the table don't follow the steps that I'm about to give this is only for those
Using the soft copy of the assignment document
Let's continue first go to the table in the PDF document and click on it
Once it will select the table right-click on it and select save image as option a pop-up window will appear and you will be prompted
To select where you want to save the image. I recommend saving it on the desktop since it is easier to locate now
Give it a name example table 1 and then click on Save button what you have just done is basically
Extracting the image from the PDF document
separately after that confirm that the document is on the desktop next open your browser and in the URL bar type
Www.blender.org
And
Put format step 3 convert now, let's follow the steps first
Let us click on select file and go to where we have saved the file on the desktop at this point
This is where those who have taken a picture and saved it on the desktop can join us now
Let us click on the image file. We saved earlier and click Open button after that
Let's go to step 2 where we have to choose language, but by default, it's English and that is what we want
so we skipping it to now choosing our output format we have
Microsoft Word doc as default but we don't want that what we want is Excel so click on the drop down arrow and then choose
Microsoft Excel finally click on the convert button now, let's wait until it finishes
Converting and after that you will see download output file
Click on it and a pop-up window will appear
Click on save and you will be able to download an excel file having the same name as the name of the image. We
Extracted earlier next step is to open the excel file and boom
We have already converted our document and now we have our editable excel sheet
What we have to do next is to perform some few fixes on the fonts and also confirm that there are no errors now
Let's change the fonts
And if you can notice the alignment of texts in the cells are not
exactly
Like the ones that are on the table in our document to fix this
select everything under Home tab we go to fonts and change the fonts to calibrate the
default fought and again under the same tab in the alignment section choose centre alignment as you can see we have made the
Changes and this looks good
Another thing we can notice is that dates in the date column
doesn't have the zeros for the ones that begins with zeros as it appears on our
Original document and even if we try inserting them manually we still can't do that it gets lost
So to go around this we will select the entire column and then right-click and choose format
Cells' a pop-up window will appear and on the date type
we pick one that begins with a zero this one here and then we click OK and now
We have a change to the way we want them to appear. We do the same with the next column
And
Now we are done. This looks great
So let's go and save our work go to the safe icon and click on safe
make sure that you know where your final document is located we are done with our
Assignment within a very short time and now we are ready to submit it just to make it clearer to you
We have used an OCR software to convert images containing text to editable file in case you wonder
OCR is an abbreviation of optical character recognition
OCR is the recognition of printed or written text characters by a computer
This involves photo scanning of the text character by character
Analysis of the scanned and image and then translation of the character image into character codes
Such as ASCII commonly used in data processing. Thank you for watching this video
My hope is that you have learned something and at least you can be able to convert text on images to editable text
using a free online
OCR within a short time now if you need more videos like this
Leave or mention a topic on the comment area below or post it on a JIRA forum. Whatsapp group and if you have any questions
Feel free to ask as well just down here in the comment area below this video
Don't forget to subscribe to this channel. And also without forgetting share
So that others can also benefit to subscribe to this channel
Click here on the subscribe button and then hit the bell icon
when you do this
You will be able to receive a notification every time I post a new video so that you cannot miss any
Thank you again. See you in the next video. You have been with me Latif from stains creative studio checking out. Ciao
For more infomation >> 【EVERYDAY MAKEUP】 BETTER.Ver! Thanks To You, Am I A Little Bit Better!? [CC Available] - Duration: 16:15. 
For more infomation >> ЖЕЛЕЙНЫЙ МИШКА И КИК ЗЕ БАДИ ПОЗВОНИЛИ ДЕВУШКА БЕНДИ В МАЙНКРАФТ! МУЛЬТИК МАЙНКРАФТ МЕДВЕДЬ НУБ - Duration: 14:51. 
For more infomation >> 【Kman】超狂！夜晚出門走走，不小心又夾一座金冠塔！[台湾UFOキャッチャー UFO catcher]#415 - Duration: 10:01. 
For more infomation >> Honda Super Cub Monkey xe thiết kế nhỏ nhưng đắt 85 triệu - Duration: 2:40. 
Không có nhận xét nào:
Đăng nhận xét