11/30/2015

Remove Background From Picture in Microsoft Office 2016

From many of new Microsoft Office features, you certainly going to
love this one called, Remove Background. 
Many times, you may be inserting Pictures into a Word Document, Excel
Spreadsheet, or in a PowerPoint presentation. But what usually happen is, that
you have a separate background color on your document or presentation, then on
the picture, that you have inserted. For instance, the background color of this
picture is a bit grey, whereas the presentation background color is pure white.
So this inbuilt Remove Background tool will help you to remove the background
color of this picture, and make it transparent.

So what I do to remove the background from the picture, first I
select the photo, and then click the Format tab from the Ribbon. In the very beginning
at the left hand side, you can find Remove Background tool, and as soon as I
press this button, instantly PowerPoint will make an assumption of what part of
the picture you want to keep, and what part you want to remove. The purple
color indicates the part of the picture that you want to make transparent.

What I need to do first is to, select the area that I want to keep
by adjusting the white bullets around the outline of the photo. If you think
that PowerPoint is making a wrong assumption, or a part of the photo is still
purple, but you want to keep it, then you can use “Mark Areas to Keep”, and
draw a line over the area of the picture that you want to keep. You can draw
lines over the areas that you want to be appear in the photo, and once you are
done, click Keep Changes button, and there you have the picture with a
transparent background.

Let’s try it again on another picture.

You can also mark an area that you want to remove from the picture,
by clicking on Mark Areas to Remove. Sometimes, you may need to remove some
portion of the photo that is getting visible. Then you can mark that area, it
will become purple, indicating that it will get removed, when you will apply
the changes.

Once the picture becomes transparent, it does not matter what background
color you use for your page, the picture will seem nicely adjusted on the paper
with a transparent background. Removing backgrounds and making your pictures
transparent can really help you to create more professional documents and
presentations.






11/28/2015

Microsoft Powerpoint 2016 Tutorial - Aligning Shapes and Pictures Perfectly

In PowerPoint 2013 and 2016, Guides
help you to place, resize, and align objects and pictures, perfectly! Guides
are red lines that automatically appears, when an object is in center to
another object, or evenly spaced. By default, Guides are remain turned on in
PowerPoint 2016, but if you want to make sure that either they are turned on or
not, then click the View tab from the Ribbon, and then click arrow underneath
the Guides in Show section. From Grid and Guides dialog box, make sure,
“Display smart guides when shapes are aligned” option is checked.

Now, let’s insert some shapes. For
this practice section, I insert and draw four different shapes in my current
slide. First I draw a rectangle, then a triangle, an oval, and in the end, I
draw a star. Now what I want to do is to, resize them equally, and evenly space
them on the slide.

So, I select the rectangle first, and
resize it from the bottom right corner. Now let’s resize the second object,
which is a triangle, to an equal size to the first object. When I drag and drop
the triangle, the red line indicates that the top of the object is perfectly
aligned with the previous object, and if I resize the triangle from the bottom
right corner, the red guide line will again tell me, when the bottom is perfectly
matched. Using the same method, I resize all the four objects equally, so they
aligned up perfectly on the slide.

You can do the same with pictures as
well. As on this presentation, I have inserted four different pictures of
different size, and using the same method, I can resize and align them on the
slide.

What I need now is to, space them
evenly. Now when I slide the first picture a bit to left or right, the double
side red arrow line indicates that, this picture is spaced evenly with other
pictures next to it. So I do the same with other pictures, to evenly align all
the pictures to each other. Now all of our pictures are sized and aligned
perfectly, and we can do the same for our shapes and objects.

If later you want to reposition and
resize them all together, then what you need to do is to select all of them
together, and you can do this by, holding the Shift key, and click on each
picture or object one by one. Once they all get selected, you can either resize
them all together from one corner, or can change their positions on the slide.
Sometimes, after resizing the pictures or objects, you may require to realign
them, as space between them may differ.

So, this is how Guides can help you to
perfectly resize, align objects and pictures on your slide.




Microsoft Word 2016 Tutorial - Designing and Formatting A Word Table

In our previous Microsoft Word
Tutorial videos, we had learned that how you can Insert a new table, or draw a
table, and even how you can convert simple text into table. In this video, you
will learn that how you can quickly design and format your table, and spice the
table up.

Sometimes, when getting late for an
office meeting, you may require to quickly format and design your table, so you
may present it on the desk. This is when the Design tab under Table Tools comes
to handy. By default, when you insert a new table in a Word document, the
default table style is Table Grid, with a dark black lines for your entire
table. But Word gives you many more predefined table styles to choose from.
Place your cursor inside the table, and if you hover your mouse over these
Table Styles, you can instantly see a live preview in your document. If you
click the drop down button, then you can see a vast list of ready made table
styles. You can pick any table style that you want. Let’s say, for this example
I choose, Grid Table 4 – Accent 5. As you can see that, in a blink of eye, your
entire table has been redesigned automatically.

But you may want to customize this
table a bit, according to your preferences. As you can see, there are a few
more options under Table Style options. For this table style, Header Row,
Banded Rows and First Column options are pre-checked. Let’s see what these
options does. If your current table contains a Header Row, like I have in this
table, Crumbs and Prices Per Bag, then you might want a different color and
style for your header row, and this is what exactly the Header Row under Table
Styles option does. It fills an extra dark color in your header row, so it may
look slightly a bit different from other rows. If your table does not contain
any headings, then you may uncheck this option.

