Learning Microsoft Office package with Tutorial for Word, Excel and PowerPoint

The best things of Office 365

The new Microsoft Office: As with the previous versions, you can get Word, Excel, PowerPoint and more as a locally installed suite of applications or as Office 365, a cloud-based subscription. However, choosing between Office 2013 desktop software and the new Office 365 is a dramatically different decision than in the past.
This time, there is virtually no decision to make. Comparing Office 2013 to Office 365 is an exercise in semantics; Microsoft has significantly stacked the deck to favor one over the other.

Microsoft has given Office 365 a clear advantage over Office 2013.
There is a clear distinction between the two options. Office 2013 describes only the desktop applications. By contrast, Office 365 is a Web-based platform that pairs the Office applications with cloud storage. In the past, though, the Office 365 versions of the software had limited features and capabilities compared to the full desktop versions, and if you didn’t have an Internet connection you didn’t have Office.

With the new versions of the productivity suite, though, Office 2013 vs. Office 365 is a smoke-and-mirrors debate. Office 2013 is more expensive than Office 365, and the license is only good for one machine. If you only need the core applications (Word, Excel, PowerPoint, and OneNote) you can get Office 2013 Home & Student for $140. Throw in Outlook, and you get Office 2013 Home & Business for $220. Office 2013 Pro adds Access and Publisher, all for $400.

Office 365 comes in two flavors: Office 365 Home Premium for $100 per year and Office 365 Small Business Premium for $150 per year. Both come with the full Office 2013 Pro software for your PC, but there are key differences. Up to five people can use Office 365 Home Premium on up to five devices, with each user getting an Office experience customized to their own Microsoft ID.

Office 365 Small Business Premium also comes with five licenses, but billed per user per year. Each user can install and use Office on up to five PCs, but the licenses can’t be shared with other users. Office 365 Small Business Premium also includes a managed Microsoft Back Office environment including Exchange, SharePoint, and Lync.

Office 365 includes five licenses for Office 2013 Pro.

Subject on how many computers and devices you want to install Office 2013 on through Office 365, and which version of Office 2013 you’re comparing to, it will take somewhere between one and a half to 20 years ($400 multiplied by five to install Office 2013 Pro on five machines comes to $2000—or 20 years of Office 365) for Office 2013 to become the more reasonable choice.

The only consequence that truly makes sense for Office 2013 is if you only need the software in Office 2013 Home & Student, and only on a single PC. In that case, you can spend the $140 and be done. Once you throw in a second PC, though, or if you need the additional tools like Outlook, Access, or Publisher, the math is heavily skewed in favor of the Office 365 subscription.

The beauty of Office 365 is that you get more than just Office 2013 for your money—it also comes with benefits that Office 2013 lacks. It comes with an additional 20GB of SkyDrive storage and 60 minutes per month of transnational Skype calls. Office 365 also has a new feature called Office On Demand that enables you to stream virtualized versions of the full desktop software to any Windows 7 or Windows 8 PC.

But, even for other stands or mobile devices there are Web-based versions of the Office applications, and as long as you store your files in SkyDrive you can access them seamlessly from virtually any Web-connected device. The world doesn’t end if your laptop is stolen or destroyed, and you can still edit a crucial client presentation even if you don’t have your PC with you.

Even if you only need the applications in Office 2013 Home & Student, it would cost $700 to put that software on five machines, and it would take seven years to break even on the cost of the Office 365 subscription. By that time, there will be a new version of Office (or two, maybe three). If you buy Office 2013 Home & Student, you’ll still have it in the year 2020. But, if you subscribe to Office 365 you will always have the most current version of Office available.

Microsoft has set things up so that the conclusion is already made. You are free to purchase Office 2013, but Office 365 has very clear advantages, and it makes more sense financially in almost every state.

How to Add a Filter in Excel 2007-2010-2013

For example your worksheet contains a lot of content, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

How to filter data:

In this example, we'll apply a filter to an equipment log worksheet to display only the laptops and projectors that are available for checkout. In order for filtering to work correctly, your worksheet should include a header row, which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1: ID#, Type, Equipment Detail, and so on.

Select the Data tab, then click the Filter command.

A drop-down arrow

