KnowledgeWave Blog

Sort by more than one column or row

You may want to sort by more than one column or row when you have data that you want to group by the same value in one column or row, and then sort another column or row within that group of equal values. For example, if you have a Department column and an Employee column, you can first sort by Department (to group all the employees in the same department together), and then sort by name (to put the names in alphabetical order within each department). You can sort by up to 64 columns.

Note: For best results, the range of cells that you sort should have column headings.

1. Select a range of cells with two or more columns of data, or make sure that the active cell is in a table with two or more columns.
2. On the Data tab, in the Sort & Filter group, click Sort.
3. Under Column, in the Sort by box, select the first column that you want to sort.
4. Under Sort On, select the type of sort. Do one of the following:
* To sort by text, number, or date and time, select Values.
* To sort by format, select Cell Color, Font Color, or Cell Icon.
5. Under Order, select how you want to sort. Do one of the following:
* For text values, select A to Z or Z to A.
* For number values, select Smallest to Largest or Largest to Smallest.
* For date or time values, select Oldest to Newest or Newest to Oldest.
* To sort based on a custom list, select Custom List.
6. To add another column to sort by, click Add Level, and then repeat steps three through five.
7. To copy a column to sort by, select the entry and then click Copy Level.
8. To delete a column to sort by, select the entry and then click Delete Level.

Note: You must keep at least one entry in the list.

9. To change the order in which the columns are sorted, select an entry and then click the Up or Down arrow to change the order.  Entries higher in the list are sorted before entries lower in the list.
10. To reapply a sort after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply.

Date(s): September 13-17, 2010
Duration: 5 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to introduce MS50238: Introduction to SQL Server 2008 Administration. This five-day instructor-led course provides students with the knowledge and skills to administer SQL Server 2008.  The course focuses on support tasks, including installation, upgrading, backups, restores, monitoring, and auditing.

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

Objectives:

Module 1: Installing SQL Server 2008
Module 2: Managing SQL Server 2008
Module 3: Database Management
Module 4: Security
Module 5: Disaster Recovery
Module 6: Automation and Maintenance
Module 7: Indexing
Module 8: Monitoring and Performance Tuning
Module 9: Auditing SQL Server 2008
Module 10: Upgrading to SQL Server 2008

KnowledgeWave is pleased to introduce VMware vSphere: Fast Track: the intensive, extended-hours training course focusing on installing, configuring, managing, and troubleshooting VMware® vSphere™. It combines the content of the VMware vSphere 4: Install, Configure, Manage course with advanced tasks and skills for configuring a highly available and scalable virtual infrastructure.  See below for a complete course outline and call us today to reserve your spot - hurry, seating is limited! 800.831.8449.

Date(s): September 20-24, 2010
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

Objectives:

* Install and configure VMware ESX™/ESXi, vCenter™ Server, and the vSphere
* Management Assistant
* Configure, manage, and troubleshoot ESX/ESXi networking and storage
* Create, configure, migrate, manage, convert, and monitor virtual machines and virtual
* appliances
* Scale the vSphere virtual infrastructure
* Implement business continuity solutions
* Manage changes to the vSphere environment

Module 1: Course Introduction
Module 2: Introduction to VMware Virtualization

* Discuss virtualization and vSphere components

Module 3: Configuring VMware ESX/ESXi

* Configure ESX/ESXi settings and view system logs

Module 4: Installing and Using VMware vCenter Server

* Install and configure vCenter Server and vSphere Management Assistant

* Manage vCenter Server inventory hierarchies

Module 5: Networking

* Configure and troubleshoot vNetwork components

Module 6: Storage

* Review storage management technologies

* Analyze and troubleshoot storage-related issues

Module 7: Virtual Machines

* Deploy virtual machines using templates, VMware vCenter Converter, and Guided
* Consolidation
* Modify and manage virtual machines

Module 8: Access Control

* Control user access through roles and permissions

