Archive | Online Class RSS feed for this section

Gmail Tutorial 2014 – Quick Start by Anson Alexander

 

Share
Comments { 0 }

Title Only Slide Master Image

Title Only Slide Master

Title Only slide master

PowerPoint 2010 Urban Pop Theme

Share
Comments { 0 }

Need a little help with Microsoft Outlook?

Maybe it’s time to take an Outlook class. 2EducateYou offers an Outlook 2010 class and an Outlook 2007 class. Both of these six-week, non-credit, online classes start the third Wednesday of each month. Here’s a little info about each of the classes:

Microsoft Outlook 2010

Are you overwhelmed by emails, meetings, and to-do lists? Harness the power of Microsoft Outlook 2010, and you’ll instantly enhance your efficiency and productivity.

In this course, you’ll learn your way around the new ribbon-based interface and get up and running quickly. Then you’ll focus on the core skills you really need in order to work smarter and faster.

First, you’ll learn how to manage the flood of emails you receive, creating folders and archives so you can always find what you need. Then you’ll discover how to keep track of your contacts and how to use Outlook’s Calendar and Alert features. You’ll also find out how to customize Outlook so it perfectly meets your needs, and you’ll discover how to automate your work with rules.

As a bonus, you’ll get insider tips that will make you the Outlook guru in your office. For example, did you know that you can create, send, and receive email messages without ever touching the mouse? You’ll find out how, and learn lots of other tricks for getting the most out of Outlook’s versatile tools.

Whether you’re new to Outlook or you’ve been using it for years, you’re sure to learn something useful in every lesson. In just a few weeks, you’ll be a skilled and confident user of this time-saving tool—and you’ll never have to worry about missing a meeting, losing an email, or forgetting an important task again!

A free 60-day trial version of Office 2010 may be available at http://www2.buyoffice.microsoft.com/usa/?torb=4&WT.mc_id=ODC_ENUS_GenTry_Control. Both the Microsoft Office Home and Business 2010 and the Microsoft Office Professional 2010 editions include Outlook 2010.

Microsoft Outlook 2007

Want to learn Microsoft Outlook 2007 fast? Want to become a confident and productive user of this powerful program without having to memorize a lot of technical mumbo-jumbo? In this course, you’ll see what’s new in Outlook 2007 and get up and running quickly with the most important aspects of the program, from basic e-mailing to automating your work with rules. You’ll learn security basics and how to perform maintenance tasks, like backing up your data. You’ll even create a Google Gmail account for class assignments and personal use. You’ll also interact with other students and an instructor whose Outlook books, articles, and online courses have helped thousands of people like you learn the essentials of earlier editions of Outlook. Whether you’re new to Outlook or you’ve been using it for years, you’re sure to learn something useful in every lesson.

Enroll today in Office 2010 or Outlook 2007

Kathy

Share
Comments { 2 }

Converting Text to Columns in Excel

Today, I taught myself how to separate text in an Excel column into two columns with the Text To Columns function. This can be a huge time-saver when you have a lot of data to convert.

I have a spreadsheet with student info…name, email address, etc. The first and last names were in one column separated with a comma. Well, I needed the names in separate columns, and discovered the Text to Columns function. Now, I would like to share it with you.

It’s a good idea to create empty columns for your converted data to the right of the column holding the text you’d like to convert or split (first and last names for me). Then select the column you’d like to split and click Text to Columns on the Data tab on the Ribbon.

Text to Columns command on the Data tab in Excel

Text to Columns command on the Data tab in Excel

When you click the Text to Columns command, the Convert Text to Column Wizard dialog box appears with a two choices…Delimited or Fixed width. Use Delimited if the text in the column is separated with a comma, tab, semicolon, or a space; and choose Fixed if the text is aligned in columns with spaces between each field.

In the next step of the Wizard, you’ll choose the column format, like Text or General; and the destination column for your output. If you don’t choose a destination, the converted text will replace the original text in the column you selected earlier and flow into the column or columns to the right when you click Finish. It’s so easy and it works with Microsoft Excel 2007 or 2010 (Windows) and Excel 2011 (Mac). So cool!

I need to use this function two times a year; so if I forget it, I’ll refer to this blog post to refresh my memory. And,you can do the same.

I hope you found this Excel tip helpful. Post a comment if you have an Excel question for me!

Kathy

Microsoft Excel Online Classes Start Monthly

 

Share
Comments { 2 }

New PhotoShop Online Classes