If the last row of your table contain
a total sum of values, then you may like to give it a separate formatting. So
as I check the Total Row option, you can see that the last row has been
separated by applying a double border.

Then we have Banded Rows option. As
you can see in the following table that, each second row has a slightly darker
color than others, and this is what the Banded Row options does. If you uncheck
this option, all the rows will have the same formatting. I like the Banded
Rows, so I will remain it checked. This also goes with the Banded Columns
option. If your table consist of more than two columns, then you can experiment
with Banded Columns as well, which automatically fills the color in every
second column of your table.

As the First Column option is checked
by default, and what it does is, it makes the contents in the first column
darker by automatically applying the Bold command, and the same does the Last
Column option, which also applies Bold command to the contents of your last
column.

So, this is how you can customize the
table after using a predefined table style, and it is up to you that how you
want to format your table.

If you want to experiment with the
filled color, then you have the Shading Option in Design tab. It let you
customize fill color in rows and columns according to your preference. Like, if
I click the drop down button and choose a lighter blue color, then it will
instantly apply to the current selected cells. Do note that, the Shading
applies to the selected area only. So you must first select those contents to
whom you want to apply the shading, and that could be a single row, or a single
column, or you can apply shading to the entire table by selecting it from the four
side arrow button. But if you fill the entire table with a single color, then
Table Style Options will no longer be effective, as you will lose Banded Row,
First Column, Total Row, other styles.

If you want to customize the borders
of your table, then you can do this by clicking the Border Style drop down
button. The default selected border style is, Solid Line style, but you can go
for other styles, like for a more depth line or a double line border. As I
select a double line border style, you can see that the Border Painter button
has automatically been selected, and now when I move the mouse pointer inside
the document, you can see that, it has changed to pencil style. Now, draw the
lines over the borders that you want to change. You can have different border
styles for different lines. You can even customize the border color by clicking
on Pen Color. You can also customize the Line Style and Line Width before
applying the border, and then nicely draw it over the current borders.
You can also add or remove borders
from the Borders button. Like, if I want to remove the borders from entire
table, then first I select the entire table, and then click No Borders from the
Borders drop down menu. You can even apply border to a specific selected area.
We will cover border customization
options in much detail in our next lesson. Leave us your suggestions and comments in the box below. 




11/26/2015

Microsoft Excel 2016 Tutorial - Getting Started and User Interface

After Office 2003, Microsoft has
entirely changed the user interface in the newer versions, especially in Office
2013 and Office 2016. The new Ribbon interface is entirely redesigned according
to user requirements.

For instance, if you are working on a smaller
screen, and need more space on your screen while entering the data, then you
can temporarily hide the ribbon. Like, if Home is currently the selected menu,
then double click the Home tab, and the entire ribbon interface will
temporarily hide. If you need to use a command from any of the menu, then click
the menu, and then click the corresponding command button, and as soon as you
will click inside the worksheet or document, it will again automatically hide.
If you need to fix the ribbon again permanently, as it was before, then just
double click on the selected menu name. So this feature comes to handy, when
working on small screen devices, like Mobiles or Tablets.

One more thing that you may have
notice from previous versions that, many of the unnecessary menu commands and
toolbars has been removed, and they only appear when you select a certain set
of data. Like, if I select the following picture, only then the Format menu
will appear in the Ribbon, which also will only have pictures related commands,
and this applies to many other contents like, if I select a Chart from the
worksheet, then you will see Design and Format menu in the ribbon, and if you
are working inside a table in a Word Document, then you will have a Design and
Layout menu in the Ribbon. So this makes it easy to find the corresponding
commands easily, instead of searching them in different menus.

Above the Ribbon, you will find a
toolbar with a few default buttons like Save, Undo and Redo. It is called the
Quick Access Toolbar. If you remembered, that in older versions of Office, the
most useful commands were available in Toolbars only, like Standard Toolbar,
Formatting Toolbar and Drawing Toolbar, and for rest of the commands, there
were separate menus like, File, Edit, Format and so on. Now with new interface,
you only have one toolbar by default, which is Quick Access. However, you can
customize this toolbar and can add or remove most used commands. To do this,
click the Customize Quick Access Toolbar drop down button, and make a check
mark on most used commands like, New, Open and Print Preview. You can also add
any of Microsoft Excel command in Quick Access Toolbar, by clicking on More
Commands. Here you can search for your favorite commands either in Popular
Commands list or, you can add commands from any of Excel’s menu tabs. Select a
command and click the Add button. You can also remove any command from the
Quick Access Toolbar, by selecting the command from the right side pane, and
then click Remove. Once you are done adding or removing commands, click the OK
button to save the changes. You can also place the Quick Access Toolbar either
on the top of the Ribbon, or below the Ribbon. You can also customize the Quick
Access Toolbar using the same method, for other Office applications like
Microsoft Word and PowerPoint.

