hi guys my name is abdul latif from Tana River County for those who remember me
what's up group admin core hot 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 Ajira 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 Ajira 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
Không có nhận xét nào:
Đăng nhận xét