Update: Word 2007 Training

We are getting more requests for Word 2007 Training, both in Bakersfield and Oxnard.  Clients are asking about both Word Level 1 and Word Level 2.

We wish we could say it was the post on Word training, but these are coming in from new clients and clients we haven't contacted on a regular basis.

For more information on the Level 1 class, click here.  (Well, OK, it was the last post before this one, so you can just scroll down from the blog home page...)

We are posting info on the Level 2 class next...

Word 2007 Level 1

We had a nice article (well at least it was informative, we think) last week on the need for Word training.  

 

Since then, we've been asked to do Word training.  Both in Bakersfield and in Oxnard.

 

Here's a link to the original article:  

"It's just Word. Why do I need training?"

 

And here's what's in our Level 1 class:

 

• The Word interface (and what's new in Office 2007)
• Navigation
• Formatting Text
• Tables
• Page Layout

And lot of other useful things. (Like how to do add the bullets to this list.)

 

If you are interested in this class, please post a reply here indicating how many students you would like to send and when are the best dates for you. Please don't post anonymously...log in so that we can contact you to enroll your students. Or email info@diamondtechsolutions.net

PowerPoint 2007 Level 1

There is some interest in holding a PowerPoint 2007 Level 1 class in Bakersfield.  (And of course, we'd love to have one in Oxnard too!)

 

This class covers the basics of building a PowerPoint presentation.  We will cover formatting slides, graphics, using drawing tools, and everything you need to start creating your own slide shows.

 

• Getting Started
• Building Presentations
• Formatting
• Drawing Tools
• Grapics
• Tables and Charts
• Templates
• Delivering Presentations

 

…and much more!

 

If you are interested in these classes, please post a reply here indicating how many students you would like to send and when are the best dates for you. Please don't post anonymously...log in so that we can contact you to enroll your students. Or email info@diamondtechsolutions.net

Excel 2007 Level 3 in Bakersfield

We have a request for an Excel 2007 Level 3 class in Bakersfield.

It’s a great chance to learn about the advanced capabilities of Excel 2
007. This class does not run very often. So if you are interested, please take advantage of this course offering!

We will cover the advanced capabilities of functions in this class, including lookups and database functions.  PivotTables are a very popular topic in this class.  And since many of us deal with databases, coverage of Excel's importing and exporting capabilities is a key topic.

Topics include:

• Advanced Functions
• Lookups and Data Tables
• Advanced list management
• PivotTables and PivotCharts
• Exporting and importing Data
• Analytical options
• Macros and custom functions
• Conditional formatting and SmartArt

There's also the Excel 2007 Level 3 class in Oxnard on June 7, 2011.  

If you are interested in these classes, please post a reply here indicating how many students you would like to send and when are the best dates for you. Please don't post anonymously...log in so that we can contact you to enroll your students. Or email info@diamondtechsolutions.net

Word 2007 Training

"It's just Word.  Why do I need training?"

If we had a nickel for every time we heard this…well we probably wouldn't be in the business of computer training.

The reality is that everyone needs Word these days.  Pretty much anything beyond minimum wage requires a resume.  And what's the best way to write a resume? With Word!  And if you get into large documents, contracts, proposals, and pretty much any situation where you are creating documents...you need Word.  And not just as a glorified typewriter.  No, need to know about outlining, paragraph formatting, text formatting, bullets and numbering.  Etcetera, etcetera, etcetera. I think you get the picture.

If this has been an eye-opener, here's a quick overview of our Word classes:

Word Level 1

Covers the basics:  

• The Word interface (and what's new in Office 2007)
• Navigation
• Formatting Text
• Tables
• Page Layout

And lot of other useful things. (Like how to do add the bullets to this list.)

Word Level 2

More detail on formatting and layout:

• Styles
• Sections and Columns
• Labels and Envelopes
• Templates
• Tracking Changes

And a whole lot more!

Word Level 3

Covers using advanced features to streamline your workflow:

• Mail merge
• Forms
• Macros
• Large document tools (table of contents, index, bibliographies, etc.)

So there you have it!  Word is more than just banging away at keys.  It is a powerful tool to help you create the documents you need to do your work.  Or even help you find work.

If you are interested in these classes, please post a reply here indicating how many students you would like to send and when are the best dates for you. Please don't post anonymously...log in so that we can contact you to enroll your students. Or email info@diamondtechsolutions.net

Excel 2007 Level 1 in Bakersfield

We have even more requests to run Excel Level 1 in Bakersfield.  At the moment, we have nearly enough people to run the class, so we're probably going to schedule it for the last two weeks of June or possible the beginning of July.  When would you like to have the class?

We've split this post off from the Oxnard class, which we're about to schedule.

If you're curious about what the class covers:

Students will learn the basics of building a spreadsheet and pick up useful tips on increasing their productivity.  This class consistently gets rave reviews…even from veteran Excel users!

This class will cover:

• The Office 2007 Interface
• Excel Basics
• Calculations
• Formatting
• Charts

.…and more

Wrap Text in an Excel Cell

This applies to all versions of Excel.

Have you ever had a problem with your text in a cell being truncated?  By default, Excel will simply cut off text that does not fit in a cell, particularly if the next cell to the right contains data.

You can resolve this issue by formatting the cell to Wrap Text.

In Excel 2007/2010, you can find the Wrap Text button on the Home Tab, in the Alignment group:

To help position you text within the cell, there is a set of Vertical Alignment commands, just to the left of Wrap Text:

If you have Excel 2003 or an earlier version, open the Format menu.  Cells is a the top of the Format menu.  (You'll also find it in the right-click menu as Format Cells.  Note the shortcut is Ctrl+1.)  

Cells/Format Cells will open the Format Cells dialog box.  Go to the Alignment tab and you will find both Wrap Text and the Vertical Alignment properties:

Do note that the Format Cells dialog box and even the Ctrl+1 shortcut are also found in Excel 2007/2010.  

Use these commands to control the behavior of the text in your cells.  You'll find this opens up many possibilities!