Compaq iPAQ H3000 manual Pocket Excel

Page 70

Pocket Excel

Pocket Excel works with Microsoft Excel on your computer to give you easy access to copies of your workbooks. You can create new workbooks on your iPAQ H3000, or you can copy workbooks from your computer to your iPAQ H3000. Synchronize workbooks between your computer and your iPAQ H3000 so that you have the most up-to-date con- tent in both locations.

Use Pocket Excel to create workbooks, such as expense reports and mileage logs. To cre-

ate a new file, tap , Programs, Pocket Excel, then New. A blank workbook appears. Or, to select a template for a new workbook, tap Tools, Options, then tap New. The tem- plate you selected appears with appropriate text and formatting already provided. You can open only one workbook at a time; when you open a second workbook, you’ll be asked to save the first. You can save a workbook you create or edit in a variety of formats, includ- ing Pocket Excel (.pxl) and Excel (.xls).

Pocket Excel contains a list of the files stored on your iPAQ H3000. Tap a file in the list to open it. To delete, make copies of, and send files, tap and hold a file in the list. Then select the appropriate action from the pop-up menu.

Pocket Excel provides fundamental spreadsheet tools, such as formulas, functions, sort- ing, and filtering. To display the toolbar, tap View then Toolbar.

Cell contents appear here as you enter them.

Format button

AutoSum button

Zoom button

NOTE: If your workbook contains sensitive information, you can protect it with a password. To do so, open the workbook, tap Edit, then Password. Every time you open the workbook, you will need to enter the password, so choose one that is easy for you to remember but hard for others to guess.

5-6Companion Programs

Image 70
Contents Ipaq H3000 Pocket PC IPAQ H3000 Pocket PC Reference Guide Table of Contents Microsoft ActiveSync Microsoft Pocket Outlook Appendix B Character Recognizer B-1 Appendix C Regulatory Notices C-1 Getting Started WelcomeWhere to Find Information Symbols and Conventions Customer RegistrationHow to Transfer Palm-size PC Data Basic Skills Front Panel ComponentsInformation, see Getting Conected Mation, see Reset the iPAQ H3000 and Clear Bottom Edge ComponentsCradle and AC Adapter Recharging the Battery Power sourceTo add a Compaq iPAQ Expansion Pack Compaq iPAQ Expansion Pack SystemTo view the Expansion Pack properties To remove a Compaq iPAQ Expansion Pack Compaq iPAQ CF Card Expansion PackTo insert a CompactFlash card Guidelines for Using CompactFlash Cards To remove a CompactFlash cardStylus Today Screen Programs Inbox CalendarContacts InfraredNavigation Bar and Command Bar Pop-up Menus NotificationsTyping Using the Input Panel Enter Information on Your iPAQTo use Character Recognizer To type with the soft keyboardTo select typed text To write on the screen Writing on the ScreenTo select writing To convert writing to text Tap Tools then RecognizeOr, tap the word you want to use To create a drawing Drawing on the ScreenTo select a drawing Recording a Message To create a recordingFind Information Adjusting SettingsCustomize Your iPAQ H3000 Tap , Settings, then Password Setting a PasswordCally adjusts the recording volume DescriptionTo add programs Adding or Removing ProgramsTo add a program to the Start menu To remove programs Using File Explorer on your iPAQUsing ActiveSync on the computer Tap Remove Programs on the System tabTo set the power off timer PowerTo display the Power control panel Tap , Settings, System, then PowerAdjusting the Backlight To set the backlight to reverseQStart To adjust the backlight time-outTap , Programs then QStart Task Management QUtilities and QMenuTap , Programs then QMenu File Explorer Self TestTo read the Self Test log file on your computer Tap , Settings, System, then Sounds & Reminders Controlling VolumeContrast Saving Contacts Backup and Restore DataTo perform a backup Backing up Data to a CF CardTo restore a backup onto your iPAQ Pocket PC Tap Restore from CFMicrosoft Activesync 2Microsoft ActiveSync Microsoft Pocket Outlook Calendar Scheduling Appointments and Meetings To create an appointment Using the Summary Screen Creating Meeting Requests To schedule a meetingContacts Tracking Friends and Colleagues Tap to see additional phone num- bers and e-mail addressesTo create a contact 8Microsoft Pocket Outlook Tasks Keeping a To Do List To create a task Microsoft Pocket Outlook 12Microsoft Pocket Outlook To create a note Inbox Sending and Receiving E-mail Messages Connecting Directly to an E-mail ServerSynchronizing E-mail Messages Using the Message List Select the service and folder you want to display16Microsoft Pocket Outlook Composing E-mail Messages To compose an e-mail messageManaging E-mail Messages and Folders Folder behavior with ActiveSyncCompanion Programs Pocket Word2Companion Programs Typing Mode Writing Mode Drawing Mode Recording ModePocket Excel Microsoft Money Tips for Working in Pocket ExcelTo create a new account Getting StartedTo navigate within Microsoft Money Using the Account Register Entering Transactions Entering and Tracking Investments Using Windows Media Manager for Pocket PC Windows Media Player for Pocket PCWhat is Packaged Content? Using the Playlist Manager Microsoft ReaderGetting Books on Your iPAQ H3000 Using the LibraryReading a Book Using Reader Features Removing a Book Installing Pocket StreetsPocket Streets Getting Maps on Your iPAQ H3000Viewing Maps Creating Map and Pushpin Files for Your iPAQ H3000Click Create Map For Pocket Streets on the Tools menu Mobile Favorites Folder Pocket Internet ExplorerFavorite Links To create a mobile favorite Mobile FavoritesTo save iPAQ H3000 memory Channels Using AvantGo ChannelsTo sign up for AvantGo Using Mobile Channels Use Pocket Internet ExplorerTo view mobile favorites and channels To browse the Web AutomaticallyGetting Connected To receive information Transfer Items Using InfraredTo send information Tap , Programs, then Infrared ReceiveTo create a modem connection to an ISP Connect to an ISPTap New connection Connect to Your Network To create a modem connection to a network To create an Ethernet connection to a network End a Connection To set up a e-mail serviceConnect Directly to an E-mail Server Get Help on Connecting Inbox Sending and Receiving E-mail Messages in ChapterReset the iPAQ H3000 and Clear Memory Tips and TroubleshootingResetting the iPAQ Clearing memory Use external power whenever possible Battery Loses PowerShorten auto-suspend time Turn off sounds you don’t need If You Forget Your PasswordIf You Run Out of iPAQ H3000 Memory Turn off notification lightStorage memory Screen is Dark Screen Freezes or Responds SlowlyScreen is Blank Program memoryInaccurate Response to Stylus Taps Infrared IR Connection ProblemsScreen is Hard to Read Slow or No ResponseModem Connection Problems Can’t dial outCan dial out but can’t make a proper connection Connection is unreliableNetwork Connection Problems Cable Connection ProblemsBattery Guidelines Routine MaintenanceRoutine Care International Travel Travel GuidelinesShipping Guidelines Appendix b Character Recognizer2Character Recognizer Character Recognizer 4Character Recognizer Regulatory Notices Regulatory Agency Identification NumbersModifications Federal Communications Commission NoticeCables Avis Canadien Battery WarningCanadian Notice European Union NoticePower Cords Hardware Specifications System SpecificationsPhysical Specifications Operating Environment