Office 2010 Quick Tips

Take advantage of expertly curated tips for; Word, Excel, PowerPoint and Outlook to take your skills to a new level
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
173 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 100
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

Do you already know the basics of Office 2010?

Then now’s the time to learn valuable tips & tricks that will expand your knowledge and save you time with this one-of-a-kind video training course. Office 2010 is a complete suite of software productivity tools from Microsoft and includes Word, Excel, PowerPoint, and Outlook.

With this video course, you can take advantage of expertly curated tips to help take your skills to a new level. Our instructors provide expert, straight-forward, user-friendly training to help you enhance your Office 2010 knowledge the way you want to learn.

This course includes more than 50 two-four- minute lessons that will quickly help you discover workspace shortcuts, cool productivity tips, and optimization tricks.

If you’re looking for real-world Office 2010 instruction, you’ll find it here.

What are the requirements?

  • It's helpful to have access to Microsoft Office; Word, Excel, PowerPoint and Outlook to practice your new skills.

What am I going to get from this course?

  • Take Your Basic Microsoft Office Skills to the Next Level, focus on tasks that are similar across of Microsoft's applications, Word, Excel, PowerPoint and Outlook; Microsoft's email application.
  • We'll start with the Ribbon display, how to customize, move out of the way and to share with a different computer or a friend who uses office.
  • You will learn how to set up documents properties, how to password protect a document, control permissions, mark a document file and learn to recover an unsaved document.
  • You’ll learn how to automate typing with AutoText, which can come in handy if you find yourself typing the same long phrase or paragraph of text into a document over and over again.

What is the target audience?

  • Beginner to Intermediate users who want to sharpen their skills and learn the tips and tricks to advance your knowledge to a new level.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: General Office 2010 Maximizing Tips
01:03

This chapter focuses on tasks that are similar across many of Microsoft Office’s applications.

01:09

In this lesson, you’ll learn how to customize the Ribbon.

00:50

In this lesson, you’ll learn how to control the Ribbon display so you can easily move it out of the way when you don’t need it, or call it up when you do.

00:51

In this lesson, you’ll learn how to share a customized Ribbon with a different computer, or other people who use Office.

01:18

In this lesson, you’ll learn how to automate Office tasks with macros.

00:55

In this lesson, you’ll learn how to change the default font and size.

01:56

In this lesson, you’ll learn how to organize notes with OneNote

Section 2: TimeSaving Tips for Office Files
02:01

This chapter shows you several different tasks that apply to Office files. Office 2010 has retooled the old Office button into a File tab on the Ribbon that displays a whole screen of options for working with your files.

01:04

In this lesson, you’ll learn how to check a document’s compatibility to be sure it will work with new programs.

01:50

In this lesson, you’ll learn how to assign document properties.

01:33

In this lesson, you’ll learn how to remove sensitive document information.

01:08

In this lesson, you’ll learn how to encrypt a document. When a document is encrypted, a password is needed to open the file.

00:59

In this lesson, you’ll learn how to add a digital signature to your files.

01:36

In this lesson, you’ll learn how to control author permissions.

01:06

In this lesson, you’ll learn how to mark a document as final.

01:01

In this lesson, you’ll learn how to recover an unsaved document.

Section 3: Boosting Your Productivity in Word
01:23

This chapter will help you boost your productivity using Word.

00:49

In this lesson, you’ll learn how to share building blocks with others.

01:15

In this lesson, you’ll learn how to use bookmarks to jump around to other documents.

01:03

In this lesson, you’ll learn how to navigate long documents with the Navigation pane.

01:18

In this lesson, you’ll learn how to automate typing with AutoText, which can come in handy if you find yourself typing the same long phrase or paragraph of text into a document over and over again.

00:51

In this lesson, you’ll learn how to emphasize text with drop caps.

01:10

In this lesson, you’ll learn how to set a new default line spacing.

00:37

In this lesson, you’ll learn how to quickly insert a horizontal line into your document.

00:32

In this lesson, you’ll learn how to resume numbering in an interrupted numbered list.

01:23

In this lesson, you’ll learn how to set off a paragraph with a border.

00:30

In this lesson, you’ll learn how to add filler text, which is helpful when creating a mock-up or layout design for a project in Word.

00:44

In this lesson, you’ll learn how to keep words together with a nonbreaking space.

00:52

In this lesson, you’ll learn how to summarize information with a chart.

Section 4: Optimizing Excel
01:30

This chapter offers some tips for optimizing Excel.

01:04

In this lesson, you’ll learn how to automate data entry with AutoFill in Excel.

01:18

In this lesson, you’ll learn how to color-code and name your worksheet tabs in Excel.

01:00

In this lesson, you’ll learn to keep cells in view with a watch window using Excel.

01:27

In this lesson, you’ll learn how to protect cells from unauthorized changes in Excel.

00:46

In this lesson, you’ll learn how to generate random numbers in your cells.

00:49

In this lesson, you’ll learn how to join text from separate cells using the concatenate function.

01:11

In this lesson, you’ll learn how to add a calculator to the Quick Access Toolbar.

01:28

In this lesson, you’ll learn how to audit a worksheet for errors.

01:10

In this lesson, you’ll learn how to create projections using Excel.

01:11

In this lesson, you’ll learn how to establish what-if scenarios using Excel.

00:48

In this lesson, you’ll learn how to set goals with Goal Seek in Excel.

01:38

In this lesson, you’ll learn how to define and solve problems with Solver, which lets you produce a value using multiple variables.

01:15

In this lesson, you’ll learn how to create a database table using an Excel worksheet.

01:00

