conciergepaster.blogg.se - Fgcu excel 2007 tutorial

#FGCU EXCEL 2007 TUTORIAL HOW TO#
#FGCU EXCEL 2007 TUTORIAL UPDATE#
#FGCU EXCEL 2007 TUTORIAL SOFTWARE#
#FGCU EXCEL 2007 TUTORIAL FREE#
#FGCU EXCEL 2007 TUTORIAL WINDOWS#

In this lesson you will learn how to layout and how to print your documents. However, before you print you may want to add page numbers and tell Word such things as the page orientation, the paper size, and the margin setting you want to use. One way to share your document is to print and distribute it. After you have completed your document, you may want to share it with others. The first part of this lesson teaches you to bullet and number. When using Microsoft Word, bulleting and numbering are easy. If you have lists of data, you may want to bullet or number them. Lesson 5: Adding Bullets and Numbers, Undoing and Redoing, Setting Page Layouts and Printing Documents In this lesson, you will learn about the various formats you can apply to a paragraph and about styles. For example, by applying a style, you can set the font, set the font size, and align a paragraph all at once. Styles are a set of formats you can quickly apply to a paragraph. This tutorial is derived from an MS Excel 98 tutorial copyrighted by the Department of Computer Science at The University of. Left, right, center, or flush with both margins. You can format paragraphs.įor example, you can indent the first line of a paragraph, you can set theĪmount of space that separates paragraphs, and you can align a paragraph Press the Enter key Word creates a new paragraph. When you type information into Microsoft Word, each time you Lesson 4: Formatting Paragraphs and Working with Styles All of these features either make your work easier or make your document more attractive. This Microsoft Word lesson teaches you how to open a file, cut, copy, paste, use AutoText, use spell check, use Find and Replace, and change fonts.

The features in Word 2007 can make your work easier, make your documents more attractive, and/or enable you to work more efficiently. This lesson covers typing, using the Backspace key, using theĭelete key, inserting text, bolding, underlining, and italicizing. YouĪre now ready to learn how to create a Word document. Lesson 1 familiarized you with the the Microsoft Word window. Lesson 2: Microsoft Word 2007 Basic Features

Execute Commands with Keyboard Shortcuts.

The Vertical and Horizontal Scroll Bars.

You use this window to interact with Word. Although this tutorial was created for the computer novice, because Microsoft Word 2007 is so different from previous versions of Microsoft Word, even experienced users may find it useful.This lesson will introduce you to the Word window. This tutorial teaches Microsoft Word 2007 basics. It gives you the ability to use your computer for desktop publishing. You can use it to type letters, reports, and other documents.

#FGCU EXCEL 2007 TUTORIAL SOFTWARE#

Microsoft Word is a word processing software package.

#FGCU EXCEL 2007 TUTORIAL WINDOWS#

Lesson 1: Getting Familiar with Microsoft Word 2007 for Windows

#FGCU EXCEL 2007 TUTORIAL FREE#

You can use this free online tutorial to learn Microsoft Word 2007. Use a Special Excel Array Formula to Simulate SUMI.Our Other Word Tutorials: 2013, 2007 Microsoft Word 2007 Tutorial-Free & Online.Use a CSE Formula (Array Formula) to Perform Super.Use Conditional Sum Wizard To Enter CSE Formulas.Processing Market Research Data in Excel.

#FGCU EXCEL 2007 TUTORIAL UPDATE#

Update Charts Automatically When You Enter New Data.

Conditional Sum Wizard To Enter CSE Formulas.

How do I capitalize the values in a particular col.

Making An Exact Copy Of A Range Of Formulas.

Restrict cursor movement to unprotected cells.

Message Board Hall of Fame - Color Banding to Curr.

Converting non-numbers to actual values.

Using Data Validation To Check For Repeated Values.

Setting up Data Validation Lists in Excel.

Do Power Excel with the hot DigDB Add-In for Excel.

Identify formulas using Conditional Formatting.

From the menu, Data - Pivot Table and PivotChart Report.ģ. You will have to delete the date field.ġ. Excel sums all numeric data, which in this case includes the date field. The result: For each unique customer in the left column of your data, you get one row. Fill out the Consolidate dialog as follows: Select a blank cell to the right of your data.ģ. Press the "2" group and outline button to show a summary.ġ. Click the AZ sort button in the standard toolbar.ģ.

Copy the formula down to the other rows in column H. This will give you a unique list of customers in column G.Ĥ. In the Advanced Filter dialog, choose Copy to New Location, Unique Values. From the menu, Data - Filter - Advanced Filter.ģ. Copy the Customer heading to a blank cell G1.Ģ.