Uncategorized

Formatting Numbers with the General Format in Excel 2010

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
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
 Choosing the 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
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. 

Enjoy!

Kathy

Share
Classroom, Online Class, Uncategorized

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
Uncategorized

New Keyboarding Class

ed2go is pleased to announce a major update to an instructor-led online course designed to help students improve their keyboarding speed and accuracy. This course is popular with students seeking careers in health care, office management, and related fields.

This course has been fully revised to allow students to use the latest keyboarding software, Keyboarding Pro 5. The title and price for this course will remain the same.

Keyboarding

Instructor: Kathy Van Pelt

Description: Students will learn how to touch-type or improve their existing typing skills using Keyboarding Pro 5. By the end of the course, they will know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.

Share
Uncategorized

Creating a Favicon

One of my students asked how to create a favicon for his Web site, and I thought I would share the answer with you.

A favicon is the icon you see before a Web site address in the address bar of your browser. Here’s the one I created today for my 2EducateYou blog:

There a few ways to create a favicon:

  1. Build one from scratch with a graphics program such as Adobe Photoshop or Adobe Photoshop Elements.You’ll need to create a file that is 16 x 16 pixels and save it as an icon. I used Adobe Photoshop Elements, which is similar to PhotoShop, but much cheaper! It has all the features I need in a graphics program. In fact, it has way more than I need! If you have access to one of the PhotoShop products, use these directions from Tutorials by Jennifer to build your favicon.
  2. Use a Web site tool.I found the Favicon.cc Web site easy to use. You simply choose a color for your icon, then click on the squares to apply your color and build your favicon.

    Another handy Web site is FavIcon from Pics. If you have a company logo, this Web site can create your favicon from your logo. Pretty slick! I tested it with a graphic I created in PhotoShop Elements, and it worked great. Also try DynamicDrive, which does the same thing.

    While many of you will find this option easier, using a graphics program may give you a nicer looking favicon. I tried both methods, and found the graphics approach more difficult, but I liked the icon much better.

After saving your favicon, you’ll need to upload it to your Web hosting company. FTP is one method of transferring files from your computer to your hosting company. Each Web hosting company has its own set of rules which you’ll need to get familiar with so you can transfer your files to them. Network Solutions has three FTP options! If you’re using a  template from your hosting site, you’ll need to ask them which folder to upload your favicon to. If you’re using Network Solutions, you’ll upload to the htdocs folder.

You may also need to add this html code between the beginning and ending HEAD tags in your Web pages:

<link rel="shortcut icon" type="image/x-icon" href="/favicon.ico">

although I found I didn’t have to do this for a WordPress blog.

Good luck!

Kathy Van Pelt
2educateyou.com

 

Share
Uncategorized

Web-ready photos

A student asked me recently how to make photos web-ready.

You’ll need to use a photo editing program to get your photos web-ready. If you have access to PhotoShop, you might find the information at these links helpful:

http://graphicdesign.about.com/od/howto/ss/save_for_web_2.htm

http://tutorialblog.org/is-your-image-web-ready/

Here’s another link with more options that you might like if you don’t have PhotoShop installed on your computer. This article explains how to make photos web-ready with a variety of programs including PhotoShop Elements and Microsoft Photo Editor. Microsoft Photo Editor is probably the most basic and easiest to use for a beginner:

http://www.nvsd44.bc.ca/Staff/GH/Help/~/media/89AF0C9C89A947CDA6EB4B14018450A7.ashx

Hope this helps!

Kathy

Share