Excel Mobile

October 22nd, 2007 — Uncategorized
Applies to: Windows Mobile 5.0 Pocket PCNot only can you edit Excel workbooks and templates created on your PC, you can create and edit workbooks and templates on your device with Excel Mobile.

Edit

Adjust column widths and row heights
 
TipTo specify an exact column width and row height, tap and hold the column or row, tap Format Cells and enter the measurements on the Size tab.
 

Copy and paste data

You can copy data from one cell to another in an Excel Mobile workbook by using the Copy and Paste commands on the shortcut menu. In addition, you can do the following:
TipTo preserve memory, Paste is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the copy and paste procedure multiple times.
 

Delete cells, rows, or columns

 
NoteExcel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations. However, a formula that refers to a deleted cell displays the #REF! error value.
 

Fit rows and columns to data

 
 
 
 

Format numbers and text

You can easily format numbers in an Excel Mobile workbook by assigning a numeric category such as number, currency, date, or fraction to a cell. You can also format text by changing the font type, size, or color, applying bold or italic formatting, and underlining text.
 

View

Adjust the view of a worksheet

In an Excel Mobile workbook, you can display and hide window elements such as scroll bars, view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes, and use the full screen to see as much data as possible.
 

Go to a cell or region

 
NoteThe current region is defined as the block of filled-in cells that includes the currently selected cell or cells. The region extends in all directions to the first empty row or column.

Tip

To go to a specific cell, you can also enter the cell reference in the name box and then tap Enter.
 

Hide and display rows and columns

 

Calculate

Automatically calculate values

You can quickly calculate the largest number, smallest number, average number, and sum of the numbers in a selected range of values.
 

Automatically enter a sequence of values

 
Note
With Autofill you can quickly fill cells with repetitive data such as numbers or repeated text. Autofill takes the content of the first cell in the selected row or column and copies it down or across the rest of the selection.Tip
To preserve memory, Fill is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the fill procedure multiple times.
 

Automatically add values

 
Note
Any time you change a value in the cells you originally selected to add, the sum will be updated.
 

Enter a formula

 

Enter a value or text in a cell

Note
To enter text, you may need to tap Input to display Input panel.Tip
To quickly edit cell contents, tap the cell and replace or edit the text or value. To undo an edit, tap Menu > Undo Typing in x.
 

Filter data in a worksheet

 
Note
The data in the top row of the selected cells or range of cells will not be filtered. The row should contain column headings.Tips
To turn off AutoFilter, tap Tools > AutoFilter.
To display all rows again, tap All in the filter list in each of the selected columns.
 

Insert a function

 
Tip
To learn about a function, review the information provided in the description area below the Function list.
 

Insert a symbol

 
Tips
If you select a different font or subset, a different set of symbols displays.
To use Microsoft Wingdings or Microsoft Webdings that are available on your PC, connect your device to your PC and open ActiveSync. Copy the Wingdings.ttf and Webdings.ttf files from the Font folder on your PC to the My Windows Mobile Device /Windows/Fonts folder in the ActiveSync window. For more information, see ActiveSync Help on the PC.
 

Worksheets

Insert a worksheet

An Excel Mobile workbook contains three worksheets by default. You can easily add more sheets if you need them to help organize your data.
 

Delete a worksheet

You can delete a worksheet you no longer need from your workbook.
 

Rename a worksheet

Worksheets are named Sheet1, Sheet2, and so on, by default. You can easily rename the worksheets with meaningful names.
 

Move a worksheet

You can easily change the order of sheets in your Excel Mobile workbook.
 

Switch to another Worksheet

 
 

Sort data in a worksheet

You can sort data in ascending order (A-Z, or 0-9) or descending order (Z to A, or 9 to 0).
Tip
To undo a sort, tap Menu > Undo Sort.
 

Insert cells, rows, and columns

 
Note
Excel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations.

No Comments

Bluetooth Settings

