Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Generate a list of unique entries in an Excel column
- When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done. by Jeff Davis
- Tags: Column, List, Microsoft Excel, Microsoft Office, Office Suites, Software, Jeff Davis
- Blog posts 2008-08-05
- How do I... Reseed a SQL Server identity column?
- Microsoft SQL Server’s identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works. by Susan Harkins
- Tags: Microsoft SQL Server, Server, Column, Value, Identity, Table, Identity Column, Seed Value, Term Seed, TRUNCATE TABLE, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-07-15
- Quickly copy a column and row in Word table
- By holding down the Ctrl key, you can copy a Word table's row or column to create a new row or column. by Susan Harkins
- Tags: Column, Word Table, Microsoft Word, Word Processors, Productivity, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-06-27
- How do I... Identify and delete duplicates from SQL Server tables?
- Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. Your application will probably run, but everything it generates will be suspect. You have to find them and delete them or your client might...
- Tags: Microsoft SQL Server, Server, Column, Record, Table, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Susan Harkins
- Blog posts 2008-06-03
- How to create columns in the middle of a Word document
- Columns, or specifically, newspaper-style columns, are common in newsletters and reports. The good news is that they're easy to implement and you don't have to apply the column format to your entire document; you can columnize any text with just two clicks. In version 2003 and earlier,...
- Tags: Column, Microsoft Word, Word Processors, Corporate Communications, Microsoft Office, Office Suites, Software, Marketing, Susan Harkins
- Blog posts 2008-04-21
- Moving to CSS-based layouts with the YUI Library
- While initiating a recent project to make substantial changes to an existing Web application, it was decided to dump the table-based layout used in its original design in favor of CSS. We opted to use the Yahoo! User Interface YUI Library after evaluating different approaches. The YUI Library provides core...
- Tags: HTML, Menu, Yahoo! Inc., Class, Column, Layout, Yahoo! User Interface Library, Header, Background Color, Yahoo! User Interface Grids CSS, CSS, Scripting Languages, Software/Web Development, Web Development, Tony Patton
- Blog posts 2008-03-17
- Install Windows Server 2008 Features with servermanagercmd
- Although Microsoft continues to expand PowerShell with more capability, the trusty traditional command prompt has not been left behind in Windows Server 2008. In fact, with this latest Windows Server release, the command prompt gains some capability, including a tool that allows administrators to add features to a Windows Server...
- Tags: HTTP, Microsoft Access, Network File System, Network, Microsoft Windows Server, Column, Management Console, Microsoft Windows, Microsoft Windows Server 2008, Servers, Operating Systems, Networking, Software, Hardware, Scott Lowe
- Blog posts 2008-02-24
- How do I... Create and manage PowerPoint table data?
- Tables are great for communicating and organizing data in a meaningful way. They're also efficient. You can substitute several lists with a single table and your viewers will spend less time pursuing a table than several single column lists. In Microsoft PowerPoint, tables can be a bit...
- Tags: Data, Row, Column, Microsoft PowerPoint, Cell, Table, Figure D, Center Tool, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-02-12
- How do I... Display multiple values in an Access value list control?
- The title's a mouthful, but don't get too hung up on the terminology. The technique is simple, although not commonly implemented. You can populate a Microsoft Access list control with an explicit list of values and generally that list consists of one column, although you can display more. Creating a...
- Tags: Technique, Data Source, Microsoft Access, Property, Column, Difference, Form, Title, GetString Method, Susan Sales Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-01-23
- How to sort a single column in Excel without disrupting the rest of the spreadsheet
- We tend to view spreadsheet data as a whole, and that's as it should be. Seldom does a single column of values mean much to us without some related data to define it. Together, seemingly useless values become information. In fact, that's the definition of data and information. Information is...
- Tags: Information, Column, Microsoft Excel, Spreadsheet, Cell, Productivity, Susan Harkins
- Blog posts 2008-01-19
- How to move Outlook’s flag column
- You can rearrange, resize, and even remove all of the columns in Outlook's message list in Mail view -- all except the flag column. Moving that column requires more work: Right-click any field in the message list and choose Customize Current View from the resulting submenu. ...
- Tags: Column, Dialog Box, Microsoft Outlook, Groupware, Microsoft Office, Office Suites, Software, Enterprise Software, Susan Harkins
- Blog posts 2007-10-04
- See SQL Server graphical execution plans in action
- Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to...
- Tags: Query, Microsoft SQL Server, Data, Server, Column, Index, Speed, Table, Execution Plan, SalesHistory, SaleID, SaleDate, PoolTable, Product, Bookmark Lookup, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-01
- 10+ tips for working faster with Word tables
- Word tables have a million handy uses, from organizing tabular data to building an attractive page layout. Unfortunately, they don't always act in predictable ways, and users have to waste time puzzling over dialog box options and toolbar choices. The following list of pointers isn't intended to...
- Tags: Column, Cell, Microsoft Word, Microsoft Office, Office Suites, Software, Jody Gilbert
- Blog posts 2007-09-26
- Format Excel column charts to match data series values
- Let's say that each month you provide your sales team with a column chart that compares year-to-date monthly sales. You want to draw attention to the columns representing the months when the salespeople did not meet their goals. It would be great if you could change the color of those...
- Tags: Column, Microsoft Excel, Mary Ann Richardson
- Blog posts 2007-09-18
- How do I... Even up columns in a Word document?
- Balancing columns in a document is not a monumental task, yet there's a trick to it that few users are aware of. If you find yourself supporting Word users (or simply want to fine-tune your own skills), this is a good technique to know. Learn and share the answer to...
- Tags: TechRepublic Inc., Column, Microsoft Word, Jody Gilbert, screenshots, Word Processors, Microsoft Office, Productivity, Office Suites, Software
- Image galleries 2007-09-10
- How to select blocks of columnar text in Word
- Moving text from one column to another can be frustrating unless you know a trick or two. With tables, the move is easy. For instance, switching the second and third columns in the table below is simple: Select the third column. To do so, position the cursor at the beginning of...
- Tags: Microsoft Word, Column, Susan Harkins
- Blog posts 2007-08-20
- Change Excel 2007 spreadsheets to tables for easier data analysis
- Excel 2007's Format As Table feature can make columns of data easy to read, while providing a set of tools that you can use to perform basic data analysis with a few mouse clicks. For example, say you have collected unit sales for 100 products sold during the last quarter....
- Tags: Data Analysis, Column, Sales, Microsoft Excel, Spreadsheet, Microsoft Excel 2007, Cell, Mary Ann Richardson
- Blog posts 2007-08-07
- Handling NULL values in SQL Server 2005
- In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare...
- Tags: Function, Microsoft SQL Server, Column, Microsoft SQL Server 2005, Value, Tim Chapman
- Blog posts 2007-08-06
- Hide columns in a form using Datasheet view
- A Datasheet form is a form object that resembles a table or query in Datasheet view. The following view is actually a form, not a table or query. You might be surprised to learn that the ApplicationID column’s Visible property is set to No. For most forms, you...
- Tags: Property, Column, Form, Susan Harkins
- Blog posts 2007-08-04
- 10 key enhancements in Excel 2007
- This information is also available as a PDF download.Given the learning hurdle that comes with an entirely revamped albeit improved user interface, Excel 2007 must offer significant enhancements to encourage you to upgrade. Herewith, my top 10.#1: Make the Ribbon work for youThe Office 2007 redesign includes some radical...
- Tags: Microsoft Office, Column, Microsoft Excel, Microsoft Excel 2007, Craig Stinson
- Blog posts 2007-06-07
Smartphones
-
Last year, many businesses deferred the purchase of new laptops in favor of smartphones, and why not? Offering phone, calendar, email, IM and Web access, they’re arguably the most practical business tools. Check out the latest CNET Reviews of Blackberry devices for all the knowledge you need to make an intelligent choice.
- From Our Sponsors
-
Press and be impressed.
-
-
Tap into streaming videos or view files on the go. Feel life with the powerful touch of the BlackBerry® Storm™.
Learn more
-
