8012 Bonhomme, Suite 200 * Clayton, MO 63105 * Phone: 314-863-0333 * Fax: 314-863-6650 * E-mail: mail@StaffingSolutionsInc.com
Missouri Certified Women-Owned Business Enterprise (WBE)

Follow Us:

facebook twitter linkedin  youtube

Our Blog

SSI

Spreadsheets - Microsoft Excel

 

Bold Text

Select cell to be bolded, then click on the B on the Formatting toolbar or Control+B

Center on Page

File/Page Setup/Margins tab - Select horizontal or vertical centering by clicking in the appropriate box

Change Alignment

Select cells Format/Cells/Alignment - select desired alignment or use alignment buttons on the formatting toolbar

Change Borders

Select the cell range to be changed. Format/Cells/Borders tab - change as desired or use the border button on the toolbar. There are more options available through the menu than the toolbar

Change Column Width

Format/Column/Column Width - Type the column size in the highlighted box or Get the sizing handle at the right edge of the column heading (dark line with two horizontal arrows)/double click to size to fit or drag the sizing handle to the appropriate width

Change Font (typeface)

Select the cell range to be changed, then Format/Cells/Fonts tab - select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name

Change Headers and Footers

File/Page Setup/Headers and Footers. Adjust using the preformatted headers and footers, or make a custom header/footer

Change Page Orientation

File/Page Setup/Page tab - Select portrait or landscape orientation

Change Row Height

Format/Row/Height - Type the row height in the highlighted box or Get the sizing handle at the bottom edge of the row heading (dark line with two horizontal arrows)/double click to size to fit or drag the sizing handle to the appropriate line height

Close Document

File/Close or Control+F4

Compress/Scale

File/Page Setup/Page tab - Select number of pages to fit or enlarge spreadsheet by percentage

Copy/Paste and Cut/Paste

Select the cell range to be cut or copied. Click on File/Edit/Cut or File/Edit/Copy or use the buttons on the toolbar. Position the cursor in the space where the selection is to be cut/copied. Click on File/Edit/Paste or on the clipboard button on the tool bar

Find

Edit/Find - type word to be found and click on Find Next

Format Cells - Number Type, Alignment, Font, Border, Pattern, Protection

Format/Cells - This tabbed dialogue box has several options. Select the cell(s) and then select the appropriate formatting changes

Freeze Panes (Titles)

To keep the column headings at the top of the screen while doing data entry, click in the cell that is in the row below, and to the right , or any column/row headings to be frozen. Click on Window/Freeze Panes. To remove, click on Window/Unfreeze Panes

Italicize Text

Select text to be italicized, then click on the I on the Formatting toolbar or Control+I

New Document

File/New/Blank Document or Control+N or click on the New button on the Standard toolbar

New Page

Control+Enter or Insert/Break/Page

Print Preview

File/Print Preview or use the button on the tool bar

Replace

Edit/Replace - type word to be found in first box and word to replace it in the second box. Click on Replace or Replace All

Save File

File/Save - Select appropriate folder and name document. Click on Save

Select Text

Click in the cell to be selected and drag the mouse to the last cell in the range to be selected (using the fat cross cursor) or navigation keys (arrows, page-up, page-down, home, end) to select cells or click in the first cell of the range to be selected, hold shift key, click in the last cell in the range to be selected

Set Margins

File/Page Setup/ Margins tab - Change numbers by typing in box or by using the up and down arrows

Set Print Area

File/Page Setup/Sheet - Click in Print Area box, select print range

Set Print Titles

File/Page Setup/Sheet - Click in Rows to Repeat at Top or Columns to Repeat at Left

Spell Check

Tools/Spelling or press F7 or use spell-check button on the toolbar

Spreadsheet Operators/Simple Formulas

Addition +
Subtraction -
Multiplication *
Division /

Use these symbols to set up formula using the cell addresses as the variables

Underline Text

Select text to be underlined, then click on the U on the Formatting toolbar or Control+U

Undo/Redo

