Centering Across Columns

Excel has a nifty feature that allows you to format your headings to look better on the printed page. You can center the contents of a cell so that it is spread across several columns. For instance, if the body of your worksheet is six columns wide, you can center your headings across all six columns. Applying this type of formatting is very easy:

1. In the left-most cell of the range in which you want the text centered, enter the text.

2. Select the range of cells across which you want the text centered.

3. Click on the Center Across Columns tool on the toolbar.

MicroSoft AutoText

Inserting a frequently used item as an AutoText entry in Microsoft Word

If you hate typing this is the tip for you.

AutoText offers a way to store and quickly insert text, graphics, fields, tables, bookmarks, and other items that you use frequently. Microsoft Word comes with a number of built-in AutoText entries that are divided into different categories. For example, if you’re working on a letter, Word can offer letter-specific AutoText entries, such as salutations and closings.

In addition, you can create your own AutoText entries. This is useful if you often use the same large or complex item and don’t want to have to reinsert or retype it, or if you want to store text that contains a particular style or format. For example, if you send customers a monthly report that always includes the same lengthy disclaimer, you can create an AutoText entry for the disclaimer.

PAS Administration Support Services can show you and your staff how to use this feature to optimize your day-to-day office administration

 

An EXCEL Customer List

A well designed name and address database would define a separate cells for the First Name and Last Name. Reasons to separate the name fields are for the purposes of Sorting the list and Finding a Customer  in your list using Excel functions. Below are instructions to combine the First and Last Names into a single cell… these new cells can then be used for  envelopes or mailing labels.  Don’t forget… your Customer Excel database can hold everything you need to know about your Customer.

Give us a call and we show you how we help you “Work Smart – Not Hard”

loadTOCNode(2, ‘moreinformation’);You can concatenate or adjoin text in multiple columns by using the & operator or the CONCATENATE function–for example, if you type the following data in cells A1:C2:

A1: First	B1: Middle	C1: Last
A2: Tom	B2: Edward	C2: Smith

To put the full name, in cell D2, type one of the following formulas:

$D$2: =CONCATENATE(A2,” “,B2,” “,C2)

$D$2: =A1&” “&B2&” “&C2

Note A space (” “) between the cells is used to insert a space between the displayed text.

Business Administration 101

This is my first post.

My experience has taught me one very important thing. Quick Access to your business information is essential. If you have easy access to your business’s information, you can own the control of your business. Control of your business will give you the Power to Know more about your business, such as:

* The Performance of Your Products or Services

* Inventory Control and Management

* Your Customer Profiles

* Who Owes You Money

* Who You Owe Money To

* Your Business’s Income

* Tax/GST/PST Status

All of the above are the controls of conventional accounting practices can be managed on a 36 column columnar pad. However, instant access to the above noted controls is a tedious task. Product performance (Inventory Control) would require a completely separate set of records.

Do not miss the opportunity of learning the dynamics of a manual set of ledgers…it will prepare you for an easy transition to a computerized accounting system.

My future posts will give admin tips. Also, my other sections will help you with MS Excel, Word and PowerPoint.

My next post to this section will help the Small Business Owner understand the business’s pieces of information and how they can relate to each other (tech note: a relational database)