will appear in the header cell for each column.
Click the drop-down arrow for the column you wish to filter. In our example, we will filter column B to view only certain types of equipment.

The Filter menu will appear.
Uncheck the box next to Select All to quickly deselect all data.

Check the boxes next to the data you wish to filter, then click OK. In this example, we will check Laptop and Tablet to view only those types of equipment.

The data will be filtered, temporarily hiding any content that doesn't match the criteria. In our example, only laptops and tablets are visible.

To apply multiple filters in Excel:

Filters are cumulative, which means you can apply multiple filters to help narrow down your results. In this example, we've already filtered our worksheet to show laptops and projectors, and we'd like to narrow it down further to only show laptops and projectors that were checked out in August.

Click the drop-down arrow for the column you wish to filter. In this example, we will add a filter to column D to view information by date.

The Filter menu will appear.
Check or uncheck the boxes depending on the data you wish to filter, then click OK. In our example, we'll uncheck everything except for August.

The new filter will be applied. In our example, the worksheet is now filtered to show only laptops and tablets that were checked out in August.

How To clear a filter in Excel:

After applying a filter, you may want to remove, or clear, it from your worksheet so you'll be able to filter content in different ways.
Click the drop-down arrow for the filter you wish to clear. In our example, we'll clear the filter in column D.

The Filter menu will appear.
Choose Clear Filter From [COLUMN NAME] from the Filter menu. In our example, we'll select Clear Filter From "Checked Out".

The filter will be cleared from the column. The previously hidden data will be displayed.

To remove all filters from your worksheet, click the Filter command on the Data tab.

Transitions

There are three categories of unique transitions to choose from, all of which can be found on the Transitions tab:

Subtle: These are the most basic types of transitions. They use simple animations to move between slides.

Subtle transitions
Exciting: These use more complex animations to transition between slides. While they're more visually interesting than Subtle transitions, adding too many can make your presentation look less professional. However, when used in moderation, they can add an nice touch between important slides.

Exciting transitions
Dynamic Content: If you're transitioning between two slides that use similar slide layouts, dynamic transitions will move only the placeholders, not the slides themselves. When used correctly, dynamic transitions can help to unify your slides and add a further level of polish to your presentation.

Dynamic transitions

Applying a Transition:

Select the desired slide from the Slide Navigation pane. This is the slide that will appear after the transition.

Selecting a slide
Click the Transitions tab, then locate the Transition to This Slide group. By default, None is applied to each slide.
Click the More drop-down arrow to display all transitions.
Clicking the More drop-down arrow
Click a transition to apply it to the selected slide. This will automatically preview the transition.
Selecting a transition

You can use the Apply To All command in the Timing group to apply the same transition to all slides in your presentation. Keep in mind that this will modify any other transitions you've applied.

Applying the same transition to all slides

Preview a Transition:

You can preview the transition for a selected slide at any time, using either of these two methods:

Click the Preview command on the Transitions tab.
Clicking the Preview command
Click the Play Animations command in the Slide Navigation pane.
Clicking the Play Animations command in the Slide Navigation pane

About Modifying Transitions

To Modify the Transition Effect:

You can quickly customize the look of a transition by changing its direction.

Select the slide with the transition you wish to modify.
Click the Effect Options command and choose the desired option. These options will vary depending on the selected transition.
Modifying a transition effect
The transition will be modified and a preview of the transition will appear.

Some transitions do not allow you to modify the direction.

To Modify the Transition Duration:

Select the slide with the transition you wish to modify.
In the Duration field in the Timing group, enter the desired time for the transition. In this example, we'll increase the time to 2 seconds, or 02.00, to make the transition slower.
Modifying the transition duration

To Add Sound:

Select the slide with the transition you wish to modify.
Click the Sound drop-down menu in the Timing group.
Click a sound to apply it to the selected slide, then preview the transition to hear the sound.
Adding a sound to a transition

Sounds are best used in moderation. Applying a sound between every slide could become overwhelming or even annoying to an audience when presenting your slide show.

How to remove a Transition:

Select the slide with the transition you wish to remove.
Choose None from the Transition to This Slide group. The transition will be removed.

Removing a transition from a slide

Now, to remove transitions from all slides, apply the None transition to a slide and then click the Apply to All command.