In Excel, then you have the Formula
bar below the Ribbon. The Formula Bar not only relates to Excel Formulas, but
it also has comprehensive meaning as well. For instance, in this worksheet the
current active cell is E4, and you can see the same in the Name Box alongside
the Formula Bar. If I type something in here, you can also see the same
contents in the Formula Bar as well. So Formula Bar represents the value of the
Active Cell. Like, if I select any other cell either from the mouse or, using
arrow keys from the key board, you can see the active cell contents on the
Formula Bar as well. But if I move the cursor to the cell which consist
formula, like in this worksheet I move the cursor to the cell E16, which has a value
of 37015. But what here important to look at is the cell E16 showing you the
value, whereas in the Formula Bar, Excel indicates that values are coming out
from a formula. So it is important for you to keep an eye on the active cell
that either it is a value, or it is a result from a formula. More importantly,
if you don’t see a Formula Bar below the Ribbon, then make sure to check
Formula Bar option from the View menu.
The Excel files are called Workbooks,
and an Excel workbook could consist of one or more worksheets. In Excel 2013
and 2016, by default there is only one worksheet for every new file or workbook
that you create. Each Microsoft Excel worksheet consists of Columns and Rows.
The alphabet letters, A, B, C, and so on, represents the column headings,
whereas the left side numbers represent the Row number. These column letters
and row numbers are used to identify the cells, are called cell references. For
instance, the current selected cell in this worksheet is E16, and how you can
identify this, is by seeing the column heading, which in this case is E, and
the row number, which is for now is 16. If you also check the formula of the
active cell, then you can see that I am using Cell References in the formula,
not the values. As the current formula depicts the sum of the values of other
three cells from the same worksheet, but instead of typing the values in
formula, I used their cell references. This is because, if later I change the
value of any given cells, then the result in the cell E16 will automatically be
updated, because I have not assigned a fixed value in the formula, instead I
command Excel to always pick the updated values directly from the given cells,
so if the values get updated in those cells, then the output in the current
formula cell will also be updated. 

You can add more worksheets to your
current Excel workbook by clicking the plus sign alongside the sheet names.
Creating separate worksheets in the same workbook or file helps you to work
more efficiently, when you are working on a project and needs to create several
reports on separate pages. So, instead of creating separate files for the
different reports for the same project, you can add additional worksheets in
the same workbook.
At the very bottom of the worksheet,
below the Worksheet tabs, you have the Status Bar. The Status Bar which is
already having a default indicator of “Ready”, shows you different indicators
as you work with your worksheet. For instance, as I select the values from the
column E, you can see that Excel is quickly showing the Average, Sum, Minimum
and Maximum values from the selected cells. This really comes to handy, when
you don’t want to type a formula but just want to have an assumption of the
selected values. You can also customize the Status Bar and can configure that,
what you want to see, and what not. To do this, right click on an empty area of
the Status Bar, and there you have a list of things that you can enable or
disable. Like, you might want to count the numbers of selected values, then you
can make a check mark on Count, or if you would like to see the Status of
Toggle Keys like Caps Lock, Num Lock and Scroll Lock, then you can make a check
mark on them respectively, and the indicators for those keys will appear right
in the Status Bar.
So this was a quick overview about
Microsoft Excel interface.




11/22/2015

Microsoft Word 2016 Tutorial - Convert Table To Text

In our previous video, we had learned
that how you can convert text into a table. This video is about reversing the
effect, that is converting a table back to text. Converting a Table to Text is
really a simple task. What you only need to do is to, first select the entire
table. To select the entire table, either you can drag and drop, or move you
mouse over the table, till you see the four arrow table selection button.
Click this button to select the entire table at once.

To convert a table back to text, click
the Layout tab under the Table Tools, and then click Convert to Text. In
Convert Table to Text dialog box, you are asked that how you want to separate
the text, using what paragraph mark?

Do note that, when you convert a table
back to text
, then it almost always using TAB as a paragraph mark. If you have
used any special paragraph mark in your table to separate text, such as comma
or enter key, then you can select the desire paragraph mark from the list, or
can type the custom paragraph mark by clicking on Other.

Nested tables are tables inside
tables. So if your selection contains a table inside a table, then Word will
also convert it automatically to text, as this option is checked by default.
Once you are done with the settings,
hit the OK button, and there you have, all the tables are gone now, and your
text is separated using the specified paragraph mark. As I had not used any
special paragraph mark sign while creating the table, so while converting table
back to text, I used the default Tab paragraph mark to separate the text, and
you can see the same tab paragraph mark sign in the ruler. If the Ruler is not
visible, then you can enable it from the View tab, by making a check mark on
Ruler.

To adjust the gap between the
separated text, then first select the text, and move the tab from the ruler to
the desire location.

If you want to learn more about
Microsoft Word, then do watch other videos from our Microsoft Word Tutorial
Series. 




Microsoft Word 2016 Tutorial - Convert Text To Table

Sometimes you may require to move text
inside a table, that you have already written, but decided later that it should
be inside the table. So, in this video, we will learn that how you can convert
that already written text, into a table without actually moving it by cut and
paste.

In this document, I have some piece of
information already written that I want to convert into a table. Before we do
this, let’s clarify some information first. The first thing you should aware of
that, how the text has been separated. Converting text to table work best if
the text has been consistently separated. To understand this, let’s first turn
on Show Hide Paragraph mark option from the Home tab.

As you can see in this document, where
I have Item Names on one side and their prices on the other, and both has been
separated using Tab key, and that Tab key is the separator in this text. As you
can see in the ruler that I have assigned a left tab to move the cursor exactly
below to 4 inch, in a single tab press. Whereas on the second page of the same
document, you can see that I have used many tabs to separate text to a specific
position on the page. So how this will affect the conversion? We will talk
about this later in this video. Let’s convert the above text first.

