Microsoft Sharepoint

10802A: Microsoft Enterprise Search for IT Professionals

Course Outline

 
View
Duration: 24 Hours
Course Fee: INR. 20,000 + Tax


55045: Microsoft End to End Business Intelligence

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 30,000 + Tax


MCSE: SharePoint Boot Camp

Course Outline

 
View(20331)
View(20332)

Duration: 60 Hours
Course Fee: INR. 60,000 + Tax


Office 365 Demo Session (SATVs)

Course Outline

 

  • What is Office 365?
    • Understanding Office 365
    • Getting Office on Demand.
    • Using cloud services on demand.
    • Creating and editing files in your browser.
    • Sharing Office docs with SkyDrive Pro.
    • Using the Office 365 navigation bar.
    • Basics of Office 365
    • Customizing the ribbon.
    • Getting started quickly: New templates right from the start page.
    • Understanding the Backstage view.
    • Adding elements to your documents.
    • Adding online images or videos.
    • Office 365 integration with services
    • Simultaneously edit your documents.
    • Connecting to your favorite online services.
    • Sharing documents online with Lync.
  • Outlook
    • Look and feel
    • Navigating Outlook.
    • Personalizing email with themes.
    • Communications
    • Connecting to Hotmail.
    • Using the People Card.
    • Managing your email
    • Searching mail.
    • Extras to help you work better
    • Including your attachments.
    • Working smarter with extras.
  • Word
    • Enjoy the read
    • Reading your documents in Read Mode.
    • Editing PDF documents.
    • Design and edit
    • Editing documents confidently: Simple Markup.
    • Aligning objects: Live preview.
  • Excel
    • The basics
    • Working with multiple workbooks.
    • Working with data
    • Analyzing data instantly: Quick Analysis.
    • Filling out data in a flash: Flash Fill.
    • Getting more out of Excel with new functions.
    • Interacting with data with Power View.
    • Drilling up, down, or across data.: PivotTable hierarchy drilling made easy.
    • Analyzing data with PivotTables and PivotCharts.
    • Improved charting
    • Sprucing up your charts: Recommend charts button.
  • PowerPoint
    • Basics
    • Improving PowerPoint for touch support.
    • Adding multimedia.: More formats, HD content.
    • Design and layout
    • Choosing a theme for your presentation.
    • Working with objects.
    • Animating presentations.
    • Save, share, and collaborate
    • Reviewing presentations.
    • Starting an online Lync meeting from PowerPoint.
    • Presenter tools
    • Presenting with ease.

 
Duration: 1 Hour
Course Fee: INR. 5,000 + Tax


SharePoint Hero Clinic

