Excel Tutorials Deciding when to use Excel. https://youtu.be/cssdbnlLRm0
Many times, I find that people use Excel instead of word, because it has the formatting tools that they want. If that is the case, you have come to the right video! I am briefly going to go over three methods of formatting information in Word.
Here is the transcript of what I planned to say in this video:
Before you start using Excel, ask yourself "is Excel the correct tool for what I want to do?"
If you are going to be doing calculations, obviously Excel is your tool.
If you are just storing data that will be used in reports later, Excel is an ok tool, but Access, MySQL, Postgres, or some other database platform is a better option.
Finally, if you need to write paragraphs of text, Microsoft Word is a better tool.
Tabs are a hugely underutilized tool in Word. When I say "tab," I don't mean your typical 5-space tab. There are so many options with Tabs! Some are hard to describe. So, lets play with them!
First, if you are working in a document that already has text in it, you need to highlight the text where you want these tabs to exist. Otherwise they will only exist for the line that you are on when you set them. If you create the tabs when you first start the document, they will exist for any lines of text you add later.
If you double click the ruler bar, it should give you the tab dialog. If the ruler is not on your screen, go to the view tab and check the "ruler" box.
The tab dialog will list all the tabs you have set. I didn't mean to set one when I double clicked. So, I am going to Clear it!
Now, lets say I want to set one at 2 inches. Type 2 and hit Set. Thats it!
Other things you can play with here:
You can change the alignment of text around your tab. For instance, you can set one at the right side of the page 6.5" and say Right aligned. Then your text written after the tab will end at the right side of the page.
You can also make a Leader for the tab. If you have text written and you hit tab and then write more text, the leader will fill the space between those two sets of text.
To demo, these two things, I'll create a mock table of contents. We'll set a tab on the right and say Right aligned and I'll put a dotted leader on it. Then we'll type Chapter 1, tab, page 2, enter, Chapter 2, tab, page 10.
One more demo of tabs: do you remember putting headings on your papers in school? Name in the top left, Class in the top right, Title in the center. Lets make those tabs:
We'll put this in the header of the page. Just double click the white space above our table of contents.
Now double click the ruler and clear all previous tabs.
Set a tab at 3.25 (the center) and center align it.
Then set a tab at 6.5 (the right) and right align it.
Now we type our information: Mickey Mouse, tab, An Entertainment Culture, tab, MGMT 2205
The second way is to insert a table. If you go to the Insert tab, Click the arrow below "table" and choose Excel Spreadsheet. Now you have a little object in word that will behave just like excel, but it allows you to write paragraphs around it!
The only major tip I have about the Excel Object is that if you resize it while you are working in it, the object will include more or less columns and rows. If you resize it while you are working in the text around it, it will make the whole thing larger or smaller and keep the same number of rows and columns.
You'll have to play with it to get the hang of it.
The third way to mimic excel organization in Word is to use Columns under Layout.
I suggest hitting the arrow beneath columns. Then you can set the number of columns, their size, and the space between them.
Now when you type enough to fill one of the columns, your text will automatically flow to the next column....
Well I hope those three methods might become useful to you in the future.
Next week we'll head back to Excel and I'll cover several string functions. That will include:
What that ampersand was for a minute ago.
How to put a formula result in a sentence.... inside one cell
And how to get a small piece of the text in a cell....and use it in your formula.
Please like this video, subscribe to my channel, and share with anyone you think would benefit. Also, feel free to comment below. All of these things tell YouTube how often they should show my videos in Search Results. So, I appreciate your feedback and input. Thanks for watching.
Tags: Excel Tutorials Deciding when to use Excel, how to use word, how to use microsoft word, tabs in word, tables in word, columns in word, excel, when to use excel, word tips, word tricks, Word how to, Excel advice, Word Tutorial 2016, Word Tutorial Advanced, Word Tutorial Intermediate, Excel Spreadsheet Tutorials, Excel Spreadsheet