ProductsOnline TrainingSamplesSolutionsSupportCompanyDeals
News
Free Training Samples

Exercise excellence: Using Excel to work out

Exercise excellence: Using Excel to work out

It's easy for some aspects of technology, like television and video games, to distract us from exercise and wellness activities. However, with creativity and some online training it's just as easy to use it to help us get fit. Here are some tips for setting up a workout log in Microsoft Excel.

For a completely personalized experience, start by deciding what exercises you want to focus on and make those the titles of your columns. By labeling the rows with the dates you intend to work out (three times a week, for example) you can easily track your progress by graphing your progress over time.

Microsoft Online also provides several templates featuring themed charts to provide some recommendations on how to craft a chart and help you start exercising right away.

Using Excel's built-in arithmetic and some simple Microsoft Office training, you can get a little more complicated, too. If weight loss is your target, you can input your weight and convert it into useful information like body mass index or body fat percentage.

However you choose to do it, tracking your progress with Excel will help you stay motivated and goal-oriented. 

Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe, Microsoft, Apple, and more. Click here to learn more about Total Training and see how it works.

Draft professional cover letters that stand out using Microsoft Office

Draft professional cover letters that stand out using Microsoft Office

The current job market offers a wealth of challenges for those both experienced and new to the hunt for professional opportunity. More than ever, a multitude of educated individuals are clamoring to have their credentials stick out to potential employers. If you are looking for new and proven ways to get ahead of the pack, consider investing in online training programs to help you create professional cover letters.

Brushing up on industry-standard software improve your technical skills, and it will also provide guidance on formatting a number of professional documents - including cover letters. Microsoft training offers you the opportunity to compare your cover letter to templates or use the ones it offers.

A few cover letter industry standards to adhere to include using a simple and easy-to-read font style, or perhaps two - one for the title and one for the body text. Keep the body text size between 10 and 12 point font.  By contrast, the header, which includes your name, contact information and the recipient’s details can be larger, within reason - you don't want to overdo it.

Try to keep the cover letter and resume similar so they easily tie back to each other. This and other helpful guidance can be gained with online training tutorials.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe, Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

Design business cards in Microsoft Office

Design business cards in Microsoft Office

If you are planning to strike out on your own and open your own business or have done so already, you can't forget the importance of business cards. These seemingly simple 2 x 3.5 inch cards can help a business owner make new contacts, find new jobs and advertise - and could end up remaining a permanent fixture in someone's wallet.

Therefore, Microsoft training videos may provide the direction you need to design these important business fixtures. Gain the advantage by knowing exactly what needs to be where and in what typography. If you're worried about your own creativity, Microsoft Office provides simple and easy-to-use business card templates.

Want to try your hand at designing your business card? A Microsoft Office training course will provide you the visual, audio and written direction you can follow for step-by-step instructions. The directions for any tip or effect you are looking to implement in the design of your business card will be available through online training.

Consider designing one of the most important small business tools in Microsoft Office and feel comforted that tutorials will lead the way.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe, Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

How to add a header or footer in Microsoft Office Word that includes a page number

How to add a header or footer in Microsoft Office Word that includes a page number

Headers, footers and page numbers are key organizational tools for Microsoft Office Word users who plan to create multi-paged documents. They can contain a multitude of information that can help direct readers through a document they did not create.

Microsoft online training can help those who may require more instruction on the variety of details a user can include in a header or footer.

To add a header or footer in Microsoft Office Word that includes a page number, enter the insert tab at the top of the document. Under the header and footer group, select either the header or footer option depending on need.

Close header on footer on the design tab to return to the main document to add custom details. Double click on the grey space. Then enter the information by preference, such as the name of the document’s author, page number, title or property title claim. Once completely filled out, hit the clock header and footer button at the top.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

What text wrapping options are there in Microsoft Office Word?

What text wrapping options are there in Microsoft Office Word?

After adding an image, you may wish to further refine its integration in a document by wrapping text around it. It cuts down on unnecessary white space and creates a cleaner copy. Consider online tutorials for further instruction on text wrapping options and how they can be applied.

Here are the four text wrapping style option in Microsoft Word and how they differ from one another:

1. In line with text. This is often the default text wrapping option. It inserts the graphic at the indicated point by the insertion arrow and allows text to immediately continue after the image ends.

2. Square. The square text wrap option is one of the most commonly used features because many of the images inserted in a document will be in a square or rectangular format.

3. Tight style. Use this text wrapping option to reduce white space. The program identifies the image and uses a rectangular shape to close in on the actual graphic, removing unnecessary white space.

4. Behind or in-front text. You can place the image either behind the words, similar to a watermark, or in front of the text. These two options are less commonly used and can lead to readability problems if not used carefully.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

