Menu

Private

Microsoft Publisher Topics

One Day Course

  1. Getting Started with Microsoft Publisher 2013
  2. Topic A: Explore the Interface
  3. Topic B: Customize the Publisher Interface
  4. Topic C: Create a Publication
  5. Adding Content to a Publication
  6. Topic A: Add Text to a Publication
  7. Topic B: Organize Text Boxes and Picture Placeholders in a Layout
  8. Topic C: Control the Display of Content in Text Boxes
  9. Topic D: Apply Building Blocks
  10. Formatting Text in a Publication
  11. Topic A: Format Text and Paragraphs
  12. Topic B: Apply Paragraph Styles
  13. Topic C: Apply Schemes
  14. Editing Text in a Publication
  15. Topic A: Edit Text in a Publication
  16. Topic B: Present Content in Tables
  17. Topic C: Insert Symbols and Special Characters
  18. Adding and Formatting Graphics in a Publication
  19. Topic A: Add Graphical Objects to a Publication
  20. Topic B: Manipulate the Appearance of Pictures
  21. Preparing a Publication for Sharing and Printing
  22. Topic A: Save a Publication
  23. Topic B: Run Design Checker
  24. Topic C: Preview and Print a Publication
  25. Topic D: Share a Publication

Microsoft OneNote Course

One Day Course

  1. Exploring Notebook Structure
  2. Navigate the OneNote 2013 Environment
  3. Use Predesigned Templates for OneNote Notebooks
  4. Customize the User Interface within OneNote
  5. Adding Content and Formats to a OneNote Notebook
  6. Modify Formatting in a Notebook
  7. Add Audio and Video to a Notebook
  8. Add Quick Notes and Links
  9. Use Tags, Symbols, Drawing Tools, and Pen Options
  10. Managing OneNote Notebooks, History, and Backups
  11. Save and Export Content and Use Alternate File Types
  12. Manage Notebook Recycle Bins and Backups
  13. Working with Excel Spreadsheets and Embedded Files
  14. Work with Excel Spreadsheets
  15. Work with Embedded Files
  16. Sharing and Collaborating with Notebooks
  17. Send a Notebook and Use Outlook Integration
  18. Share and Collaborate on Notebooks
  19. Finalizing a Notebook
  20. Finalize a Notebook Using Proofing and Print Settings
  21. Configure Notebook Settings, Properties, and Security
  22. Organize and Search Notebooks

Microsoft Office 365

  1.  OFFICE 365 OVERVIEW
  2. What is Office 365?
  3. Services provided in Office 365
  4. Connecting to the Services
  5. Office 365 Integration
  6. CONNECTING TO OFFICE 365
  7. Logging In
  8. Office 365 Portal Overview
  9. Lync Options
  10. WORK WITH THE OUTLOOK WEB APP
  11. OWA Interface Overview
  12. Email
  13. Calendar
  14. Themes and Rules
  15. Contacts and Public Groups
  16. Other Options
  17. OFFICE 365 AND OUTLOOK 2010/2013
  18. Outlook 2010 New Features
  19. Use the GAL
  20. Share Calendars
  21. Schedule Meetings
  22. USING LYNC
  23. Set Options
  24. Instant Messaging and Contacts
  25. Online Meetings and Meeting Requests
  26. Application and Information Sharing
  27. Outlook Integration
  28. USING SHAREPOINT
  29. Team Site Overview
  30. Explore and Navigate a Site
  31. Use Document Libraries
  32. Collaboration Tools
  33. Outlook and Microsoft Office Integration
  34. Use the Calendar
  35. Publishing Tools
  36. Working Offline
  37. Searching
  38. WORK WITH OFFICE WEB APPS
  39. Create, View and Change Files

Power BI: Power Views

One Day Workshhop

  1. Get started with Power View
  2. Working with Data
  3. Data sources for Power View
  4. Import Data into Excel 2013, and Create a Data Model
  5. Incorporate Internet Data, and Set Power View Report Defaults
  6. Filter and highlight data
  7. Slicers
  8. Sorting
  9. Create charts and other visualizations
  10. Create Map-based Power View Reports
  11. Reporting – Create Amazing Power View Reports
  12. Reports with multiple views in Power View in SharePoint
  13. Share Power View reports
  14. Share Power View in Excel
  15. Share Power View in SharePoint reports (RDLX files)
  16. Print Power View reports
  17. Set Power View reporting properties in Power Pivot
  18. Extend Data Model relationships using Excel 2013, Power Pivot, and DAX​

Microsoft Word Topics

Word Basic Course

  1. Introduction to Microsoft office applications
  2. Explore the user interface
  3. What is word? (family)
  4. Backstage view / office button (2007)
  5. Ribbon overview
  6. Mini toolbar
  7. Status bar
  8. Shortcut key tips
  9. Contextual tabs
  10. Create, open and save documents
  11. What is word? (function)
  12. How to create your first word document?
  13. Create a new blank document
  14. Create a document from a template
  15. Open word files
  16. Getting help
  17. Save documents
  18. Add, select, navigate and delete text
  19. Viewing documents in different ways
  20. Format text and paragraphs
  21. Use the home ribbon to format font and paragraphs
  22. Format with the mini-toolbar
  23. Font and paragraph dialog boxes
  24. Use the format painter
  25. Use the quick style gallery
  26. Use basic bullets and numbering
  27. Add borders and shading
  28. Using cut, copy, paste
  29. Use the office clipboard
  30. Set tabs and use the ruler
  31. Undo/redo
  32. Find, replace and go to
  33. Check spelling and grammar:
  34. Proofing, thesaurus and translate
  35. Navigate a long document (part 2)
  36. Printing and viewing your document
  37. Use the page set-up group and dialog box
  38. Print preview and print options (2007)
  39. Customize
  40. Customize the quick access toolbar
  41. Show/hide the ribbon

