Whats New in Microsoft Office 2013

Details

In this course, you'll learn how to use the exciting new features of Microsoft Office 2013, including Word, Excel, PowerPoint, Access, Outlook, OneNote, and Publisher, using step-by-step, easy-to-follow instructions. With this latest version of the Microsoft Office, you'll be able to store and share your work "in the cloud" on Microsoft SkyDrive, a great, free online location that lets you access your files from any computer.  

You'll explore Word, where you'll get experience using the new Start screen, templates, and Ribbon commands. You'll master new features in graphics, movies, and tables as well as the new Reviewing features and Office apps (some great mini-programs you can add to Office), and learn how you can work with PDFs in Word.   

In Excel, you'll learn to speed up your work using the Quick Analysis tool, Flash Fill, and some great new chart features. You'll also get an orientation to PivotTables and explore a few new PivotTable tricks.  

In PowerPoint, you'll discover new ways to make your presentations look better than ever, including themes, graphics, shapes, colors, and animation. You'll also learn how to use the new Presenter view and commenting features, and how to present your slide show in an online meeting. 

In Access, you'll get acquainted with WebApps, which are Access databases you can put online and share with others who can use it with their Web browsers—they don't even need Access to use it! We'll also take a quick spin through the new features of the Office email program, Outlook.  

In addition, we'll explore often-overlooked but really valuable note-taking program, OneNote, as well as the easy-to-use page layout program, Publisher. And we'll top everything off with a bonus lesson on how to use some of the Office programs together, a skill known as integration. Before you know it, you'll be using each MS Office 2013 program with ease, and working more efficiently with cloud computing!

Enrollment Options:

Instructor-Led
6 Weeks Access Course Code: of3
Start Dates* Jul 17 | Aug 14 | Sep 18 | Oct 16
*Choose start date in cart

$115.00

USD

Enroll before 31th May and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.

Syllabus

Introducing Office 2013 and the Cloud

Microsoft Office 2013 adds new capabilities and a new look to the features of Office 2010. In addition, Office 2013 lets you store and work on your documents "in the cloud," making it easier to work from different locations and to share your work with others. In this lesson, you'll take a peek at the new look of Office 2013 and then learn about working with Office programs and documents in the cloud.

A Tour of Word 2013 Startup and Graphics Features

Microsoft Word offers several new startup features, including a Start screen and templates. Its enhanced cloud connectivity appears when you open and save files. A new view and improved graphics capabilities make it easier to view and work with pictures and videos. In this lesson, you'll use these features in both a short and a long document

Formatting and Sharing Word Documents

Word 2013 makes working with tables easier than ever, with new border choices and a new easy way to add rows and columns. And when you finish formatting, you'll most likely want to share your documents with others, often to get their responses to your work. In this lesson, you'll learn about new Word reviewing features that make this faster. We'll explore Office apps, which help you extend what you can do in the program. You'll also learn that Word 2013 features the ability to open PDF documents so that you can edit them right inside of Word. Last, we'll look at file compatibility.

­­­­Introducing Microsoft Excel 2013

Like Microsoft Word, Microsoft Excel 2013 has added some important new features that can help speed up your work. You'll see that the Excel screen elements are similar to those you saw earlier in Word. We'll also go over new data analysis tools that let you preview various data relationships before you choose one. Combine these with new chart formatting tools and the ability to create slicers from tables, and you'll find better ways of communicating your data more clearly than ever before.

­­­­More New Excel Features

In this lesson, you'll begin by exploring changes to Excel PivotTables and PivotCharts, after a quick review. You'll also learn a great new PivotTable feature called the Timeline. We'll then move on to workbook sharing and then experience some of the new apps for Excel. Finally, you'll look at sharing workbooks and the new procedure for creating and saving you own templates.

­­­­Getting to Know New PowerPoint Graphics Tools

Today, you'll look at the PowerPoint Start screen templates and then open a presentation. There you'll learn about themes and theme variants, you'll examine new slide formats, and you'll look at how the Ribbon tabs have changed. Then you'll explore several new tools that let you add and work with graphics in less time.

PowerPoint's New Formatting, Animation, and Slide Show Features

Today, you'll gain experience in formatting slide backgrounds, formatting pictures, and presenting in Slide Show view. I'll then introduce you to the new Presenter view, which lets you practice and present your show using new tools. We'll then turn to the new comment features, which allow you to more easily exchange information with people who review your presentation. Finally, we'll look at new animation features that let you create custom animations more easily.

Creating Access Web Apps

Access 2013 has one big new feature: It lets you create Web apps, which are online databases that other people can open and work with using a Web browser. In this lesson, we'll do a quick review of Access and then create two Web apps. You'll need Access 2013 and a SharePoint server address, which you can get by signing up for a free trial of an Office 365 subscription.

­­­­Learning New Outlook Features

In this lesson, you'll look at the most important new features in Outlook 2013, including improvements to the email, contacts (now called people), calendar, and tasks areas. Some areas have been renamed, and some have gotten a new look to help you communicate more efficiently with others. Finally, we'll look at ways of customizing the screens in the major Outlook areas so that you can always have the information you need at your fingertips.

­­­­What's New With OneNote 2013

In this lesson, I'll introduce you to the basics of OneNote 2013, including creating a notebook, tabs, and pages. You'll then see the major new features, including creating and tagging text, creating tables with shading, converting tables to Excel spreadsheets, and inserting existing Excel spreadsheets. Finally, you'll learn about sending information to OneNote from other programs and exporting notebooks.

­­­­What's New in Microsoft Publisher 2013

In this lesson, we'll look at the new features of Microsoft Publisher 2013, including new templates and new text and graphics formatting options. We'll cover fills, outlines, and special effects such as shadows, reflections, glows, and bevels. These effects offer countless combinations that let you make your text and graphics truly distinctive. You'll learn to easily swap images in a publication and make any image into a page background. Finally, you'll learn how to save any publication as a graphic file that you can send to any photo printer.

Integrating Office Information

In this lesson, you'll learn how to perform basic integration techniques, which let you reuse information between the Office programs. We'll compare and contrast pasting, embedding, and linking and get some hands-on experience as you integrate spreadsheet cells and a chart into a Word report. Finally, you learn to create an entire PowerPoint presentation in an instant from a Word outline.

Requirements

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites

There are no prerequisites to take this course.

Instructor

Barbara Clemens has been a software product manager, editor, writer, and teacher since 1984. She has worked with educational publishers Addison-Wesley and Course Technology to create software textbooks for colleges and universities. She has edited, revised, and written many Microsoft Office texts and has co-authored two textbooks on new versions of Office: Upgrading to Microsoft Office 2007 and Upgrading to Microsoft Office 2010. She holds a B.A. in English, an M.A. in English as a Second Language, and a Masters in Business Administration. She has worked as a university English instructor, computer trainer, and consultant, and is known for teaching computer software using careful, clear, and understandable instructions.

Reviews

About ExpertRating

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.

Company Timeline

Since 2001

Decades of excellence

800+ Skill Tests

World’s largest test inventory

2500+ Companies

Thousands depend on use

25 Million People Tested

10 tests every minute

35 Countries Serviced

Over 1500 clients in the US

86% Reorder Rate

Satisfied clients

We deliver over 3 million online certification tests and online courses annually.

Awards

ExpertRating is a winner of the Google SME Heroes award. This award has been instituted by Google to honor IT companies that have excelled in their domain and have leveraged the internet to grow and expand their businesses in innovative ways.


ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well-balanced, comprehensive and meaningful content.