You can find Convert Text to Table
command under Insert tab, then in Insert drop down menu. But as you can see
that this command is currently unavailable. To convert text into table, first
you need to highlight the text that you want to convert. Now click on Insert
tab, then click Insert drop down menu, and then click Convert Text to Table.
The Convert Text to Table dialog box appear with some predefined settings.

The first thing you should note here
is the Separate Text at, where Tab is already selected, and within from the
entire selected text, Word has automatically counted that how many columns
should be used during conversion, which in our case is 2. Word check the mode
of the written text, like how many paragraph marks has been used between words,
and which paragraph mark has been used to separate text. If your text has
consistency, then Word will automatically suggest you the number of columns
required and the paragraph mark used to separate text.

On the other hand, if I do the same
for the text on the second page, then you can see that Word has automatically
grasp the correct paragraph mark, but this time it is showing a total of 7
columns required to separate the text. This is because, Word counted the
maximum and similar paragraph marks used in the selected text. So, how we can
correct this? We will come to this later, let’s first convert the previous
text.

One more thing that you can notice
while converting text to table is, number of rows, which in our case are 10.
The total selected text actually has a total of 10 lines separated by enter in
the end of each line. So, this is how Word identify your text by paragraph
marks.

The next option you have is, Auto Fit
Behavior that we have already discuss in our previous video about Creating
Tables in Word. You can either choose Fixed Column Width which is set to Auto,
so Word will automatically try to fit the text within columns, or you can go
for Auto Fit according to text, and wrap the text if that doesn’t fit within
column, or Auto Fit to Window size.

If you think that Word has by
mistakenly identify the wrong paragraph mark, then you can choose the correct
paragraph mark that you have used to separate the text, or if you have used a
custom paragraph mark like, Hyphen or Asterisk sign to separate the text, then you
can type it in the Other box.

Once you are done with the settings,
click the OK button, and there you have the entire selected text converted into
a table. You can adjust the column width if required.
Now let’s move to the second page,
where the Tab paragraph mark has been used to separate text, but the problem is
that, it has been used more than one time in a single line, so Word counted a
wrong number of columns, which we don’t want.

You can also note that, if I reduce
the column numbers, then Number of Rows are automatically increasing, and if I
go with this setting, see what happened? So the only way to overcome from this
problem is to, only use a single paragraph mark between text to separate them,
and delete the remaining from all the lines. Convert the same text to table
again, and you will see that, this time Word has correctly counted the columns.



11/21/2015

Microsoft Word 2016 Tutorial - Introduction to Tables

There are many different ways to create table in Microsoft Word. Tables are best way to organize contents in your documents, when you need to enter data in different columns and rows. In this video, we will discuss about creating new tables in your document using different methods, and how to enter data in them effectively?



To create a new table, click Insert Tab from Ribbon, and then click Table drop down button. The first thing you will notice here is set of boxes, which represents number of columns and rows. Let’s say, you need a table of 2 columns and 5 rows. Then what you need to do is to, hover your mouse over these boxes, and you will instantly see a live preview in your document. Click the left mouse button, and a 2 columns by 5 rows table will be draw in your document.



The first thing to note here is, how Microsoft Word distribute or decide the columns width? To understand this, let’s move to Page Layout section of the Ribbon. The first thing you need to check is the Paper Size that you are using for your current document. Like currently I am using Letter size page, which has a width of 8.5 inches, and a height of 11 inches. Now click the Margin drop down button, and check what margins are currently set for your document. For this document, they are set to Normal, and having an equal margin of 1 inch for all four sides of the paper. So, if you remove the total sum of left and right margins from the page width, which is a total of 2 inches, then what left is, 6 and ½ inches, and that is the actual space you are having on your document to enter the data between the margins. So, when you insert a new table in your document, Microsoft Word divides the available width to number of columns inserted, which in our case is 6.5 divided by 2, and we get 3.25 column width for each column.



Let’s undo this for a while, and do this again in a new document. Here, before inserting the table, I change the paper size and margins according to my preferences, which in this example, going to be Ledger as paper size, and margin are set to narrow. Now I have a total of 10 inches’ space available in my document between the margins, and let’s say I insert a new table of 3 columns by 6 rows, and see what happened?



Now, you can see that Word has divided the total available space equally to all the 3 columns, which is 3.33 for each column. So, this is how Word distribute and assign the column width, and you should take care of the Page Width and Margins before you actually insert the table.



You can also adjust the columns width later on by moving your mouse pointer over the line between the columns, and when your cursor changes to double arrow, then slide to left or right side to adjust the width. You can also adjust column width from the ruler. First make sure that Ruler is turned on, and if it is not, then click the View tab, and make a check mark on Ruler. In the ruler, you can see that the total page width has been divided into different column sections. Let’s say if you want to adjust the width of the first column then, move your mouse pointer over the first section, then move the table to adjust the width. 



Do note that, there is slightly a bit difference between both methods. If you adjust the column width from the ruler, then you can see that, even though you are adjusting the width of the first column, but the entire table is also being shifted along with. This is useful, when you need larger columns width and want to cover the blank area of the margins as well. On the other side, when you adjust the column width from the line between columns, it only affects a particular column width, not the entire table. 

As the maximum number of rows that you can insert while creating a new table is 8, and a maximum of 10 columns, when you insert a new table using pre-defined boxes from the table drop down menu. 



