Table of Contents
Excel Formula (20)
- Removing Titles from Names and Counting the Number of Words in a Cell
- Extracting First Names, Middle Names, and Last Names in Excel 2007
- Extracting All but the First Word of a String in Excel 2007
- Extracting the First Word and the Last Word of a String
- Determining a Column Letter for a Column Number in Excel 2007
- Expressing a Number as an Ordinal in Excel 2007
- Counting Specific Characters in a Cell and the Occurrences of a Substring, excel 2007
- Searching and Replacing within a String in Excel 2007
- Finding and Searching within a String in Excel 2007
- Replacing Text with Other Text in Excel 2007
- Extracting Characters from a String in Excel 2007
- Edit Excess Spaces, Nonprinting Characters, Case of Text in Excel 2007
- Padding a Number in Excel 2007
- Repeating a Character or String & Text Histogram in excel 2007
- Displaying Formatted Currency Values as Text in Excel 2007
- Displaying Formatted Values as Text
- Determining Whether Two Strings Are Identical
- Working with Character Codes
- Text Functions
- Manipulating Text
Microsoft Access (50)
- Browsing Tables with the Navigation Pane
- Opening a Database Created in an Older Version of Access 2007
- Opening More Than One Database at Once in Access 2007
- Opening a Database in Access 2007
- Saving a Database with a Different Name or Format in Access 2007
- Making Backups in Access 2007
- Saving and Opening Access Databases
- Cut, copy, and paste in Access 2007
- Shortcut keys in Edit tables, Access 2007
- Edit mode in Access 2007
- Editing a Table in Access 2007
- Creating a Simple Table in Access 2007
- Understanding Tables in Access 2007
- Creating a New Database in Acces 2007
- Understanding Access Databases
- Distributing a Report Snapshot in Access 2007
- Creating Mailing Labels in Access 2007
- Creating a Multiple-Column Report in Access 2007
- Starting Report Sections at the Top of a Row or Column in Access 2007
- Preventing Widowed Report Records in Access 2007
- Adding Page Breaks after Report Sections in Access 2007
- Inserting the Current Date in a Report in Access 2007
- Inserting Page Numbers in the Report in Access 2007
- Creating Custom Report Groups in Access 2007
- Creating Calculated Form Controls in Access 2007
- Applying Formatting to Special Form Values in Access 2007
- Creating Shortcut Keys for Form Controls in Access 2007
- Customizing the Form’s Tab Order in Access 2007
- Preventing Changes to the Form’s Data Source in Access 2007
- Using a Toggle Button for a Yes/No Field in Access 2007
- Creating a Switchboard Form in Access 2007
- Automatically Moving to the Last Record When You Open a Form in Access 2007
- Opening a Form Automatically When You Load a Database in Access 2007
- Prompting for Query Criteria in Access 2007
- Calculating Inventory Value in Access 2007
- Calculating Order Totals in Access 2007
- Adding a Custom Calculated Column to a Query in Access 2007
- Selecting the Top Values with a Query in Access 2007
- Finding Duplicate Records with a Query in Access 2007
- Collecting Access Data via E-mail in Access 2007
- Importing Data from an Outlook Folder in Access 2007
- Inserting Hyperlinks into a Table in Access 2007
- Entering a Field at the End for Easier Editing in Access 2007
- Selecting a Field Value from a List in Ms. Access 2007
- Ensuring That No Duplicate Values Display in a Field
- Requiring a Value for a Field in Access 2007
- Setting a Default Value for a Field in MS Access 2007
- Using an Input Mask to Ensure Consistent Data Entry in Access 2007
- Validating Data Entry In Microsoft Access 2007
- Your Workout Journal
Microsoft Excel (80)
- Quick Ways to Add Data in Excel 2007
- Controlling Your Data Types in Excel 2007
- Adding Different Types of Data in Excel 2007
- Plotting a Best-Fit Trendline in Excel 2007
- Creating a Scrolling Chart in Excel 2007
- Charting Small Values with a Bar of Pie Chart in Excel 2007
- Exploding a Slice from a Pie Chart in Excel 2007
- Displaying a Second Vertical Axis in Excel 2007
- Automatically Expanding a Chart to Include New Data in Excel 2007
- Charting a Dynamic Range in Excel 2007
- Stacking a Picture as a Bar Chart Data Marker in Excel 2007
- Plotting the Average on the Value Axis in Excel 2007
- Using Worksheet Text in a Chart in Excel 2007
- Applying Percentile-Based Icon Sets in Excel 2007
- Analyzing Cell Values with Data Bars in Excel 2007
- Highlighting Values Below the Median in Excel 2007
- Highlighting Cells Above or Below a Certain Value in Excel 2007
- Optimizing Profit and Margin in Excel 2007
- Determining the Break-Even Point in Excel 2007
- Plugging Multiple Input Values into a Formula in Excel 2007
- Calculating Multiple Solutions to a Formula in Excel 2007
- Using a Watch Window to Watch a Cell Value in Excel 2007
- Using a Range Snapshot to Watch a Cell Value in Excel 2007
- Using Dialog Box Controls to Input Data in Excel 2007
- Saving All Open Workbooks in Excel 2007
- Selecting the Named Range that Contains the Active Cell in Excel 2007
- Selecting the “Home Cell” on All Worksheets in Excel 2007
- Selecting A1 on All Worksheets in Excel 2007
- Creating a Workbook with a Specified Number of Sheets in Excel 2007
- Creating a Workspace of Workbooks in Excel 2007
- Transposing Range Rows and Columns in Excel 2007
- Automatically Sorting a Range After Data Entry in Excel 2007
- Automatically Sorting a Range After Data Entry in Excel 2007
- Adding a Live Stock Price Quote to a Worksheet in Excel 2007
- Preventing Users from Changing Parts of a Worksheet in Excel 2007
- Sharing a Workbook with Other Users in Excel 2007
- Removing All Comments from a Workbook in Excel 2007
- Keeping Track of Worksheet Changes in Excel 2007
- Annotating a Worksheet with Comments in Excel 2007
- Applying Text or Formatting to Multiple Worksheets in Excel 2007
- Deciding Whether to Buy or Lease in Excel 2007
- Monte Carlo Option Pricing Simulation in Microsoft Excel
- Calculating the Future Value of an Investment in Excel 2007
- Determining How Much You Can Borrow in Excel 2007
- Black-Scholes Option Pricing Calculator in Microsoft Excel
- Calculating the Principal and Interest for a Loan in Excel 2007
- Okumura Hata GSM Link Budget System in Microsoft Excel
- Setting a Product Price Point in Excel 2007
- Determining the Fiscal Quarter in Which a Date Falls in Excel 2007
- Calculating the Number of Weekdays Between Two Dates in Excel 2007
- Calculating Tiered Bonuses in Excel 2007
- Converting Mainframe Dates to Excel Dates in Excel 2007
- Building an Accounts Receivable Aging Worksheet in Excel 2007
- Winery Start-Up Profile and Business Plan Workbook in MS Excel
- Extracting a Person’s First Name or Last Name in Excel 2007
- Removing Unprintable Characters from a Cell in Excel 2007
- Removing Excess Spaces from a Cell in Excel 2007
- Generating Random Numbers to Test Worksheet Models in MS Excel 2007
- Generating Account Numbers in Excel 2007
- Looking Up a Customer Account Number in Excel 2007
- MS Excel 2007: Looking Up a Value in a Discount Rate Schedule
- Allowing Only Certain Values in a Cell
- MS Excel Home Mortgage Refinance Calculator
- Microsoft Excel (XP) Hot Tips (2)
- MS Excel Daily Calorie and Fat Percentage Log Template
- Fitness & Weight Loss Progress Tracking with MS Excel
- MS Excel Template - Customer Profitability Analysis
- The Village - Excel Freak Work of Art
- Your Personal Financial Statement With Excel Template
- Prepare a Projected Balance Sheet with MS Excel Template
- Excel Calculator to Help You Decide Buy or Lease Car
- Calculating Break Even Analysis with MS Excel Template
- Implementing Balanced Scorecard with MS Excel
- MS Excel Hot Tips (Part 1)
- Where are those Office 2003 buttons and commands go?
- SWOT Analysis for Your Business
- Planning Your Loan with MS Excel
- Preparing a Family Budget with MS Excel Template
- Should You Buy or Rent a Home?
- Smart Excel Data Sorting
Microsoft OneNote (1)
Microsoft Outlook (35)
- Working with Another Email Account as a Delegate in Outlook 2007
- Viewing Another User’s Shared Folder in Outlook 2007
- Sharing a Folder with Delegate Access via Microsoft Exchange in Outlook 2007
- Sharing a Folder with Other Users in Outlook 2007
- Printing a Phone Directory of Your Contacts in Outlook 2007
- Displaying a Map for a Contact’s Address in Outlook 2007
- Adding a Contact Picture in Outlook 2007
- Calling a Contact in Outlook 2007
- Editing Multiple Contacts at Once in Outlook 2007
- Color-Coding Appointments Automatically in Outlook 2007
- Customizing the To-Do Bar in Outlook 2007
- Using Natural-Language Dates and Times in Outlook 2007
- Printing a Blank Calendar in Outlook 2007
- Customizing Calendar’s Holidays in Outlook 2007
- Adding Another Time Zone to the Day and Week Views in Outlook 2007
- Customizing the Day View’s Time Scale in Outlook 2007
- Changing the Number of Days That Calendar Displays in Outlook 2007
- Starting Outlook 2007 in the Calendar Folder
- Cutting Your Mailbox Down to Size in Outlook 2007
- Setting Up a Password-Protected Folder in outlook 2007
- Prompting to Save Messages in the Sent Items Folder in Outlook 2007
- Using a Different Outgoing (SMTP) Mail Port in Outlook 2007
- Having Replies Sent to a Different Address in Outlook 2007
- Creating an Email Shortcut for a Recipient in Outlook 2007
- Downloading Mail for a Single Account Using Multiple Computers in Outlook 2007
- Applying Colors to Messages from Specific Senders in Outlook 2007
- Creating Custom Color Categories in Outlook 2007
- Supplementing a Reminder with an Email Message in Outlook 2007
- Setting a Message Follow-Up Reminder in Outlook 2007
- Allowing a Blocked File Type as an Attachment in Outlook 2007
- Avoiding Viruses by Reading Mail in Plain Text in Outlook 2007
- Blocking Foreign or Non-English Messages in Outlook 2007
- Blocking Messages from a Particular Person or Domain in Outlook 2007
- Setting the Junk E-mail Protection Level in MS Outlook 2007
- Customizing the Inbox Message Fields for Outlook 2007
Microsoft Powerpoint (53)
- Copying the Presentation to a CD in Powerpoint 2007
- Enabling Animations on the Web in Powerpoint 2007
- Publishing a Slide Show to the Web in Powerpoint 2007
- Protecting a Presentation by Distributing It as a Slide Show File in Powerpoint 2007
- Linking to the Last Slide Viewed in Powerpoint 2007
- Linking to a Hidden Slide in Powerpoint 2007
- Controlling a Slide Show from the Keyboard in Powerpoint 2007
- Presenting a Slide Show Using Two Monitors in Powerpoint 2007
- Creating a Custom Slide Show in Powerpoint 2007
- Playing CD Tracks During a Slide Show in Powerpoint 2007
- Setting Up an Automatic Slide Show in Powerpoint 2007
- Adding Narration to a Slide Show in Powerpoint 2007
- Calculating the Average Slide Time in Powerpoint 2007
- Assigning Slide Times with a Macro in Powerpoint 2007
- Rehearsing a Slide Show in Powerpoint 2007
- Adding Scrolling Credits in Powerpoint 2007
- Emphasizing the Current Bullet Point in Powerpoint 2007
- Playing a Video to Introduce a Slide in PowerPoint 2007
- Playing a Video to Introduce a Slide in PowerPoint 2007
- Uncovering Parts of an Image, One at a Time in Powerpoint 2007
- Animating Separate Elements of a Clip Art Image in Powerpoint 2007
- Animating an Organization Chart in PowerPoint 2007
- Animating Chart Elements in PowerPoint 2007
- Making Bullets Display Individually in PowerPoint 2007
- Using Triggers to Display and Hide a Slide Object in Powerpoint 2007
- Creating a Custom Animation in Powerpoint 2007
- Applying a Custom Sound to a Transition in Powerpoint 2007
- Using Word to Custom Format Handouts in PowerPoint 2007
- The Open XML Theme Builder for Powerpoint 2007
- Creating a Summary Slide with a Macro in PowerPoint 2007
- Converting a Slide into an Image in PowerPoint 2007
- Maintaining a Slide Library in PowerPoint 2007
- Creating a Custom Blank Presentation in PowerPoint 2007
- Using Multiple Slide Masters in PowerPoint 2007
- The Secrets of the PowerPoint Status Bar - View Switching
- Microsoft Powerpoint Random Questions and Answers
- Applying a Custom Sound to a Transition in Powerpoint 2007
- Multiple Screen/Monitors for Powerpoint Productivity
- Hiding a Slide Master Object on One Slide in PowerPoint 2007
- Creating a Custom Slide Layout in PowerPoint 2007
- Using Drawing Guides to Precisely Align Objects in Powerpoint 2007
- Drawing Shapes at Evenly Spaced Intervals in Powerpoint 2007
- Recoloring a Picture to Match Your Presentation
- Replacing Fonts Throughout a Presentation in Powerpoint 2007
- Creating Custom Bullets in Powerpoint 2007
- Inserting Custom Text into Powerpoint 2007 Slide Footer
- Converting a Word 2007 Outline into a PowerPoint Presentation
- Your Powerpoint Presentation Stucture & Organization
- Using MS Powerpoint 2003 AutoContent
- Powerpoint Slides Design Guidelines
- Putting Those Objects In Order
- Presenting Your Marketing Plan
Microsoft Visio (5)
- Starting Visio 2007 Diagrams by Using Templates
- Visio Cross Functional Flowchart
- MS Visio Template for Web Paper Prototyping
- Web Prototyping with Visio
- Comprehending Your Problem with Fishbone
Microsoft Word (75)
- Creating a Blank File in Word 2007
- Using Multiple Page Number Formats in the Same Document in Word 2007
- Using Continuous Numbers in Two Separate Numbered Lists in Word 2007
- Displaying a Document with a Random Texture Background in Word 2007
- Giving a Document a Parchment Paper Background in Word 2007
- Creating a Custom Watermark in Word 2007
- Creating Jump Text in Word 2007
- Displaying Text in Multiple, Linked Text Boxes in Word 2007
- Updating All Fields Automatically in Word 2007
- Viewing Two Documents Side by Side in Word 2007
- Setting Up a Document for Structured Editing in Word 2007
- Preventing Untracked Changes in Word 2007
- Calculating Billable Time Charges in Word 2007
- Viewing Total Editing Time Updated in Real-Time in Word 2007
- Locking Document Formatting in Word 2007
- Creating a Trusted Location for Documents in Word 2007
- Automatically Prompting for Document Properties in Word 2007
- Creating and Opening Document Workspaces in Word 2007
- Opening the Most Recently Used Document at Startup in Word 2007
- Showing More Items on the Recent Documents List in Word 2007
- Making Backups as You Work in Word 2007
- Closing a Document Without Saving in Word 2007
- Closing All Your Open Documents in Word 2007
- Automatically Saving Your Work Frequently in Word 2007
- Recovering More of Your Work with a Shorter AutoRecover Interval in Word 2007
- Adding a Drop Cap in Word 2007
- Wrapping Text Around an Image in Word 2007
- Ensuring Consistent Document Formatting in Word 2007
- Formatting a Single Column in Tab-Separated Text in Word 2007
- Converting Smart Quotes to Straight Quotes in Word 2007
- Converting Uppercase Words to Another Case in Word 2007
- Creating an Inline Numbered List in Word 2007
- Specifying a Custom Bullet Image in Word 2007
- Applying Formatting from the Keyboard in Word 2007
- Removing Formatting with Precision in Word 2007
- Copying Formatting from One Section to Another in Word 2007
- Changing the Document Map Formatting in Word 2007
- Selecting Text with Similar Formatting in Word 2007
- Setting Up the Quick Style Gallery to Suit the Way You Work in Word 2007
- Quickly Modifying the Normal Style in Word 2007
- Toggling Hidden Codes and Text in Word 2007
- Finding the Longest Sentence in a Document in word 2007
- Creating a Custom Spell Check Dictionary in Word 2007
- Displaying Sentence Word Counts in Word 2007
- Inserting a Hyperlink in a Document in Word 2007
- Adding Dummy Text to a Document in word 2007
- Creating a Dynamic AutoCorrect Entry in Word 2007
- Asking a User for Text Input in Word 2007
- Creating a “Click-and-Type” Text Placeholder in Word 2007
- Saving Boilerplate as an AutoText Building Block in Word 2007
- Using AutoCorrect to Enter Boilerplate Text in MS Word 2007
- Using AutoCorrect to Insert Your Signature in MS Word 2007
- Highlighting All Instances of a Word or Phrase in MS Word 2007
- Summing a Column in a Word 2007 Table
- Word 2007 Guide: Keeping Table Headings in View
- Quickly Create An All-Purpose Calendar In Word
- Microsoft Office Word Hot Tips
- Microsoft Office Word 2008 Review
- Changing Word's 2003 Normal Template Defaults
- Microsoft Word Food Diary
- Invite for Interview & Reject Applicants MS Word Pre-Made Letter
- Plan Your Channel Strategy with MS Word Template
- 9 Free MS Word Template to Make Flyer on Your Own
- Tips on Writing Successful Press Release
- Choosing Fonts for Printed Document and On-Screen Reading
- Make Your Own CD/DVD Labels with MS Word Template
- Designing a Company Web Site with MS Word Template Guide
- Word 2003 Protection Feature
- Reusing Text with the AutoText Feature
- When Your Document is Too Wide to View
- Training Performance Evaluation
- Fast Document Zooming
- Having issues with envelopes, huh?
- Preparing Your Business Plan
MS Office TuneUp (1)
Templates (35)
Tips & Tricks (237)
- Your Working Values: How They Affect Your Career Choice
- Microsoft Office 2008 for Mac Pro-Cons and Review
- Change the Default Open and Save As Folders
- Frog Leap - Just to Kill The Time :-p
- Yes, You MAY Copy Your MS Office on a PC and Laptop at The Same Time
Uncategorized (1)
Simple Archive by Sterling Adventures
Popularity: 3% [?]
Recent Comments