Office365_Icon   Here you will get the material for computer IT and Office related courses and tutorials . The materials for which you will get the PDF, DOC, PPT, RAR and ZIP files are Word, Excel, PowerPoint, writer, calc, Microsoft office, LibreOffice and many others. As these tutorials are included in many of the academic schedules, you will need to get detailed information on them. As it will not possible for you to browse the web for every small topic, you can go for downloading the PDFfiles for having easy access to the information. Also tutorials, corrected exercises and practical work will make it easy for you to have a clear understanding of every topic.

Beginner Courses:

Contents

  • Set up your account
  • Attach files without searching
  • Set up an Outlook group
  • Outlook is more than just email
  • Find whatever you need
  • Get other Quick Start Guides
  • Look up relevant information
  • Next steps with Outlook

 

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Identify the components of the Word 2016 interface.
  • Use the Tell Me feature to enter words and phrases related to what you want to do next to quickly access features or actions.
  • Create a new document.
  • Set document margins.
  • Set paragraph alignment, indentation, and spacing.
  • Set tabs.
  • Add headers and footers to a document.
  • Apply a theme to a document.
  • Format text.
  • Check the document for spelling and grammar.

 

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Identify the components of the Office 2016 interface
  • Be familiar with the layout of the spreadsheet
  • Have the ability to enter text and numbers
  • Have the ability to modify a spreadsheet
  • Know how to change the appearance of text and numbers within the spreadsheet
  • Be able to apply borders
  • Be able to insert graphics
  • Be able to add headers and footers
  • Be able to insert hyperlinks
  • Be able to work with shapes
  • Have the ability to print
  • Know how to save a worksheet

Table of Contents

  • Introduction
  • Learning Objectives
  • The Office 2016 Interface
    • The Ribbon, Customizing the Ribbon
    • The Quick Access Toolbar, Tell Me and Smart Lookup
    • The Smart Lookup Tool, The File Tab
  • Columns and Rows, Entering Text
  • Long Words and Numbers, Completing a Series
  • Selecting Multiple Cells, Moving Text and Numbers
  • Copying Data
  • Insert a Row or Column, Delete a Row or Column
  • Changing Column Width and Row Height, Formatting Numbers
  • Formatting Text and Numbers, Changing the Font, Borders
  • Graphics
    • Clip Art
    • Images from a File
  • Printing, Saving, Additional Help

 

Introduction

Microsoft Office PowerPoint 2016 is a presentation software application that aids users in the creation of professional, high-impact, dynamic presentations. Slides are the building blocks of a PowerPoint presentation. By using slides, the focus is not only on the speaker, but on the visuals (slides) as well.

Learning Objectives

After viewing this booklet, you will be able to:

    • Become familiar with PowerPoint’s interface
    • Create a new presentation and save it
    • Add slides to a presentation
    • Delete and Rearrange slides
    • Apply a design theme
    • Work with themes and background styles
    • Use the various PowerPoint views
    • Enter and edit text
    • Insert graphics and other objects
    • Play the slideshow
    • Print handouts

 

Introduction
SharePoint is a Microsoft tool to create web sites to securely store, organize, share, and access information. Only those with whom you share your site can access the information; however, it can be accessed from virtually any device using a Web browser. This booklet was created using the Mozilla Firefox browser.
Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Accessing a SharePoint Site
  • Become familiar with the Interface, Ribbon, Quick Launch, and Top Links
  • Create a SharePoint site
  • Manage site permissions
  • Create, and format site pages and content
  • Create and manage document libraries
  • Search for content on your SharePoint site

 

YammerIconYammer – Getting Started

Introduction

Yammer is a private collaboration tool that helps you connect to colleagues in your organization, share information across teams, and organize around projects. Only your coworkers can join, so your communications on Yammer are secure and visible only to people within your organization.

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Sign In and Out of Yammer
  • Navigate and Manage your Inbox
  • Access, Create, and Manage Groups
  • Configure Notifications
  • Follow People and Conversations
  • Upload Files

 

 

 

Advanced Courses:

Introduction

This booklet is the companion document to the Excel 2013: Advanced Excel Tools workshop. The booklet will explain how to create a simple macro, how to use nested formulas, how to create templates, hide/unhide rows and columns, and protect/unprotect your spreadsheets and workbook.

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Understand what Nested Functions are
  • Link data between sheets
  • Understand what Macros are
  • Create a simple Macro
  • Hide/unhide information in your spreadsheet
  • Protect your spreadsheet and workbook
  • Create templates out of workbooks

This booklet is the companion document to the Excel 2016: Advanced Excel Tools workshop. The booklet will explain how to create a simple macro, how to use nested formulas, how to create templates, hide/unhide rows and columns, and protect/unprotect your spreadsheets and workbook.

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Understand what Nested Functions are.
  • Link data between sheets.
  • Understand what Macros are.
  • Create a simple Macro.
  • Hide/unhide information in your spreadsheet.
  • Protect your spreadsheet and workbook.
  • Create templates out of workbooks.

This Page is under construction…..

underconstruction

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s