But if you need more rows and columns, and need to configure more settings while inserting the table, then you can use Insert Table command. 



From the Insert Table dialog box, you can specify the number of columns and rows you need in your table. Say, you need 8 or more rows, then you can either type the number, or can increase or decrease the numbers using up and down arrows. The next thing that you can configure here is the column width behavior. 



The first option in Auto Fit Behavior is “Fixed Column Width”, which is set to Auto, and that is how Word automatically distribute columns width, as I had described earlier. Or you can define a column width in inches here. Like, I need 3 columns of 2 inches each, then I can define the size here.



Then you have other options in Auto Fit Behavior like, Auto Fit to Contents and, Auto Fit to Window. Auto Fit to Contents will not create columns of a particular width, but will automatically adjust the column size, and will wrap the text according to the contents that you will type. Auto Fit to Window will adjust the column width according to available space divided by number of columns, which is similar to when Fixed Column Width is set to Auto.



The another way to insert a table is to use, Draw Table option from Table menu. When you click the Draw Table and move your cursor inside the document area, it changes to a pencil, that you can use to draw a table. You can only draw a single cell table, or you can say, a one by one table, using Pencil option. If later on you need more columns, then you can draw a line between when it changes to dashed line, to divide the single cell to multiple cells.



From Office 2003 onwards, Microsoft totally changed, how the commands appear in Menu or Ribbon. Like you see different commands in the Ribbon according to contents that you are working on. For now, as I am working inside a table, you can see two new menus, Design and Layout. If I click outside the table, then they both disappear. So, if you need to use any command from Design and Layout menus, then make sure that your cursor is inside the table. 



So, if you need to erase a line, make sure Layout menu is highlighted, and then click Eraser, and then click on the line that you want to erase.



For this lesson, I would like to tell you about one more interesting thing about tables. While entering the text in columns, when you need to move to the next column, you can press the Tab key from the keyboard. If you want to move back to the previous cell, use Shift+Tab key. This is why you see both left and right arrow on tab key on your key board. Shift Tab can also be used in Microsoft Excel or other software, while working inside tables. 



If you need more rows in your table, then just hit the Tab key, and there you have one new row available. The new row is inserted every time when you press Tab key in the last cell of the table. 



This is how you can begin working with tables. There are a lot more things that you can do with tables, that we will talk about in our next videos.





11/16/2015

Microsoft Word 2016 / 2013 - Paragraph Formatting and Alignments

In this Microsoft Word Tutorial, we
will talk about Paragraph Alignment. Paragraph alignments are used to give a
feel good look to your documents, or to improve readability. Here we have a
document with two pages, where the first page contain document heading, and the
second page have descriptive text with two sets of paragraph.

As you can see in the first page that,
the text is aligned to left. The default alignment in Microsoft Word is left
alignment, which means your text goes from left to right, and is properly
aligned with left margin. If you want to change the alignment of the text,
let’s say that you want to align those headings to the center of the page, then
you don’t need to do it manually by adding some spaces or tabs. You can easily
accomplish this by just selecting the text, and then choose a desire text
alignment from the Paragraph Section of Home tab.

In the Paragraph section, you have
four paragraph or text alignment options. The first one is left, which is
selected by default, and indicates that your current selected text is aligned
to left, which is mostly used for body text, but as these two lines are our
documents headings, you might want to make them in center of the page. So, what
I do is, I click the second button which is for Center Alignment. In an instant
you can see that both lines are aligned exactly to the center of the page. The
best way of aligning text in your document is to use these paragraph alignment
options, instead of manually aligning your text by adding spaces, or tabs. This
is because, say if later I decrease or increase the text size, you can see that
according to the text size and available paper space, text is still getting
automatically aligned to the center of the page.

Now, let’s move to second page of the
document. In this page, I want to align the last two closing quote lines to the
right side of the page margin. So, I first select both of them, and then click
Right Align button from the paragraph section. If anytime you want to change
the alignment, just select the text, and change the alignment as required.

Now let’s come to the paragraph
alignments, for which we have two paragraphs here. The fourth option for text
alignment is justify. Before I tell you about the Justify alignment, let me
first tell you about what Paragraphs are? In Microsoft Word, each enter that
you press in the end of a line, is counted as a paragraph. Usually we assume
text as a paragraph which has more than one line of text. Like in this page,
you might be counting the whole page having only two paragraphs, but actually
there are a total of eight paragraphs. Don’t believe me? then check this out.
As I said earlier, Word count each enter in the end of a line as beginning of a
new paragraph, so if I check the Readability Statistics of this page, then it
will show you that this page is having a total of eight paragraphs. Then the
question arises, how and why?

To understand this, you need to turn
on a Microsoft Word feature called, “Show or Hide” paragraph marks, which is
also available in Paragraph section. Click this button and Word will start
showing you all the paragraph marks in your document. So, this mark indicates
the ending of the current paragraph. If you count all these marks, there are
nine in total. In newer versions of Microsoft Word, Word does not count empty
paragraph marks, that you use to add more line spacing. So there are actually a
total of eight paragraphs counted by Word.

Now, let’s talk about paragraph
justification. If I select the first paragraph of this page, and then click the
Justify button from paragraph section, then you can see that Word has evenly
distributed your text to the both left and right side of the page margin, which
gives a crisp look to your paragraph. Word does this by adding extra spacing
between words, which is not easily visible in those paragraphs having a large
number of words.
On the other hand, if I do the same
for the second paragraph, you can see that Word has not aligned or justified
the text. This is because, you have added line or paragraph breaks by pressing
Enter key in the end of each line. Do remember, paragraph justification does
not work on those paragraphs, which have, paragraph or line breaks. So, if you
want to justify a paragraph, make sure that, there are no line breaks.

