Create Citations and Bibliographies for your Academic Work in Word

Creating citations and bibliographies in academic work is very common. Every time we use another author’s work, we must refer this author and cite them. There is a way to do this with the features of Word that will make the process much simpler.

Let’s get to it!

1.First, Click the References tab.

2.Click Insert Citation.

3.Click Add New Source.

insert citation in word

Enter the information according to its bibliographic information.

create source in word

The reference to the author will be inserted into the document.

example of reference in word

The cool thing about using this feature is that the quote is saved and can be used as often as necessary.

As you create your quotes, you can also enter a bibliography.

insert bibliography in word

All you have to do is to select one of the options.

 

How to Clean Up Your Excel File After Conversion

After importing raw data in Excel from an online data source or after the conversion from PDF to Excel format, which is done with our service, the next step would be to clean up your data. Before we start analyzing our data, we need to clean it from unnecessary characters, unknown symbols and everything that might interfere in conducting proper data analysis. This is a necessary step because if you are copying or importing data from various sources into Excel, it is possible that some invisible characters or spaces are accidentally created. These characters will cause a problem if we want to calculate something or apply a formula to the document.

Fortunately, Excel has some great functions that we can use to fix this and today, we are going to show you how to use them.  If you know of another good solution, please share it with us in comments.


1) Trim function

The Trim function clears unnecessary spaces in cells.

trim function in excel

For example, if there is space before data in a cell, it can make searching merging or calculating a bit difficult. This is because, if it is a text field, then the distance is calculated as the portion of the cell.

2) Clean function

The Clean function enables us to remove some problematic nonprintable characters, like the ones that are invisible and cause errors or mistakes. Such characters are often created when importing data from other sources.

3) Substitute function

SUBSTITUTE function allows you to replace one type of characters with another.

substitute function in excel

For example, as shown in the image, you can replace spaces with blank fields. Keep in mind that in some versions of Excel you have to type in a comma between the values, and in other versions, you have to type in semicolons.

4) Find and replace tool

Use  Find and Replace to manually replace the values in the cells.

find and replace excel functionality

Select the cells that you want to modify. Press the CTRL + H, a new menu will open. In the first field enter the character that you want changed, and in another field enter the character you want it changed into. This can be a space, or nothing (empty field). In our example, we deleted all spaces by replacing the space character with a blank field.

5) Data sorting

Sorting data through different criteria can be highly beneficial, because it allows us to move data around, delete, copy or view how the data looks.

multiple levels for sorting in excel

You can choose multiple levels for sorting and also decide if the data should have headers.

How to Manage Your PDFs with Google Drive

Google Drive is used by almost everyone to store digital data such as contacts, reports, and documents, as well as digital data in PDF format.  In order to get the most out of your Google Drive, you need to be able to manage all of these files. Today, we are going to show you how you can use the functionalities of Google Drive to manage your PDF files more effectively.

1) Save PDF Files Directly into Google Drive

You can save PDFs onto Google Drive from Google Chrome’s integrated viewer. Simply, click on the Print button.

print pdf google chrome

Next to Destination, choose Change.

change printer in chrome

At the bottom, find the option Save to Google Drive.

save to google drive

As you can see, it’s all very easy.

2) Save Gmail PDF Attachments to Google Drive

You can directly save an email with a PDF attachment onto your Google Drive account for further use, by clicking on Save Attachment.

save pdf attachment to google drive

3) Recover Deleted PDFs

recover deleted pdf file from trash

Files inside Google Drive do not get deleted automatically. In case you delete a file accidentally, you can easily recover it from the Trash folder, located on the left hand side.

4) Convert PDFs into Editable Formats

convert pdf inside google driv

It is also possible to convert PDFs right within Google Drive. In order to convert a PDF into doc format, right click on the document and choose Open with – Google docs. If you want higher quality conversions to Excel,Word, PowerPoint or Images, you can use our PDF converter app designed for Google Drive.

5) Create Scanned PDFs with Your Mobile Phone

convert scan pdf with google drive

You can use the Google Drive app from your phone to scan documents and images into PDF, just click on the Scan button to take a picture.

6) Merge PDFs

A nice little tool for merging PDF files is PDF mergy. After installation, select the PDFs you want merged and choose the option Open With – PDF mergy.

 

How to Convert Time Difference into Hours or Seconds in Excel?

When working in Excel with dates and times, there might be an instance where we need to calculate the difference between two times. For example, we may want to calculate how many hours, minutes and seconds have passed since our last birthday. In order to figure this out, little tweaks are needed.

1) Convert Time Difference to Hours, Minutes and Seconds

You can calculate the time difference between two times by subtracting the end time minus the start time. If you get a number that looks completely out of place, what you need to do is to right click on that number and choose Format Cells.

calculate time difference in microsoft excel

Go to Number – Custom.

 

difference in time in hours minute seconds

Choose the type [h]:mm:ss.

The exact number of hours, along with the minutes and seconds will be shown.

2) Convert Timespan to seconds

 Converting the time difference to seconds might be the best solution. In doing so, we can perform calculations on data, without having to worry about the incompatibility between different units, like numbers and dates.

time difference in seconds in excel

The principle here is similar. Simply repeat the same procedure as before, but in Custom Type: type in [ss].
Bonus tip: You can easily convert hours and minutes into seconds by using the text function and the format for seconds.

convert hours to seconds

To do the opposite is a bit more complicated, but we will be sure to explain it some other time.

Cometdocs Releases a New PDF Converter Extension for Google Drive

A lot of new and exciting features are coming to Cometdocs, and one of them is a new extension for Google Drive. This extension Cometdocs PDF Converter has been requested by a lot of our users and so, in order to fulfill those requests, we created the extension.

This is an excellent solution for everyone who uses Google Drive to store and manage their documents. It converts files right inside Google Drive, making this a very convenient feature.

You must install this add-on from Google Chrome, but once you have downloaded it, you may use it from any other browser that you use to access Google Drive.

Here is how it works:

PDF Conversion

After installing the add-on, head to your Google Drive account, and right click on any PDF file. Once you have right-clicked on it, select the Open with menu and then choose Cometdocs PDF Converter.

cometdocs pdf converter add on

After this, you will be prompted to select the conversion type.

 select conversion type

Once you have done this, if you are not currently registered to Cometdocs, you will be prompted to create an account. Otherwise, you can log in with your Cometdocs account details.

Selection_012

Now, you simply have to wait for the conversion to finish.

file is converting

The newly created file will be uploaded to the same folder where the original file is. This is very convenient because it doesn’t interfere with your current workflow.

converted files

Google Drive itself supports PDF to Word conversion for files of up to 2mb, but with our extension, you can convert PDF to Word, Excel, PowerPoint, Images, OpenOffice formats and Text, with files of up to 100mb in size.

PDF Creation

The add-on supports the creation of PDF files from multiple other formats. However, have in mind that the Conversion of native Google formats is not supported, so before conversion you might want to check off the automatic conversion to Google Format.

uncheck the google docs conversion

Right click on the image or any file in Microsoft Office or OpenOffice format.

convert image to pdf

Choose the option Open With – Cometdocs PDF Converter and that’s it!

image to pdf inside  google drive

The newly created PDF will be waiting inside your Google Drive account. This is especially useful if you are creating drawings, and you need the PDF file right inside your Google Drive, without having it downloaded to your computer.

Check the Google Drive PDF Converter extension here: https://chrome.google.com/webstore/detail/cometdocs-pdf-converter/olgfoomjdkeijllelookodfgiogbdoch/