In this lesson, you’ll learn how to add and edit records using data forms.

01:00

In this lesson, you’ll learn to sort and filter records in Excel.

01:31

In this lesson, you’ll learn how to restrict cell entries using Excel.

Section 5: Polishing Your Spreadsheet Data
00:56

This chapter introduces you to a variety of tasks designed to help you make your data look great and print great so you can convey your information with ease and clarity.

01:02

In this lesson, you’ll learn how to change gridline colors to make your spreadsheet easier to read. You'll also learn how to print gridlines.

01:01

In this lesson, you’ll learn how to add a background color to the cells in your worksheet.

01:22

In this lesson you will learn how to use Excel’s conditional formatting to assign certain formatting when the value of the cell meets a specified condition.

01:11

In this lesson, you’ll learn how to customize your chart with chart objects such as legends, a chart title, or a plot area using Excel.

01:28

In this lesson, you’ll learn how to create trends with trendline.

01:10

In this lesson, you’ll learn how to add sparklines to illustrate data trends at a glance.

01:32

In this lesson, you’ll learn how to wrap text, center-align printed data, and how to center text across columns without merging cells.

Section 6: Increasing PowerPoint’s Potential
01:04

This chapter offers some tips on how to create PowerPoint presentations to convey all kinds of messages to an audience.

00:58

In this lesson, you’ll learn how to insert a hyperlink directly into your PowerPoint slides.

00:38

In this lesson, you’ll learn how to add an equation to your PowerPoint slides.

00:42

In this lesson, you’ll learn how to create a self-running PowerPoint presentation.

01:03

In this lesson, you’ll learn how to write on a slide during a PowerPoint presentation.

00:30

In this lesson, you’ll learn how to create speaker notes so you can help people follow along with your PowerPoint presentation.

01:09

In this lesson, you’ll learn how to compress media files so your PowerPoint presentation doesn’t take up too much space.

00:52

In this lesson, you’ll learn how to turn a presentation into a video that includes all of your assigned transitions, narration, slide timings, and animation.

00:54

In this lesson, you’ll learn how to copy a PowerPoint presentation to a CD.

00:58

In this lesson, you’ll learn how to broadcast a PowerPoint presentation, live and synchronized, to friends or colleagues no matter where they are.

Section 7: Enhancing Your Presentations
01:47

This chapter highlights some of the features you can use to enhance your PowerPoint presentation visually.

00:55

In this lesson, you’ll learn how to insert a custom slide master into a PowerPoint presentation.

01:39

In this lesson, you’ll learn how to streamline your PowerPoint presentation with themes.

01:20

In this lesson, you’ll learn how to insert a SmartArt graphic or diagram into your PowerPoint presentation.

01:50

In this lesson, you’ll learn how to add video or sound to your PowerPoint presentation.

01:20

In this lesson, you’ll learn how to edit a video from within your PowerPoint presentation.

01:05

In this lesson, you’ll learn how to animate the items on PowerPoint slides for added interest.

01:14

In this lesson, you’ll learn how to create a photo album presentation for projects that rely more on illustrations than text.

Section 8: Streamlining Outlook Tasks
01:08

In this lesson, you’ll learn how to add multiple e-mail accounts in Outlook.

01:14

In this lesson, you’ll learn how to create your own Quick Steps to increase productivity and conquer several actions at once.

00:44

In this lesson, you’ll learn how to create a distribution list, which is helpful when sending e-mails to a group.

01:44

In this lesson, you’ll learn how to encrypt a message so only recipients with the necessary key can decipher the message.

01:26

In this lesson, you’ll learn how to recall a message in case, after sending a message, you realize it contains an error.

01:35

In this lesson, you’ll learn how to manage messages using rules.

01:17

In this lesson, you’ll learn how to clean up folders and conversations with Outlook’s Clean Up tool.

01:17

In this lesson, you’ll learn how to filter junk e-mail with Outlook’s Junk E-Mail folder.

01:40

In this lesson, you’ll learn how to archive e-mails to create space and how to view archived e-mails when you need them.

01:08

In this lesson, you’ll learn how to subscribe to RSS – or Really Simple Syndication – feeds.

Section 9: Managing Multiple Priorities with Outlook
03:01

In this lesson, you’ll learn how to create an electronic business card using a contact entry from Outlook.

01:17

In this lesson, you’ll learn how to use Map It to locate an address.

01:04

In this lesson, you’ll learn how to categorize an Outlook Item.

00:58

In this lesson, you’ll learn how to send a snapshot of your calendar to others.

00:57

In this lesson, you’ll learn how to view two calendars in Overlay mode.

00:42

In this lesson, you’ll learn how to record journal entries automatically to save time and be more efficient.

00:38

In this lesson. You’ll learn how to delegate a task to another person.

Section 10: Creating Pizzazz with Office Graphics
01:37

In this lesson, you’ll learn how to capture a picture of your screen using Screenshot.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Founded in 1807, John Wiley & Sons, Inc. has been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace.

Wiley is a global provider of content and content-enabled workflow solutions in areas of scientific, technical, medical, and scholarly research; professional development; and education. Our core businesses produce scientific, technical, medical, and scholarly journals, reference works, books, database services, and advertising; professional books, subscription products, certification and training services and online applications; and education content and services including integrated online teaching and learning resources for undergraduate and graduate students and lifelong learners. Wiley's global headquarters are located in Hoboken, New Jersey, with operations in the U.S., Europe, Asia, Canada, and Australia. The Company is listed on the New York Stock Exchange under the symbols JWa and JWb.

Ready to start learning?
Take This Course