The last thing that I would like to
discuss about paragraph justification is, why people add paragraph breaks in
the end of each line, even there is no need to do this, because when your text
cover all the available spacing in a line, then your cursor automatically moves
to the next line. But still I have seen many people, who press enter key in the
end of each paragraph line. This could be because they want to shorten the
width of the paragraph. But this is not the right way because if you add line
breaks then paragraph justification will not work. The right way of doing this
is to, use all the available space while writing the paragraph without adding
line breaks, and later, use Right Indent if you want to shorten the width of
the paragraphs.

So, this was all about using four
different paragraph alignment options. There are much more paragraph settings
options available in Microsoft Word, that we will discuss in our next videos.





11/13/2015

Microsoft Excel 2016 Tips and Tricks - Enter Data Into Multiple Cells Si...

In Microsoft Excel, many times you may
require to enter same data or formulas, in different cells simultaneously. Like
in this worksheet, I need to enter, “Each”, under unit in cells F6 to F8, then
F10 to F13, and F15 to F16. So, instead of typing “Each” in one cell and later
copy to other cells, I first select the cells from F6 to F8, then hold down the
control key to select other non-adjacent cells, then type “Each” in one cell.
Instead of pressing the Enter key, what I do is to press Control + Enter Key,
and the word “Each” will automatically get copied to all the other selected
cells.

I can also do this for numerical
values as well. For instance, I want to enter a value of 10, for all the empty
cells under Quantity column. So, I select the first empty cell which is, G8,
then hold down the Control Key to select the remaining cells, then type a value
10 in one cell, and press Control + Enter Key, and in an instant the same value
will be typed in all the selected cells.

Not only with text or numbers, you can
also use the same method for formulas as well. Like, I want to sum the
Quantity, Recorded Quantity and, Inventory Value. So, I first highlight the two
cells G17 and H17, and then hold down the Control Key and highlight cell J17.
Now, I type the formula in one cell, and then press Control + Enter Key, and as
you can see, the same formula has copied to all the remaining selected cells.

The method described in this tutorial
is similar to entering data or formula to a single cell, and later copying it
into other locations.



11/11/2015

Microsoft Excel 2016 Tutorial - Show or Hide All Formulas in Worksheets

In Microsoft Excel, you can instantly see all the formulas in a worksheet. For instance, various formulas has been used in this worksheet, and finding each formula individually could be a real headache in larger worksheets. What if you could see all the formulas in your worksheet with just a single keyboard shortcut?

Before I tell you about the keyboard shortcut, let me first clear you about the keys used in this shortcut. You need to press this key along with Control Key, and this key is found below the Escape key, and left to number 1 key, and it is called Acute, or Back Quote. There are other name of this key as well like, grave, grave accent, left quote, open quote, or a push. I will call it Acute.

So, what you need to do is to press Control + Acute key, and in an instant all the formulas on your current worksheet will be visible. You can again toggle back to normal view by pressing the same shortcut which is, Control + Acute Key.

If you are having some kind of problem with formulas, then you can easily figure out by viewing all the formulas at once. You can also toggle between Normal and Formula view by clicking on, Formula menu, and then click Show Formulas, which also displays the same keyboard shortcut in its Tool Tip.

You can also print your worksheet in same form, if you want to sort out things later on a paper. But what you will require in the print out is the row and column headings. To print row and column headings along with formulas, then first switch to formula view, and then click on Page Layout menu, and make a check mark on Print under Headings in Sheet options. It will then easy for you to understand and figure out the problem on a paper as well.

But there is one problem that may occur if you want to take a print out while showing the formulas, and that is, when you turn on Show Formula option, each column size get doubled, and the text could spread to more than one sheet, and you may require to adjust the columns and rows before you actually take the print out.

The easiest method could be, changing the Page Orientation to Landscape, set the Margins to minimum like Narrow, or you can scale down your worksheet to fit into one page, using Scale to Fit options under Page Layout.
 
 

11/08/2015

Microsoft Word 2016 Zoom Features

Microsoft Word supports viewing of multiple pages on the screen at the same time, which is especially useful if you have a large high resolution monitor, and you are working on a document having many pages. This feature comes to handy when you need to view more than one page side by side, to check the alignments and spacing of various pages, before you actually take the print out.

Let’s see, how to use different Page View methods in Microsoft Word.

Open a document with multiple set of pages, and then click on View menu. Make sure you are viewing your document in Print Layout mode, as many Microsoft Word features will not be available in Read Mode. You can also use different page viewing options in Web Layout, if you are creating a website using Microsoft Word.

Assuming you have a file open with multiple pages, clicking Multiple Pages from the View menu will instantly start showing you two or more pages side by side, according to your screen size. Do note that, the zoom level of viewing a document will be reduced automatically, so multiple pages may fit to your screen. My default the zoom level is set to 100% for a single page, but when you click on Multiple Pages, then according to pages being displayed on your screen, the zoom level will automatically get reduced.
 
Once you are done with editing, you can click the One Page button to switch back to single page view. Do check the zoom level for a single page, if it is below 100% then you can either adjust it from the zoom slider, or you can click the 100% button from the Zoom section.

