microsoft office suite excel tips newsletter News and Other Resources

Articles

Concatenate date cells with text cells in Excel

December 12, 2006 8:00am PST

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

7 Latest comment by tali.tv

Articles

Configure DHCP on a Cisco router or switch

May 5, 2005 7:00am PDT

Many administrators forget—or don't even realize—that they can configure Dynamic Host Configuration Protocol (DHCP) on Cisco IOS routers and switches. David Davis discusses the pros and cons of...

43 Latest comment by thedzaho

Articles

Use Excel to calculate the hours worked for any shift

June 23, 2005 7:00am PDT

With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how.

23 Latest comment by ron4415

Articles

Using NOLOCK and READPAST table hints in SQL Server

May 21, 2007 10:12pm PDT

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server.

23 Latest comment by hamish.holder@...

Articles

Launching remote desktop from the command line in Windows XP Pro

December 13, 2006 8:00am PST

Remote desktop allows you to configure and connect to another computer running Windows XP Pro. Here's what you need to know about the remote desktop connection dialog box, including a few...

23 Latest comment by inspiron80

Articles

Copy an Excel formula without changing its cell references

October 31, 2006 8:00am PST

If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help...

56 Latest comment by f.quintas

Articles

Adjust text to fit within an Excel cell

August 24, 2005 12:30am PDT

Microsoft Excel's AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can't change the size of a cell to fit the text, this...

11 Latest comment by moni123

Articles

Properly set a Cisco router's clock and time zone

October 25, 2006 6:17pm PDT

Does setting the correct time on a router really matter? Actually, it does. In this edition of Cisco Routers and Switches, David Davis reviews the benefits of setting the correct time on your...

13 Latest comment by ciscoman84

Articles

Understand the levels of privilege in the Cisco IOS

April 14, 2005 7:00am PDT

Many network administrators who work with the Cisco IOS never bother to think about the level of privilege they're using or what that level means. However, the Cisco IOS actually offers 16...

8 Latest comment by eventhefield

Articles

Working with the ASP.NET Global.asax file

July 5, 2005 7:00am PDT

The ASP.NET Global.asaz file allows you to implement a variety of tasks, including application security. Find out how may use this file in your application development efforts.

10 Latest comment by hushcat

Articles

Find the top 10 values in an Excel range without sorting

March 21, 2006 8:00am PST

When you want to total the amount of sales from your top 10 performers, you usually would have to sort the data first, then use the SUM function to add up the first 10 values in the sorted range....

19 Latest comment by u4ic

Articles

Create a survey form in Word

May 30, 2006 7:00am PDT

One of the best ways to gauge user responses and collect data is with a survey. In this Word tip, Mary Ann Richardson explains how to create a customized survey form, step by step.

4 Latest comment by mcclassie

Articles

Synchronize a Cisco router's clock with Network Time Protocol (NTP)

May 26, 2005 7:00am PDT

It's critical that all devices on an organization's network display the accurate time and date. If they don't, things can go wrong in a hurry. David Davis explains why Cisco devices need to use...

6 Latest comment by m_ramadan85@...

Articles

Print multiple pages of a Word document on one sheet

May 10, 2005 4:15pm PDT

Find out how you can use Microsoft Word's Zoom feature to print as many as 16 pages on one sheet of paper. This handy tip will help you conserve paper and possibly even save on postage costs.

8 Latest comment by nataliyas

Articles

Use Excel's Autofill to generate a series of dates

January 31, 2006 8:00am PST

Isn't it frustrating to do a task manually in Microsoft Excel when you know there must be a faster and easier method for accomplishing your goal? One Excel feature that will save you time is...

4 Latest comment by LocoLobo

Articles

Displaying money values in currency format in SQL

July 25, 2005 8:51pm PDT

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.

1

Articles

Cisco administration 101: Five interface commands you should know

August 10, 2006 7:29pm PDT

Whether you're a seasoned admin or a newbie, it's always a good idea to review from time to time. When working with routers and switches, you usually don't have to configure an interface using the...

12 Latest comment by Syed Abdul Ali

Articles

Get to know your logging options in the Cisco IOS

June 15, 2006 9:31pm PDT

Knowing how to properly use logging is a necessary skill for any network administrator, and the Cisco IOS offers many options for logging. To help bring you up to speed, David Davis discusses how...

6 Latest comment by Polypeter

Articles

Configure SSH on your Cisco router

September 22, 2005 7:00am PDT

Most IT pros know that using Telnet to manage routers, switches, and firewalls is not exactly a security best practice. Instead, the accepted alternative to Telnet's lack of security is Secure...

11 Latest comment by aw_willis@...

Articles

Windows 101: Know the basics about NTFS permissions

June 15, 2006 9:45pm PDT

NTFS permissions offer a great deal of control when it comes to resources on your systems. When it comes to the old NTFS (from Windows NT) and the current NTFS (from Windows 2000, Windows Server...

1 Latest comment by infinite_pk@...