To undo the last action, click undo button on the Standard toolbar or Control+Z. To redo an action, click the redo button on the Standard toolbar or Control+Y

 

 

 

 

 

 

 

 

Word Processing- Word

 

Bold Text

Select text to be bolded, then click on the B on the Formatting toolbar or Control+B

Bullet and Numbered Lists

Format/Bullets and Numbering - Select desired bullet or numbering format or click on the bullet or numbered list button on the Formatting toolbar

Center a line

Select text to be centered, then click on center button on the Formatting toolbar or Format/Paragraph/Alignment/Center or Control+E

Change Font (typeface)

Select the text to be changed, then Format/Fonts - select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name

Change Justification

Format/Paragraph/Alignment - Change Alignment or use buttons on Formatting tool bar

Change Line Spacing

Format/Paragraph - Click on drop down arrow next to the Line Spacing control. Select line spacing desired. Click OK

Change View

View/Normal or View/Page Layout

Close Document

File/Close or Control+F4

Find

Edit/Find - type word to be found and click on Find Next

Grammar Check

Tools/Grammar

Header and Footer

View/Header and Footer - Type and format text of Header in the header area. Use toolbar to switch to the Footer area. Type and format footer text. Close Header/Footer toolbar

Indent Text

Select paragraph to be indented. Format/Paragraph - Select the indention desired or click on the Increase Indent button on the Formatting toolbar

Insert Date

Insert/Date and Time - Change to appropriate format, click OK

Italicize Text

Select text to be italicized, then click on the I on the Formatting toolbar or Control+I

New Document

File/New/Blank Document or Control+N or click on the New button on the Standard toolbar

New Page

Control+Enter or Insert/Break/Page

Print Preview

File/Print Preview or View/Page Layout, then View/Zoom/Full Page

Replace

Edit/Replace - type word to be found in first box and word to replace it in the second box. Click on Replace or Replace All

Save File

File/Save - Select appropriate folder and name document. Click on Save

Select Text

Click at the beginning of the text to be selected and drag the mouse to the end of the text to be selected or Hold the shift key and use the navigation keys (arrows, page-up, page-down, home, end) to select text or click at the beginning of the text to be selected, hold shift key, click at the end of the text to be selected

Set Margins

File/Page Setup/ Margins - Change numbers by typing in box or by using the up and down arrows

Set Tabs

Format/Tabs - Set tabs as desired or use the ruler bar to set tabs in the desired position

Spell Check

Tools/Spelling or press F7

Tables

Table/Insert Table - Set number of columns and rows/click OK. Use auto format if desired

Underline Text

Select text to be underlined, then click on the U on the Formatting toolbar or Control+U

Undo/Redo

To undo the last action, click undo button on the Standard toolbar or Control+Z. To redo an action, click the redo button on the Standard toolbar or Control+Y

 

 

 

 

 

 

 

 

Presentations - Microsoft PowerPoint

 

Add a slide

Click on Common Tasks Toolbar, New Slide

Alignment - Change (Right, Left, Center, or Full)

Select the text information. Format/Alignment - select desired alignment or use alignment buttons on the formatting toolbar

Bold Text

Select cell to be bolded, then click on the B on the Formatting toolbar or Control+B

Change Font (typeface)

Select the text to be changed, then Format/Fonts. Select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name

Change Headers and Footers

View/Master Slide. Change the headers and footer here and it will effect your entire presentation. Or, select the footer on the individual slide you wish to change and make the changes. This will effect only that slide

Close a presentation

File/Close or Ctrl + W or Ctrl + F4

Copy/Paste and Cut/Paste

Select the text information to be cut or copied. Click on Edit/Cut or Edit/Copy or use the buttons on the toolbar or use the Control-C or Control-X shortcut keystrokes. Position the cursor in the space where the selection is to be cut/copied. Click on Edit/Paste or on the clipboard button on the tool bar or Control-V

Display the Find dialog box

Edit/Find or Ctrl F

Display the Print dialog box

File/Print or Ctrl P

Go to first slide

Ctrl + Page Up or pick it from the Slide Sorter View (lower left-hand corner)

