Microsoft Office Tutorial

1. Microsoft Office Tutorial Produced by Naveen Albert Produced using Microsoft PowerPoint 2010

2. Microsoft Office Overview • Microsoft Office is the world’s most advanced office-suite and is produced by Microsoft Corporation • The latest version is Office 2013, and comes with Windows 8.1

3. Microsoft Office Types • The main forms in which you can get Microsoft Office are: • Student Edition: Includes Word, PowerPoint, and Excel and OneNote • Professional Edition: Includes Word, PowerPoint, Excel, OneNote, Access, Outlook and Publisher (other programs may be available)

4. What do I need to get Microsoft Office? • Microsoft Office is not free and must be purchased • A good place to purchase Office would be at the Microsoft Store or Office Depot. • If you are employed at an office, your employer has most likely already installed Microsoft Office Professional onto your computer • Your computer must have Windows XP, Windows Vista, Windows 7, Windows 8 or Mac iOS (limited features) to run Office.

5. General Tips and Tricks • Pressing CTRL+A will highlight ALL of your text. • Pressing CTRL+S will save your document. • Pressing ALT+TAB will switch between multiple windows open on your computer. • If you want to make sure that your file is up to date, make sure that the file name at the top does not read [Compatibility Mode] in addition to the document. To convert to a newer layout, click File, Info, and then click Convert. • CTRL+C is the keyboard shortcut for Copy. CTRL+V is the keyboard shortcut for Paste.

6. Bill Gates • “Computers were invented to solve problems that didn’t exist before.” -Bill Gates

7. Microsoft Word Overview • Microsoft Word is the world’s most advanced word processor. It does cost money, but if you have a Microsoft Account, you can use Microsoft Word for free by logging into SkyDrive (now OneDrive). You can also use PowerPoint, Excel and OneNote for free by logging into SkyDrive. • Microsoft Word is include in the Student Edition of Microsoft Office.

8. Basics of Microsoft Word • The image on the right Is what Microsoft Word Looks like when it opens. • To start typing a basic document, start typing. Press ENTER and TAB to start a new paragraph.

9. Home Page Features • A number of items are available on the Word home page. • The Font options are circled in blue above. You can also pressCTRL+SHIFT+P to pull up a full font menu • Calibri is the default font in Microsoft 2007 and later. To change the style to 2003 or before, click Change Styles in the far right corner of this panel. Then click Change Styles> 2003. • The default font size is 11 in Microsoft Word 2007 and later. To change the size, click the arrow next to the button.

10. Other Font features • You can also customize how your font looks by using the menu circled in blue. Bold, Italics, and underlined are all font customizations that you can make. CTRL+B, CTRL+I, and CTRL+U are the respective keyboard shortcuts that you can use. • Strikethrough, Subscript, and Superscript are more advanced formatting options.

11. Other Home Page Features • The Paragraph panel includes alignment, spacing, background color, bullets, numbers and a number of other features. • Click the top leftmost button in the Paragraph panel to start a bulleted list. Click the number to start a numbered list. Typing 1. will also by default start a numbered list. If you press ENTER, and then TAB, it will automatically start an embedded bulleted list. • The default in Microsoft Word is left page alignment. To center the text you have highlighted, press the according button. Pressing CTRL+L, CTRL+E, and CTRL+R, will also align your text.

12. More Home Page Features • The Styles Panel is changing for changing your font to a preset style. Clicking Change Styles and then hovering over Style Set will display options to toggle between current and outdated Word layouts. If your document is outdated, go to Style Set and click Word, followed by the latest year available. • The Find option will find text in your document. CTRL+F also pulls up the Find task. Clicking Replace will find and replace text in your document. • There are more options available, but these will not be covered in this tutorial.

13. The Insert tab • The Insert tab displays a number of useful features that you can use to enhance your document. • The Pages Section of the Insert Tab is advanced, but one of the most useful commands available.

14. The Pages options • The Pages section displays formatting options that visually enhance your document. • The Cover Page option will insert a cover page (like in a book) into your document. A number of themes will automatically be displayed. If you choose, connect to Office.com for more themes. • The Blank page option inserts a blank page into your Word document. This is not a commonly used feature, but can be useful. • The Page Break tool can be very useful. If you want to separate your text to the next page after a certain point, click the beginning of the text that will be sent to the next page and then click Page Break.

