First in a series of newsletter articles, begin building your understanding of how QuickBooks reports through our Make sense of your Reports using expand & collapse features in QuickBooks and Auto Outlining in excel. Reports that contain MANY Subaccounts or Classes become very cumbersome to read. By clicking on the collapse button at the top of your report (on the report button bar), QuickBooks will display only the totals of the subaccounts ( under the parent ) Example of Before and after If you want more control over what will get collapsed you can export into excel the expanded report by clicking on the export button on the QuickBooks Button Bar. Next click Advanced and select 'auto outline' (see screenshot below). When you click the Export button, the QuickBooks report will open in Excel with the outlining tool in the left margin By clicking on the Plus's and minus's excel will collapse the data into one row total. In the example below, Income, Car/Truck Expenses, and Insurance have all been collapsed into one row totals yet we choose to leave Job labor costs and the subaccounts detailed on the report. If when you export to Excel you DO NOT receive the auto outlining tool, you need to turn on the feature in Excel.

Can't change row height in standard Gantt Chart This is driving me crazy. All I want is for the rows to do a word wrap or to be able to adjust the row height by dragging so I can read the entire Task Name. I can do this dragging in the detailed Gantt Chart, but NOT in the 'standard' Gantt Chart.

Leawo is such kind of PowerPoint to audio converter which could help you not only convert PowerPoint to MP3, but also PowerPoint to AAC, AC3, AIFF, WMA, WAV, M4A, etc. However, if you received this PowerPoint file from others and want to save the audio file separately, this guide will tell you how to extract audio out of PowerPoint files and convert PowerPoint to MP3. Audio doesn't transfer when exporting video from powerpoint for mac. Unlike inserted pictures, you can simply click “Save as Picture” and extract them out.

Tools Menu > Options > View > Check the box for Outline symbols. In the event you still are having trouble displaying this awesome tool, simply, while the report is displayed in Excel 'Click Control + 8': Set up your customized groups- You organize your filing cabinets for easy access of your business records.

Use the same concept to set up the reports you use frequently. Quickbooks predefines up to 7 reports group headings and each group heading contains up to 9 reports.

All of these reports are also available in the reports menu. Keep the memorized reports for those which you use regularly or have customized to your needs. The memorized reports list includes predefined group names and reports. The identical reports are available from the reports menu under the headings, company & financial, Customers & Receivables, Vendors & Payables, etc. If you would prefer to see only those reports that you have modified in your memorized reports list. Set up your own group names that have meaning to you.

Then add to these memorized reports the customized reports you find useful to run your business. These steps will delete all the default memorized reports, and then delete the memorized group names to be replaced with the set of folders that work best for you to manage your business. One caveat: if you use the QuickBooks navigators, and regularly run reports from the navigator window, do not delete the group names or reports, instead simply add the new group names with a prefix of AA so your reports and report groups appear at the top of the list. Backup your company file and do not reuse this backup disk. >(next) The Reports menu > Memorized Reports List > Memorized Reports window.

The group names are in bold font, non-bold names are reports. Highlight a report name that you have not used or customized to your needs. Delete this report using Control key + D All the reports provided by QuickBooks under the memorized reports menu option are also available under the reports menu. Deleting from the memorized report list does not delete it from the reports menu. Any report from the reports menu may be re-memorized.

Repeat this process for all the reports that do not fit your needs. Delete group names you will not be using. To delete, highlight then Ctrl + D. Add group names that have meaning to you. Whenever you spend a few minutes customizing a default report, memorize it for reuse under these new group names. From the menu bar on the lower left select 'memorized report'. Select 'new group'.