Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- How to subtotal Excel lists the easy way
- Lists are new in Excel 2003 and they're great, unless you want to subtotal columns; Excel disables the Subtotal feature for lists. Now, you can keep the list and produce subtotals the hard way. Or you can temporarily convert the list into a conventional range and subtotal the easy way....
- Tags: Spreadsheet, Subtotal, Salesperson, Dialog Box, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-01-25
- Make subtotal values stand out in Excel
- Subtotal stand,outThis does not work for me. I hightlighted data including column header, entered formulas, then summed on one of the columns. It subtotaled and grand totaled but no underlining occurred.
- Tags: drogers@..., excel, hardware, Make, Microsoft Excel, subtotal, underline
- Discussion threads 2006-03-22
Additional Resources
- Anatomy of Excel data analysis: Achieve better information organization with subtotals
- Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within a vast range of skill level and knowledge. This series of Excel tutorials...
- Tags: Data Analysis, Analysis, Microsoft Excel, Microsoft Office, Office Suites, Software
- Download resources 2005-11-21
- Make subtotal values stand out in Excel
- When using Data | Subtotals to summarize data in your Excel worksheets, the more columns there are between the resulting subtotal labels and their values, the harder it is to read the data. Here's a step-by-step process that will make it easier to read the summarized data. Help users...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, grand total, font, Click OK, Microsoft Office Suite Excel Tips Newsletter, Value, Office Suites, Software
- Technical articles 2005-04-06
- EZ-Format for Excel (exe)
- Save time and utilize dozens of features too time consuming and difficult when using only Excel. In seconds turn unformatted data into a feature-rich, printer-ready formatted Excel worksheet. Create subtotals with counts, sums, and Excel formulas on every subtotal row. Subtotals are completely bolded, shaded and display when Excel data...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2008-01-02
- Achieve better information organization with subtotals
- In aprevious article, I went over sorting and filtering information in Excel. These two features help you to better organize yourinformation in a useful way. But, those two features alone can't answer everydata analysis question. Here are some examples: How much have you spent in yourequipment line for the month...
- Tags: category column, Figure B, Microsoft Excel, Scott Lowe MCSE, spreadsheet, Subtotals
- Technical articles 2005-11-21
- ActionXP (zip)
- ActionXP providing wonderful Year/Month/Week/List-Views with tabs to group or filter tasks, Auto-calculate subtotal income/outcome for each group, Gatta chart, and address book. You can change Skin in this version. To present or print the schedule, table, with build-in KeyPoint. Version 5.9 allows to sync calendar data by server.
- Tags: Address Book
- Software downloads 2007-08-30
- Access 2000 Sample: Database of Sample Forms (exe)
- The Access 2000 Database of Sample Forms provides sample user forms that demonstrate how to perform a wide variety of tasks such as bringing a subtotal from a sub form to a form, and how to disable command bar items. This version is the first release on CNET Download.com.
- Tags: Microsoft Access, Microsoft Corp., Form, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware
- Software downloads 2007-09-20
- To insert a row after grouping a column with same contents
- Currently am working on excel sheets in which I have to group a no. of columns which are having the same contents from a sorted list and just after the last column I have to insert a row for the subtotal. Alongwith that I have to insert the no....
- Tags: renjibhat@...
- Discussion threads 2007-11-21
- Aspose.Grid for .NET (msi)
- Aspose.Grid is a .NET component that provides you a total grid solution. It is packaged with two different .NET components to support Desktop and Web applications. Main features include: Importing/exporting to CSV & SpreadSheetML format, Find/Replace feature, Easy to apply skins, Extensive support for Grouping rows & creating subtotal features,...
- Tags: Aspose, Aspose.Grid, .Net, Application Servers, Middleware, Software Development, Software/Web Development, Enterprise Software, Software
- Software downloads 2007-06-18
- 32Printer (zip)
- 32Printer offers MFG/PRO (QAD Inc.) users the easiest and most affordable way to achieve professional results. Do not waste your time with custom Progress programming or with high-end reporting tools, which cost a fortune and take a lifetime to learn. Electronic output (or e-output) for MFG/Pro, 32Printer is an easy-to-use...
- Tags: 32Soft, Microsoft Outlook, Groupware, Microsoft Office, Desktops, Enterprise Software, Office Suites, Software, Hardware
- Software downloads 2006-12-07
- Use error handling to enhance your Excel spreadsheets
- If you're tired of seeing #N/A errors in your spreadsheets, we've got the solution for you. Find out how built-in Excel error-handling functions can hide these errors.In my two previous articles "Use this sample spreadsheet to make the most of Data Validation drop-down lists" and "See how our sample spreadsheet...
- Tags: Bob Johnson, Excel spreadsheet, cell, Vlookup, ISNA
- Technical articles 2001-04-02
- Anatomy of Excel data analysis: Restructure worksheet information with PivotTables
- Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within a vast range of skill level and knowledge. This series of Excel tutorials...
- Tags: Data Analysis, Analysis, Microsoft Excel, Microsoft Office, Office Suites, Software
- Download resources 2005-11-29
- Building cross-tab queries using Access
- Despite SQL Server's stability, performance, and range of tools, no facility is provided for building cross-tab queries. Check out how Arthur Fuller uses Microsoft Access to make up for SQL's lack of a cross-tab wizard. Cross-tab queries are an extremely common requirement in database applications. Given SQL Server's...
- Tags: Microsoft Access, Databases, Arthur Fuller, Sales strategy, Sales force management, cross-tab query, sales, SQL Server Newsletter, TechRepublic Inc., Database, Column, Microsoft Office, Enterprise Software, Software, Data Management, Office Suites
- Technical articles 2005-05-23
- EZ-Stat for Excel (exe)
- EZ-Stat instantly calculates up to 29 commonly used Excel Formulas. Calculations are independent of the original data's formatting. Select from Sum, Count, Average, Mean, Min, Max, Range, Rank, Stdev and 20 additional Excel formulas. Only the selected formulas are automatically calculated for the selected numeric fields. Calculations use the data...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2008-01-02
- Use an array to add time components in Excel
- I recently acquired a worksheet with time components entered separately. I have no idea why they did this, as doing so seems inefficient and unnecessary to me. Just the same, I had to work with it. The first problem was getting Excel to recognize integer values as...
- Tags: Formula, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-05-26
- 10 tips for sorting, grouping, and summarizing SQL data
- This article is also available as a PDF download.Arranging data in a manner that'smeaningful can be a challenge. Sometimes all you need is a simple sort. Often,you need more--you need groups you can analyze and summarize. Fortunately, SQLoffers a number of clauses and operators for sorting, grouping, andsummarizing. The following...
- Tags: clause, Group-By, SELECT ZIP, SQL, Susan Harkins, ZIP
- Technical articles 2006-11-06
- DigDB for Excel (zip)
- Use this Excel add-in to remove duplicates. Remove by list matching or key fields; do Access-like query, aggregation, join; simplify pivot table with a roll-up that outputs in simple list; enhance pivoting and subtotal to aggregate in 21 statistical functions such as median and count of unique values. Use this...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-01-09
- Quickly sort and total your data with Excel's Data-Subtotals
- If your end users are looking for a fast, easy way to sort and subtotal their Excel data, the Data-Subtotals menu can help. In this article, Mary Ann Richardson offers a quick lesson on how to use this handy tool.When I decided to hire a couple of part-timers to help...
- Tags: Mary Ann Richardson, database, Microsoft Excel, Data-Subtotals, Data-Subtotals menu, Using Data-Subtotals
- Technical articles 2001-06-06
- EZ-Deluxe for Excel (exe)
- EZ-Deluxe combines EZ-Total, EZ-Chart, EZ-Pivot and EZ-Calc into one economical solution for the ad-hoc formatting of data. Quickly create better formatted printer-ready Worksheets, Subtotals, Charts, PivotTables and Drills. Create eight types of calculated fields including accounting type 'Date Agings'. Use automatically created and applied Styles. For any field view the...
- Tags: Field, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-04-05
- << Previous
- page 1 of 1
- Next >>
Harnessing the power of waves
Planting solar gardens
Fill your car for $1.10 a gallon?