Learn How to Combine Two Columns in Excel - Join Two Text Columns with Ampersand (&) Operator
If you have data in two columns that you’d like to combine into one single column in Excel, you can do so by using the ampersand (&) to …
Continue ReadingShowing items from business
Microsoft Excel Help: Count, Average, Etc. Without Using A Formula
You don’t need to construct a formula to determine certain measures, like an average, in Excel. Read on to learn a quicker way.
Continue ReadingMicrosoft Excel Help: How To Isolate Everything Before A Dash In A Column By Using Functions
Problem: A vendor provides an Excel worksheet. As shown in Fig. 268, one field has a manufacturer code, a dash, and a part number. The manufacturer …
Continue ReadingMicrosoft Excel: How to Isolate the Middle Portion of a Cell with MID Function
Problem: Your company assigns an account ID in the format of SSS-XX-YYYY as shown in Fig. 266. You need to isolate the XX portion of the account ID in …
Continue ReadingHistory of RSS Feeds & Who Invented the 0.9, 1.0, and 2.0 RSS Versions
Really Simple Syndication, as RSS is now referred to, lived through a challenging puberty to become an important and valuable resource for people at …
Continue ReadingiPhone and Exchange Server Activesync - iPhone 2.0 Makes Syncing With Microsoft Outlook Possible!
Apple has licensed Microsoft’s ActiveSync protocol and now represents a valid option for corporate mobility solutions. Secure push e-mail and …
Continue ReadingMicrosoft Outlook 2007 Tips: Customization of Message Views, Column Sorting, and Filtering Messages
Outlook allows users to make changes to their message folders to filter content and to best suit their preferences.
Continue ReadingDiscover How To Assign A Formula To A Name With This Excel Tutorial
Problem: You have thousands of identical formulas on 20 worksheets, as shown in Fig. 223. Every time that you want to change the formula, you have to …
Continue ReadingLearn How To Total Without Using A Formula With This Microsoft Excel Tutorial
Need to quickly and easily sum up a total in Excel? With this trick, you don’t even need to enter a formula.
Continue ReadingMicrosoft Outlook 2007 Autocomplete NK2 Nickname Cache: Helpful Shortctus in Outlook
Outlook has a productivity feature which suggests names for the To, Cc, and Bcc fields as you type. This Nickname cache is stored in an NK2 file and …
Continue ReadingThe Best Extensions for Firefox 3 - and one for Firefox 2
Firefox 3 supports extensions, which are features you can add to the browser to make your online sessions faster and more productive. This article …
Continue ReadingBetter Pay Per Click Advertising with Google Keywords and Excel
How do you pick keywords and how can you organize the information in a clear and coherent way? Microsoft Excel can help you.
Continue Reading