I am pleased to announce three recently-released Online Instructor-Led Courses offered this month. Each six-week course is facilitated by an instructor and is the perfect way to enhance a skill or learn a new one. I have learned SO much from the many online courses I’ve taken, and I think you will too!

The August session begins Wednesday, August 15. To enroll, visit my Online Instruction Center at http://2educateyou.com/online-classes/, search for the course you want to take, and follow the enrollment instructions.

Featured Classes:

Introduction to Photoshop CS6

Intro to PhotoShop CS6 image

This hands-on, project-oriented course is filled with easy-to-follow, detailed step-by-step instructions that teach you about editing photos and creating basic paintings. Discover how to improve photographs by removing flaws, correcting for poor exposure, or adding new elements using the newest techniques Photoshop CS6 can offer. You’ll even learn how much fun it can be to paint again, without the mess of cleaning up. And, best of all, you need no prior artistic ability or Photoshop experience to take this course.

Learn More button

Photoshop CS6 for the Digital Photographer

Photoshop CS6 for the Digital Photographer image

In this course, you’ll master techniques to make the most of your digital images and add a professional polish to your work. This course offers simple, step-by-step instructions for correcting flaws, enhancing the final product, adding text, and preparing images for email and the Web. Designed for those with no image-editing experience, this class will take you from novice to accomplished photo editor.

Learn More button


Intermediate Photoshop CS6

Intermediate PhotoshopExtend your Photoshop knowledge and learn how to enhance graphics by using layers, layer masks, and other advanced photo-editing features. You’ll learn non-destructive editing techniques that let you easily re-edit and change projects long after they were originally created. You’ll see how to use Smart Objects, so that even if you crop or resize an image, you’ll be able to get it back to its original size months afterwards. This course will teach you the building blocks you need to unleash your creativity!

Learn More button

Share
Comments { 1 }

Formatting Numbers with the General Format in Excel

 

Have you ever typed a number in a cell, and the number appeared as a date? To Excel, dates are numbers. Luckily, it’s easy to fix by selecting the desired cells and choosing the correct format from the Home tab on the Ribbon or from the Format Cells dialog box.

Notice in the example below that cells cells B2 through F2 are formatted as dates. You can verify the formatting of a cell by clicking the cell and looking at the Number Format box in the Number group on the Home tab in Excel. In the example, find the word Date in the Number Format box.

Cells B2 through F2 formatted with the Date format in Excel

To change the format of the numbers (yes, dates are numbers to Excel), select cells B2 through F2; click the down arrow in the Number Format box and choose the desired format. To choose a number without any special formatting (no dollar sign or decimal places, for example), choose General as shown in the example below.

Choosing General Number Format in Excel

After formatting the numbers with the General format, your numbers will look like this:

Numbers formatted with the General format in Excel

Notice that the newly formatted numbers in cells B2 through F2 are right-aligned in each cell. Right alignment is the default format for numbers. Numbers formatted with the General format have no decimal places, commas, or dollar sign.

Have an MS Office question? Post it at my 2educateyou website or Facebook page. And I have a PowerPoint Facebook page devoted just to PowerPoint!

From Formatting Numbers with the General Format in Excel page.

Applies to Excel/PowerPoint 2007 and 2010

Kathy

 

Share
Comments { 0 }

Remove files from the Recent List in Office 2010 Applications

 

One enhancement Microsoft made in Office 2010 is the ability to remove individual files from the Recent Presentations list on the File menu. To remove a file from the list:

  1. Click the File tab then click Recent from the menu.
  2. Right-click the file you’d like to remove from the list and choose Remove from List as shown in the example below:
Remove File from Recent List - PowerPoint 2010

Remove File from Recent List - PowerPoint 2010

It’s as easy as that! Removing a file from the list deletes the pointer to the file, not the actual file.

Unfortunately, this option is not available in Office 2007. You can, however, remove all the files from the list in Office 2007 (and 2010) applications. Here’s how to do it in PowerPoint 2007/2010:

  1. Click the PowerPoint 2007 Office button or PowerPoint 2010 File tab.
  2. Click the PowerPoint Options button (PP 2007) or the Option button (PP 2010)
  3. Click the Advanced link and scroll to the Displaysection.

    Changing the number of Recent Documents - PowerPoint 2010

  4. Use the Show this number of Recent Documents spin arrows (up and down arrows) to change the value. The default value for PP 2007 is 17 documents, and 25 documents for PP 2010.
  5. Click OK when you’re done.

If you have questions, please leave me a comment. I’d love to hear from you!

