Create a formula in a PivotTable report

NOTE: You cannot create formulas in a PivotTable report that is connected to an OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.) data source.

1. Decide whether you want a calculated field or a calculated item within a field.
* Use a calculated field when you want to use the data from another field in your formula.
* Use a calculated item when you want your formula to use data from one or more specific items (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field “Month” could have items such as “January,” “February,” and so on.) within a field.
2. Do one of the following.

Add a calculated field
1. Click the PivotTable report.
2. On the Options tab, in the Tools group, click Formulas, and then click Calculated Field.
3. In the Name box, type a name for the field.
4. In the Formula box, enter the formula for the field.

To use the data from another field in the formula, click the field in the Fields box, and then click Insert Field. For example, to calculate a 15% commission on each value in the Sales field, you could enter = Sales * 15%.
5. Click Add.

Add a calculated item to a field
1. If items in the field are grouped, on the Options tab, in the Group group, click Ungroup.
2. Click the field where you want to add the calculated item.
3. On the Options tab, in the Tools group, click Formulas, and then click Calculated Item.
4. In the Name box, type a name for the calculated item.
5. In the Formula box, enter the formula for the item.

To use the data from an item in the formula, click the item in the Items list, and then click Insert Item (the item must be from the same field as the calculated item).
6. Click Add.
7. If you ungrouped items in step 1, regroup them if you want. For more information, see Group items in a PivotTable field

For calculated items, you can enter different formulas cell by cell.

For example, if a calculated item named OrangeCounty has a formula of =Oranges * .25 across all months, you can change the formula to =Oranges *.5 for June, July, and August.

Do the following:

1. Click a cell for which you want to change the formula.

To change the formula for several cells, hold down CTRL and click the additional cells.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), type the changes to the formula.

If you have multiple calculated items or formulas, adjust the order of calculation by doing the following:

1. Click the PivotTable report.
2. On the Options tab, in the Tools group, click Formulas, and then click Solve Order.
3. Click a formula, and then click Move Up or Move Down.
4. Continue until the formulas are in the order that you want them to be calculated.

Microsoft PowerPoint 2007: Inserting, playing, and modifying movies

Sometimes the best way to ensure that your audience understands your message is to show a video or animation, collectively referred to in PowerPoint as movies. For example, if your company has developed a short advertising video, it makes more sense to include the video in a presentation about marketing plans than to try and describe it with bullet points or even still pictures. You can insert the following types of movies in slides:

* Video clips. You can insert a digital video file in one of two ways: If a slide’s layout includes a content placeholder, you can click the Insert Movie button in the placeholder. You can also click the Movie button in the Media Clips group on the Insert tab. Either way, the Insert Movie dialog box opens so that you can select the file. Before PowerPoint inserts the file, you specify whether the video should play automatically when the slide containing it appears or whether you will start the video manually.
* Animated clips. PowerPoint comes with several animated graphics. You insert these animated objects by clicking the Movie arrow in the Media Clips group on the Insert tab, and then clicking Movie From Clip Organizer to display the Clip Art task pane, where you can select the clip you want. If you are connected to the Internet, clicking the Clip Art On Office Online link in the task pane takes you to the Office Online Clip Art and Media Web site, from which you can download hundreds of clip art images, photos, sounds, and animated clips.

Videos and animated clips both appear on the slide as objects represented by icons that you can size and move to meet your needs. When you select an animated clip object, PowerPoint adds a Format contextual tab to the Ribbon so that you can adjust the way it looks on the slide. When you select a movie object, PowerPoint also adds an Options contextual tab so that you can adjust the object’s size and position, its volume, how it is displayed on the slide, and how it is activated.

In Normal view, you can preview a video by double-clicking its icon or by clicking the Preview button in the Play group on the Options contextual tab. You can preview the action of an animated clip by clicking the arrow that appears when you select it in the Clip Art task pane and then clicking Preview/Properties. In Slide Show view, a video plays either automatically or when you click its icon, depending on your specifications, whereas an animated clip always plays automatically.

Date(s): March 1-5, 2010
Duration: 5 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to introduce MS6231: Maintaining a Microsoft SQL Server 2008 Database.  This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. Hurry, seating is limited! 800.831.8449.

Location: 30 Community Drive, Suite 5, South Burlington VT 05403
To register: Click here or call 800.831.8449

Objectives:

