When you want to copy the result of the cell to another cell in Excel, the target displays an invalid references error messag. This error can be avoided by copying cell value into target cell and not the whole formulas.
The new version of the popular text editor also offers a very simple adding online videos in the document. I will show you how to add online video in Microsoft Word 2013 document.
In this lesson we will show you how to use the enhanced cropping tool to trim and efficiently remove unwanted portions of pictures to get just the look that you want.
In Microsoft Word 2013 we can easily format text with the help of layout options. In this lesson I will show you how you can easily align text with inserted picture.
It often happens that we need to insert a table into the document. In this lesson we will show you how to create a table and then we will redesign it to be more transparent.
You don't need Photoshop or some other advanced piece of software to resize a large number of images at once. You can use Microsoft Office Picture Manager which is part of the Office suite.
Microsoft Excel allows you to sort your data in a number of different and custom ways, let's learn how to sort Excel data according to the color of the fonts.
You will find out how to summarize cells that have a same color of the font, the red one in my case. Really useful when working with different types of specific data in Excel.
Sometimes you get an email with a lot of attachments and saving them one after another to your computer can be really time consuming. Let's learn how to save all Outlook attachments at the same time.
Word is becoming stronger in graphic design tools and I will show you something really neat today. We will draw a custom shape and add your favorite gradient colors.
Mail merge is one of the most useful features of Microsoft Word when wanting to send personalized letters, documents or e-mails to people you have stored in an Excel sheet. Let me show you how to use it.
If you know how many years or months you got left until the retirement or any other event or project in your life, Excel can return you the exact date and the number of days left to reach it.
Microsoft Word allows you to add the comments to text, images or basically anything included in the document. It's a great way do review a document and suggest the changes that should be made.
There are two levels of Microsoft PowerPoint password protection, one to open the presentation and one to enable making changes to presentation. Let's check both of them.
If you want you can turn any Microsoft PowerPoint presentation into a video so you can play the presentation on a computer that doesn't have Microsoft Office installed.
Sometimes when you are writing a title, one last word jumps into the next row. If you don't want to change the font size, there is another way to deal with these so called widow words.
When you send an email to multiple people, those people can see who else got that email. But if you don't want certain email addresses to be visible to others, this is how you do it in Outlook 2010 in secrecy.
If you are using the same entries all over again, you can create a custom list with these entries and when you need it just enter the first one then drag the cell down for the rest to fill out automatically.
In Microsoft Excel you can use formating tools like colors, text alignment, font styles and many more to make your sheets look nicer and more transparent.