Go to last slide

Ctrl + Page Down or pick it from the Slide Sorter View (lower left-hand corner)

Go to next slide

Page Down or pick it from the Slide Sorter View (lower left-hand corner)

Go to previous slide

Page Up or pick it from the Slide Sorter View (lower left-hand corner)

Italicize Text

Select text to be italicized, then click on the I on the Formatting toolbar or Control+I

Move between slide objects or placeholders

Click on each object or Control-Enter

Open a new presentation

File/New or Ctrl + N

Open an existing presentation

File/Open or Ctrl + O

Print Preview

View/Slide Show

Save a presentation

File/Save or File/Save As or Ctrl S or Shift + F12

Select Text

Hold the Shift Key and use the arrow keys to highlight the text

Spell-Check

Tools/Spelling or F7

Underline Text

Select text to be underlined, then click on the U on the Formatting toolbar or Control+U

Undo/Redo

To undo the last action, click undo button on the Standard toolbar or Control+Z or Edit/Undo. To redo an action, click the redo button on the Standard toolbar or Control+Y

View All Slides

View/Slide Sorter

 

 

 

 

 

Internet Glossary

 

Browser:

See Web Browser

Database:

A repository of related information (records) accompanied by a set of tools for searching, sorting , and retrieving those records. As relates to a search engine, the database is the body of information in which a search engine seeks matches to a user-submitted query term. Search engine databases vary greatly

Download:

The transfer of data or files from a server computer to a client computer via a network. (see Upload)

Frames:

A convention by which a Web page can be split into multiple panes. An individual Web page can be split into as few as two frames and as many as dozens of frames. Some frames are scrollable, whereas others are not. Frames at the edge of a Web page that cannot be scrolled are called ledges

Hit list:

The result of a search engine query that is displayed to a user as an ordered (and often relevancy ranked) list. The individual hits may contain hyperlinks to the resources identified

Hyperlink:

A hypertext or hypermedia navigational anchor within a Web page that can be either 1) a text block, 2) an image, or 3) multiple anchors within a single image (image map). Hyperlinks, or links for short, allow the user to move from one source to another by clicking on the anchors (hot spots)

Hypertext:

A system of organizing and navigating information used on the Web. Hypertext information is organized into an interconnected matrix of linked text and images. Hypertext documents (called Web pages) contain navigational anchors (called hyperlinks or links) that allow you to navigate to another part of the same document or to a different hypertext document with a mouse click. Web-based hypertext documents are created with the Hypertext Markup Language or HTML

Link:

(see Hyperlink)

Query input form:

The user interface of a search engine into which you enter and submit a request (query term) to a search engine database

Query term:

The information submitted to a search engine. A query term may consist of up to three basic elements, including one or more keywords, logic operators, and switches

Search engine:

An Internet-based search tool that provides an automated result (hit list) to a user-submitted query term (see Query term). Search engines comprise four discrete elements: 1) query term, 2) user interface, 3) search algorithm, and 4) database

URL (Uniform Resource Locator):

The address of any Internet-based information resource when accessed via a Web browser. Neither Navigator nor IE require the entry of the transfer protocol http:// as part of a Web page URL

Web browser:

A universal Internet software application that runs on a client computer. The browser performs five basic functions: 1) locates Internet resources, 2) requests the resources from a server, 3) downloads data, 4) interprets data, and 5) displays the information to the user. Browsers can download and display information from Web servers, Gopher servers, and FTP servers

World Wide Web (Web, WWW, or W3):

A global hypertext and hypermedia-based service of the Internet that is known simply as "the Web." The Web was conceived in 1990 by Tim Berners-Lee and Robert Cailliau at CERN in Geneva, Switzerland and was officially introduced to the Internet community in 1992. Today the Web is the fastest-growing service of the Internet, offering over 440 million pages. It is estimated that 1.5 million pages are added to the Web each day

 

Software Tips and Tricks

Weekly Software Tips and Tricks
Previous Software Tips

 

"Help!" Desk

Select Software

Help Desk
%