Word Intermediate Course

  1. Explore the user interface
  2. Working with styles
  3. Create a style from text
  4. Use the styles pane
  5. Modify and delete styles
  6. Use the style inspector
  7. Use reveal formatting
  8. Manage styles
  9. Use and modify themes
  10. Create a template
  11. Modify a template
  12. Attach a template to a document
  13. Bullets and numbering
  14. Custom bullets and numbering
  15. Create a multi-level list
  16. Restart or continue numbering
  17. Advanced page formatting
  18. Use columns
  19. Insert page breaks, column breaks, section breaks and line breaks
  20. Set break options
  21. Add quick parts and use building blocks
  22. Create a blank page and a cover page
  23. Add page colours, watermarks, borders and horizontal lines
  24. Add headers and footers
  25. Add hyperlinks
  26. Edit/ Remove hyperlinks
  27. Use hyphenation and word count
  28. Use research, language and translation tools
  29. Use and customize autocorrect
  30. Insert the date and time
  31. Insert symbols and special characters
  32. Use the mail merge wizard
  33. Use the mailings ribbon
  34. Create envelopes and labels
  35. Email a document
  36. Working with graphics
  37. Add pictures and clipart
  38. Format and modify images
  39. Add and format word art
  40. Add and format AutoShapes
  41. Add and format text boxes
  42. Align, distribute, group and order graphics
  43. Add and format SmartArt
  44. Insert a table
  45. Table selection options
  46. Format a table
  47. Modify table structure
  48. Draw a table
  49. Use table options dialog boxes
  50. Convert text to table
  51. Sort a table
  52. Use and insert equations
  53. Insert a chart
  54. Format a chart
  55. Modify chart options
  56. Embed and link excel tables and charts

Word Advanced Course

  1. Work with forms
  2. Work with webpages
  3. What is a Macro
  4. Set macro security
  5. Record a macro
  6. Assign a macro to a keystroke or quick access toolbar
  7. Reviewing documents
  8. Add, edit, navigate and delete comments
  9. Track and review changes
  10. Track changes options
  11. Inspect the document
  12. Prepare for sharing
  13. Compare and combine documents
  14. Protect documents
  15. Create and modify outlines
  16. Create a table of contents from heading styles
  17. Create a table of contents from an outline
  18. format, modify and update a TOC
  19. Add footnotes and endnotes
  20. Use bookmarks – use cross references
  21. Create a bibliography
  22. Manage bibliography sources and choose styles
  23. Add captions and create a table of figures
  24. Mark entries and create an index
  25. Update and modify an index
  26. Create and update a table of authorities
  27. Create a master document
  28. Create and work with sub documents
  29. XML and word
  30. What is XML and why is it used?
  31. Use the XML structure pane
  32. Tag a document
  33. Apply an XML schema

Course Outline

Microsoft Excel Topics

Excel Basic Course

  1. What is Excel?
  2. Open Excel Sample Files
  3. Excel Interface
  4. Adding Buttons to QAT
  5. Customizing the Ribbon
  6. Open Workbook (New-Existing- Temp)
  7. Saving a workbook
  8. Data Selection & Navigation
  9. Split & Freeze
  10. Enter, Edit & Delete data
  11. Find, Replace, Proofing
  12. Copy, Cut & Paste
  13. Formatting (FANS)
  14. Styles & Themes
  15. Conditional Formatting
  16. Basic Formulas
  17. Basic Charting
  18. Printing: Page Layout – Header
  19. Page Break Preview
  20. Getting Help with Excel

 

Excel Intermediate Course

  1. What is a Formula?
  2. Basic Formulas
  3. Order of Operation
  4. Relative & Absolute Reference
  5. Basic & Intermediate Functions
  6. Formula Auditing
  7. Naming
  8. Sort & Custom Lists
  9. Filtering Data
  10. Data Validation
  11. Lists & Tables
  12. Structured Reference
  13. Illustrations – Smart Art
  14. File Properties & Info Panel
  15. Hiding Workbooks
  16. Advanced Customization
  17. Protecting Sheets
  18. Protecting Workbook
  19. Hiding Formulas
  20. Custom Views

Excel Advanced Course

  1. Summarizing data using Outline
  2. Summarizing data using Subtotal
  3. Combining data using Consolidation
  4. Pivot Tables
  5. Pivot Charts
  6. Advanced Pivot Tables
  7. Filtering Pivot Tables
  8. Sparklines
  9. Create Scenarios
  10. Using Goal Seek
  11. Variable Data Tables
  12. Using the Solver
  13. Linking & Embedding
  14. Getting External Data
  15. Sharing – Tracking Changes
  16. Combining Worksheets
  17. Creating Macros
  18. Advanced Macros
  19. Creating Forms
  20. Assign a Macro To a Control

Alphabetic Shortcut keys

For Microsoft Word