» Microsoft Office Kara the Computer Tutor

How to Change the Default Font Color in Windows 7

Posted on May 21, 2013 by Kara the Computer Tutor

Would you like to make all your text in Windows 7 uniform across the board? This tip will help you change your default font in Excel, Outlook, and the other Microsoft Office programs. It will also change the default font for your folder names in your Windows boxes, etc. Beware, though, it will change everything! [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Outlook, PowerPoint, Uncategorized, Windows 7, Word | Tagged: change all font colors, change default font color, change default font color Excel, change font color, change font color Windows 7, font color windows 7, new font color excel, new font color windows 7 | Leave a Comment »

How to Change the Selected Text Color in Windows 7

Posted on May 20, 2013 by Kara the Computer Tutor

Is it hard for you to see the gray highlighting that appears when you select text? You might be selecting text in Word, Excel, Outlook, or another Microsoft Office program. Or, you may be highlighting text on a webpage. Well, there’s a way to change the default highlighting color in Windows 7. Unfortunately, though, I [...]

Filed under: Blogroll, Computers, Excel, Internet, Microsoft Office, Outlook, PowerPoint, Uncategorized, Windows 7, Word | Tagged: change highlight text color, change highlighted color, change Microsoft Office highlighting color, change selected text color, Change website highlighting color, change Windows 7 selected text color, highlighted text color, selected text color, use different highlighted text color, use different selected text color | Leave a Comment »

How to Color Tabs in Excel

Posted on March 30, 2013 by Kara the Computer Tutor

You can spruce up a workbook by coloring its worksheet tabs. There are several ways to do it. For this exercise you need a workbook with at least three tabs. Here’s the easiest way: Right click on the first tab you want to color. Hover your mouse over Tab Color in the menu that pops [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: color tabs, color tabs in Excel, colors box, custom colors, how to color tabs, tab colors, tab colors in Excel, theme colors | Leave a Comment »

How to Subtract Numbers in Excel

Posted on March 15, 2013 by Kara the Computer Tutor

For this exercise you need to start with an empty spreadsheet. First let’s enter the numbers we’re going to use: We want to give ourselves some room to work, so click in cell C5. Type the number 65. Hit the down arrow key on your keyboard to go to cell C6. Type the number 4. [...]

Filed under: Computers, Excel, Mac, Microsoft Office, Software | Tagged: how to subtract in excel, simple formulas in excel, subtract in excel, subtract numbers in excel, subtracting in excel, subtraction formula, subtraction symbol | Leave a Comment »

How to Center a Title in Excel

Posted on January 15, 2013 by Kara the Computer Tutor

Have you racked your brain trying to center a title on a spreadsheet? Here’s a beginning exercise on learning how to type a title, format it, and then center it: Click in cell A1 to make it the active cell. A black border will appear around it. Look down at the lower left-hand side of [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: center a title in excel, center a title on a spreadsheet, center heading in excel, center title on spreadsheet, centering title tutorial, excel centering tutorial, free excel merge & center tutorial, merge & center, merge & center button, merge and center | Leave a Comment »

Parts of the Excel Screen

Posted on January 13, 2013 by Kara the Computer Tutor

Let’s learn some Excel lingo. Go ahead and open your Excel 2010 or 2007 program if you haven’t already done so. Here’s what you’ll see: The ribbon. This is the wide strip across the top of your screen where all the buttons are. The ribbon consists of various tabs. These include Home, Insert, Page Layout, [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: cell names, excel jargon, excel lingo, names of parts of excel, names of parts of spreadsheet, parts of a spreadsheet, parts of excel screen, parts of excel workbook, what is the ribbon | Leave a Comment »

How to Print in Excel 2010

Posted on January 6, 2013 by Kara the Computer Tutor

Printing in Excel can be very tricky. This tutorial teaches how to print a spreadsheet so it actually looks good. There are a few ways to setup a spreadsheet in Excel 2010. We’re going to use the print settings in the Page Setup dialog box because to me that’s the simplest way. To access this [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: how to print in excel, one page spreadsheet, print in excel, print on one page excel, print one page excel, print spreadsheet in excel, print spreadsheet on one page, printing in excel, setup spreadsheet to print | Leave a Comment »

How to Create a Simple Macro in Microsoft Word

Posted on January 1, 2013 by Kara the Computer Tutor

Creating a macro in Microsoft Word isn’t as hard as you might think. It’s really just a bunch of steps you need to perform in an exact order. This tip provides an example on how to do it: Let’s say you write a lot of business letters, and you’d like to end them the same [...]

Filed under: Blogroll, Computers, Microsoft Office, Software, Uncategorized, Word | Tagged: create a macro, create macro in word, creating macros, how to create a macro, how to make a macro, macros, make macro, make macro in word, making macros | Leave a Comment »

How to Combine First and Last Names in Excel

Posted on September 18, 2012 by Kara the Computer Tutor

Let’s say you have two columns. Column A has people’s first names, and Column B has last names. You want to combine the first and last names into the same column. Here’s how: First we’ll insert an empty column to the right of Column B. To do this, move your mouse arrow directly on top [...]

Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: combine first and last names, combine first and last names in Excel, combine first and last names in same cell, combine names in excel, concatenate, Excel 2007, excel 2010, excel concatenate, first and last names in same cell, how to concatenate | Leave a Comment »

How to Format Dates in Excel

Posted on September 15, 2012 by Kara the Computer Tutor

The default format for dates in Excel is kinda weird, at least for the United States. If you don’t change the format, the dates look like this: Unformatted Dates No worries. You can change the format to something normal looking in no time. This tip shows how to do it in both Excel 2010 and [...]

Filed under: Computers, Excel, Microsoft Office, Software, Uncategorized | Tagged: change date format, change date format in Excel, dates are in wrong format, excel dates, format dates, format dates in Excel, format dates in excel 2007, format dates in excel 2010 | Leave a Comment »

Kara the Computer Tutor

Blogroll

Call from the U.S.

Posts from the Past

How to Subtract Numbers in Excel

How to Format Dates in Excel

Recent Posts