Kathy
Computer Applications Instructor
PowerPoint 2010 online class
PowerPoint 2007 online class
PowerPoint 2010 one-day workshop
Office 2011 for the Mac

 

Share
Comments { 1 }

Project Management Applications

Project Management Applications

Increase your value to your employer by discovering and mastering essential quantitative and qualitative project management applications.

A successful project begins with process definition, data collection, and the scoping of project requirements. Every project ends with a motivated project team able to accomplish objectives on time and within budget. Winning projects rely on accurate cost and time estimates, identification of the critical path, and use of tracking and control tools.

In this course, an experienced Project Management Professional will teach you the same powerful tools and techniques that experienced project management professionals rely on every day.

You’ll increase the probability of project success by mastering the tricks of the trade: Earned Value Performance Measurement, Gantt Charts, Network Scheduling, Work Breakdown Structure, and Cost-Volume Analysis.

You’ll become proficient at recruiting project team members and empowering them to succeed. You’ll understand the stages of team development, and you’ll gain skills in developing and motivating team leaders. You’ll learn how to understand and relate to an organizational culture and the differing characteristics of its work groups.

You’ll also learn about project software, statistics, change management, processes, and estimating. And you’ll gain valuable experience with project planning, control and data analysis tools.

The course also includes essential information that will help you prepare for the Project Management Professional (PMP®) and the Certified Associate in Project Management (CAPM®) exams offered by the Project Management Institute (PMI®). Certification Magazine recently identified PMP® Certification as “the highest-paying certification” of the year.

PMBOK® Guide, PMI®, PMP®, CAPM®, and the PMI R.E.P. logo are either marks or registered marks of the Project Management Institute, Inc.

Share
Comments { 0 }

Create a SmartArt Graphic in PowerPoint 2010 or 2007

SmartArt Graphics

This feature allows you to use shape, color, pictures, and text to make a point visually in Word, Excel, and PowerPoint 2010 (and 2007).

One way to work with this feature is to use the SmartArt button on the Insert tab. Another way is to use the Insert SmartArt Graphics button on a Title and Content slide layout in PowerPoint.

If you have existing text that you’d like to convert to SmartArt, select the text, and then click the Convert to SmartArt button in the Paragraph group on the Home tab.

There are over 80 SmartArt graphics to choose from in the SmartArt Gallery! The categories include List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid, Picture, and Office.com.

Here’s a short video I created showing you two ways to create a SmartArt graphic in PowerPoint 2010:

Please post your questions or comments below.

Thanks!

Kathy
PowerPoint 2010
icon

PowerPoint 2007
icon

Share
Comments { 2 }

Start 2012 off with learning something new!

Lots of new online classes to choose from. Here’s just a few:

Writing Young Adult Fiction

From Harry Potter to Twilight, young adult fiction is one of the hottest genres for today’s novels. Teens and adults alike have discovered the excitement and passion of these stories, and publishers are hungry for more. If you’re eager to break into this market, this  course provides you with the recipe for creating your own successful young adult story and shows you how to get it published.
Learn why writing young adult fiction is both fun and financially rewarding. Discover the secrets for bringing your characters to life. Find out how to introduce conflict, suspense, and mystery so you can grab and hold your readers’ attention. Master the art of creating dialogue that resonates with teenagers and young adults. Analyze excerpts from bestselling young adult books to see what makes them so successful. Get expert advice on publishing and marketing your book.
If you’ve dreamed for years of becoming an author, this course can help you turn your dream into a reality. In just six weeks, you’ll have all the tools you need to create a polished manuscript and get your story in print!

Microsoft PowerPoint 2010 in the Classroom

What teacher couldn’t use help motivating students and keeping their interest?

In this course, you’ll learn how to create captivating lessons and attention-grabbing classroom presentations using Microsoft PowerPoint 2010. Learn PowerPoint basics including creating slides, using templates, inserting text, changing background colors, creating WordArt titles, using SmartArt graphics, and adding slide transitions. Develop advanced skills such as inserting graphics, sound, video, custom animations, timed transitions, and hyperlinks. Get step-by-step instructions for creating several different types of classroom presentations, including lectures and interactive narrations for your students’ independent use at computer stations. Address  different learning styles, making it much easier to reach students.

Discover how to upload your presentation to a Web server, email a slide show, broadcast a presentation in real time, and take your PowerPoint shows on the road. By the time you’re done, you’ll be an expert at using PowerPoint to add appeal to any lesson—and you’ll even find out how you can help your students develop their own
PowerPoint skills!