How to add new contacts in Microsoft Office Outlook from an electronic business card

How to add new contacts in Microsoft Office Outlook from an electronic business card

Creating a contacts list can assist a person in their personal and professional lives. However, if developing that master list seems to be taking too long, there are a variety of shortcuts available to quicken the process. Microsoft Outlook users can add contacts from a message he or she receives, from an electronic business card or by copying the contact from another contact.

Consider online training to provide additional instruction for adding new contacts. Add a new contact from an electronic business card by opening the message, right clicking on the card and selecting the add to contacts button. In the contact tab, select the save group and click save and close.

If a contact already exists under the same name, Microsoft Outlook will prompt you to either select add a new contact or to update the existing listing. The newly updated or added contact will be available in business card format and list format for a user.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

How to show comments for increased editing efficiency with Microsoft Office Word

How to show comments for increased editing efficiency with Microsoft Office Word

Microsoft Office Word provides users a variety of methods to track editing changes to a document to fit various individual needs. Whether a person would like editing to remain on the margins to review or balloons that appear when they hover over the highlighted material, Microsoft Word is an efficient program.

The default of the program is to display the deletions, additions or comments in balloons in the margins of the document. It is one of the easiest to understand with online training for users and limits the possibility of forgetting edits. Under the review tab, select the tracking group and click show markup.

Point to the balloons in the margins and click show all revisions inline to show any deletions, additions or comments. When a user hovers the pointer over the comment in the document, the edits will appear in a ScreenTip dialog box. Further Microsoft Office training can increase a user’s ability to track document edits for increased efficiency.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

How to remove duplicate rows in Microsoft Office Excel

How to remove duplicate rows in Microsoft Office Excel

Importing data can often leave a Microsoft Office Excel sheet with a few extra components such as extra rows, columns, extending titles and even high-lighted cells. Unless those directions were purposely added to the document you may want to remove them and online training can help direct you.

One of the most common additions is the duplication of rows, with values or not. Once you have identified a duplicate it is best to filter through the document to identify if any else have been added. Select all of the rows, including column headers in the list you wish to filter and click the top left cell of the range and drag it to the bottom right cell. Under the data menu, point to filter and click advanced filter.

In the advanced filter box select filter the list in the place option box. Then choose the unique records only check box option and hit ok. The filter list will be displayed for your review. Make sure the filtered list is still selected and click ok. Under the data menu button, point to filter and select the show all option that appears. Once the original list is re-displayed, press the delete key. The filtered file should be under the listed item and free of any duplicate rows. 


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

How to merge and unmerge cells in Microsoft Office Excell

How to merge and unmerge cells in Microsoft Office Excell

Microsoft Office cells create necessary divisions in the spreadsheet application for both formula and navigation purposes. Therefore, it is important to determine and accurately merge or unmerge a cell, and Microsoft training videos could help achieve it. It is unfortunately easy to accidentally fat-finger a key stroke and create a formula inconsistency or cell division that could change account formula results.

Distinct cells can reduce error potential. Therefore, merge adjacent cells by selecting two or more boxes and entering the home tab. Under the alignment group, click merge and center to combine the sections together. It may then become necessary to change the text alignment in the merged cell. Select the dialog box and enter the alignment group under the home tab to choose your structure preference.

If you require a cell to split, select the merge cell and enter the merge and center tab. Choose the button featuring arrows pointing to the right and left and then click the unmerge cells control. Online training can provide further instruction on merging and splitting cells if needed.


 

Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe,Microsoft, Apple,  and more.  Click here to learn more about Total Training and see how it works.

Sign off on emails with Microsoft Office training

Sign off on emails with microsoft office training

The Microsoft Office Suite delivers options across its programs. Online training provides people with options as well, letting them choose to become experts on software including Microsoft Word, Excel and Outlook.

People can use Outlook to send and receive large numbers of emails quickly. The program provides businesses and individuals tools that enhance email organization and communication. The software incorporates social networking features as well, adding a personalized touch that makes it easy for users to use Facebook and Twitter accounts through the program.

Outlook offers a Signature option that enhances personalization. Users can create personalized signatures that include images, text and logos in their emails. In addition, people can incorporate a scanned image of a handwritten signature. People can add their John Hancocks to an email by selecting the Message tab in the Include group. Click Signature, then click Signatures. On the Email Signature tab, select new. Additional online software courses can give Outlook users the tools to enhance their signatures further.


Total Training is the leader in software training solutions, offering video and interactive instruction on leading software products from Adobe, Microsoft, Apple and more. Click here to learn more about Total Training and see how it works.


Home | Products | Company | Return Policy | Contact Us | Site Map | Free E-Newsletter

© 2011 Total Training Inc. All rights reserved.