15. Creating Tables • Creating Tables are an extremely useful resource • To create a table, click Insert and then click Table. • A Quick and Easy Table option will be displayed. These are for small tables. • To customize your table, click ‘Insert Table.’

16. Illustrating your document • Use the Illustrations section of the Insert tab to include Pictures, Shapes, SmartArt, Charts and more into your Word document. • The most common prompt is Picture. Click Picture and then select the file on your computer that you would like to insert.

17. Hyperlinking Text • A useful feature of Word is hyperlinking text. • Internet urls are hyperlinked automatically by default. To hyperlink ordinary text to an internet address, email or file, right click the word or words and then click Hyperlink from the Links menu. • Linking to other files can be extremely useful at times. However, you must be aware that if you send a copy of the current document to a recipient and not the attachments as well, the hyperlinks will not work. • Be aware that any changes to your file’s location will discontinue the hyperlink.

18. Header, Footer, and Page Number • The Header and Footer are extremely useful tools. They can affect every page of your document by only typing it once. • To insert page numbers into your document, click Insert and then Click Page Number. • To insert a Header or Footer, you can click Insert and then header and footer, or double-click on the header and footer in your document.

19. Enhancing Your Word Document- Additional Features of the Insert Tab • There are multiple features on the Insert page that are not commonly used but can be useful. • Click Text box to insert a Text box into your document. • You can also insert dates, equations and symbols in the Text, Symbols and Flash sections of the Insert Tab.

20. Page Layout • The Page Layout option will help you enhance the layout of your Word document. • You can change the Page color by going to the Page Background section and clicking Page Color. • You can orient your document Portrait or Landscape by clicking on the Orientation button in the Page Setup section of the Page Layout tab. • More advanced options are also available.

21. References • The References page can add footnotes, Table of Contents or Citations. • To insert a Table of Contents, click Reference, and then click Table of Contents. You will need to choose from bookmarks or headings throughout your document, and refresh your table when changes are made. It is recommended that only advanced Word users use this function.

22. Mailings • The Mailings tab is used to Send and Receive text, as well as merge to an Adobe PDF format. These are all advanced options, and are not needed for the standard user. However, these become useful when you are merging or sending to recipients. This is compatible with Microsoft Office Outlook.

23. Review • The Review tab is a tab that allows you to comment, track and proofread your document. • Click New Comment to comment on a section of your document. These can be useful if someone sends you a document to proofread and you would like to critique their work. • The Proofing panel can be used to proofread your document. • If you want to get rid of a comment, click Accept or Reject in the Tracking panel. • Word also lets you restrict editing of your document. This is available in the Protect panel.

24. View • The View page lets you control how you read a Word document. • The default view is Print Layout. To change views, select a view in the Document Views panel. • By default, Word will show a ruler in the Word window. To get rid of the ruler, uncheck the Ruler box in the Show section. • You can change your Zoom here, or at the bottom of your document by sliding the bar or customizing the number. • Addition features are available.

25. Acrobat • The Acrobat tab may not appear on your computer. This will depend on the software installed on your device.

26. The File page • The File page redirects to Info in Word 2010 and later. • You can password protect your document from the Info page. • You can view all the statistics about your document, such as total editing time, pages, size and authors from this page. • You are able to Print, Close, Open, Create and Save Word documents from the File Page. • You can access Help by clicking Help.

27. Options • The Options window controls options for Microsoft Office and Microsoft Word. • The default style in Word 2010 and later is Silver. To change to Black or Blue, click the drop down menu that appears and select. • You can click pages apart from the General menu for advanced settings.

28. How to access Word • You are able to access Microsoft Word by a means of multiple ways • Create a Microsoft Account. Login to SkyDrive and create a Word document. • Open Microsoft Word on your computer. Click Start, All Programs, Microsoft Office, and then click Word. • There are other ways to access Word but these are the most common. • Note that installing Word on your computer requires activation and is not free.

29. Microsoft Word • These are the basics of Microsoft Word! However, the best way to learn how to use is not to learn from a tutorial or a person! In fact, the best way to learn is to learn yourself and explore Word on your own! No tutorial would ever be able to discuss everything that there is to learn about Word. The only way to learn is to explore it yourself!

