Articles, Tips, Tutorials, and More
This web page is a new addition to our web site. We now offer articles, tips, tutorials, and other valuable information. More tips and tutorials will be added every few weeks, so bookmark us and keep checking back!
Articles
Web Design
The Transition to CSS
"Separating content from presentation" describes an approach to web design in which the markup (HTML or XHTML) of a web page contains the structure and content, but does not define its visual layout or presentation. The presentation of the web page is defined by Cascading Style Sheets (CSS), the most popular language used today by web designers for web page presentation.
Tips
Excel
Prime Time Excel Keyboard Shortcuts
Word
Prime Time Word Keyboard Shortcuts
Tutorials
Excel
How to Print a Multi-page Worksheet without Printing the Header on the First Page
Well, it doesn't seem like a difficult thing to do. You just want to print your multi-page worksheet with headers, but you do not want the header printed on the first page. It's not a problem in Word, but how do you do it in Excel?
How to Record and Run a Macro
The objective of this tutorial is to teach you how to record and run a macro. In Part 1:Introduction to Macros, we record a simple macro to give us an overview of the steps and procedures involved in the creation of a macro. In Part 2: Recording a Macro, we discuss in detail the steps involved in recording a macro. Since you will have already created a simple macro in Part 1, you will be able to more easily understand the concepts involved in recording a macro. In Part 3: Running a Macro, we discuss the various ways you can run a macro.
The Anatomy of An Excel If Statement
The goal of this tutorial is to provide you with a solid understanding of IF Functions. The tutorial is in 4 parts. In Part 1: Introduction to IF Functions you will learn the syntax of an IF function and how it works. In Part 2: Nesting an IF Function, you will learn how to nest an IF function within itself giving you more values that can be returned in the cell containing the function. Part 3: Multiple Nested Conditions and Multiple Return Values in IF Statements teaches you that as many as 7 IF functions can be nested within an IF Function and shows you how to do it. Finally, Part 4: Nesting Another Function Within an IF Function, teaches how other functions can be used in conjunction with IF functions. When you finish this tutorial, you should have a thorough understanding of IF Functions!
Count the Unique Values in a Range Using a Function
Let's say you have a column in one of your worksheets that contain duplicates of several items. How individual items do you have in that column? This tutorial will demonstrate how to count the number of unique values in a range using a function.
Outlook
Add a Profile and an Email Account in Outlook
This tutorial will show you how to add a new profile and an email account using Outlook 2002 or 2003.