You can also view multiple pages in Print Preview window. Click the File menu, and then click Print, and from thebottom right corner, you can adjust the zoom slider to view multiple pages in the print preview window. You can click the Zoom to Page button, when you are done viewing multiple pages in print preview mode.

There are more document viewing options available, that you can try while working in different word documents. For instance, Page Width option in View menu, either expand or reduce the zoom level of viewing, according to width of your document. Less page width increases the zoom level, more page width decreases the zoom level. This feature makes it easier to view those documents which have custom page with larger width.

If you want to try more document viewing and zooming options, then you can click on the Zoom button under View menu. Along with other viewing options, another interesting viewing option that you will find here is, Many Pages. Click the radio button, and from the Monitor button below, select how you want to view multiple pages. Like, do you want to view four pages in a single row, or four pages in two rows? The preview box in the left side will illustrate, how your document will be displayed.

Remember to switch back to One Page and 100% view when you are done!

The Whole Page Zoom option gives you the entire view of your document, covering the entire width and height of your document. As you can see in this document, where I have a custom page which has a width of 18 inches, and height 15 inches. Clicking the Whole Page button will gives you the view of the entire page, including the entire width and entire height, while fitting it to the screen.

Another option that you can use from Zoom option is, Text Width. Text Width option is very useful for the smaller monitors. What it does is, it removes the blank grey area that you are currently seeing in this document in 100% view. If you click the Zoom button, and then choose Text Width, then Word will not display the blank grey area, and the text will be seen larger on smaller screen.

If you only want to read your document in, as much as larger size word may display then, you can also view your document in Draft view, and then set the Zoom level to Page Width.
If you want to set a zoom level as the default zoom for a particular document, then what you only need to do is to, set your prefer zoom settings, make at least one change, like removing or adding a single character in your document, and then save the document. Reopening the document will give you the same zoom level.


 

11/07/2015

Set Multiple Homepage in IE, Google Chrome, Firefox & Microsoft Edge Bro...

If you do a lot of Internet Research during working hours, then you may be thinking of setting Multiple Home Pages, so whenever you open your favorite web browsers, you don’t need to open your most favorite websites individually.

Let’s start with Internet Explorer 11 in Windows 8.1. Open Internet Explorer, and click the Settings button from the top right corner, or you can press ALT key from the keyboard to bring the Menu bar. Click the Tools menu, and then click Internet Options.

In the General tab, under Home page, you can type the addresses of the websites that you like to access every time you open Internet Explorer. You can add more than one websites by entering their addresses in separate lines. Once you are done, press the Ok button, close and reopen Internet Explorer to see the effects. Now you have your multiple favorite websites getting opened automatically.

For Google Chrome, click the three bar Customize button, and then click Settings. Under On Startup section, select “Open a specific page or set of pages”, and then click “Set Pages” link. Type the first web site address, and then press Tab key, to enter more addresses. Once you are done, click the Ok button, and then close and reopen Chrome browser, and there you have multiple home pages getting opened for you.

You can do the same in Firefox as well, but what you only need to take care about is to know, how to separate website addresses in Firefox. Open Mozilla Firefox, Click the three line Menu button, and then click Options. Under Startup settings, open the drop down menu for “When Firefox Starts”, and select “Show my home page”, and under Home Page address bar, type the first web site address. To add and separate a second address in the same bar, you need to use the Pipe sign between addresses. That’s it, now close and reopen Firefox to see the changes.

If you have already upgraded to Windows 10 and using Microsoft Edge browser, then here are the steps to set Multiple Home Pages in Edge Browser. Open Edge browser, click the three dotted More Action button from the top right corner, and then Click on Settings. Under “Open with”, select “A specific page or pages”. From the drop down menu, choose Custom and then add your favorite website address in the box below. To add another website click the Plus sign. When you are done, close and reopen the
Edge browser, and there you have multiple home pages getting opened for you. This trick saves a lot of time, if you always open specific set of pages while browsing internet.

 
 

Closed Captioning Tutorial using Windows Media Player and VLC Media Player

If you are a fan of foreign language movies, then certainly you will love the Windows Media Player’s Close Caption option. Some viewers also like to read the Close Captions, when they need to keep the volume low, while watching their favorite movies.
 
VLC Media Player do support this feature from the beginning of its release, and this feature is enabled by default in VLC Media Player. On the other hand, you need to enable this feature in Windows Media Player.
 
Do remember, Close Captions are the textual representation of the audio being played in the video. An example of the Close Captions could be our tutorial videos that you watch from our channel. We uploaded Close Captions almost for all of our videos, and the viewer can click the Subtitles, CC button from the bottom right corner. Subtitles are a little bit different than Close Captions. Using Subtitles you can translate the text in other foreign languages. Like, in Youtube you can click the Settings button to translate the text in other languages, in real time.
 
In Windows Media Player, you can turn on Close Captions or Sub Titles by clicking on Play menu, point to Lyrics, Captions and Subtitles, and then click on “On if available”. Now, play a video, which has sub titles available. You must note that, the option itself says “On if available”, that means Subtitles or Close Captions only be visible, if a corresponding file is available on the same location, where your video file is located, as you can see in this folder, and most probably caption file name should be same as video file name, so video player may load them automatically. Media Player supports, SSA, ASS, and SRT file types.
 