Module 1: Installing and Configuring SQL Server
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning

Use Outlook with Comcast e-mail
(applies to Microsoft Office Outlook 2002 and 2003)

You can use Outlook with your Comcast e-mail account. The following steps will set up Outlook to both receive and send e-mail messages with your Comcast account.

Note:  You can receive your Comcast e-mail messages by using Outlook from most places with an Internet connection. Comcast provides you access to an authenticated SMTP server — allowing you to send e-mail messages using Outlook from your Comcast account when you are using another Internet service, such as at your office or when traveling.

Add your Comcast Email account:

1. On the Tools menu, click E-mail Accounts.
2. Select Add a new e-mail account, and then click Next.
3. Select POP3, and then click Next.
4. Under User Information, do the following:
***In the Your Name box, type your full name the way you want it to appear to other people.
***In the E-mail Address box, type your e-mail user name followed by @comcast.net.
5. Under Server Information, do the following:
***In the Incoming mail server (POP3) box, type mail.comcast.net.
***In the Outgoing mail server (SMTP) box, type smtp.comcast.net.
6. Under Logon Information, do the following:
***In the User Name box, type your user name provided by Comcast.
***In the Password box, type your password.
***Select the Remember password check box.
Note  You have the option to have Outlook remember your password by typing it in the Password box and selecting the Remember password check box. Having Outlook remember your password means that you won’t have to type your password each time you access the account; however, it also means that the account is vulnerable to anyone who has access to your computer. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don’t have to write it down.
7. To verify that your account is working, click Test Account Settings. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it. Make sure your computer is connected to the Internet.
8. Click More Settings.
9. On the General tab, under Mail Account, type Comcast.
Note  If you are attempting to send and receive Comcast e-mail messages from a location where you are not directly connected to Comcast, such as at work or when travelling, see the Notes section for additional steps.
10. Click OK, and then click Next.
11. Click Finish.

Notes
* Do not select the Log on using Secure Password Authentication (SPA) check box.
* Unless specified by Comcast, all server and address entries are typed in lowercase letters.
* To send and receive e-mail messages with your Comcast account when you are not directly connected to the Comcast service, such as at work or when travelling, you must use the following:
***After step 9 above, click the Outgoing Server tab, and then select the My outgoing server (SMTP) requires authentication check box.
***Select Use same settings as my incoming mail server.
***Continue with step 10 above.

Microsoft Excel – Cleaning up Excel Data

Product(s): Microsoft Office Excel (all versions).
Audience(s): Business Professional.
Date(s): Friday, December 18, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:

These days, Excel users are doing less data entry and a lot more downloading data from other sources. Whether that data is coming from Access, some other data base software, or a poorly designed Excel worksheet, it isn’t always in the best of shape.
Excel has a variety of functions, commands, and techniques that let you quickly re-structure data, remove unwanted characters, get rid of empty cells, rows, and columns, and prepare data for efficient analysis. This webinar will use Excel 2007, but will demonstrate techniques in Excel 2003 for those features that have been altered.

What you will learn:

The Text to Columns command
* A powerful, yet simple command sequence that lets you quickly split data (improperly grouped into one column) into multiple columns; includes techniques for handling Julian dates another unusual groupings.

How to transpose data
* a simple copy technique to convert data from a row/column into a column/row layout.
How to remove duplicate data
* Use either Excel’s new 2007 command (Remove Duplicates) or the Advanced Filter in Excel 2003 to eliminate duplicate records.

The Find/Replace command sequence, including using special wild cards.

Critical Text functions
* (LEFT, RIGHT, and MID) for character extraction; REPLACE and SUBSTITUTE for character swapping; CLEAN and TRIM functions to remove unwanted characters; PROPER and UPPER for quick uppercase/lowercase conversion.

Concatenation techniques for pulling together data from different locations

Sorting techniques to eliminate blank rows or columns from data

Techniques for learning how to:
* Convert text data to values
* Remove trailing minus signs while converting data into negative values
* Fill in missing title data from columns containing first entries only
* Alter any kind of date data into a more useful computational form

To Register: Click Here.  Fee: $99.00

KnowledgeWave is pleased to introduce MS6421: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure. This five-day course provides students with the knowledge and skills to configure and troubleshoot a Windows Sever 2008 network infrastructure. Students will learn to implement and configure secure network access and implement fault tolerant storage technologies. Students will gain an understanding of the network technologies most commonly used with Windows Server 2008 and IP-enabled networks. Students will also learn how to secure servers and maintain update compliance.

