Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Restructure Excel worksheet information for better analysis with PivotTables
- Atsome point in your Excel work, you'll probably come across a spreadsheet thatyou wish was formatted a little differently. In this series, you've learned about reformatting your spreadsheetto look different and have learned how to handle data presentation issuesthrough the use of subtotals and sorting. But, what about the actual...
- Tags: PivotTable, Scott Lowe MCSE, Microsoft Excel, analysis
- Technical articles 2005-11-29
- Restructure Excel worksheet information for better analysis with PivotTables
- Pivot TablesThe downloadable version of this article is available here:http://techrepublic.com.com/5138-10877-5975482.htmlDo you take advantage of the Excel PivotTable functions or are you too intimidated to even try it?This topic came from a reader suggestionOne thing I love about writing for TechRepublic is the reader focus, and the flexibility my editors provide...
- Tags: analysis, data analysis, excel anatomy, hardware, Mark W. Kaelin, pivottables, scott lowe
- Discussion threads 2005-11-29
Additional Resources
- Excel Hacks: Hacking PivotTables
- PivotTables are one of Excel's most powerful attractions, though many people don't know what they do. PivotTables display and extract a variety of information from a table of data that resides within either Microsoft Excel or another compatible database type. PivotTables are frequently used to extract statistical information from raw...
- Tags: Hacking, O'Reilly Media Inc., Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2007-06-01
- 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
- EZ-Pivot for Excel (exe)
- Create formatted printer-ready PivotTables, PivotCharts and Drill worksheets in seconds. Because EZ-Pivot uses an automatic copy of the data, you never have to modify the original data's format. This also allows EZ-Pivot to work with subtotaled and filtered data. Easily modify EZ-Pivot's pre-defined colors, fonts and alignments for PivotTable Regions,...
- Tags: Column, EZ-Pivot, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-11-16
- 10 key enhancements in Excel 2007
- Getting used to Excel 2007's new interface might require some time and patience, but given the number of enhancements and expanded capabilities, it may pay off.Excel expert Craig Stinson runs through some of the most significant additions, including styles for formatting tables, charts, and PivotTables, improved conditional formatting, superior charting...
- Tags: Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software
- Download resources 2007-06-07
- Lunch and Learn: Microsoft Excel 2007, advanced functionality
- This Lunch and Learn presentation is a preformatted solution for training staff to maximize Excel's more advanced functions. The accompanying quick reference guide provides a single document end users can keep at their desks as a handy reference guide to the material reviewed in this presentation. The presentation covers such...
- Tags: Microsoft Corp., Training, Microsoft Excel 2007, Presentation, Microsoft Excel, Workforce Management, Microsoft Office, Office Suites, Software, Human Resources
- Download resources 2007-10-25
- Using PivotTables and PivotCharts in Microsoft Access 2002
- This webcast will present an overview of how to use the basic feature set of the PivotTable and PivotChart features in Microsoft Access 2002. Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. One can now perform data analysis and build rich...
- Tags: Microsoft Office, Databases, Microsoft Access 2002, Microsoft Access, data analysis, Microsoft Corp., Webcast
- Webcasts 2006-10-20
- Sur La Table: Creating Microsoft Excel PivotTables in a Jiffy From SAS Data
- Creating good looking Excel Pivot Tables to hold an individual's nicely summarized SAS data can be surprisingly labor intensive. This paper presents a technique and macro that combine Base SAS with Visual Basic Scripting to make possible to fully automate the creation of custom formatted Excel Pivot Tables from SAS...
- Tags: SAS Institute, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software
- White papers 2006-02-28
- AutoFormat for Excel PivotTables (zip)
- This Excel add-in that allows you to save pivot table formatting and to use it as a format template for your other pivot tables. The add-in remembers formatting of each pivot table area including page, row, column, and data fields and stores all format options such as number format, borders,...
- Tags: Add-in Express, Add-in, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2008-07-07
- Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to consider the end-user experience in Office Excel 2007 while designing cubes. This paper outlines how to make the end-user experience great...
- Tags: Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Analysis, Microsoft Excel 2007, Microsoft Office Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software
- White papers 2007-04-01
- Microsoft Office System Webcast: Advanced Tips and Tricks for Excel Charting: Financial Pitch Books Made Simple (Level 300)
- If there is logic to it, Microsoft Office Excel can do it, especially when it comes to charting. This webcast explains tips and techniques for the things one might not know Excel charts can do, from fine-tuning data labels to combining chart types. The webcast looks at advanced chart types...
- Tags: Financial, Webcast, Books, Microsoft Corp., Microsoft Excel, Microsoft Office, Productivity, Digital Media, Office Suites, Software, Consumer Electronics, Personal Technology
- Webcasts
- MSDN Webcast: Building Business Intelligence Solutions Using Excel 2007 and SQL Server 2005 Analysis Services (Level 200)
- This webcast shows how to use Microsoft Office Excel 2007 and Microsoft SQL Server 2005 Analysis Services to build end-to-end Business Intelligence BI solutions. The webcast shows how to create an Analysis Services 2005 Unified Dimensional Model UDM that can be consumed by Excel 2007, and demonstrates how to use...
- Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Analysis, Microsoft Excel 2007, Pricing, Business Intelligence, Tools & Techniques, Microsoft Excel, Microsoft Office, Databases, Enterprise Software, Digital Media, Marketing, Software, Data Management, Management, Office Suites, Consumer Electronics, Personal Technology
- Webcasts
- Xcelerator for Excel (exe)
- Completely automate Excel formatting utilizing every major Excel feature. In seconds automatically transform unformatted data into a formatted workbook. Automatically change field descriptions, add calculated fields, re-order and hide columns, sort, create better formatted subtotals, apply Styles and Conditional Formats, create Charts, PivotTables, PivotCharts and formatted Drill worksheets ... Format...
- Tags: Xcelerator, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-06-10
- 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
- EZ-Calc for Excel (exe)
- Quickly create Excel formulas and eight custom fields in totaled and subtotaled data. In seconds and without knowing Excel formulas create fields too time consuming and too complicated to manually create. Fields include: Date Agings, Reformatted Dates, Running Total, Percent of Total, Extracted Text, Conditional Negative, and Calendar Date to...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-04-05
- Anatomy of Excel: Sorting and filtering
- Ifyou've used Excel at all in the past, you've seen the millions ofsquare boxescellsall over the screen. These cells make up the rows andcolumns in an Excel workbook. In all recent versions of Excel, each sheet inyour workbook can contain up to 65,536 rows of information. Imagine looking forspecific information,...
- Tags: Microsoft Excel, Scott Lowe MCSE, spreadsheet
- Technical articles 2005-11-03
- Use Excel to create simple graphs and bring your point home
- Youknow the saying: "A picture is worth a thousand words." In mostcases, an appropriate pictorial representationâ"akagraphsâ"of data can be even more valuable than the actual data since it can helpa manager spot trends that might otherwise go unnoticed. As such, graphs can goa long way toward helping a business make...
- Tags: graph
- Technical articles 2005-12-06
- Microsoft's business intelligence strategy is a work in progress
- By Bill Hostmann and Kevin H. StrangeMicrosoft’s SQL Server and related business intelligence BI products are rated “promising” by Gartner because they provide a cost-effective, integrated set of BI tools and technology on Windows. However, enterprises must recognize their limitations.Microsoft's BI investments and productsMicrosoft has made significant investments in several...
- Tags: business intelligence, business intelligence product, Data Transformation Services, Gartner , Microsoft Analysis Services, Microsoft Corp., Microsoft SQL Server, server
- Technical articles 2003-08-21
- 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
- << Previous
- page 1 of 1
- Next >>
