fbpx

Tag Archives | 2EducateYou

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
Comments { 0 }

My Wellness Journey

I’ve had so much fun teaching the past 30 plus years, I’ve decided to expand my horizons and teach something new. I enjoy doing research and learning new things, so learning about the wellness benefits of essential oils has been fun.

What are the wellness benefits of oils? There are many, depending on the person and need. I find that diffusing Cedarwood, Lavender, Vetiver, and Valor oils in the evening helps me (and hubby) sleep. Sometimes I’ll change it up and diffuser Harmony, Peace and Calming, or Stress Away. Here’s a peak at my sleepy blend…

 

Image of diffuser and four oils

 

A few other favorite products of mine are AgilEase for joint support; Super Calc Plus as a bone health supplement; Immupro for sleep and immune support; and Thieves Cough Drops for a cough, sore throat, or stuffy nose. These are the BEST! I take the AgilEase and Super Calc Plus daily and the Immurp and Thieves Cough Drops as needed.

There’s so much more I can share about what I have learned and what I love. Head over to my OilyThingsEssential website for my free online essential oils class full of fun info and no exams! You’ll find my Blog there. More good stuff to come!

Kathy
Get started on your wellness journey with a Premium Starter Kit today! 

Share
Comments { 0 }

2EducateYou Introduces New Online Course: Introduction to Microsoft PowerPoint 2010

2EducateYou has a program that makes it easy to take high-quality, noncredit online courses. 2EducateYou has partnered with ed2go to offer hundreds of online, instructor-led courses and is pleased to announce the launch of Introduction to Microsoft PowerPoint 2010.

Participants in this course will learn how to use Microsoft PowerPoint 2010 to create exciting slide presentations that include text, objects, SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks. With the help of hands-on activities and step-by-step instructions, even beginners will quickly be creating everything from professional-quality business presentations to PowerPoint photo albums.

This course is part of 2EducateYou’s growing catalog of more than 300 instructor-facilitated online courses. Through well-crafted lessons, expert online instruction, and interaction with fellow students, participants in these courses gain valuable knowledge at their convenience. They have the flexibility to study at their own pace combined with enough structure and support to complete the course. And they can access the classroom 24/7 from anywhere with an Internet connection.

New sessions of each course run every month. They last six weeks, with two new lessons being released weekly (for a total of 12). The courses are entirely Web-based with comprehensive lessons, quizzes, and assignments. A dedicated professional instructor facilitates every course; pacing learners, answering questions, giving feedback, and facilitating discussions.

To learn more, visit the course website: Introduction to Microsoft PowerPoint 2010

Kathy Van Pelt
2EducateYou.com

Share
Comments { 0 }

Create a Website-in-a-Day Class

In this one-day, hands-on workshop, you’ll learn the basic principles for creating a Web site. Students will learn how to:

  • Create HTML code
  • Use an HTML editor to create HTML code
  • Use an HTML template to create web pages
  • Choose a host and domain name
  • Create a Web site with a homepage
  • Create links
  • Create and insert Web-formatted photos
  • Upload to a Web server
  • The difference between WordPress.com and WordPress.org

Come with an idea of how you would like your Website to look, the content you would like to include, and any Web-ready photos that have been re-sized for Web pages.

Students may bring a USB drive.

Friday, September 23, 2011, 9:00 am – 3:30 p.m. or Friday, December 2, 2011, 9:00 am – 3:30 p.m.
Tuition: $80.00

Materials Cost: $10.00

Register: Online/ or by phone: 760-795-6820

MiraCosta College-San Elijo Campus
3333 Manchester Avenue
Cardiff, CA 92007

Directions: Take I-5 to Manchester Ave. exit. Go east on Manchester Ave. A free parking pass for your class or workshop can be obtained at the front desk of the Administration Building on campus.

Share
Comments { 0 }