If you have never come through the term Dropbox and don’t know how to use Dropbox to share files and folders, probably you are missing out something!
Dropbox is an online storage service which lets you save your data including all your photos, videos, documents and everything you prefer saving on your desktop.
Gone are the days when we used to rely on our desktop and computers to store our important files. With the emerging technology, everything has become online and so is the way we used to deal with our data. If you have a kindle, you can also share Books on Kindle.
Cloud storage services like Dropbox, Google drive, and Microsoft OneDrive not only let us store our important data online, they have made sharing data online way too easier! Besides these two mentioned features, there are many features offered by them which make them very beneficial for official as well as personal use.
The cloud storage service we will be discussing in this article is Dropbox. There are certainly a lot of advantages of Dropbox that you should not miss! This article is devoted to teaching you everything you need to know about Dropbox from what is a drop box to how to use drop box.
How To Use Dropbox to Share Files and Folders
You have a great song on your computer, and you want to share it with your friend who is currently online with you in a chat, how will you share that file with him? Or you have zip file of a marriage album which you have to send to your relative who attended the wedding with you, how will you send that file to him??
If your answer is via Email, then let me remind you email services have a limit of sending files. You can’t send large files over the emails. Then how would you do that?? Well, the answer to this question is Dropbox.
Dropbox let us share files and folders online even though the receiver does not necessarily have the Dropbox account. If you are a Mac user, you can still download Dropbox on Mac. I know after getting to know a little about What is Dropbox app; you can’t wait to learn how does dropbox work!
In order to start using Dropbox, the thing you need to do is drop box sign in. And presumably, you need to have a Dropbox account.
To create an account on Dropbox, Go to Dropbox website and create an account by filling out the necessary details. Once the details are filled, click the Sign up for free button.
Or sign in, if you already have an account. After the drop box log in, you will be landed on the homepage of Dropbox account. The screen will look like the below screenshot!
Now in order to share the files and folders on Dropbox, first we need to upload them to our dropbox account and then we can share them with anyone we want.
So to upload the files and folders, click on the upload option located on the top right corner. If you can’t locate the option, see the below screenshot.
Now click on Choose files option and navigate to the files you want to share. Once the file is selected, click on Open. You can also upload more than one files at a time.
Once the file uploading is completed, click on done.
As sooner you click on Done, you will be redirected to the home page where all the files and folders stored on your Dropbox account resides. Now hover your cursor over the file or folder you want to share, and click on the Share option. A screenshot for the same is given below.
There are two ways you can share your file. Either you can invite people to collaborate, or you can just share the link with someone in the Chat box.
If you want to invite people for collaboration, choose the first option. Else select the second option i.e., Send link.
To invite people for collaboration, click on the file option in the above screenshot and write the name of the person you want to collaborate with. Once selected, that person would be able to view, edit and comment on the file. But you can change the user permissions if you want.
And if you want to send the link to someone either via chat or email, select the second option. You will see the following screen.
In the above screenshot, the highlighted link is the one to be shared, copy it and send it via email or in the chat box. The person who clicks on the link can view this file.
Under send this link to, type the email ID of the person you want to share your file with and also you can add a note. Once done, click on the send button. Mails would be sent to the person containing the link to the file.
So this is how we share files on Dropbox including videos, photos and any document you want.
The above method helps you share single files. But if you want to create a dropbox public folder, then follow the below steps.
Click on the Share a folder icon on the top. You will find this option just beside the upload file. Once you click on the Share a folder option, a new popup window will open up. It will look like the below screenshot.
Now select the first option if you want to create the folder, or select the second option if you want to share the existing folder. I’m creating a new folder, so I’m selecting the first option. Now click on Next. Now you need to type the name of the folder, once done, click Next.
Now in the next screen, type the email id of the person you want to share your folder with and click on Share Folder, your folder would be shared.
And if you want to share an existing folder, click on the share button next to the name of the folder when you hover the cursor on it, and rest of the sharing procedure is same.
These are the multiple ways on how to use Dropbox to share files and folders. Apart from Dropbox, there is another service by Google that you can use to share data online. You can also make Google Doc and directly share it with your colleagues, friends or anyone for that matter.
For any doubt or query, you can drop your comment below!
How to Merge Word Documents
Have you ever wondered how to merge word documents? You might have! In our daily life, the situation often occurs when it feels the need for combining the word documents into one.
If you have been using MS word, you probably have felt the need of merging up more than one document into a single word file. For instance, if you write a thesis, dissertation or book, you will create all the pages separately, like page 1, page 2 and so on.
But after, when you are done writing up all the pages and want to merge them up in one single document, how would you do that? How would you merge word documents? Probably, you will create a new document and copy all the pages one by one page and paste them into the chief doc (main document).
But let me tell you this is absolutely a wrong way of merging up the documents. This article explains how to combine Word documents into one document.
So let’s get started, and learn how to merge documents in word.
How to Merge Word Documents
To merge up the files, you can use two ways. One by copy-pasting as I said above and another way is by creating a main document and combining them.
In this article, we will let you know to merge up the multiple files into one file in almost all the versions of MS word. No matter you use MS word 2007 or 2010, you will get to learn the procedure for all. Just keep reading the article until the end.
In order to provide you the tutorial with screenshots, I have created three-word file name file 1, file 2 and file 3. And the main file that is named with the Main file. I will merge up the file, file 1, file 2, and file 3 into the principal file that is the Main file.
Ok, so here go our guide on how to merge two-word documents. The steps are given below. Follow all the steps carefully and see how the multi-files are merged into one.
But before moving to the guide make sure to follow some prerequisites given below.
- First of all, make sure the files you have saved are in the same extension.
- Also, the files that you are up to merge should be in a particular order. Word will merge your files in alphanumerical order.
For example, if you have named your files as file 1 introduction, file 2 projects, and file 3 docs, then the word will combine all the files in the same order.
But if you have named your files as an introduction, projects, and docs, then the files will be sorted in alphabetical order. And the order would be docs, introduction, project.
So if you want your files to merge in some sequence, then you will have to save them with a particular order or sequence.
How to combine word documents in Word 2007 or later
The following procedure is for MS Word 2007 and later versions. If you own some older version of MS office then still not to worry, below I have covered that also.
- In MS Word, go to the Insert menu from the top menu bar.
- In the Insert tab, at the rightmost side, you will see an option, Object. Click on that. Don’t click on the object, but on the small arrow just beside the object option.
- After you click on the Object, you will see two options, Object.. and Text from the file. See the screenshot below.
- In order to insert the file, you will need to choose the second option that is Text from the file. As sooner you click on the option a dialogue box will open. Here you will need to select the files you want to merge.
For instance, I am selecting the files named file 1, file 2 and file 3. See the screenshot below.
- After selecting all the files you want to merge you will have to click on the insert button as shown in the above screenshot.
- And you are done! After clicking on the insert button, all the files you selected would get merged into the main document. Now save the main file at the location you want.
This is how we merge a document to the current file or multi documents into one single file.
If you have a single file that you want to merge in the current file, then you need to open the current file first and then select the file you want to merge by going to the Text from file option.
And if you want to merge multi-files as said above, then you can press CTRL key to select multi-files in one go.
If you have an older version of MS office like 2003 or so, then the procedure of merging file would be a slight different from the previous one. The procedure to merge files in MS word 2003 is given below.
- First of all, go to the Tools menu from the top menu bar. Here you will need to select the Compare and Merge Documents option. See the screen mentioned below.
- When you click on the Compare and Merge Documents option, you will see, a dialogue box will open. Here you have to select the files you want to merge.
- open the files by clicking on them and click on Insert as shown in the below screenshot.
- That’s it. After you click on the insert option, you will see all the selected files will be opened up in the Mian MS word file.
- Now save the file with the new name at any location you want.
Isn’t merging files in MS word is easy? Let me know your views on the guide and the procedure I have mentioned. If you have any other way other than the mentioned procedure do let us know.
Also, do drop your comments and views regarding the guide on how to merge word documents. In the case of any confusion, you can ask them without any hesitation.
If you find the article useful share it with your friends and relative.
How to Cite a Website?
Citing a website might sound a new term to many. It’s not different than acknowledging someone’s work by giving them credit for their work!
Many people including writers, bloggers, news websites and others mention statements of other people with their names and this is what we exactly call citation.
If you know the term plagiarism, you might understand Citation better by exactly counting it as just the opposite of plagiarism. Plagiarism is representing others’ work as our own, without giving them any credit for their hard work, whereas, in the citation, we mention the name of the author after or before mentioning their work.
Citing can be done to any website, photo, art, music, report, etc. The other name for citation is Quoting. So next time when you read the term quote or cite consider them both as same!
While preparing any report or doing some research, we often stuck around some content on a website, which we just want to put as it is to our report. Apparently, it is unfair to do it without giving the credit to the website for their good work.
Therefore it becomes really essential for us to cite the website, i.e give credit to the website for their work and it is the best way to show your curtsy too!
If you don’t know how to cite a website, then probably the article is for you! There are a number of ways we can cite a website, let’s find out what are those ways!
How to Cite a Website:
As suggested above, there are a number of ways you can make the citation of a website. We won’t be teaching you here all the ways for citation but the two most used ways i.e Modern Language Association’s (MLA) and American Psychological Association’s (APA).
These both methods follow the different guidelines to show the website as a source you have researched and show your curtsy towards the website for providing valuable contents.
Both the methods i.e MLA and APA use their different sets of rules and format for citation. I’ll walk you through the step by step guide for citing a website through APA and MLA!
Citing a website in MLA:
Below steps will tell you how to cite a website using MLA citation.
Step 1. If you are supposed to cite a website where you know the name of the author, you need to follow the below format.
Last Name, First Name, “Article Title.” Website Title. Website Publisher, date of publication, month, year. Date/Month/Year you accessed the content.
You can well understand it better by the following screenshot.
Although, in MLA we don’t require to add the URL of the website some websites may ask you to do that’s exceptional. If you want, you can add the URL of the resource at the bottom of your content under the title references.
Or simply place it just after the format given above. To be more specific, the website URL should be given just after the date, the content has been accessed.
The above format is applicable when you know the name of the author. But if you don’t know the name, follow the format, given in step 2.
Step 2. Not every time you will see the name of the author on the article you took the reference from. In such cases, you can follow the below format for citation.
The correct citation format to be followed when the author’s name is unknown is as follows.
“Article Title.” Website Title. Website Publisher, date of publication, month, year. Date/Month/Year of the day you accessed the content.
You can see, there is no difference in the format accept the name in the beginning. See the following image to see how it works!
Isn’t it really easy to cite a website with the MAL method?? The steps are equally simple for APA citation as well. Let’s find out!
Citing a website in APA:
Unlike MLA, we need to embed the URL of the website to be cited in the text of the website. This is really essential to do that, hence you can’t skip this step.
In MLA, we do it in some circumstances, while in APA, we do it on a mandatory basis. Below steps will tell you how to cite a website using APA citation.
Step 1. If you know the name of the author of the article, then below citation format is applicable for you!
Last Name, First Name (Year, Month Date of Publication). Article title. Retrieved from URL
Yes, in APA, we write the date of the content published before the title of the website. The last name and first name of the author separated with the commas, then the date ( in the format Year, Month date) when the content was published. And then comes the title of the article, followed by the website URL.
Exactly the same, as the below screenshot.
Step 2. And if the author’s name is unknown to you, the following Format needs to be followed.
Article title. (Year, Month Date of Publication). Retrieved from URL
You can see the difference. If you still have any doubts, about how this method works, have a look at the below screenshot.
When you use others’ work like photos, tweets, FB status, any article of a website on your report, website or book, it becomes really essential to give the credit to them for their work to avoid any kind of copyright infringement and to show your thankfulness.
The above guide was compiled to teach you how to cite a website using MAL and APA methods. There are many other methods for the same which you can easily get from other resources on the web.
The Citation is also handy for your readers. By getting to know about the resources you have researched, they can explore the topic more clearly and in-depth, if they desire to!
On that note, we have reached the end of the guide. Feel free to share the guide if you found it useful and drop your comment below if you encountered any problem while following the steps.
How to Create a Pie Chart in Excel?
Creating a pie chart in Excel is one of the most used functions of this application. But let me tell you a secret, I really hate this feature!
I mean when I was a kid, I spent hours and hours to do all the calculations and then make the pie chart. My drawing was very bad that meant I spent countless hours trying to make a perfect circle.
And then let’s just not talk about making the lines of the perfect angle inside. And then when I grew up I thought it was the time to show my superhuman skills of making a perfect pie chart.
But then Microsoft made Excel pie charts means all my skills are of no use now (I hate you! Bill). Anyway, Pie Charts in Excel is one of the most amazing features of this app.
We can create not only the perfect pie charts in terms of Angles but also they are great in terms of looks. So today we have brought you a complete tutorial on how to create a pie chart in Excel?
After going through this article, you will be able to make a pie chart.
What is a Pie Chart In Excel?
Before knowing how to make a pie chart in excel, you need to know what the Pie Chart actually is. Well, in simple words pie charts is a chart to display data relative to other data in a circle. Each set of data has his own value or slice in the circle (or Pie).
Now Microsoft had taken this and changed the approach. Previously you had to create a pie chart with your hand, and you had to calculate the size/angle of each slice manually.
Now you can just enter the primary values of the chart and then create a flashing attractive pie chart within 5 minutes without any calculations and drawing skills.
Uses of Pie Chart in Excel.
So now you know what a pie chart is so it’s time to know how can you use it. It’s a basic human behavior that we understand the things we can see more easily rather than the things we have to read and understand.
So if there are lots of data which are related to each other and you want to explain it to somebody else. Then creating a pie chart is the best option.
For example, if your boss gives $1000 each month to spend on staff. And at the end of the month, he wants to know how you spent the money.
Now if you’ll try to explain to him that you spend $50 on tea, $10 on buying pens, $10 on buying paper, etc. then he might order to through you out of the office for confusing him with lots of data.
But at the same time if you know how to create a chart in Excel and then show it to your boss then it will be far more easy for him to understand it.
How to create a pie chart in Excel?
So now you have enough knowledge of Pie Chart, and it’s usages so now it’s time to learn how to create a pie chart using Excel. Relax it’s not rocket science, in fact, you can create a pie chart within 5 minutes. Just follow the following steps to do so-
Step #1: Enter the necessary data.
For creating a pie chart you first need to enter a set of data in the Excel Spreadsheet. Type the names of all categories in one cell range and the value associated with them in the other cell range just in front of the related categories.
For example, we are writing the name of animals found in an area and their population in the other category. See the image below for better understanding:
Step #2: Select all the necessary data.
Once you have entered the necessary categories and their values, you’ll need to select them. Just use your mouse and select all the cells you want to use in your Excel Pie Chart.
Note that you should not leave any line blank while writing the data.
Step #3: Adding the pie chart.
Once you have entered and selected the values, now it’s time to add the much-awaited pie chart. Click on the Insert tab and choose ‘Pie’ from the options that appear.
Once you click on it, a new pop-up will appear, it will contain all the styles you can use for your pie chart. From there select your pie chart. For this example, we are selecting the 2D pie chart which is the first option from the pop-up.
Congrats that’s all you have to do. Your pie chart will now automatically appear in the Spreadsheet as seen in the below picture.
Now if you like, you can play with your pie chart. You can click on any slice of the pie and then take it away from the chart. This will be very helpful while giving a presentation. You can take the slice out of the circle which you are trying to explain. So people will easily understand which slice you are talking about.
Pie chart Frequently Asked Questions
Pie charts are the most commonly used features for business, so obviously people always have what-if questions or how to question it. So we have created a handy faq section to answer questions about pie charts-
Q: I entered a wrong before creating the pie chart excel?
It often happens that you notice that you have entered a value wrongly after creating a pie chart. Well, don’t worry. You won’t have to create the whole pie chart again. Rather than you can just change the numbers, you entered in the spreadsheet, and the pie chart will be updated automatically.
Q: I can’t find the pie option in Excel 2013?
With the 2013 version of Microsoft Excel, Windows have made big changes in the UI section. So if you are used to working with the older versions, you may find it hard to locate the pie option.
But don’t worry it’s just there. Once you open the Insert menu, you can find the pie options there. For your ease, we have marked out the pie option in the picture below-
Q: What is the design tab and how to find it?
A design tab is a unique option in the Excel 2013 version. You can see it on the menu above after you have inserted the pie chart in it. Here is a quick look at all the options available in the design tab-
- Add Chart Element- it allows you to change the chart title, legend or data labels.
- Quick Layouts- they are different preset charts. You can use any of them if you don’t want to change every part of chart one by one.
- Change Colors-it allows you to change the colors in your chart.
So this was the complete tutorial on how to create a pie chart in Excel? Do you still have any questions in your mind? Do tell us in the comment box.
Stay tuned and thank you for giving it a read.
How to Reset Windows Password Without an Installation CD
Password – one word with a huge meaning in our life nowadays, because daily we use lots of sites over the internet. To remember all login passwords is not an easy task but browsers are giving the facility to remember them. What, when you forgot your Windows Password?
Reinstall the Windows Copy? That’s not a good idea because there are many ways to reset Windows Password. And right now you don’t have the installation CD, in this case also there is no need to worry.
Today, I am gonna show you a tutorial on “How to Reset Windows Password without an installation CD”. So, below is the step by step guide on How to Reset Windows Password without an installation CD, just follow it and reset Windows Password easily.
Step by Step Guide on:
How to Reset Windows Password without an installation CD
Firstly, you have to download the Offline NT Password & Registry Editor and make a boot disk using ISO image which you have downloaded.
Boot your PC from the boot disk and you will see below image on your screen. On-screen, it asks if you want to select the first partition (Windows installed partition) then “1” is already selected, so just hit Enter.
The next screen will appear to choose the path to your registry. The default is fine don’t need to change it, so just hit Enter.
Now, the screen will appear displaying Password reset and many other options, don’t do anything because “1” is already selected so now also just hit Enter.
Here you will be prompted, whether you want to edit users or the registry. You want to edit user passwords, so hit Enter again.
Now, comes the main part and please don’t hit enter again (Just Kidding). The screen will show usernames which are available on your PC, so you have to enter that username for which you want to reset Windows password and now you can hit enter.
The next screen will show some advanced options no need to worry because you have to blank the password by selecting the “1” option and that’s probably been already selected so just hit enter and get reset Windows Password.
And now, you’ll have to save what you just did. So type an exclamation point to quit (or the “!” symbol), then type the letter “y” to save all your work. Now you can reboot your computer and of course, you will able to login into Windows without any problem.
The above is the complete guide on How to Reset Windows Password without an installation CD. If you face any problem in resetting your Windows Password then put your problem/query in below comments section via the comment form.
So, that we can help you to get rid of that problem as early as possible.
How to setup hMailServer
hMailServer – a Free Email Server for Microsoft Windows, used by Internet service providers, companies, governments, schools and enthusiasts in all parts of the world. hMailServer Webmail works on SMTP, POP3, and IMAP for performing outgoing and incoming mail services.
You can integrate hMailServer with Microsoft SQL Server, or you can make use of an external Microsoft SQL Server, PostgreSQL or MySQL database for the same. Features of hMailServer are it consists of multiple domains, auto-reply and forwarding options, Active Directory support, distribution lists, built-in backup, etc.
If you want to use hMailServer, then firstly download from here and after that, you have to Set Up Own Email Server. To setup hMailServer is a typical task, so today in this article I will give step by step guide on Setup My Own Email Server.
Step by Step guide on:
How to setup hMailServer
#) Connecting to hMailServer
Download hMailServer from here and install it to start setup hMailServer.
Open “hMailAdmin” (C:Program FileshMailServerbinhMailAdmin). A dialog box will be opened that allows you to connect to different hMailServer services.
Double-Click on the “localhost” to connect hMailServer. A small dialog box will be opened asking the password. Enter your password which you specified during the installation of hMailServer and click on “OK”.
If the password is correct then you have successfully started hMailServer Administrator.
#) Domains & Accounts
Now you have to specify your domain name for which you have to setup hMailServer.
From the last opened window, click on “Add Domain” or you can also start “hMailAdmin again”.
Enter your specific domain. As example, I have inserted “technobol.com” and click on save.
Now, you have to specify your email address on which you will receive and send an email. For that, Expand the Domains node in the tree to the left.
Click on your given domain name and click on “Add Account”.
Now, enter “webmaster” or “info” or you can put any name as per your choice in the Address box, set the password and click Save.
Now, in the tree to the left, you will find your Account and Address both.
#) Specifying the public hostname and SMTP relayer
For the working of hMailServer, you have to specify the public hostname.
From opened Window or start hMailAdmin and in the tree to the left, go to Settings > Protocols > click on SMTP
From the right-hand side click on Delivery of the e-mail tab. Into that, under the hostname enter the public hostname of the computer where hMailServer is running and click on Save.
Now, you have to specify SMTP relayer, so enter the hostname of your ISP’s email server, along with your credentials on that server in case it demands authentication and click on save.
You have successfully setup hMailServer and now you can use it.
So, a guide on How to setup hMailServer is completed. I hope you have understood the guide and cam setup hMailServer by own. If you are facing any problem while doing setup hMailServer then connects us via comments so that we can resolve your problem.
How to Insert a Line in Word?
How to Add a YouTube Subscribe Button to Your Site?
How to Change PSN Name on Playstation?
How to Solve Yahoo Mail not Working?
How to Reset Macbook Air?
How to Use Apple Thunderbolt Display with PC?
Tech2 weeks ago
How to Solve Yahoo Mail not Working?
Computers3 weeks ago
How to Reset Macbook Air?
Mac1 week ago
How to Use Apple Thunderbolt Display with PC?
Tech2 weeks ago
How to Make a Yahoo Account Without a Phone Number?
iOS3 weeks ago
How to Stream Torrents on iPhone?
Tech2 weeks ago
How to Tame a Horse in Minecraft?
Tech2 weeks ago
How to Receive Money through PayPal?
Windows3 weeks ago
How to check RAM type (DDR, DDR2 or DDR3) in Windows?