1 / 54

Welcome to: PowerPoint 2013/2010 day 2

Class will be from: Now – 4:30 (?). Remote Student Cynthia Say Hi to Gene . Friday!. Welcome to: PowerPoint 2013/2010 day 2. With Your Instructor: Gene Moirao {Mo-ray-o}. Can you access “I” drive? .

cora
Download Presentation

Welcome to: PowerPoint 2013/2010 day 2

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. Class will be from: Now– 4:30 (?) Remote Student Cynthia Say Hi to Gene  Friday! Welcome to: PowerPoint 2013/2010 day 2 With Your Instructor: Gene Moirao {Mo-ray-o} Can you access “I” drive? 

  2. Time to introduce yourself name your experience with… your expectations

  3. Now it’s my turnSomething about ME! Gene  Question Answer ! Problem Solver !

  4. Manuals on-line @ www.LearnIT.com/manuals Username: manuals Password: password

  5. Handouts on-line @ www.LearnIT.com/HandOuts

  6. Word 2010/2007 mod 3 10-15-09 Setting tabs in a document Creating tables in a document Formatting tables Sorting and Calculating table data "Drawing" tables in Word Applying and displaying styles Create a custom style Modify and delete a style Using styles to create documents Replace styles

  7. Evaluation Time! ShortCut on Desktop Left Starting from the left: * Choose Class Type: = Private Event * Select Account: = Your Company Name * Select Course: = Todays Topic * Follow simple instructions from here.

  8. Now something about YOU!

  9. Evaluation www.LearnIT.com/Evaluation No “S”

  10. Access 2010 mod 3 (Queries) Remember day 1? Create select queries Use criteria to refine query results Create multi-table queries Create query joins Implement query parameters Performing calculations in a query

  11. Class Files @ www.LearnIT.com/Files GENE the Instructor Excel…..

  12. Evaluation Time www.LearnIT.com/Evaluation Starting from the left: * Choose Class Type: = Private Event * Select Account: = Your Company Name * Select Course: = Todays Topic * Follow simple instructions from here. No “S”

  13. Excel 2010/2007 mod 3 • Rules for proper list design • Formatting a list as a table • Single, Multi-level sorting & Custom sorting • Removing duplicate values from a list • Filtering data in a list using custom and multiple condition criteria • Inserting automatic subtotals in a list • Creating Sparklines in Excel (2010 only) • Creating charts in Excel • Modifying and formatting chart types and chart elements • Modifying Themes to effect chart formatting • Adding or deleting data from a chart • Creating custom chart templates 10.06.09

  14. We Remember… 10% of what we read 20% of what we hear 30% of what we do 50% of what we hear & do 70% of what we discuss with others 80% of what we experience personally 95% of what we teach someone else

  15. Excel 2010/2007 mod 1 • Introduction to the Excel 2010/2007 Interface (The Ribbon, The Backstage View& The Quick Access Toolbar) • Zooming in and out of a worksheet • Navigating and selecting cells • Keyboard Shortcuts • Entering and editing data • Deleting/replacing cell data • Performing simple calculations • Saving the workbook file • Checking compatibility with older versions of Excel • Overview of the Formulas Ribbon • Building basic Formulas • Using simple Functions • Copying formulas/functions with the AutoFill command • Using Relative and Absolute cell references in calculations

  16. Tips for Retention1) You have to be present to win!2) Avoid distractions (FB, cell, emails)3) Take notes4) Apply new concepts to real work5) Ask questions6) Use it or lose it

  17. Project 2007 mod 1 Tour MS Project Create a Project Calendar Add Tasks Enter Task Durations Summary & Project Summery Tasks Links (4 types) and Lead/Lag Milestones& Constraints

  18. Access 2007 mod 1 Introduction to database design concepts & terminology Become familiar with the Access 2007 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips Open and examine and existing Access database Working with Tables and data records Find, sort and filter records in a table Create tables using the design view Create tables with the Table Wizard Introduction to table field properties

  19. Visio 2010 mod 1 • Introduction to the Visio 2010 Interface (The Ribbon, The Backstage View, Mini-Toolbar & The Quick Access Toolbar) • Use Smart Shapes (Stencils – Drawing Shapes) • Drawing Page Tabs • Stencils for Quick Shapes • Agile Status Bar • Add shapes with mini-toolbar (automatic alignment and spacing) • Modify and add text to shapes • Connect shapes • Align and space automatically • Create hyperlinks 10.06.09

  20. Outlook 2010 mod 1 • Introduction to the Outlook Interface • Navigating through Outlook • Introduction overview of using Outlook with or without Exchange • Creating and sending new mail • Mail message options • Viewing and responding to mail • Attaching a file to a message • Printing and deleting messages • Creating and editing a new contact • Sorting and finding contacts • Creating a Distribution List • Introduction to using Outlook views • Creating and applying a category • Creating and editing a new task • Assigning a task to a contact

  21. Outlook 2010 mod 1 • Introduction to the Outlook Interface (The Ribbon, the Backstage View & Quick Access toolbar) • Introduction overview of using Outlook with and without an Exchange Server • Navigating through Outlook • Creating and sending new mail • Mail message options • Attaching a file to a message • Viewing and responding to mail • Sorting messages & using the Conversation view • Flagging and Categorizing email • Creating custom categories • Overview of the To-Do Bar • Printing and deleting messages • Creating and editing a new contact • Sorting and finding contacts • Creating a Distribution List • Creating and editing a new task • Difference b/w Task list and To-Do list • Converting email into a task

  22. Outlook 2010 mod 2 • Introduction to the Outlook calendar • Using the Schedule view • Adding and editing appointments • Scheduling recurring appointments • Scheduling events • Sending and responding to meeting invitations • Customizing the calendar • Creating your own mailbox subfolders • Moving items into folders • Searching & finding Outlook items • Adding Search Folders • Creating Notes

  23. PowerPoint 2010/2007 mod 3 Turbo review of day 1 Applying different slide styles, design themes and custom backgrounds Working with the slide masters Adding custom slide layouts to the Master slide Adding headers & footers Creating custom templates Creating SmartArt Diagrams Converting bulleted lists into SmartArt Using images to create SmartArt Creating Data Charts Linking & embedding objects from other programs

  24. Excel 2007 mod 4 • Creating and modifying pivot tables • Creating pivot charts • Applying Data Validation • Protecting cells, worksheets, and workbooks • Linking data • Using conditional formatting • Importing data from text file (CSV) • Creating Custom Views -1 : 10.06.09

  25. Access 2010 mod 1 (tables) Introduction to database design concepts & terminology Become familiar with the Access 2010 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips Open and examine and existing Access database Working with Tables and data records Find, sort and filter records in a table Create tables using the design view Create tables with the Table Wizard Introduction to table field properties

  26. Access 2007 mod 2 Relational database design concepts Create table relationships Explore relationship types Define referential integrity Display object dependencies How to “Normalize” databases Additional table field properties Create a lookup list

  27. Evaluation Time www.LearnIT.com/Evaluation Starting from the left: * Choose Class Type: = Private Event * Select Account: = Your Company Name * Select Course: = Todays Topic * Follow simple instructions from here. No “S”

  28. PowerPoint 2010 mod 2 7.8.10 Slide Master Headers & Footers SmartArt Convert bulleted lists into SmartArt Convert Pictures to SmartArt Design Themes, backgrounds, Slide styles Excel charts into PowerPoint (Linking & Embedding)

  29. Outlook 2007 mod 3 • An overview of Outlook message formats • Creating and Using AutoSignatures for messages • Utilizing message Voting buttons • Creating rules for email • Setting folder permissions • Setting delegate status for folders • Accessing another user's folders • Creating a Personal Folder file (PST file) and subfolders • Archiving information • Mailbox maintenance techniques

  30. Project 2007 mod 3 Turbo review of day 1 Baseline Tracking actuals/progress Reschedule project Look at different tables views Look at views Customize tables and Gantt Chart Hyperlink

  31. Access 2007 mod 5 (Forms) Creating an AutoForm Using the Form Wizard to design new forms Add and modify form controls Work with control properties Adding images and titles Create calculated controls Create forms in design view Creating Forms with Sub-forms Create tabbed forms

  32. Visio 2007 mod 1 • Explore the Visio environment • Use Smart Shapes • Insert pages • Modify and add text to shapes • Connect shapes • Align and position shapes • Create hyperlinks • and MORE!

  33. Visio 2007 Drawings • Flowcharts • Organizational Charts • “Swim Lanes” / Cross Functional Diagrams • and more if time permits.

  34. Excel 2010 mod 5 • Creating and applying names in a worksheet • Using the IF function • Nesting functions • Calculating dates • Using the formula auditing tools • Using LOOKUP functions • Using Database functions • Using Text and other useful functions 10.06.09

  35. Windows 7 10-15-09 Look at Windows 7 screen “Super” Search Customize the Taskbar Customize the Desktop Working with Folders Snipping Tool IE8 Gadgets And much, much more!

  36. Word 2010/2007 mod 5 10-15-09 Designing a form Working with form fields Using highlights and comments in a document Tracking changes in a document Protecting documents Creating a table of contents Using footnotes and endnotes Creating and Using bookmarks Creating cross-references Creating an index

  37. PowerPoint 2010/2007 mod 1 7.8.10 Introduction to the New Interface (The Ribbon, Backstage View, Quick Access Toolbar) Overview of the various PowerPoint views Creating new presentations Inserting new slides Inserting and formatting text Adding bulleted lists Saving your presentation Adding text boxes Adding ClipArt to a slide Modifying ClipArt properties Importing images to the ClipArt gallery Applying WordArt styles

  38. Excel 2007 mod 1 • Intro to the Excel 2007 interface: Ribbon, Tabs & Tool-tips • Navigating and selecting cells • Keyboard Shortcuts • Entering and editing data • Deleting and canceling data • Performing simple calculations • Saving your workbook • Checking compatibility with previous versions of Excel • Spreadsheet structure and design • Introduction to the Formulas Ribbon • Creating basic formulas • Creating basic functions • Copying a formula with AutoFill • Recognizing the differences b/w Relative and Absolute references 10.06.09

  39. Word 2010 mod 5 7-12-10 Displaying the Developer Ribbon Designing a form Working with form fields Using highlights and comments in a document Tracking changes in a document Protecting documents Creating a table of contents Using footnotes and endnotes Creating and Using bookmarks Inserting citations and bibliographies Creating an index

  40. Excel 2007 mod 5 • Creating and applying names in a worksheet • Using the IF function • Nesting functions • Calculating dates • Using the formula auditing tools • Using LOOKUP functions • Using Database functions • Using Text and other useful functions 10.06.09

  41. PowerPoint 2010 mod 2 7.8.10 Introduction to Inserting Drawing Shapes and Auto Shapes Formatting Drawing objects Grouping and ungrouping objects Layering (reordering) objects Inserting & editing pictures from a file Inserting Screenshots Adding slide transitions Introduction to animating to text and objects Running a slideshow Adding speaker notes Printing slides, speaker notes and handouts

  42. Visio 2010 mod 1 • Look at new Visio 2010 screen • Smart shapes & Stenciles • Drawing Page Tabs • Stencils for Quick Shapes • Add shapes with “mini-toolbar” • Modify and add text to shapes • Connect shapes • Align and space shapes automatically and manually • Create hyperlinks 10.06.09

  43. Access 2007 mod 6 Using the Report Wizard to create new Reports Modify report's page setup settings Modify report design and layout Work with report sections Create summary functions Create reports in design view Use the Mailing Labels Wizard

  44. Windows 7 mod 1 • Explore the Desktop • Enhanced Taskbar • Notification area (Desktop) • AERO Features • Customize Windows • Taskbar, Start Menu, Gadgets, Desktop • Manage Files & Folders • Control Panel apps • Internet Explorer 8 2.21.11

  45. Windows 7 mod 1 • Explore the Desktop • Work with Windows • Access the Help and Support Feature • Customizing the Windows 7 Desktop • Customize the Start Menu & Taskbar • Personalize the Desktop • Add Gadgets to the Desktop • Apply Aero Features • Modify Display Settings • Managing Folders and Files • Navigate to Folders Using Windows Explorer • Work with Folders and Files • Organize Folders and Files • Search for Folders and Files • Using Common Tools and Programs in Windows 7 • Create a Document in WordPad • Work with the Calculator • Capture Screens Using the Snipping Tool • Browsing the Web with Internet Explorer 8 • Browse Websites Using Internet Explorer 8 2.21.11

  46. Access 2007 mod 4 Create a totals queries Create crosstab queries Create Action Queries Import/export data Linking tables from one database to another Use MS OfficeLinks Overview of importing data from Microsoft Outlook Overview of the collecting data via email feature

  47. Excel 2007 mod 6 • Consolidating data • Using the Goal Seek • Creating Data Tables • Using the Scenario Manager • Adding the Developer tab to the Ribbon • Recording and running a macro • Editing a macro • Adding a button to run a macro 10.06.09

  48. Excel 2007 Mod 2 • Inserting rows and columns • Moving and copying data • Using the Autofill feature to complete a series of values • Intro to worksheet Themes & Styles • Formatting spreadsheet data • Apply automatic Cell Styles and table formats • Using and creating templates • Worksheets - inserting, deleting, renaming, moving, copying, & grouping • Zooming in or out on a worksheet • Freezing and splitting panes • Spell checking your data • Setting print options through Page Setup • Using the Page Layout view • Printing your worksheets 10.06.09

  49. Word 2007 mod 1 10-15-09 Introduction to the Word interface Basic Page Setup Creating a new document Entering and editing text Navigation techniques in a document Keyboard shortcuts Basic and Advanced techniques for selecting text Saving and closing documents Getting help in Word Moving and Copying text Formatting text in a document Formatting paragraphs including spacing and indentation Creating bulleted and numbered lists

  50. Word 2007 mod 2 10-15-09 Creating Headers & Footers Working with document margins Creating columns Working with sections Inserting and controlling page breaks Using proofing tools (Spell/Grammar Check, Thesaurus) Using AutoText and AutoCorrect Finding and replacing text Creating individual envelopes and labels Using and creating templates Printing your documents Sending Word documents as e-mail

More Related