Click here for a complete course outline and call us today to reserve your spot – hurry, seating is limited! 800.831.8449.

Date(s): November 30 – December 4, 2009
Duration: 5 days
Format: Instructor-led, Classroom training
Location: 30 Community Drive, Suite 5, South Burlington VT 05403
To register: Click here or call 800.831.8449.

Quoted from http://blogs.msdn.com/sharepoint/archive/2009/10/19/sharepoint-2010.aspx:

Microsoft SharePoint Team Blog : SharePoint 2010

SharePoint 2010

This is my third and final post as part of our disclosure of SharePoint 2010 today. The previous posts covered the SharePoint History and how we Engineer SharePoint. This morning, Steve Ballmer and I are kicking off the SharePoint Conference so it is time to talk about SharePoint 2010! It is incredibly fun and rewarding to unveil this release driven input from you and innovative ideas from the team. As Steve announced, we will release the Beta of Office 2010 and SharePoint 2010 in November and look forward to your feedback as we finalization the product and documentation for release in the first half of next year.

Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas

SharePoint is a broad solution so we often get asked how we would describe it in a sentence. For SharePoint 2010, we settled on “The Business Collaboration Platform for the Enterprise and the Web”. A few words are worth explaining. We decided “Collaboration” was broad enough to cover the spectrum of publishing, sharing, finding, analyzing and managing information that SharePoint enables. We chose “Platform” not only because custom solutions are a major focus of the 2010 release but also “platform” conveyed a solid base for all the out-of-box usage that never requires a developer. Finally, we want to call out “the Web” to highlight both internet scenarios reaching customers and partners and the cloud-based delivery of SharePoint Online. For SharePoint 2007, we used a pie diagram chart to describe the major SharePoint categories such as “Enterprise Content Management”. This release, we picked words we thought were both simpler and gave us more freedom to innovate beyond traditional category boundaries. We settled on Sites, Communities, Content, Search, Insights and Composites as the new category names. Within each of these plus Administration and Development, I will highlight 5 major feature areas for a total of 40. At the next level down are hundreds of exciting new features which will be covered on www.microsoft.com\sharepoint and subsequent posts from the team. Needless to say, this is the biggest release of SharePoint yet and we hope you find it as exciting as we do!

Read More: http://blogs.msdn.com/sharepoint/archive/2009/10/19/sharepoint-2010.aspx

Making Headlines with PowerPoint: A Beginners Guide to Learning the Power of Visual Presentations using Microsoft PowerPoint 2007

Date(s): Wednesday, September 23, 2009
Time: 11:00AM (EST) U.S.
Duration: 60 minutes 

Description: You’ve been asked to put together a presentation using PowerPoint, and you have no idea how to begin. Get equipped with the skills to do the job. We’re not talking fancy; the goal is to prepare you with the basics, how to put content on slides and get ready to present a show. The bells and whistles can come later.

Click here to register. Fee: $79.00.

Our friends at the VTDONET Users Group are hosting the first Vermont Code Camp!

This event is being held Sept 12, 2009 at UVM.

This event is for developers and it’s completly free! A light breakfast and lunch will provided.  They will also have books, software licenses and other swag to give away throughout the day.

There will be 3 rooms and 6 time slots with a bonus session as well in a separate room. A total of 19 sessions throughout the day! 2/3 of the sessions are on .NET, the rest are Ruby, PHP, Django, Joomla and more.

This event is free but you must register:

To get additional information and to register visit: http://www.vtdotnet.org/codecamp/

KnowledgeWave to host an AUTHORIZED Cisco SNAF course (Securing Networks with ASA Fundamentals) v1.0. KnowledgeWave is pleased to announce that we are hosting the certified course on the latest Cisco Security Apliance – SNAF.

The SNAF course is a five-day, leader-led, lab-intensive course. The course takes a task-oriented approach to teaching the skills to configure, operate, and manage Cisco Adaptive Security Appliance product family.  SNAF v1.0 is an update to Securing Networks with PIX and ASA (SNPA) v5.0.  Complete Cisco Outline

This class is scheduled for May 18-22, 2009.

Please contact KnowledgeWave to register or for additional details and pricing.

800-831-8449