30. End of Microsoft Word Tutorial This is the end of the Microsoft Word Tutorial

31. Microsoft PowerPoint Overview • Microsoft PowerPoint is one of the world’s leading presentation software available. • Microsoft PowerPoint is included in the Student Edition of Microsoft Office. • You can access PowerPoint for free by logging into your Microsoft Account and going to SkyDrive.

32. Microsoft PowerPoint • This presentation was created using Microsoft PowerPoint. It is not the most advanced presentation that exists. By using PowerPoint, you can animate your presentation, control and time your transitions, play a beautiful slideshow, and include fun and intriguing designs.

33. Home • This is what Microsoft PowerPoint will look like when you open it on your computer:

34. What should I do first? • Unlike Word, in PowerPoint, it is recommended that you make any formatting and style changes before you begin more than a few slides. When using PowerPoint, you typically want to choose a title and then click the Design tab.

35. Start Your Presentation • Start your presentation by choosing a title and then typing your name or a subtitle into the box below that. • Do not worry about the appeal of your presentation yet. That will come later. By the end of this tutorial, you will learn how to design a fast, fluid presentation.

36. The Design tab • As you can see, I have now chosen a Design or theme for this Presentation.

37. Choosing the right Transition • As you can see, the screen is darkened because it is in the middle of a transition. If you look at the Transitions menu, you can see that the Fade transition is selected.

38. As you can see, the title is being animated- if you look at the menu- you can see that it is bouncing in. You’ll be able to choose your own animations. Select what you would like to animate and then choose how you want to animate it.

39. What’s Next? • Now that my presentation has a design, has a transition and has an animation, we can now add content. • Note: You will have to repeat the Transitions and Animations options for everything you would like to do that for. Employers look for a consistent Transition when designing a presentation, so for the best outcome during a speech, only use one or two types of transitions. • Also note that clicking on a slide at the left side of the window and then hitting CTRL+A and then applying changes will automatically change all of the slides.

40. Your text • A lot of the features are similar to the features in Microsoft Word. You can change the font and the size of it like in Microsoft Word. The File, Home, and Insert pages are similar to what you may have seen before. However, some of the pages you see are unique to Microsoft PowerPoint.

41. Presenting your Presentation • When presenting your presentation: • Click or use the down or right arrow keys to advance to the next slide. • Be aware that animations are introduced in the order that they were applied. If you animate a square and then the word OF, the square will appear when you advance the presentation, and the word OF will appear next. • Click the Slide Show button to present your presentation. Or, click the icon next to the zoom slider in the right hand corner to present directly.

42. Presenting your PowerPoint • Typically, you will click From Beginning to start your presentation over in presentation mode. • If you want to start presenting from the slide that is selected in the menu, then click From Current Slide. • A number of other features are available.

43. More Advanced Features • Again, the best way to learn all the features of PowerPoint is to do it yourself. Customize and create an advanced presentation using PowerPoint software today!

44. Microsoft Excel • Microsoft Excel is a workbook that contains ‘worksheets’ or spreadsheets. • Microsoft Excel is includes in the Student Edition of Microsoft Office • Access Microsoft Excel for free by logging into SkyDrive

45. What can I Use Excel For? • Excel can be used as a giant calculator, an organized for immense amounts of data, creating sophisticated charts, and more!

46. Upon Startup • This is what Excel looks like when you first open Microsoft Excel:

47. Microsoft Excel- What do I do first? • Microsoft Excel is similar to Microsoft Word; there isn’t something that you should do first; you can do whatever suits you. • In this tutorial, I will show you how to use formulas, charts, and tables.

48. Naming your Spreadsheet • Rename your current spreadsheet by right clicking on the worksheet you wish to rename and clicking rename. You can also Delete, Move, Copy and do a variety of different things in this manner.

49. Inserting a Formula • Inserting a formula in Excel is really quite simple: Just click the Formulas page.

50. Types of formulas • There really is no end to what you can use formulas for. You can use them to add, subtract, average; almost any mathematical computation. • For the purposes of this tutorial, we will be adding. • Adding is performed by clicking AutoSum and then Sum. • NOTE: If you are fluent with Excel, you are also able to directly type in the code for a specific formula into the cell. However, it is not recommended that beginners do this. Also note that Excel does not perform Spell Check by default.