Tech Update Current Issue

January 2012 Issue - Click to read it now!

2011 Tech Update Tech Tips

January

• Windows: User Defined Keyboard Shortcuts
• Excel's AutoSum Tool
• Word: Building Blocks and Quick Parts Tools

February

• Office 2010: Custom Ribbon
• Excel: Creating Charts
• Outlook: Working with Quick Steps

March

• Windows 7: Explorer Jump List
• Creating Many PivotTables from One
• Excel: Green Light Conditional Format

April

• Using Excel's Fill Justify Tool
• Taking Advantage of the Windows 7 User Experience
• Predicting the Future with Trendlines in Excel

May

• Libraries - One of the Best New Features in Windows 7
• Working with Two QuickBooks Files at the Same Time
• Employing New PivotTable Options in Excel 2010

June

• Applying Conditional Formatting to PivotTables
• Linking Excel Data into Word Documents
• Tracking QuickBooks Inventory in Multiple Warehouses

July

• Restricting Access to an Excel Workbook Using Passwords
• Protecting Specific Cells in an Excel Worksheet
• Preventing Unauthorized Changes to an Excel Workbook

August

• Customizing the Appearance of a Bar Chart
• Creating a Screen Capture on an iPad
• Ranking Data in Excel Without Sorting

September

• Changing How Excel PivotTables Display Subtotals
• Creating a Period Copy of a QuickBooks Data File
• Solving Excel Formatting Problems with Accounting Underlines

October

• Using Excel to Identify Entries that Add to a Specific Value
• Emailing a Single Excel Worksheet
• Creating and Using Custom Styles in Excel

November

• Creating a PDF Portfolio
• Using Two Minus Signs in Excel

December

• Creating a Chart with Two Vertical Axes
• Advanced SUMIF and SUMIFS Formulas
• Creating "Sticky" PivotTable Formatting

Click Here for 2010 Tech Update Tech Tips