ed2go, Education

Microsoft Office Certification Courses

Microsoft Office Specialist 2019 (MOS) Certification Training

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) certification demonstrates your knowledge of the Office and proves that you’re ready to make an immediate impact at your organization.

Image of man sitting at desk with mac computer

This course prepares you for the Microsoft Office Specialist (MOS) 2019 certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MOS Certification Exams MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access) exams. This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included. ENROLL

PowerPoint 2016 Microsoft Certification
In this class, you will learn the fundamentals needed to create and modify basic presentations using Microsoft Office PowerPoint 2016. You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity and add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form and then finalize a presentation.

You will then move on to build upon their basic skills and will learn and use advanced techniques such as working with Masters and Special Effects within their presentations. Upon completion of this course, you will be prepared for the Microsoft Office Specialist Certification exam 77-729 (PowerPoint). This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included. ENROLL

icon
Share
Classroom, Education, Instructional Videos, Microsoft Office, Tutorial, Windows

Kathy’s Ed2Go Online Classes

Online education is fun with Kathy!

PowerPoint and Keyboarding Classes

New sections of my PowerPoint and Keyboarding classes start Wednesday, January 15. New sections start monthly…February 12, March 18, April 15, etc. I’d love to hear from you in one of my classes!
You can find more information about my classes here
https://2educateyou.com/classes-i-t…/education-to-go-classes/

Kathy Van Pelt

Share
Microsoft Excel, Online Class, PowerPoint

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