In Windows 10, you can also personalize Close Captions. Open Settings window by pressing Windows + I key, and then click Ease of Access. From the left side pane, click Closed Captions, and then adjust the settings accordingly.
 
In VLC Media Player, if captions does not load automatically, then you load them from Subtitle menu. You can also download captions files for your favorite movie from Internet, and can then place them into the same folder.
 

 

Readability Statistics Word 2016 / 2013 - Know More About Your Writing S...

Readability Statistics in Microsoft Word is available since from the older versions of the Word, but very less people know about this as it is turned off by default. This feature displays information about your document reading level and how many words, paragraph, sentences, and passive sentences has been used in your document.
To enable Readability Statistics, click the File menu, and then click Options. From the left side pane, click Proofing. Under “When correcting spelling and grammar in word”, make sure “Show readability statistics” is checked.
Do remember that, Readability Statistics is a part of spelling and grammar check, and Microsoft Word will not display any Readability Statistics until you check Spelling and Grammar mistakes in your document. For this, click the Review tab, and then click Spelling & Grammar, or alternatively you can press F7 keyboard shortcut to do a spelling and grammar check. Once you finished correcting all the Spelling & Grammar mistakes in your document, Word will display Readability Statistics in the end.
In Readability Statistics Report, Reading Ease is measured in a scale of 0 to 100. The more your document score, the contents are easier to understand. The Grade Level indicates that, how much education one need to understand the contents of your documents. Through Grade Level you can estimate, the average age of a person, who can understand the contents of your documents.
 

Windows 10 Hidden Features - Know Your System Uptime

In Windows, you can easily know that from how long your computer has been running, and can easily find your system uptime. There are various method to know your system uptime. Let’s have a look:
 
The first method is to use Task Manager. Right-click on your Taskbar and then click Task Manager. Click the Performance Tab, and below you can see your system uptime.
 
The second method is to use Elevated Command Prompt. Right-click on the Start button, and then click Command Prompt Admin. Click Yes for User Account Control. At Command Prompt type, systeminfo and hit enter key. Scroll the screen upwards, and there you can find System Boot Time.
 
Another command that you can try at Command Prompt is, net stats SRV, and hit enter key. The Statistics Since are, actually the date and time, when your system was booted up.
 
The last option to see the System Uptime is to use Window Power Shell. In the Search box, type Power Shell, then right-click on Windows Power Shell, and click Run as Administrator. At Windows Power Shell, run the script line that you can copy and paste from the description below, and then hit the enter key. This power shell script only give you information about the system uptime in days, hours, minutes, seconds, and even milliseconds.
 
 

Windows 10 / 8 / 7 - High Definition Audio Drivers - What You Are Missing?

If you have recently installed a fresh copy of Windows, then you may be glad that Windows has installed almost all of your hardware drivers automatically. But those are the standard drivers that bundle with Windows, and are dated back to Windows release, means, you are using out dated and standard drivers for your hardware devices.

For instance, your Windows computer might be playing sound, but if you look into Sound, Video and Game Controller under Device Manager, then you can see that Windows has installed the Standard High Definition Audio Device, and you may be missing the actual sound quality, and feature that your sound card can provide, but due to out dated and standard drivers, those features will be unavailable.

What you need to do is to, install the actual driver provided by your manufacturer, or download the latest drivers from manufacturer’s website. Let’s see how to do this, and how it will affect your hardware working efficiency?

To download the sound drivers for your embedded motherboard sound card, first you need to know the exact model number
of your motherboard. For this, you can download and run this small utility called, CPU ID. The link is given in the description. Once you download and installed, run the utility and let it identify your system. Click the Mainboard tab, and here you will find the manufacturer and model number of your motherboard. Now, Google for the same and download the latest drivers for your
sound card. After the download complete, install the drivers.

Once the installation get completed, recheck if Windows has properly installed the drivers. Now, not only the sound quality will improve but you may also get some more features that your sound card may support. You may look into Control Panel, if there is an applet corresponding to your sound card. Open it, and you will find a dozen of new features, to give you a new listening experience.

So this is how updating the device drivers can improve the performance of a device, and updating other drivers like, the video card drivers and chipset drivers can also improve the overall speed of your computer.
 
 

Change Default Download Location in Google Chrome, Mozilla Firefox and I...

In Google Chrome, Mozilla Fire Fox, and Internet Explorer, when you download a file, the default location for downloads is the Download folder, under your User Profile folder. If you occasionally download large files from internet, and do not want to store them on the same drive, where Windows is installed, then you can change the default location in the said browsers, so you don’t need to move the files after downloads are completed.

For instance, I want to store the next downloads to separate folders that I have created on drive D. To change the default download location in Google Chrome, open Chrome, click the three bar customize button, and then click Settings. Click Show Advanced Settings link. Scroll down and move to Downloads section. Click the Change button, and point to your new folder where you want to save your next downloads.

Now, open Mozilla Fire Fox, click the three lines Menu button, and then click Options. Alternatively, you can press the ALT key to bring the menu bar and the top of the screen, then click Tools menu, and click Options.

From the left side pane, make sure General is selected. From the Downloads section, click the Browse folder, and point to the folder where you want to save your next downloads. In Internet Explorer, click the Settings button, and then click View Downloads. Click the Options link from the bottom left corner. Browse for the new location where you want to save your
next downloads.

So this is how you can manage your new downloads, and can save them to your favorite folder locations.