Accounting Class Extra Credit
AccountingWEB articles
- My Quixotic Pursuit of Microsoft Excel for the Android Platform
- Use Excel to File Your 2014 Form 1040 and Related Schedules
- How You Can Determine The First Sunday in a Month in Excel
- Mastering the Conversion of Minutes to Hours/Minutes in Excel
- Freezing a Middle Row in Excel While Scrolling Above
- Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF
- Timesaving File Menu Tricks in Excel 2010-2013
- Microsoft Adds Key Features to Excel for iPad
- When Excel Dates Mysteriously Shift by 4 Years
- Exploring the Nuances of Excel's SUM Function
- Maximizing Excel's Alt-Down Arrow Keyboard Shortcut
- Embed Frequently Used Lists into Excel
- Why Solid State Drives are Worth the Extra Cost
- Creating an Equivalent to the MAXIF Function
- Hackers have Discovered a Way into the Internet Explorer
- My First Impressions of Excel for iPad
- You Want to Use Sparklines, but they Seem to Be Disabled
- Getting Excel to Handle Social Security Numbers Properly
- The Indispensable NCAA Bracket Tool: Excel
- Part 2 of Identifying Duplicate Values in an Excel List.
- Techniques for When Excel Worksheet Tabs Go Missing
- Many Ways to Use Excel's Name Box
- How to Improve Spreadsheet Integrity with VLOOKUP
- How to Resolve Duplicate Data within Excel Pivot Tables
- Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year
- The Curious Case of Strikethrough in Word and Excel
- How to Conditionally Display Decimal Places in Excel: Part 2
- How to Conditionally Display Decimal Places in Excel: Part 1
- Reinstalling Microsoft Office When You Don't Have a Disc or Download
- How to Restore “Shrink One Page” in Word 2010 and 2013
- How to Create a “Chainsaw” List of Excel Worksheet Functions
- How to Speed Up Microsoft Excel's Help Window
- Maximizing Excel's Recent Items Menu
- Converting a Digital Photo into an Excel Spreadsheet
- How to Automate Text File Links in Microsoft Excel
- How to Eliminate a Common Spreadsheet Design Flaw
- Three Ways to Convert Text-Based Numbers to Values
- Automating Data Validation Lists in Excel
- Improving the Integrity of Excel's SUM Function
- Microsoft's Chip In Program Offers Crowdfunded Laptops to Students
- Resolving #VALUE! Errors in Microsoft Excel
- Overcome a Nuance of Excel's Subtotal Feature
- Farewell, Lotus 1-2-3
- Excel Tip: Determining the Remaining Length of a Loan Using NPER
- The End Is Near for Windows XP
- Excel Tip: Use Conditional Formatting to Identify Unlocked Cells
- Resetting the Last Cell in an Excel Worksheet
- Sticker Shock Awaits Sage 50/Peachtree Payroll Service Users
- Determining Worksheet Cell Protection at a Glance
- Creating a Series of Letters in Excel
- Microsoft Excel: Inserting Rows and Columns with Ease
- Recovering Unsaved Excel Workbooks
- How to Disable Worksheet Animation in Excel 2013
- Restoring Classic Print Preview in Excel 2010/2013
- Part 1 on Identifying Duplicate Values in an Excel List
- Microsoft Office 2013 Officially Released
- Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year
- Three Ways to Fill Blank Cells within Excel Spreadsheets
- Homeland Security Warns of Java Vulnerability
- Hide and Unhide Multiple Excel Worksheets with Ease
- Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014
- Utilizing Excel's COUNTIF Function to Break Ties
- Identifying Largest and Smallest Values in an Excel List
- First Impressions of Windows 8
- Microsoft Excel: Use Color to Identify Variances
- Microsoft Outlook: Disabling the Send without a Location Prompt
- Managing Protected View in Excel 2010/2013
- Automating Excel Spreadsheet Report Titles
- Trapping Errors within Excel Formulas
- Microsoft Office 2013 Crosses RTM Threshold
- Little Known Techniques for Opening Excel Files
- Microsoft Reveals New Office 2013 Pricing Scheme
- Transposing Data in Excel Worksheets
- Microsoft Excel: Taking the Pain Out of Freezing Panes
- Yes, Microsoft Excel Is Talking to You
- Microsoft to Fully Embrace Open Document Standards
- Excel Tip: Calculating Interest
- Managing Excel Add-ins
- First Thoughts on Excel 2013
- First Look at Excel 2013
- Is This Excel Worksheet Protected?
- Excel Speed Tips: Do You Know the Tricks?
- Using Clip Art in Excel Charts
- Automating Chart Titles
- Excel Tip: Using Today() versus NOW()
- Excel Tip: Pasting Text into Excel 2010
- Excel Tip: Data Entry Shortcut
- Excel Tip: Automatic Backup of Key Excel Workbooks
- Automating Excel Charts in Two Keystrokes
- Business vs. Personal: How to Selectively Share on Facebook
- Farewell Peachtree Accounting, Hello Sage 50
- Microsoft Excel: Thirteen Double-Click Tricks
- Improve Your Excel Skills with this Free Excel Training
- Excel Tip: Calculating Straight-Line Depreciation
- Cloud Computing Versus Software as a Service
- Excel Tip: Text Centering Trick
- What Version of Excel is on Your Desktop?
- Excel Tip: Text Boxes
- Seven Quick Excel Tips
- Quick Steps to Take in Advance of Google's Privacy Policy Changes
- Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year
- Excel Tip: Table Feature Enables Effective Analysis
- On the Horizon: A New Version of Microsoft Office
- Deloitte Buys Boutique Mobile App Firm
- Intuit's New QuickBooks Online Accountant Brings the Cloud – and Its Benefits – to Accountants
- 5 Things CPAs Should Know about Excel Macros
- Excel Tip: Multiple criteria SUM, MIN, and MAX formulas
- Stealth price increase awaits QuickBooks 2008 users
- Business vs. personal: Controlling what people see on your Facebook pages
- Separating business from pleasure on Facebook
- Two things you can’t avoid: Apps and taxes
- Free spreadsheet-based Form 1040 available for 2010 tax year
- Time for Smaller Companies to Learn XBRL
- BlackBerry productivity apps for accountants
- iPhone, Android productivity apps for accountants
- Microsoft celebrates 25 years of Excel
- Beyond VLOOKUP: Mastering Advanced Excel Formulas
- Under the Radar Part 1: Five new features in Excel 2010
- Under the Radar Part 2: Five new features in Excel 2010
- Excel 2010 Tips and Tricks: Part 1
- Excel 2010 Tips and Tricks: Part 2
- Microsoft Office moves into the Cloud
- UPDATE: BlackBerry PlayBook means business
- New spam attack attempts to disable security software
- The Making of a Great Webcast Speaker
- Start-up company aims to simplify small business cash flow management
- What to do when Excel won't let you insert columns
- Office 2010 has arrived! Customize your ribbon!
- Two ways to determine your top customers in QuickBooks, Excel
- Transform multiple-line cell contents into columns in Excel
- Some unlikely uses for Excel's SUMPRODUCT function
- What's the FREQUENCY? Using Excel's FREQUENCY function
- Excel Tip: Converting numbers formatted as <1> to -1
- Office 2007 Themes standardize document look, feel
- Understanding the Undo option in Excel
- Excel Tip: Hide an Excel Worksheet in Plain Sight
- Three tricks for formatting rows in Excel
- First Impressions of Excel 2010
- Whither Conficker?
- Tricks for hiding and unhiding Excel rows and columns
- Tricks for opening and closing multiple Excel files
- Buried gold: Excel's Form command
- Managing Excel Add-Ins
- Three Excel menus you may have overlooked
- Introducing the AccountingWEBinar Series
- Provisioning your home accounting office
- Add contacts or meetings to Contact Manager or CRM with two keystrokes
- Free Microsoft Excel-based 1040 form available
- Excel text transformation tricks
- Excel 2007: Five ways to streamline Excel’s user interface
- Excel 2003: Six ways to streamline Excel's user interface
- AccountingWEB Webinar: Creating error proof spreadsheets
- Excel 2007: Use these three techniques to turbo charge filtering
- Excel 2003: Use These Three Techniques to Turbocharge Filtering
- QuickBooks 2009 Splashes on the Scene with Plenty of New Features
- Excel Chart Advisor Prototype Simplifies Graphs
- Tips for improving your Microsoft Office Accounting experience
Chatham County
DDE
- Extracting Inventory Items
- Improved Password Security
- Password Protection Reminder
- Transaction Data from other Periods
- Extracting Inventory Items
- Inventory Items and DDE
- Keep It Simple!
- Best Place to Start
- Troubleshooting DDE
- Sales Tax Authority Must be Manually Edited
- Launching Peachtree
- Launching and Poking
- Determining the Short ID for a Company
- More DDE Info
- Clear and Save
- Using Data in an Array
- Extracting Sales Rep ID from the Sales Journal
- Purchase Order Not Exposed
- Poking Dates into Peachtree
Excel
- My Quixotic Pursuit of Microsoft Excel for the Android Platform
- Use Excel to File Your 2014 Form 1040 and Related Schedules
- How You Can Determine The First Sunday in a Month in Excel
- Mastering the Conversion of Minutes to Hours/Minutes in Excel
- Freezing a Middle Row in Excel While Scrolling Above
- Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF
- Timesaving File Menu Tricks in Excel 2010-2013
- Microsoft Adds Key Features to Excel for iPad
- When Excel Dates Mysteriously Shift by 4 Years
- Exploring the Nuances of Excel's SUM Function
- Maximizing Excel's Alt-Down Arrow Keyboard Shortcut
- Embed Frequently Used Lists into Excel
- Creating an Equivalent to the MAXIF Function
- You Want to Use Sparklines, but they Seem to Be Disabled
- Excel-lent April Fool's Day Pranks
- Getting Excel to Handle Social Security Numbers Properly
- CSV Secrets: QuickBooks Reports to Excel
- Use Excel Your Way – Part 1
- Merging QuickBook Reports Using Excel VLOOKUP
- Become a Master of Excel From the Master of Excel
- The Indispensable NCAA Bracket Tool: Excel
- Part 2 of Identifying Duplicate Values in an Excel List.
- Techniques for When Excel Worksheet Tabs Go Missing
- Many Ways to Use Excel's Name Box
- How to Conditionally Display Decimal Places in Excel: Part 2
- How to Conditionally Display Decimal Places in Excel: Part 1
- Convert .snag files to .jpg
- How to Create a “Chainsaw” List of Excel Worksheet Functions
- Build a Dynamic Income Tax Calculator – Part 2 of 2
- Build a Dynamic Income Tax Calculator – Part 1 of 2
- How to Speed Up Microsoft Excel's Help Window
- Maximizing Excel's Recent Items Menu
- Converting a Digital Photo into an Excel Spreadsheet
- How to Automate Text File Links in Microsoft Excel
- How to Eliminate a Common Spreadsheet Design Flaw
- Three Ways to Convert Text-Based Numbers to Values
- Automating Data Validation Lists in Excel
- Improving the Integrity of Excel's SUM Function
- Resolving #VALUE! Errors in Microsoft Excel
- Overcome a Nuance of Excel's Subtotal Feature
- Excel Tip: Determining the Remaining Length of a Loan Using NPER
- Excel Tip: Use Conditional Formatting to Identify Unlocked Cells
- Resetting the Last Cell in an Excel Worksheet
- Determining Worksheet Cell Protection at a Glance
- Creating a Series of Letters in Excel
- Microsoft Excel: Inserting Rows and Columns with Ease
- Recovering Unsaved Excel Workbooks
- How to Disable Worksheet Animation in Excel 2013
- Restoring Classic Print Preview in Excel 2010/2013
- Part 1 on Identifying Duplicate Values in an Excel List
- Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year
- Three Ways to Fill Blank Cells within Excel Spreadsheets
- Write to CSV file
- Hide and Unhide Multiple Excel Worksheets with Ease
- Verifying Dates within Excel UserForms
- Utilizing Excel's COUNTIF Function to Break Ties
- Identifying Largest and Smallest Values in an Excel List
- Microsoft Excel: Use Color to Identify Variances
- Managing Protected View in Excel 2010/2013
- Building an Amortization Table in Microsoft Excel
- Automating Excel Spreadsheet Report Titles
- Trapping Errors within Excel Formulas
- Little Known Techniques for Opening Excel Files
- Transposing Data in Excel Worksheets
- Microsoft Excel: Taking the Pain Out of Freezing Panes
- Yes, Microsoft Excel Is Talking to You
- Excel Tip: Calculating Interest
- Managing Excel Add-ins
- First Thoughts on Excel 2013
- First Look at Excel 2013
- Is This Excel Worksheet Protected?
- Excel Speed Tips: Do You Know the Tricks?
- Using Clip Art in Excel Charts
- Setting Excel Version
- Automating Chart Titles
- Excel Tip: Using Today() versus NOW()
- Excel Tip: Pasting Text into Excel 2010
- Excel Tip: Data Entry Shortcut
- Excel Tip: Automatic Backup of Key Excel Workbooks
- Disabling Excel's Zoom Slider
- Automating Excel Charts in Two Keystrokes
- Microsoft Excel: Thirteen Double-Click Tricks
- Improve Your Excel Skills with this Free Excel Training
- Excel Tip: Calculating Straight-Line Depreciation
- Excel Tip: Text Centering Trick
- Searching and Replacing Wildcard Characters
- Remove All Page Breaks from a Worksheet
- You Can't have a History
- Freeze Panes
- Close Multiple Excel Files at Once
- Calculation Secrets
- Moving Rows
- Looking for more help with formulas?
- Subtotal Function
- Circular References
- Formula Arguments
- Hiding Formulas
- Array Formulas
- Dynamic Ranges
- Analysis ToolPak
- Use the Fill Handle to Copy Formulas
- Save Your Workspace
- See Two Sheets within a Workbook Simultaneously
- Math Tricks with Paste Special
- Cell Comments
- Split Screen Worksheet View
- Formatting Text Within a Cell
- Navigating Between Worksheets
- Create a Link that is a Picture
- Simplify Your Summary Page Formulas
- Formatting Every Other Row
- Transposing Formulas
- Sheet Name Formula
- Sorting By Column
- Excel Tip: Right-Drag Tricks
- Dragging Between Sheets or Windows
- Data Validation
- Calculating Part of a Formula
- Combining Multiple Sheets into One Printed Page
- Show Path and File Name on Printouts
- Displaying File Name and Path
- Eradicating Links – Part III
- Eradicating Links – Part II
- Eradicating Links – Part I
- Selecting Data
- Determining the Number of Months Between Two Dates
- Quickly Copy Data Down a Column
- Excel Programming Reference Book
- Navigating Multi-Sheet Workbooks Quickly
- Excel Shortcut Keys
- Excel Formula Debugging Trick
- Automated tasks in Excel
- Hidden Sheets Within a Workbook
- Problems with the VBE Properties Window
- Need to Determine the Last Day of a Month in VBA?
- Color Chart
- Working Around Outlook E-mail Security
- Replacing Non-Printable Characters
- Creating a Header and Footer
- Using Excel to Process Data to be Imported into a Contact Manager
- Copying Data from a Column or Row to Another
- Fix Corruption of Excel's Name Space
- Recover Password Protected Documents
- Reading a Lotus 1-2-3 Spreadsheet in Excel
- Optimizing Excel Spreadsheet Calculations
- Rounding Numbers to the Nearest 1000
- Displaying the Name of a Month
- Look Ma, No Mouse!
- Rounding Numbers To Nearest Multiple
- What Version of Excel is on Your Desktop?
- Excel Tip: Text Boxes
- Seven Quick Excel Tips
- Converting Dates In YYYY/MM/DD Format
- Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year
- Excel Tip: Table Feature Enables Effective Analysis
- Instant Amortization Table
- Excel 2010 Filtering Trick
- Spanning Excel Across Multiple Monitors
- Print Scale Trick
- Managing The Recent Files Menu
- Unscrollable Worksheets
- Table Feature
- 5 Things CPAs Should Know about Excel Macros
- Recovering Unsaved Workbooks
- Format Painter Trick
- TODAY() Versus NOW()
- Converting Text To Numbers
- Excel Tip: Multiple criteria SUM, MIN, and MAX formulas
- Rounding Tricks
- Free Clipart For Excel
- Free spreadsheet-based Form 1040 available for 2010 tax year
- Best Format For Clipart
- Time for Smaller Companies to Learn XBRL
- Microsoft celebrates 25 years of Excel
- Beyond VLOOKUP: Mastering Advanced Excel Formulas
- VLOOKUP tips
- Under the Radar Part 1: Five new features in Excel 2010
- Under the Radar Part 2: Five new features in Excel 2010
- Excel 2010 Tips and Tricks: Part 1
- Excel 2010 Tips and Tricks: Part 2
- Five More Under the Radar Features in Excel 2010
- Five Under the Radar Features in Excel 2010
- N() Function
- Moving Columns Trick
- Undo Comparision
- What to do when Excel won't let you insert columns
- Two ways to determine your top customers in QuickBooks, Excel
- Transform multiple-line cell contents into columns in Excel
- Some unlikely uses for Excel's SUMPRODUCT function
- What's the FREQUENCY? Using Excel's FREQUENCY function
- Excel Tip: Converting numbers formatted as <1> to -1
- Understanding the Undo option in Excel
- Trick For Hiding Rows
- Navigation Menu Trick
- Update Multiple Cells At Once
- Excel Tip: Hide an Excel Worksheet in Plain Sight
- Copying Cell Contents Down
- AND() Function
- Concatenation Trick
- Formatting Sets Of Rows
- Three tricks for formatting rows in Excel
- Create A Series Of Month End Dates
- Number Formatting Trick
- Removing Borders Trick
- Data Entry Trick
- Hiding/Unhiding Columns
- Resetting Excel 2003 Color Palette
- First Impressions of Excel 2010
- Workbook/Worksheet Navigation Tricks
- Date Series Formula
- IFERROR Function
- Creating A Series Of Letters
- Formula Bar Navigation Trick
- Adding/Removing Columns/Rows
- Cell Border Trick
- Tricks for hiding and unhiding Excel rows and columns
- Tricks for opening and closing multiple Excel files
- Buried gold: Excel's Form command
- Managing Excel Add-Ins
- Three Excel menus you may have overlooked
- Free Microsoft Excel-based 1040 form available
- Excel text transformation tricks
- Excel 2007: Five ways to streamline Excel’s user interface
- Excel 2003: Six ways to streamline Excel's user interface
- AccountingWEB Webinar: Creating error proof spreadsheets
- Excel 2007: Use these three techniques to turbo charge filtering
- Excel 2003: Use These Three Techniques to Turbocharge Filtering
- Excel Chart Advisor Prototype Simplifies Graphs
- AccountingWEB Excel articles
- My Quixotic Pursuit of Microsoft Excel for the Android Platform
- Use Excel to File Your 2014 Form 1040 and Related Schedules
- How You Can Determine The First Sunday in a Month in Excel
- Mastering the Conversion of Minutes to Hours/Minutes in Excel
- Freezing a Middle Row in Excel While Scrolling Above
- Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF
- Timesaving File Menu Tricks in Excel 2010-2013
- Microsoft Adds Key Features to Excel for iPad
- When Excel Dates Mysteriously Shift by 4 Years
- Exploring the Nuances of Excel's SUM Function
- Maximizing Excel's Alt-Down Arrow Keyboard Shortcut
- Embed Frequently Used Lists into Excel
- Creating an Equivalent to the MAXIF Function
- My First Impressions of Excel for iPad
- You Want to Use Sparklines, but they Seem to Be Disabled
- The Indispensable NCAA Bracket Tool: Excel
- Part 2 of Identifying Duplicate Values in an Excel List.
- Techniques for When Excel Worksheet Tabs Go Missing
- Many Ways to Use Excel's Name Box
- How to Improve Spreadsheet Integrity with VLOOKUP
- How to Resolve Duplicate Data within Excel Pivot Tables
- Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year
- The Curious Case of Strikethrough in Word and Excel
- How to Conditionally Display Decimal Places in Excel: Part 2
- How to Conditionally Display Decimal Places in Excel: Part 1
- Maximizing Excel's Recent Items Menu
- Converting a Digital Photo into an Excel Spreadsheet
- How to Automate Text File Links in Microsoft Excel
- How to Eliminate a Common Spreadsheet Design Flaw
- Three Ways to Convert Text-Based Numbers to Values
- Automating Data Validation Lists in Excel
- Improving the Integrity of Excel's SUM Function
- Resolving #VALUE! Errors in Microsoft Excel
- Overcome a Nuance of Excel's Subtotal Feature
- Excel Tip: Determining the Remaining Length of a Loan Using NPER
- Excel Tip: Use Conditional Formatting to Identify Unlocked Cells
- Resetting the Last Cell in an Excel Worksheet
- Determining Worksheet Cell Protection at a Glance
- Creating a Series of Letters in Excel
- Microsoft Excel: Inserting Rows and Columns with Ease
- Recovering Unsaved Excel Workbooks
- How to Disable Worksheet Animation in Excel 2013
- Restoring Classic Print Preview in Excel 2010/2013
- Part 1 on Identifying Duplicate Values in an Excel List
- Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year
- Three Ways to Fill Blank Cells within Excel Spreadsheets
- Hide and Unhide Multiple Excel Worksheets with Ease
- Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014
- Utilizing Excel's COUNTIF Function to Break Ties
- Identifying Largest and Smallest Values in an Excel List
- Microsoft Excel: Use Color to Identify Variances
- Managing Protected View in Excel 2010/2013
- Automating Excel Spreadsheet Report Titles
- Trapping Errors within Excel Formulas
- Little Known Techniques for Opening Excel Files
- Transposing Data in Excel Worksheets
- Microsoft Excel: Taking the Pain Out of Freezing Panes
- Yes, Microsoft Excel Is Talking to You
- Excel Tip: Calculating Interest
- Managing Excel Add-ins
- First Thoughts on Excel 2013
- First Look at Excel 2013
- Is This Excel Worksheet Protected?
- Excel Speed Tips: Do You Know the Tricks?
- Using Clip Art in Excel Charts
- Automating Chart Titles
- Excel Tip: Using Today() versus NOW()
- Excel Tip: Pasting Text into Excel 2010
- Excel Tip: Data Entry Shortcut
- Excel Tip: Automatic Backup of Key Excel Workbooks
- Automating Excel Charts in Two Keystrokes
- Microsoft Excel: Thirteen Double-Click Tricks
- Improve Your Excel Skills with this Free Excel Training
- Excel Tip: Calculating Straight-Line Depreciation
- Excel Tip: Text Centering Trick
- What Version of Excel is on Your Desktop?
- Excel Tip: Text Boxes
- Seven Quick Excel Tips
- Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year
- Excel Tip: Table Feature Enables Effective Analysis
- 5 Things CPAs Should Know about Excel Macros
- Excel Tip: Multiple criteria SUM, MIN, and MAX formulas
- Free spreadsheet-based Form 1040 available for 2010 tax year
- Time for Smaller Companies to Learn XBRL
- Microsoft celebrates 25 years of Excel
- Beyond VLOOKUP: Mastering Advanced Excel Formulas
- Under the Radar Part 1: Five new features in Excel 2010
- Under the Radar Part 2: Five new features in Excel 2010
- Excel 2010 Tips and Tricks: Part 1
- Excel 2010 Tips and Tricks: Part 2
- What to do when Excel won't let you insert columns
- Two ways to determine your top customers in QuickBooks, Excel
- Transform multiple-line cell contents into columns in Excel
- Some unlikely uses for Excel's SUMPRODUCT function
- What's the FREQUENCY? Using Excel's FREQUENCY function
- Excel Tip: Converting numbers formatted as <1> to -1
- Understanding the Undo option in Excel
- Excel Tip: Hide an Excel Worksheet in Plain Sight
- Three tricks for formatting rows in Excel
- First Impressions of Excel 2010
- Tricks for hiding and unhiding Excel rows and columns
- Tricks for opening and closing multiple Excel files
- Buried gold: Excel's Form command
- Managing Excel Add-Ins
- Three Excel menus you may have overlooked
- Free Microsoft Excel-based 1040 form available
- Excel text transformation tricks
- Excel 2007: Five ways to streamline Excel’s user interface
- Excel 2003: Six ways to streamline Excel's user interface
- AccountingWEB Webinar: Creating error proof spreadsheets
- Excel 2007: Use these three techniques to turbo charge filtering
- Excel 2003: Use These Three Techniques to Turbocharge Filtering
- Excel Chart Advisor Prototype Simplifies Graphs
Going Concern Articles
- Use Excel to Keep an Eye on Your BMI This Busy Season
- How to Convert Spreadsheets to PDF With the Push of Button
- Excel Can Help You Choose Where to Get a Meaty Lunch
- Hasten Your Departure with Pre-written Resignation Letter
- Excel-lent April Fool's Day Pranks
- Use Excel Your Way – Part 1
- Become a Master of Excel From the Master of Excel
Microsoft Office
- Reinstalling Microsoft Office When You Don't Have a Disc or Download
- How to Restore “Shrink One Page” in Word 2010 and 2013
Outlook
Peachtree/Sage 50
- Sticker Shock Awaits Sage 50/Peachtree Payroll Service Users
- Sage 50/Peachtree Software Updates
- Quickly e-mail invoices
- Default Customer Credit Limit
- Bank Reconciliation Find Button
- Customize your Aged Receivables Report
- PeaTransaction Date Trap
- Aged Receivables/Payables Report Date
- Printing Shortcut
- Use a Network Switch instead of a Hub
- Additional State Withholdings for Employees
- Input Shortcut
- Controlling Spell Check Options
- How to Close Your Fiscal Year While Preserving Prior Year Data
- Using Templates to Print a Custom Form (Part 2 of 2)
- Using Templates (Part 1 of 2)
- Collection and Payment Managers
- Aging Schedule Doesn't Foot with GL?
- Back-up Frequently
- Posting Transactions to a Previous Month
- Peachtree Training
- Counting List Items
- Quickly E-mail Reports
- Easier Date Input
- Add List Items Faster
- Faster Finds
- Eliminate the Startup Screen
- Printing Accounts Payable Checks
- Eliminating Zeros From Your Income Statement
- State Payroll Tax Withholding
- Peachtree Performance
- Updating Peachtree
- PeaPeachtree Add-Ons
- PeaPeriod Changed to ## Due to Unposted Entries
- Peachtree Software Product Support
- Direct Deposit
- Year-end Closing in Peachtree
- Peachtree Data Checker
Quickbooks
- CSV Secrets: QuickBooks Reports to Excel
- Merging QuickBook Reports Using Excel VLOOKUP
- The Quickbooks Consultant's Reference Guide
- Need Help?
- Extracting Data from QuickBooks
Recommended Books
- Step by Step
- Spreadsheet Check and Control
- Excel Pivot Tables and Pivot Charts Books
- The Quickbooks Consultant's Reference Guide
- SQL All-in-One for Dummies
- John Walkenbach’s Favorite Excel Tips & Tricks
- Excel Programming Weekend Crash Course
- Excel VBA Programming for Dummies
- XML for Dummies
- XBRL for Dummies
- Excel Data Analysis For Dummies
- Microsoft Office Excel 2010: Data Analysis and Business Modeling
- Excel 2010 Data Analysis
- Spreadsheets Check and Control
- Access Step By Step Book
- Excel Formulas
- Excel Programming Reference Book
Resources
Sleeter Articles
- Analyze QuickBooks Data with Excel Pivot Tables
- QuickBooks Statement Writer vs. Excel FSM
- Troubleshooting When Excel Goes Awry
- Charting QuickBooks Data
- Backing Up and Restoring Excel Workbooks
- Automating an Excel-Based Financial Statement
- Use Excel Pivot Tables to Analyze QuickBooks Data
- Make QuickBooks Data Analysis More Simple in Excel
- CSV Secrets: QuickBooks Reports to Excel
- Merging QuickBook Reports Using Excel VLOOKUP
- Microsoft Excel Text Extraction Techniques
testing
Uncategorized
- Excel Charts Books
- Build a Dynamic Income Tax Calculator – Part 2 of 2
- Build a Dynamic Income Tax Calculator – Part 1 of 2
- How to Speed Up Microsoft Excel's Help Window
- New Features in Excel 2013
- Using Collections in Excel to populate UserForm Controls