Computer Training & Support

We will open the world of knowledge for you!

Support & Quick Tips

Quick Tip May Support/FAQ
Create an Organizational Chart in Excel, Word, Outlook or PowerPoint

An organization chart graphically represents the management structure of an organization, such as department managers and non-management employees within a company. By using a SmartArt graphic in Excel, Outlook, PowerPoint, or Word, you can create an organization chart and include it in your worksheet, e-mail message, presentation, or document. To create an organization chart quickly and easily, you can type or paste text in your organization chart and then have the text automatically positioned and arranged for you.

 

Read More Icon

Quick Tip April
VLookup Function in Excel You can use the VLOOKUP

function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. The VLOOKUP function syntax:
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

The lookup_value argument is the value that you want to look up in the table, and table_array is the cell range or name of the table that contains both the value to look up and the related value to return. The col_index_num argument in the VLOOKUP function is the number of the column whose value you want to return. The optional range_lookup argument in the VLOOKUP function is the logical TRUE or FALSE that specifies whether you want Excel to find an exact or approximate match for the lookup_value in the table_array. When you specify TRUE or omit the range_lookup argument, Excel finds an approximate match. When you specify FALSE as the range_lookup argument, Excel finds only exact matches.

Read More Icon

Quick Tip March
BackStage View Office 2010

The Ribbon contains the set of commands for working in a document, while the Microsoft Office Backstage view is the set of commands you use to do things to a document.

The Backstage view is where you manage your documents and related data about them, such as create, save, and send documents, inspect documents for hidden metadata or personal information, set options such as turning on or off AutoComplete suggestions, and more. The Backstage View consists of several areas, and which area opens when the File tab is clicked depends on the current state of the application. The actions that were previously available from the File menu (Office 2003) are now in the Backstage View. Actions such as saving a file, printing or opening a previously saved file are all available directly below the File tab.

 

Read More Icon

Quick Tip February
Categories & Color Coding Emails & Appointments
Tip Icon
You can color code your calendar appointments or emails by using colored Categories. For example, you are able to make appointments one color and meetings another color. The color serves as a visual clue for you. Emails can be colorful too using Categories. 

 

Read More Icon

 

News & Events

Now offering desk side support for all your training needs!

Most computer problems occur at a specific user's desktop. Solving these problems quickly is critical to keeping your employees happy and productive. We offer desktop support depending on your needs. Desk-Side Support is a fast and economical choice when you have a technical or semi-technical person in your office.

read                                



CompuSkillz

icon

Learn more about us

read