Applying Quick Styles to a PowerPoint Table

February 18, 2010

If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!PowerPoint includes several quick table styles that you can add to your table. These table formats include preset colors and border styles that you can instantly apply to an existing table. Under the contextual Design tab under the Tables tab, [...]

Read the full article →

Using Word as a Blog Editor

February 17, 2010

Did you know that you can use Microsoft Word as a blog editor? Word actually has a powerful blogging feature that allows you to publish your blog posts directly to your site. Additionally, blogging with Word allows you to use the options on the Word blogging Ribbon: WordArt, Symbols, SmartArt, Shapes, ClipArt, SpellChecker and more. [...]

Read the full article →

Inserting a Table into an Existing PowerPoint Slide

February 16, 2010

In yesterday’s post, we saw how to insert a table into a new PowerPoint slide. Of course, you can easily insert a table into an existing slide as well.

To Insert a Table on an Existing Slide Layout

Click the Table button on the Insert Ribbon.
Click Insert Table on the menu.
Enter the number of rows and columns [...]

Read the full article →

Inserting a Table in a New PowerPoint Slide

February 15, 2010

Tables are an excellent way to present and organize columns of data. Similar to spreadsheets, tables are organized in rows and columns. The intersection of rows and columns is called a cell. You decide how many rows and columns you want to appear in your table. Pressing the Tab key moves your cursor from one [...]

Read the full article →

Transpose Rows and Columns in Excel

February 11, 2010

Once I was setting up a spreadsheet and entered in a fair amount of data only to realize afterwards that the structure of the spreadsheet was not what I wanted. What I really needed, were the rows to be the columns and the columns to be the rows. Luckily, I discovered an easy way to [...]

Read the full article →

Converting Formula Results to Values in Excel

February 10, 2010

There may be certain instances when you need to convert the results of your Excel formula to a static value – that is to say, the cell no longer contains the formula but rather the formula result.
Keep in mind that there’s no going back so you may wish to make a backup of your worksheet [...]

Read the full article →

Using the Convert Function in Excel

February 9, 2010

The convert function in Excel converts a number from one measurement to another. For example, CONVERT can translate a table of temperatures from Fahrenheit to Celsius (or vice-versa), miles to kilometers, hours to seconds and much, much, more.
The Syntax of the CONVERT function is:
CONVERT(number,from_unit,to_unit)
Number is the value in from_units to convert.
From_unit is the units for [...]

Read the full article →

Print a Word Table in Landscape

February 8, 2010

If you have a table in a Word document that is too wide for portrait orientation, you can print the only the table in landscape (and keep the rest of your document in portrait). To do this, you must first select the entire table.
To Print a Table in Landscape Orientation:

Move your mouse pointer over the [...]

Read the full article →

Shortcut Keys in Excel

January 7, 2010

Many users prefer to accomplish as much as possible by using the keyboard, instead of the mouse (I happen to be such a user). Below are a few helpful shortcut keys to get things done in Excel without having to leave your keyboard:
Number Formatting

Ctrl+ Shift+ 1 Format the current cell with commas
Ctrl+ Shift+ 4 [...]

Read the full article →

Adjusting Column Width in a Word 2007 Table

November 20, 2009

When creating a new table in Word, all of the columns in your table are initially the same size. However, when entering data, you will quickly discover that some columns need to be wider than others in order to accommodate the data.
You can adjust column width by clicking and dragging the column border or the [...]

Read the full article →

← Previous Entries

Next Entries →