Module 9: Resource Monitoring

* Assess workloads and monitor resources through the GUI interfaces and CLI

Module 10: Scalability

* Scale resource management
* Manage multiple vCenter Server inventories
* Perform VMware VMotion™ migrations
* Configure clusters for VMware Distributed Resource Scheduler and VMware Distributed
* Power Management

Module 11: High Availability and Data Protection

* Review business continuity products and features
* Follow best practices to configure VMware High Availability clusters and VMware Fault
* Tolerance
* Install and configure VMware vCenter Server Heartbeat
* Deploy VMware Data Recovery to back up virtual machines

Module 12: Configuration Management

* Manage change in the vSphere environment with Host Profiles and VMware vCenter
* Update Manager

Module 13: Installing ESX

* Perform manual (ESX/ESXi) and scripted (ESX) installations

Copy Formulas with the Fill Handle

1. Create the formula in the appropriate cell on the spreadsheet.

2. Click on that cell to make it the active cell.

3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.

4. Drag the fill handle to copy the formula to as many cells as needed.

Learn the Essentials in 60 Minutes: A Beginner’s Guide to Using Photoshop

Product(s): Adobe Photoshop
Audience(s): Business Professional.
Date(s): Thursday, August 26, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
In this Webinar, you will get acquainted with the Photoshop environment, and the technical fundamentals of editing bitmap images. We will demonstrate how to determine and modify the dimensions and resolution of source images. We will also demonstrate the use of several basic selection tools (possibly the most important tools in all of Photoshop), and how to use the tools to remove the background of an image.

About the Presenter: Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years.  He has created and delivered multiple “Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer.  He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specialized in classroom instruction as well as and designs and delivers corporate and open enrollment webinars.

To Register: Click Here. Fee: $99.00

Save Time, Work Less: The Power of Using Macros to Complete Repetitive Tasks in Microsoft Word 2007

Product(s): Microsoft Word 2007
Audience(s): Business Professional.
Date(s): Thursday, August 26, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Are you tired of performing the same repetitive steps on document after document? Do you wish Word had an “easy” button? Then macros may be the tool for you. Macros allow users to record a series of actions within Word to be “played back” later. From simple to complex strings, macros help make you a more efficient user. This 60 Minute Webinar will help you save time by automating your tasks.

To Register: Click Here. Fee: $99.00

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.

Add a command to the Quick Access Toolbar

1. On the ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.

Date(s): August 30 - Sept 3, 2010
Duration: 5 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to introduce MS6419 Configuring, Managing and Maintaining Windows Server 2008 Servers. This five-day instructor-led course combines five days worth of instructor-led training content from the Network Infrastructure Technology Specialist, Active Directory Technology Specialist, and IT Professional Server Administrator courses of Windows Server 2008 to provide students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server 2008 environment. This course covers the core skills required by anyone working with Windows Server 2008 Servers.

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

Objectives:

Module 1: Introduction to Managing Microsoft Windows Server 2008 Environment
Module 2: Creating Active Directory Domain Services User and Computer Objects
Module 3: Creating Groups and Organizational Units
Module 4: Managing Access to Resources in Active Directory Domain Services
Module 5: Configuring Active Directory Objects and Trusts
Module 6: Creating and Configuring Group Policy
Module 7: Configuring User and Computer Environments Using Group Policy
Module 8: Implementing Security Using Group Policy
Module 9: Configuring Server Security Compliance
Module 10: Configuring and Managing Storage Technologies
Module 11: Configuring and Managing Distributed File System
Module 12: Configuring Network Access Protection
Module 13: Configuring Availability of Network Resources
Module 14: Monitoring and Maintaining Windows Server 2008 Servers
Module 15: Managing Windows Server 2008 Backup and Restore

Restrict changes in Word 2010

1.  On the Review tab, in the Protect group click Restrict Editing.
2. The Restrict Formatting and Editing pane appears.
3. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs.