This is a course about using Microsoft Office 365 on your PC, Mac, tablet, or Smartphone. It covers all of the mainstream applications that most schools and office environments demand: Word, Excel, Outlook, and PowerPoint. You'll also learn to use the exciting newer features of Office 365 including OneDrive, OneNote, and the new capabilities for publishing interactive content online, for free, without a website and without knowledge of web design.
This not a course for people who want to specialize in computers, but rather for people who need to use a computer as part of their non-computer job or coursework. If you are frustrated in school or work due to insufficient Word, Excel, Outlook or PowerPoint skills, this course will serve you well. If you have access to Office 365 through school, work, or your personal computer, and you have basic computer skills like knowing how to click, drag, and right-click, then you have what it takes to succeed in this course.
All lessons are video tutorials, averaging about 10 minutes each, that are easy to understand and follow. Practice activities and hands-on exercises give you the experience you need to master the most essential skills you need to master these important apps. And the new cloud-oriented approach found in Office 365 makes it easier to access all your Office files using your favorite computers, laptops, tablets, and phones. So all your information is just a few clicks or taps away. You can also share or publish your documents online for free.
You'll also learn all the new ways that Office 365 allows you to easily publish online, for free, through Docs.com, Mix, Sway, and OneDrive, even if you know nothing about web design. You'll even discover ways to convert business cards and written documents to editable, searchable files and Outlook contacts.
This course is taught by award-winning author and instructor Alan Simpson who has been called a "mastered communicator" and whose courses always generate rave reviews from non-computer people and computer experts alike.
Get a quick overview of what Office 365 is all about, what you will learn from this course, and a brief introduction to your instructor.
In this lecture you'll learn to open Word, Excel, PowerPoint, and all your other Office 365 apps on any computer or mobile device...even those that don't even have the Office apps installed.
It's great that you can access Word, Excel, PowerPoint, and other Office apps from any computer or mobile device in the world. But you also need access to the documents and files that you create using those apps. That's where OneDrive comes in. In this lecture you learn how to use OneDrive to access your documents from whatever PC, Mac, iPhone, iPad, iPod Touch, Android phone, or Chromebook you happen to be using at the moment.
Here you'll try out some of the things you've learned to strengthen your new skills. If the challenge is easy...great,..you're good to go. If you hit any snags, come by the discussion area and we'll get everything squared away so that you can forge ahead full-steam.
This optional lecture shows you how to create your own Docs.com website, for free, in about 5 minutes flat. No web design, Dreamweaver, WordPress, HTML, or other specialized knowledge required. During the course, you can use the site to show your work to your instructor and classmates, or get help with projects that just won't to bend to your will. When the course is over, you can keep the site, forever, for free, and use it to distributes photos, videos, Word documents, PDFs files, PowerPoint presentations, slideshows, screen recordings, interactive tutorials, Excel worksheets...whatever suits your fancy...to friends, family, teammates, club members, church congregants, students, customers, the world at large...any audience you wish!
Test your knowledge of basic skills and terminology
Here you'll learn the most important fundamental skills for typing and editing in Microsoft Word, and virtually all computer apps. You'll master the most important everyday computers skills of navigating documents, editing, using select-then-do, undo, redo, shortcut keys and more. So you're never "stuck" again.
In this lecture you learn to use Word templates to speed and simplify typing all kinds of documents. You'll discover lots of tips and tricks for simplifying even larger multi-page documents with pictures, Smart Art, and automatic Tables of Contents.
Word Styles are the best way to streamline your writing efforts and ensure a professional-looking end product. When you finish this lecture, you'll be able to use styles to streamline the formatting and appearance of documents you create from templates, as well as documents you create from scratch. These same techniques are used throughout the professional publishing industry and in web design.
When you finish this lecture, you'll be able to add all kinds of pictures to your Office 365 documents, including photographs, clip art, screenshots, shapes, SmartArt, and business charts.
In this lecture you'll learn to size and position your pictures like a pro, and add some special and artistic effects too, to really make them pop!
When you finish this lecture you'll know how to create bulleted, numbered, and multi-level lists. You'll know how to automatically alphabetize those lists. And you'll know how to add professional polish to your creations by styling lists or converting them to more visually appealing SmartArt.
Tables are used in many kinds of written documents, and when you finish this lesson, you'll have the skills you need to create and style any table in any Word document you create.
Cover pages, page numbers, headers, and footers are common in business documents as well as school assignments. By this lecture's end, you'll have mastered them all.
When you finish this lecture, you'll know how to print your document, as well as how to control page layout fratires like multiple columns, page orientation, and margins.
Here you'll harness some of the most powerful features of Microsoft Word. You'll learn how to translate your documents to other languages. You'll discover the collaboration techniques used by professional authors and editors. And you'll finish by know how to share your documents with anyone online, and control who can view, and who can edit, those documents.
Here you'll find a hodgepodge of using tips and techniques, including cut-and-paste, fixing imported documents, adding hyperlinks to your documents, converting to PDF, and publishing your creations to your Docs.com website.
Use this quiz to verify that you understand the basics of Microsoft Word.
This is a hands-on practice activity to try what you've learned about Microsoft Word. Download the EagleEdit1.docx file from the Resources, and edit it as per editorial comments in the text. If you need some help, you can watch me do it in the video for this lesson.
In this lecture you'll learn what Excel is all about, how to start it on any computer, tablet, or phone, and some basic skills and terms that are required for using Excel well.
Here you'll discover how to find good worksheets, so you don't need to re-invent the wheel, and also how to unprotect worksheet templates to use as a starting point for your own creations.
When you finish this lecture, you'll know how to create an Excel worksheet, from scratch, complete with text, numbers, a formula, and some nice formatting to make it look good.
Here you'll apply what you've learned about Excel so far to add professional-looking business charts to your Excel worksheets.
Formulas are the brains of every Excel worksheet. In this lecture you'll learn how to write simple formulas, as well as more complex formulas using functions and named cells. And also, how to look like a math whiz without being a math whiz.
When you finish with this lecture, you'll know how to use Excel conditional formatting to add some real professional polish to your worksheets.
It's frustrating, and all too easy, to mess a perfectly good worksheet with a minor typographical error. When you finish the lecture, you'll know how to protect your Excel worksheets from such catastrophes.
This is your hands-on practice activity for Excel. You can grab the assignment out of the Resource materials and try it on your own first. Then, if you have any problems, or are just curious about how somebody else might do it, watch the video that accompanies this lecture.
As you'll learn in this lecture, PowerPoint is all about presentations. But PowerPoint isn't just about presentation where you stand in front of an audience anymore. Now you can use it to create and publish interactive videos online. In this lecture you'll learn the basics of starting PowerPoint and creating a presentation.
Every PowerPoint presentation starts with slides, and when you finish this lecture you'll know how to create your own slides with text and pictures.
This lecture shows you how to use PowerPoint animations to add professional polish and visual excitement to your presentations.
You'll know how to add exciting transition effects to your presentation at the end of this lecture. And how to convert a presentation to a standalone slideshow that you can publish online.
When you finish this lesson you'll know how to add lengthier videos to your PowerPoint presentations, whether they're videos you took yourself, or those you downloaded. And you'll also learn some more powerful techniques for creating animations.
Music, sound effects, and vice narration can really add a lot to a PowerPoint presentation. When you finish this lecture, you'll know how to incorporate all three types of sounds to you presentations.
Here's you'll learn to present your PowerPoint presentation in front of a live audience. You'll also learn to share your presentation online on YouTube, Facebook, Twitter, Pinterest, your web site or blog. Here's where you'll also discover Office Mix, for publishing interactive PowerPoints and videos online.
For your PowerPoint Hands-On Activity, I'm going to challenge you to create a slideshow. You can use you own photos if you like. And you can share it with the class if you like (though you're not required to share anything)., The details are in the Resources section for this lection. The video in this lecture is optional, and just shows how I might go about creating and sharing such a slideshow.
Many businesses and other large organizations used Outlook for e-mail, scheduling meetings, and more. So you'll want to know what Outlook is all about before going to any job interviews where Office 365 knowledge is required (or assumed). This lecture will get you started with the basics of using Outlook on a PC, Mac, or online.
Even if you use Apple Mail, Gmail, or something else for you personal e-mail, if you get a job with a business e-mail address of your own, chances are you'll be expected to know how to use Outlook for that e-mail. This lecture will show you want you need to know about sending, receiving, replying, forwarding, attaching, and all that other good e-mail stuff in Outlook.
Using Outlook as an electronic address book can really come in handy sometimes. In this lecture you'll see what, and how.
Many large organizations rely heavily on outlook Calendar for appointments and meeting requests. When you finish this lecture, you'll know just what you need to know about those things to survive in the modern business world.
Whether your managing your own To-Do lists, or delegating tasks to others, Outlook Tasks, which you'll discover in this chapter, will surely help you stay on top of things.
See the external resources for the Hands-On Practice Activity for Outlook. If you encounter any bumps in the road while completing this lecture's assignment, or just want to see me do it, watch this lecture video. Of course, if you have questions, you can post them in the discussion area.
OneNote is a great tool for organizing and other content on-the-fly. In this lecture you'll learn how to master all the best features, including OneNote Clipper.
Office Lens is a great free app for Apple, Android and Windows mobile device that lets you take photos of business cards, whiteboards, paper documents, and photos. You can store them in OneNote and make them searchable...even automatically convert business cards to Outlook contacts without typing any text at all.
Sway is a easy new way to publish, online, photos, slideshows, stories, and more. You don't need a web site or any knowledge of HTML or WordPress to use it. And it's completely free, but the app and the publishing. In this lecture you'll learn how to master this important new tool for publishing online.
Alan Simpson is the award-winning author of over 115 computer books published throughout the world in over a dozen languages. He has also been an instructor for nearly four decades, having taught thousands of students throughout the world. He has often been called a "master communicator" and consistently receives high ratings the positive reviews from his students.
Alan has been deeply involved in tech since the earliest days of personal computing, serving first as programmer and consultant, and more recently as a web developer. However, his masters degree in the psychology of learning and motivation prepared him well for sharing his extensive technical knowledge. His courses have ranged from beginner basics to advanced web programming.
Currently Alan has online courses on Ed2Go, Teachable, Skillshare, and Udemy. He also holds COMPTIA Security+ and Hootsuite Academy Social Media Marketing Credentials.