October 22nd, 2007 — Uncategorized
Applies to: Windows Mobile 5.0 Pocket PC
Bluetooth is a short-range wireless communications technology. Devices with Bluetooth capabilities can beam (exchange information) over a distance of about 10 meters (30 feet) without requiring a physical connection. Unlike infrared, you don’t need to line up the devices to beam information with Bluetooth. You can even beam information to a device in a different room, as long as it’s within range.You can use Bluetooth as follows:
Tip
Your device might include additional Bluetooth features. For more information, see the documentation included with your device.

Bluetooth

Turn on and off Bluetooth
Ensure that the two devices are within close range and that both Bluetooth-enabled devices are discoverable.

Note
By default, Bluetooth is turned off. If you turn it on, and then turn off your device, Bluetooth also turns off. When you turn on your device again, Bluetooth turns on automatically.

Create a Bluetooth partnership
You can create a partnership between your device and another device that has Bluetooth capabilities. Once you do this, the devices must have Bluetooth turned on but don’t need to be discoverable for you to beam information between the two devices.

Note
When you turn on flight mode, Bluetooth is turned off.

Rename a Bluetooth partnership
You can give a more meaningful name to a Bluetooth partnership to help you recognize it when selecting from a list of partnerships.

Make a device discoverable
Other devices with Bluetooth capabilities can detect your device and attempt to beam information to it, establish a partnership, or use a Bluetooth service.
Other Bluetooth-enabled devices can now detect your phone and attempt to beam information to it, establish a Bluetooth partnership, or use a Bluetooth service.

Receive a Bluetooth beam
Your device will not detect and notify you of incoming infrared (IR) and Bluetooth beams unless you set it up to do this.

Set up a Bluetooth headset
You can use a Bluetooth headset (or other Bluetooth hands-free device) with your device when you create a partnership between your device and the Bluetooth headset.

Use a Bluetooth phone as a modem
If your device has no integrated phone capability, you can use another phone that has Bluetooth as a modem for your device to browse the Internet or to transfer other information. To do this, you create a Bluetooth modem connection on your device and then send information to the phone by using Bluetooth. The phone relays the information over the phone line and then sends back to your device any information that you had requested over the connection.Once a modem connection is created, it can be reused.

Note
Ensure that your device and the phone are turned on, discoverable, and within close range.

No Comments

Pictures and Video

October 22nd, 2007 — Uncategorized

Pictures and Video

Applies to: Windows Mobile 5.0 Pocket PC

Use the Pictures & Videos program* to take, view, and edit pictures as well as record and launch video clips stored on your device or on a storage card. You can also send pictures and video clips to others, or set a picture as the background on the Today screen. You can see your pictures individually, as thumbnails, or as part of a slide show. You can edit your pictures by cropping, rotating, and adjusting the brightness and contrast.

*Most Windows Mobile powered Pocket PCs come with a built-in camera, and others have both a camera and video capabilities. However, some do not come with these features.

Pictures and Video

Take a picture

Tips

To delete the picture you’ve just taken, tap Menu > Delete.

