1 / 46

Microsoft Office 2013

Microsoft Office 2013. Bob Gill Robert.Gill@k12.sd.us. Microsoft Word 2013. Bob Gill Robert.Gill@k12.sd.us. What New for Word 2013?. You can open and edit a PDF in Microsoft Word 2013  Changes it to MS Word File Button instead of the Office Icon Button. Office Word 2007.

jorryn
Download Presentation

Microsoft Office 2013

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Office 2013 Bob Gill Robert.Gill@k12.sd.us

  2. Microsoft Word 2013 Bob Gill Robert.Gill@k12.sd.us

  3. What New for Word 2013? • You can open and edit a PDF in Microsoft Word 2013  Changes it to MS Word • File Button instead of the Office Icon Button Office Word 2007 Office Word 2013 Clicking on the 2007 Button Opens the Following: Clicking on the 2013 Button Opens the Following:

  4. View Tab on Ribbon  Turn on Ruler (Make Sure Ruler is Checked) •  Set Zoom (100%, One Page, Page Width)  Split Document into two Windows  View Side By Side two open Documents • Must have Two Documents Open

  5. Review Tab • Check Spelling and Grammar, • Define, Thesaurus • Share and edit Documents between multiple persons

  6. Mail Merge Tab •  Create a Merge letter  Word uses an Access Database (created in Word) to merge data to Letter Merge Steps  Open a New Word Document Select Recipients  Type a New List Choose Customize Columns  Add, Delete, Rename Category Names Click OK to SAVE the DATA- REMEMBER WHERE YOU SAVE IT

  7. Mail Merge Tab After you Save the Database, Field Names can be Merged into the Document Click Preview the Results, to See Data entered from the Database Click on the Next Record toSee the Second Record

  8. Reference TabDesigned for Research Papers • Table of Contents Feature •  Most Common Style is MLA or APA •  Easy to insert Footnotes • or Citations •  Citations can be Inserted into a Bibliography All Citations will be Inserted into a Bibliography at the end of the Paper

  9. Page Layout Tab Margins, Alignment, Spacing, Tab Sets, Breaks, Indents, Columns & Text Wrapping Layout Tab Notice Fly-out Arrows Page Setup: Margin Tab  Custom MarginsLayout Tab  Vertical Alignment on a page Vertically Center Page Content Note: If text on 2nd page is Top aligned, this must be changed back to Top Alignment

  10. Page Layout Tab Margins, Alignment, Spacing, Tab Sets, Breaks, Indents, Columns & Text Wrapping Paragraph Fly-out Arrow  Single Space  Set Before and After spacing to Zero  Tabs Sets Tab Stop Position Left, Right, Center, & Decimal Leader Dots  Change Margins and Orientation (Landscape or Portrait) Leader Dots For True Single Spacing, Line Spacing must be set to “Single”, and “Before and After” Spacing set to Zero Choose OK  Setting Tabs

  11. Page Layout Tab Margins and Orientation can also be Changed by Clicking the Buttons

  12. Page Layout Tab- Columns Choose Columns  More Columns Check This to put Lines Between Columns

  13. Page Layout Tab Page Breaks Most Common Breaks Breaks Text from One Column to the Next Column To see Breaks, spaces and Paragraph Marks, turn on Show/Hide from the HOME TAB Breaks to the Next Page Starts a New Section Needed to Switch from One Column to Two Columns

  14. The Ruler- Indents Right Indent Left Indent

  15. Wrap Text-This is also available by double clicking on the Picture Page Layout- Wrap Text around Picture

  16. Design Tab Color and Font Themes Watermark- Faded picture behind the text on a page

  17. Insert Tab- Headers The Header Dropdown has Several Custom Headers

  18. Insert Tab- Footers

  19. Insert Tab-WordArt Word Art Choices

  20. Insert Tab Shape Choices

  21. Insert Tab

  22. Insert Tab Drop Cap

  23. Insert Tab Make Table  Format Table Styles Formatted Table Double Click On the cross Arrows to select And choose a Table Style Choose the number of rows and columns by dragging across and down

  24. Insert Tab  Add a Graph – Choose Object Button Chart Choices Choose Object Select the Table by double click the left Top arrows Right Click on the White are of the Graph to Change Chart Type Exit the Data Sheet and Stretch the Borders of the Graph Chart to fit Under the Table

  25. Home Tab- Fly-out Arrows Clipboard Fly-out  Use Clipboard to copy between documents  (Word to Word- Word to Excel) Clipboard stores up to 24 Items Font Fly-out arrow:  Font and Font size- Shading and color  Shadow, Sub-scripts, Superscripts Paragraph Fly-out  Same as the Page Layout Paragraph Fly-out Single Space - remove before and after Spacing Changes can be set as default

  26. Home Tab- Highlight the Format to be duplicated  Click the Painter  Drag Text to Paint Format Painter to duplicate format to different text

  27. Home Tab Line and Paragraph Spacing Change case- upper, lower, capitalize first letter of each word Increase and Decrease Fonts Justification Left, Center, Right and Full Justified • Bullets and Customized Bullets • Use the Increase and Decrease Buttons to Indent Bullets • The Tab key also works for Indentation • Shift + Tab will Decrease the Indentation

  28. Home Tab Continued Borders and shading  Click the Dropdown  Borders and Shading Paragraph Marks to see all Formatting Clear Formatting  Changes back to Default Font Find and Replace  Search Document for Text

  29. Home Tab Continued  Advanced Shadowing  Bold, Italic and Underline  Highlighter and Font Color  Paint Bucket- Shading behind words  Styles Canned Fonts

  30. Microsoft Excel 2013 Bob Gill Robert.Gill@k12.sd.us

  31. Workbook Vs. Spreadsheet Change Names of Tabs by Double Clicking each Tab This Workbook Contains 3 Individual Spreadsheets

  32. Workbook Vs. Spreadsheet

  33. Workbook Vs. Spreadsheet

  34. Spreadsheet Overview Process to Widen Multiple Rows at once  Select the Columns or Rows in the Letter area above the Cells Selected Columns Are Changed Drag the Right Edge of one of the Columns, and all the selected one Will change Widths

  35. More Spreadsheet Information • Cells can either contain Text or Numbers. Do NOT put dollars signs or commas on numbers • All Formulas start with an Equal Sign (=) • Example of a Summation Formula  =SUM(B5:B12)  Sums column from B5 to B12 • Example of Multiplying two cells  =C3 * C4 • Division Sign  / Times  * Asterisk • 5 to the 3rd Power =5^3 Add  + Sub - • Change the Format of a Cell(s)  Right click on cell(s) Choose Format Cells  Number Tab • Popular Formats  General, Number, Currency, Accounting, Date, Time & Percentage

  36. Selecting Non-Adjacent Rows or Columns • To Select Non-adjacent Rows or Columns (Used for Pie Graph Charts or Combo Charts) • Select the First Range by Dragging • Hold the Control Key down and Select the 2nd Range

  37. Selecting Non-Adjacent Data Continued

  38. View Tab Freeze Panes or Split windows Froze Froze

  39. Review Tab Spelling (not done automatically), Thesaurus, Protection • When you Protect a Spreadsheet- ALL Cells in the Spreadsheet are locked •  This feature is Password Protected •  Before You Protect, Right Click on All Cells that can be edited •  Choose Format Cells Protection Tab •  Uncheck the Locked Checkbox

  40. Data Tab Mainly For getting External Sources of Data • (From Access, From Text File)  Filtering and Sorting Data Formula Tab One way of inserting Formulas –  AutoSum (Also on the Home Tab)

  41. Page Layout TabSet Margins, Orientation (Landscape-Portrait), Themes, Gridlines Scale to Fit Fly-out  Print Spreadsheet on One Page Print Spreadsheet to one Page Margins can be setup in either of these Select the Area to Print

  42. Insert Tab

  43. Home TabFormats, Alignment, Merge and Center, Conditional Formatting and more Clipboard Fly-out Arrows Copy and Paste Data between Sheets or Applications  Can Hold 24 items in the Clipboard Font Fly-out  Superscripts, Subscripts & Font Manipulation Also exposes other Tabs (Number, Alignment, Border, Fill, Protection) Alignment Fly-out  Change the direction and position of the text in a cell Number Fly-out  Formats cells (General, Number, Currency, Accounting, Date, Time, %)

  44. Home Tab Merges Cells that are Selected, and Centers Text in their Range Vertically Aligns text  Top, Middle or Bottom of the Cell Paints the Format from Highlighted cell(s) to Other Cells Cuts (Control +X), Copies (Control)+ C and Pastes (Control +V) Text that meets certain conditions such as:  Is the Number Less than 20 (see below)  Data Bar Colors depend on the size of the number in each Row or Column

  45. Home Tab Utilities Continued Autosums a Column or Row – Use only when Adjacent Cells Used to Spice up the Data Cell Borders Fill Cells with Color and Change Font Color Format Accounting, Percent or Commas Right click on the cells and choose Format Cells For Currency and other formats Left, Center and Right Justify Cells

  46. The End Microsoft Office 2013 Bob Gill Robert.Gill@k12.sd.us

More Related