Course Outline

 

  • Introduction:
    • Why SharePoint is an important and viable platform for both tactical and enterprise class application
    • Discussion of Procedural and Declarative development methodologies
    • The Declarative development paradigm – Information sets and Rules
    • The value of XML technologies and how SharePoint is built on them
    • The benefits of working in a declarative development platform
    • Application design architecture – monolithic or distributed
    • The SharePoint Development Toolkit – SharePoint Designer, InfoPath, SharePoint UI and Web Parts
    • Security driven development
  • Run-Time Solution Demonstrations:
    • Employee Absence Tracking
    • Resource Reservation and Scheduling
    • Automated Document Generation
    • Automated Distribution of Contact Information
    • User Based Presentation of Complex Information
  • Design-Time Review of the Employee Absence Tracking Application
    • InfoPath Web Part Form
    • InfoPath Absence Request Form
    • SharePoint Designer Approval Workflow
    • Restricted and Reserved Date List
    • Web Part Portal Page
  • Building the Employee Absence Tracking Application
    • Creating an External Content Type from a SQL data source
    • Having the necessary user credentials set
    • Using the ECT Wizard in SharePoint Designer
    • Creating an External Content Type
    • Creating the External Data Source Connection
    • Creating the External Content Type Operations
    • Creating the ECT List and Form
  • Creating the Absence Request InfoPath Form
    • Creating an Information Set Schema in InfoPath
    • Adding Property Attributes for Information Set Schema Objects
    • How InfoPath Interprets Schema Structure to Automate Form Design
    • Adding a Secondary Data Source to the Form
    • Laying Out Form Controls and Binding Them to the Information Set Schema Fields
    • Creating a Form Load Rule
    • Setting the Current User Value for Use with the Form Load Rule Actions
    • Querying the Employee Information Secondary Data Source
    • Adding the Current User Filter Parameter to Find a Value from a Specific Record
    • Making InfoPath Controls Read-only
    • Setting a Field’s Value with a Formula Calculation
    • Using a Rule to Correct the Generation of an Incorrect Value
    • Creating a Repeating Table for the Vacation Requests Group and Fields
    • Rule Logic for Vacation Requests
    • Creating the Restricted and Reserved Dates List
    • Adding the Restricted and Reserved Dates List as a Secondary Data Source to the Absence Request Form
    • Using an InfoPath Function to Set the Request Date to the Current Date
    • Creating the Current and Previous Date Validation Rule for Vacation Request Dates
    • Creating the Restricted Dates Validation Rule for Vacation Request Dates
    • Creating the Set Hour Value Rule to Generate an Hour Value Equivalent for Each Vacation Date Requested
    • Creating the Adjust Hour Value Rule for Invalid Date Requests
    • Creating the Reset Hour Value Rule
    • Using the Sum Function to Implement a Running Total of Repeating Item Values
    • Using a Query Parameter to Filter Rule Criteria
    • Using a Formatting Rule to Hide Controls
    • Copying Controls and Rules for Reuse in the Form
    • Adding the Approval Section Schema Fields
    • Adding the Approval Section to the Form Layout
    • Creating Rules to Hide the Approval Section
    • Creating a Rule to Hide the Approval Section when the Form is First Created
    • Configuring the Property Settings and Creating the Rule Logic for the Approval Section Controls
    • Creating Form Load Rules for Existing Instances of an Absence Request
    • Adding Additional Form Views
    • Creating the “Opener is Initiator” Form Load Rule
    • Creating the “Opener is Manager” Form Load Rule
    • Creating the “Opener is Not Initiator” Form Load Rule
    • Adding the Stored Values Group and Fields
    • Creating the Formula Calculations for the Stored Values Fields
    • Creating a Rule to Offset Calculations Resulting in Negative Numbers
    • Using the addDays Function to Calculate an Employee Tenure Value
    • Adding a Submit Button and Reviewing the Submit Rule Set Logic
    • Publishing the Form and Creating the Host Form Library
    • Creating the Submit Data Connection and Using a Formula to Generate a Unique File Name for the Submitted Form
    • Creating the Submit Rule Set
    • Testing the Submit Rules
    • About the InfoPath Rule Inspector
    • Best Practices for Designing InfoPath Form Layouts
    • Using Tables and Schema Group Sections
    • Using Borders and Shading
    • Reconstructing the Absence_Time_Information Section
    • Copying Multiple Control and Label Cells
    • Reconstructing the Absence Request Dates Sections
    • Adding Borders and Shading to the Repeating Tables
    • Layout Considerations for Hidden Sections
    • Centering the Tables in the Form
    • Final Form Layout Adjustments
  • Design Layout Best Practices Review
    • Configuring the User Interface Options for a Browser Form
    • Adding a Validation Rule for the Reason_Rejected Text Box in the Approval Section
    • Copying and Pasting the Main View of the Form to the Main Read Only View
    • Creating a Formatting Rule to Hide the Approval Section in the Main Read-only View
    • Adding a “Close the Form” Button to the Message Views
    • Publishing the InfoPath Form as a Content Type
    • Creating a Form Library Configured to Support Content Types and Binding the Absence Request Content Type to the Form Library
    • Form Publishing Considerations
    • Modify the SharePoint Library Submit Data Connection to Submit to the New Form Library
    • Publishing the New Absence Request Form to the New Form Library
  • Creating the Application Workflow
    • Introduction to SharePoint Designer Workflows
    • Getting Familiar with the SharePoint Designer Workflow Editor
    • Discussion of Important Security Considerations When Creating Workflows that Interact with External Content Types
    • Creating the Absence Request Workflow
    • Encapsulating the Workflow in an Impersonation Step
    • Inserting a Condition Statement
    • Adding a Clause to the Condition Statement
    • Creating the Workflow Action for Updating the Employee Information Database
    • Creating a Workflow Action that Sends an Email to the Request Initiator
    • Creating the Second Workflow Condition and Respective Actions
    • Creating a Workflow Email Message to Send to the Approving Manager
    • Using a Parallel Block to Create a Race Condition
    • Creating the First Parallel Block Step
    • Creating the First Conditional Statement and Actions for Step 2
    • Creating the Second Conditional Statement and Actions for Step 2
    • Creating the Second Parallel Block Step
    • Configuring the Security Settings for Running a Workflow that Interacts with an External Content Type
    • Identifying the System Account under which SharePoint Workflows Run
    • Assigning the Service Account Permission to Interact with the Employee Information ECT
    • Creating Impersonation Credentials in Secure Store Service for the ECT Data Connection to SQL Server
    • Understanding the SharePoint Secure Store Service
    • Create the Windows User Account for the Impersonation Credentials
    • Add the User Account to SQL Server Logins and Database Users
    • Using the Secure Store Service
    • Initializing the Secure Store Service
    • Creating a Secure Store Service Target Application
    • Changing the Connection Properties for the ECT in SharePoint Designer to use the Impersonation Account Credentials
    • Summary of Required Settings When Using Workflows to Access External Content Types
    • Publishing and Associating the Workflow
  • Configuring the Security Settings for Running a Workflow that Interacts with an External Content Type
    • Identifying the System Account under which SharePoint Workflows Run
    • Assigning the Service Account Permission to Interact with the Employee Information ECT
    • Creating Impersonation Credentials in Secure Store Service for the ECT Data Connection to SQL Server
    • Create the Windows User Account for the Impersonation Credentials
    • Add the User Account to SQL Server Logins and Database Users
    • Using the Secure Store Service
    • Initializing the Secure Store Service
    • Creating a Secure Store Service Target Application
    • Changing the Connection Properties for the ECT in SharePoint Designer to use the Impersonation Account Credentials
    • Summary of Required Settings When Using Workflows to Access External Content Types
  • Why SharePoint Designer is Your Best Friend
    • Overview discussion of differences between SharePoint Designer 2010 and 2013
    • List View and DataView design mode editing
    • Workflows
    • Working with multiple artifacts simultaneously
    • Discussion of the functional and presentation organization of SharePoint Designer
    • Using the Navigation Site Objects pane in conjunction with Ribbon menus
    • Working with Tabs and Breadcrumbs to move to different contexts
    • Discussion of the Summary Page for different artifacts and settings dialogues
    • Opening Sites
    • Review of the attributes of the Lists and Libraries screen
    • Discussion of the Summary Page functions for a List or Library
    • Discussion of All Files hierarchy of artifacts and objects
    • Discussion of _catalogs and wp (Web Part Gallery) folders
    • Viewing and working with documents in libraries
    • Individual and batch uploading of documents and moving documents anywhere
    • Discussion of Custom Actions for Lists and Libraries
    • Navigate to form action
    • Initiate workflow action
    • Navigate to URL action
    • Discussion of Extended List View editing features
    • Design, Web Part and Table Tab functions
    • Extended Filter Criteria settings
    • Conditional Formatting
    • Creating Global Web Parts
    • Discussion of Data Source Functionality
    • Creating a SOAP Web Service Data Source
    • Creating a Data View Web Part to host the Data Source
    • Inserting the Data View Web Part on a Page and configuring it
    • Creating a REST Web Service Data Source
  • How to Create a Great Scheduling and Resource Reservation System Using SharePoint Calendars
    • Walkthrough of a finished Resource Reservation and Scheduling System
    • Activate the Group Work Lists Feature
    • Discussion of Content Types and How SharePoint Content Types Enable this Advanced Calendaring Functionality
    • Create the Resource Groups and Resources
    • Creating and Working with Resource Reservations
    • Double Booking
    • Creating and working with Appointments with Resources
    • Calendar Overlay Settings and Customizing Calendars
    • Exchange and SharePoint Calendar Overlays
    • Create a Reservation Approval Workflow
    • Creating Calendar Views
    • Creating a SharePoint Designer Workflow to Generate Email Notifications of Scheduling Events
  • Document Creation Automation Using SharePoint Designer Workflows
    • Walkthrough of completed document creation workflow
    • Discussion of Content Types
    • Create the Content Type for the Offer Letter and its requisite Site Columns and associate an actual document to the Content Type Document Template.
    • Configure a Document Library to support Content Types and add the Offer Letter Content Type to that Library.
    • Edit the Content Type Document Template in the Library to include the Quick Part Document Property fields for the information that will be auto-populated.
    • Update the document associated with the Master Offer Letter Content Type with the one that includes the Quick Part Document Property fields.
    • Creating the document creation workflow
    • Discussion of workflow choices and why a Site Workflow
    • Create List Item Discussion
    • Review of Initiation Form Parameters
    • Create List Item Value Assignments
    • Review of String Builder
    • Adding Send an Email and Copy the Document actions
    • Creating correlation mechanisms to identify unique instances of items
    • Embedding a link to the document in the body of the email
    • Review alternative workflow based on a List
    • Mapping list columns to document Quick Part Properties
    • Creating a custom list action for starting the workflow
    • Generating multiple documents automatically
  • How to Set Up a Flexible and Scalable System for Distributing and Updating Contact Information in Outlook Using SharePoint Contact Lists and SharePoint External Content Types Connected to a Database
    • Creating a SharePoint Contact List and Discussion of Special Properties
    • Importing Information from an Excel Spreadsheet
    • Using the Datasheet View
    • Connecting the Contact List to Outlook
    • Discussion of bi-directional behavior between Outlook and the Contact List
    • Declaring all the items in the list to be records
    • Declaring individual items in the list to be records
    • Discussion of records management
    • Displaying the record declaration column
  • External Content Type Section
    • Create an External Content Type to an SQL Server database and map the selected fields to their respective Office contact properties.
    • Create a SharePoint List for the ECT and an InfoPath List form.
    • Configure Object Permissions for the ECT in SharePoint Central Administration
    • Connect the SharePoint ECT List to Outlook to display the records as contacts.
    • Demonstration of bi-directional record updates
  • How to Efficiently Import Large Information Sets from Excel and Customize the Presentation of Information Using View Styles and the Identity of the User
    • Method 1 – the SharePoint Import Spreadsheet List template
    • Method 2 – Exporting a Table to a SharePoint List
    • Selectively Displaying Information Based on the Identity of the User
  • Review

 
Duration: 16 Hours
Course Fee: INR. 15,000 + Tax


Visualizing SharePoint Business Intelligence with No Code (50561)

Course Outline

 
View
Duration: 40 Hours
Course Fee: INR. 25,000 + Tax