To take another picture, tap Camera.


    Save a copy of a picture

    Before you edit a picture, you may want to save a copy of the original.


    Record a video clip

    Tip

    You can record sounds with your video clips. From within Pictures & Videos, simply tap Menu > Options. On the Video tab, select the Include audio when recording video files check box.

     

    Copy a picture or video clip to your device

    You can copy pictures from your PC and view them on your device.

    Tip

    You can also copy pictures from your PC to your device using a memory card. Insert the memory card into the memory card slot on your device and then copy the pictures from your PC to the folder you created on the memory card.


    Edit a picture

    You can rotate, crop, and adjust the brightness and color contrast of your pictures

    Tips

    To undo an edit, tap Menu > Undo.

    To cancel all unsaved edits you made to the picture, tap Revert to Saved.

    View pictures as a slide show

    You can view your pictures as a slide show on your device. Pictures are shown in full screen view with 5-second intervals between slides.

    Tips

    You can specify how pictures are scaled to optimize their display in a slide show. Tap Menu > Options and on the Slide Show tab, tap Portrait Pictures or Landscape pictures.

    Tap anywhere on the screen to display the Slide Show toolbar, which you can use to stop or pause the slide show, rotate the view, and more.

    Press NAVIGATION right or left to move forward or backward through the slides.

    Rename a picture or video clip

    You may find it helpful to rename a picture or video clip with a more meaningful name.

       

    Set a picture as the background

    You can use a picture as the background on the Today screen.

       

    Resize pictures for faster e-mail transfer

    You can make pictures smaller for sending them in e-mail because your mail server or your recipient’s mailbox may have size limitations.

    Note

    Only the picture sent in the e-mail message is resized. The original picture remains unchanged.

    Zoom in and out while viewing a picture

    Zoom in to see a portion of a picture in more detail, and zoom out to see the entire picture again.

    Tip

    To view a portion of the picture that is not visible on the device screen during zooming, simply tap the picture and drag it up, down, or to either side until the portion of the picture you want to see is visible.

    View pictures and launch video clips

    Tip

    To quickly assign a picture to a contact while viewing a picture, tap Menu > Save to contact, tap the name of the contact, and tap OK.

    Manage Pictures and Videos

    Sort pictures and video clips

    If you store a large number of pictures or video clips on your device, you may find it helpful to sort them to quickly find a specific picture or clip. You can sort by name, date, and size.

    Create a new Pictures folder

    You may find it helpful to create your own folders for organizing your pictures.

    Delete a Pictures folder

    You may want to delete a folder that you no longer use.

    Adjust Picture and Video Quality

    Select video quality

    You can specify the quality and size of the video clips you record.

    Note

    Video clips of higher quality require more memory.

      Select picture compression

      You can set the compression level for the pictures you take. Note that selecting a high quality picture increases the size of the file significantly.

      Adjust the brightness for pictures and video clips

      Notes

      The brightness setting is applied when taking pictures or recording video clips.

      The brightness level is also applied to pictures and video clips when they are saved.


      No Comments

      Set up Connections

      October 22nd, 2007 — Uncategorized

      Applies to: Windows Mobile 5.0 Pocket PC

      Make the best use of your Windows Mobile powered device by setting up your data and network connections

      Wireless Service Provider

      Before you begin, you’ll need the name of your wireless service provider and the correct access point.

      Set up a modem connection

      Before you begin, obtain the following information from your Internet service provider (ISP) or wireless service provider: ISP server phone number or access point, user name, and password.

      Notes

      Wireless connections can be made via a mobile phone network or GPRS. If you are using a mobile phone network to connect, in the Select a modem list, tap Cellular Line. If you are using GPRS, tap Cellular Line (GPRS).

      If you are using any type of external modem, in the Select a modem list, select the modem by name. If a listing does not exist for your external modem, tap Hayes Compatible on COM1. If you call from a business complex or hotel that requires a nine before dialing out, enter 9 in front of the phone number. You can also do this using dialing rules or dialing locations.

      If you know that part of the phone number will change frequently as you travel, you can create dialing rules to avoid creating multiple modem connections for the same phone number.

      If you are using GPRS, instead of a telephone number you will need to enter the access point name provided by your wireless service provider.

      Set up a wireless network

       

      Note

      To manually start a connection, tap and hold the connection, and tap Connect.

       

       

       

       

      Edit a Connection

      These directions apply to a device with access to a mobile phone network.

      Tips

      To manually start a connection, tap and hold the connection, and tap Connect. To delete a connection, tap and hold the connection you want to remove, and tap Delete.

      Connect to the Internet

      Before you begin, obtain the following information from your Internet service provider (ISP) or wireless service provider: ISP server phone number or access point, user name, and password.

      Before you begin, obtain the following information from your ISP: ISP server phone number or access point, user name, and password.

      Tips

      To set up a network card or wireless network connection to your ISP, add a new connection in Network Cards. Note that your device may say Wireless Ethernet instead of Network Cards.

      To delete a connection, tap and hold the connection you want to remove, and tap Delete.

      Connect to Work

      Before you begin, obtain the following information from your ISP: ISP server phone number or access point, user name, and password.

      Tip

      To delete a connection, tap and hold the connection you want to remove, and tap Delete.

      End a connection

      It can be useful to end a connection when you are done using it. This frees resources on the device and can save connection charges.

      Connect to intranet URLs

      If you want to connect to intranet sites that have periods in their URLs (for example, intranet.companyname.com), you must add them to the Work URL Exceptions list.

      Tip

      If you use many URLs that share the same root company name, you can avoid entering them individually by entering *.companyname.com.

      Change an intranet URL
       

      Tip

      To delete a work URL exception, tap and hold it in the list, and tap Delete.

      View intranet URLs

      Some companies use periods in their intranet URLs (for example, intranet.companyname.com). If you attempt to connect to one of these URLs, Internet Explorer Mobile will search for the Web site in the Internet rather than the company’s intranet. To connect to such intranet URLs, they need to be entered as Work URL Exceptions.

      To see if your network administrator has already entered your company’s intranet URL, do the following:

      Add a dialing location
       

      Tip

      To change how the number is dialed, tap Dialing Patterns. For example, enter dialing patterns that will set your device to always dial the number as long distance, or to first dial a 9.

      Change dialing patterns

      The following table lists supported dialing patterns for GSM phones.

      To

      Enter

      Dial a country code

      E

      Dial an area code

      F

      Dial a local number

      G

      Make an international call when using a GSM-network mobile phone, the plus sign is used to indicate that you are about to make an international call (rather than entering the international access number for the country you are in)

      + (plus sign)

      Insert a pause (typically 2 seconds)

      , (comma)

      Wait for a credit card tone

      $ (dollar sign)

      Wait for a second tone (typically used after $)

      W

      Tone-dial the numbers that follow

      T

      Pulse-dial the numbers that follow

      P

      Transfer to another extension (0.5 sec on hook, 0.5 sec off hook)

      ! (hookflash)

      Wait for a quiet answer (typically indicated by 6.5 seconds of silence followed by a ring tone)

      @

      Use special controls on some systems (tone only)

      ABCD * #

      CDMA Phones

      To

      Enter

      Dial a country code

      E

      Dial an area code

      F

      Dial a local number

      G

      Insert a pause (typically 2 seconds)

      , (comma)

      Wait for a credit card tone (specified by the dialing program)

      $ (dollar sign)

      Wait for a second tone (typically used after $)

      W

      Tone-dial the numbers that follow

      T

      Pulse-dial the numbers that follow

      P

      Transfer to another extension (0.5 sec on hook, 0.5 sec off hook)

      ! (hookflash)

      Wait for a quiet answer (typically indicated by 6.5 seconds of silence followed by a ring tone)

      @

      Use special controls on some systems (tone only)

      ABCD * #

      Notes
      Hyphens and spaces in dialing strings are ignored. Some modems may not respond to the above characters even though your device lets you add them to the dial string.

      Change general modem options
       

      Change network card settings

      If you use your network card in two locations, such as work and home, you must also change the network to which the network card connects.

      Change server settings

      You should not need to change these settings, unless your server doesn’t use dynamically-assigned IP addresses. Most ISPs and private networks use dynamically-assigned IP addresses.

      Servers that require an assigned IP address may also require a way to map computer names to IP addresses. Your device supports two name resolutions options: DNS and WINS.

      Contact your ISP to determine which name resolution you need to use, obtain the specific server address, and enter the information in the Server tab. Also, ask if alternate addresses are available. An alternate address may enable you to connect when the primary server is unavailable.

      Configure network security settings

      A wireless network can be added either when the network is detected, or manually by entering settings information. Before doing these steps, determine if authentication information is needed.

      Configure 802.1x authentication settings

      Before doing these steps, determine if authentication information is needed.

      Enter new settings

      A wireless network can be added either when the network is detected, or manually by entering settings information.

      Log on to network services

      Before you begin, obtain the following information from your network administrator: user name, password, and domain. Some certificates do not require a password.

      Note

      Certificates already configured for this network should be automatically selected by your device. If a certificate cannot be automatically selected, you will be prompted to select the necessary certificate.

      Configure advanced proxy settings
       

      Select a certificate

      Certificates already configured for this network should be selected automatically by your device. If a certificate cannot be selected automatically, you must select the necessary certificate. For information on the correct certificate to select, see your network administrator.