Intermediate Photoshop CS5

Take your photo-editing skills to a new level! In this course, you’ll become an expert at using layers, layer masks, and other advanced features that let you change images easily long after you create them (and long after the Photoshop “undo” command expires).

Non-destructive editing lets you work faster and reuse parts of images over and over. In these lessons, you’ll learn how to save every single pixel in your original image so you never have to say, “I’m sorry—I tossed that information.” In addition, you’ll discover how to use Smart Objects so you can crop or resize an image and return it to its original size months afterward. (You’ll even learn some clever tricks for warping Smart Objects!) After that, you’ll find out how to add shadows or embossing non-destructively. And if you want to design page layouts you can fill with different images, you’ll learn how to create templates you can reuse.

Whether you use Photoshop to edit photos, make scrapbook pages, or design original artwork, this course will give you all the skills you need to let your creativity shine. Once you see what non-destructive editing can do for your projects, you’ll never look back!

Photoshop Elements 10 for the Digital Photographer

Take your images from so-so to spectacular! Whether you’re making quick fixes or detailed enhancements, Adobe Photoshop Elements 10 provides the tools you need to achieve high-quality results. If you’re a novice with no photo-editing experience or you want to upgrade skills you learned in an earlier version of Elements, this course is for you.

Learn to edit images on your computer, correct flaws, enhance your final product, create simple art projects, prepare images for email and the Web, and organize your images so you can keep track of them. It’s fun and easy, and you’ll see how Photoshop Elements 10 gives you room to grow while letting you achieve high-quality results right away.

So bring your photography skills into the digital age and get ready to unlock the mysteries of Photoshop Elements 10. The hands-on, easy-to-follow exercises in this course will help you turn your photos into masterpieces and leave you with a great feeling of accomplishment!

Advanced Web Pages

Take your Web design skills to the next level! Whether you want to work as a freelance Web designer, join a Web development team, or build websites for your organization, this course will give you the advanced tools you need.

In these lessons, you’ll learn to write HTML code for page content and CSS code for page styling. You’ll master cutting-edge techniques that take advantage of HTML5 and CSS3, the latest versions of the languages used to create modern websites.

With the help of step-by-step instructions, you’ll build interactive websites that collect information from visitors through email signup and feedback forms. In addition, you’ll learn the latest and most effective techniques for presenting layouts and video that work in any browsing environment from a desktop computer to a mobile device.

This course walks you all the way through to purchasing and uploading your site to a remote server. You won’t need any special software, either—just the text editor that comes installed with your computer. Whether you’re a beginner or an experienced Web designer wanting to update and enhance your skills, this course is perfect for you. In just a few weeks, you’ll be designing state-of-the-art websites that offer all the sophisticated elements that today’s Web users expect to see.

Start Your Own Edible Garden

Grow delicious, nutritious fruit and vegetables in your own backyard!

In this course, you’ll learn how to give your garden a healthy start and keep it growing strong all season. You’ll begin by figuring out which type of garden is right for you. Explore climate considerations, learn how to read a zone hardiness map, and find out how to spot a micro-climate in your yard.  Discover how to properly prepare a garden bed so your crops have the best opportunity to thrive. See how to identify problems in pH and drainage and fix them. Learn to understand fertilizers and make compost! Delve into the variety of crops you can select: leafy greens, root vegetables, fruit, herbs, and more. Get tips on starting seeds, transplanting, pruning, and using container gardens and support structures. Learn what to watch out for so you can spot pests and diseases before they destroy your bounty. And, explore a variety of irrigation options.

Whether you want to provide your family with nutritious food, save money, get some exercise, or just be more self-sufficient, this course will give you the skills and knowledge you need to be on your way to a successful harvest.

Mastering Public Speaking

You can become an effective public speaker!
In this fun and hands-on course, find out how to talk confidently and persuasively to both large audiences and small groups. Learn how to plan and deliver your presentations skillfully and how to manage one of the most common public speaking barriers—fear. Find out how to present a short or long speech, how to handle questions and manage conflict in meetings, and even how to shine in a job interview. Get tips for training your voice and learn how to use both verbal and nonverbal communication effectively.
By the time you finish this course, you’ll have an entire set of skills you can use on the job, in social settings, and in any other situation where you need to communicate with ease and authority. 

What’s your favorite? I think I’ll enroll in the Photoshop Elements 10 for Digital Photographer class. Sounds like fun!

Kathy

Share
Comments { 0 }