Home	Case Studies	MS Office Tips and Tricks	Sample Code	Helpful Videos	Custom Development	Custom Training	Join Us	Contact Us
Search Our Site:

I Get It! Development Newsletters

Microsoft Office Tips And Tricks Database

Do you want to receive the I Get It! Development newsletter?   SUBSCRIBE

October 2009

• Create Dynamically Updated Workbooks, Part 1
• Excel Subtotals Vs Summary Queries

January 2009

• Conditional Formatting and Sorting on Format in Excel 2007
• Use Snagit From TechSmith to capture text out of list- and text-boxes

April 2008

• I Get It! Development on Microsoft Island in Second Life
• Use Data Validation and Comments For Annotating Your Spreadsheets
• Excel To Access Data Import Issues - the Autonumber Data Type

February 2008

• Being Style-ish Part 2: Implementing Word Styles
• Sensitivity Analysis Using Data Tables In Excel
• Consolidate Transactions To Shrink Database Size

October 2007

• Being Style-ish: Why Use Word Styles?
• Combo Boxes in Access: The RowSource
• Excel Text, Date and Logical Functions

August 2007

• Remove Duplicate Rows In Excel
• Keep Title And Data Together In Access Reports
• Format Your Hyperlinks (please!)

June 2007

• Calculated Fields In PivotTables
• Word Hangs Intermittently
• Clean Up Your Outlook Contacts

April 2007

• MailMerge Demystified, Part II
• Compact And Repair Access Databases
• The TEXT Function In Excel

February 2007

• Data Hygiene
• MailMerge Demystified
• Access TextBox Trouble

December 2006

• Absolute vs. Relative References In Excel
• Set Different Page Layouts In The Same Word Document
• Compare Lists

October 2006

• Pimp My Spreadsheet! (with apologies to MTV...)
• Compare Different Versions of Documents
• Uses for the UNION query in Microsoft Access

August 2006

• Sort Columns Versus Order By Property in Access Queries
• Calculating Growth Rates In Excel
• Sneak Preview of Microsoft Office 2007

June 2006

• Multiple Front-ends For Your Database
• Circular References In Excel
• Buried Treasures In Word

April 2006

• Why Use Charts In MS Access?
• The One-To-One Relationship
• Web Queries In Excel, Part II

February 2006

• Who Should You Be Talking To?
• Outlook Add-Ins
• Web Queries In Excel

October 2005

• Multicolumn Sorting In Outlook
• Audit Tools In Excel
• Spreadsheets vs Databases Revisited

August 2005

• Use Functions In Your Access Reports
• Compare Documents Side By Side
• Excel Formulas In 3D

June 2005

• Sarbanes-Oxley: Section 404
• What's Wrong With This Picture? Transactional Data In Excel
• Scrubbing Your Data In Excel

April 2005

• Case Study: The Un-PivotTable

February 2005

• Manage Your Inbox With Colors
• Access Forms In Datasheet View
• Import Problems - Excel To Access

December 2004

• Manage Email With Signatures
• Dynamically Updating Charts In Excel
• Inequality Joins In Access

October 2004

• Data Validation In Excel
• Cross Joins In Access
• Outlook Combinations

August 2004

• Why Use Styles In Word?
• Excel Subtotals (and subtotals (and...

June 2004

• Columns In Access Reports
• Exchange Access And Excel Data

April 2004

• Pattern Matching In Microsoft Office
• Convert Data Types With Text To Columns

February 2004

• Set Control Defaults In MS Access Forms
• Custom Formats in Excel

December 2003

• PivotTables in Excel
• Bound and Unbound Controls in Access
• AutoCorrect Tricks in Word

October 2003

• Using SQL In Access
• Quick Data Type Check In Excel
• Creating Charts Automatically In Excel

August 2003

• Replace Megaformulas with VBA code
• Charts and Statistical Analysis in Excel
• Custom Application Streamlines Billing Process

June 2003

• Excel Paste and Paste Special...
• 'Access'-ing Outlook's Contacts Folder
• Custom Training Means Extra Value

April 2003

• Spreadsheets vs. Databases
• Parameter Queries

February 2003

• Navigating Formula References
• Displaying Formulas
• Custom Toolbar Buttons

December 2002

• AutoFilter In Excel
• Columns In Word

August 2002

• Quick Info—COUNTIF and SUMIF
• Tables Vs. Tabs In Word

June 2002

• Named Ranges In Excel
• Managing Email
• Using SubQueries in Access

April 2002

• Mail Merge For Reports - The Data Source
• Mail Merge For Reports - The Document
• How Many Business Days is That? The NETWORKDAYS Function

February 2002

• Advanced Sorting in Excel
• How Do You Say That?
• Emailing Documents from the Source

December 2001

• Supplementing Spell Checker
• AutoFill And Custom Lists

October 2001

• Excel Tricks
• Outlook Treats
• Dressing Up PowerPoint
• Scary Macro Stories