InfoPath

Whether you are an information worker who has created only a few forms in Word or a software developer who is familiar with more advanced coding concepts, if your intention is to study how to design InfoPath forms, this program of Unique Computer Institute is for you. This program of Unique Computer Institute will talk about not only the basics of designing forms but also such advanced concepts as writing managed code for InfoPath. As long as you have an understanding of basic form concepts and a desire to study, you are in the right place. If you want to study everything you can about InfoPath, you have found the right program of Unique Computer Institute.

Designing Forms for Microsoft Office InfoPath and Forms Services

Designing Forms

Introduction to InfoPath, Basics of InfoPath Form Design, Working with Data, Advanced Controls and Customization, Adding Logic without Code, Retrieving Data from External Sources, Extended Features of Data Connections, Submitting Form Data, Saving and Publishing, Building Reusable Components, Security and Deployment, Creating Reports, Workflow, Introduction to Forms Services

Advanced Form Design

Writing Code in InfoPath, Visual Studio Tools for Microsoft Office InfoPath, Advanced Forms Services, Hosting InfoPath, Building Custom Controls Using ActiveX Technologies, Add-ins, Importers and Exporters

Introducing InfoPath, Tour of the InfoPath Client, Tour of the InfoPath Designer, InfoPath Views, Publishing InfoPath Forms, SharePoint Integration, Data Connections, Advanced InfoPath Topics, Writing Code in InfoPath, InfoPath Add-Ins and Task Panes, Workflow

 

Word

Microsoft Office Word is a sophisticated word processing program that helps you quickly and efficiently author and format all the business and personal documents you are ever likely to need.

You can use Word to:

·         Create professional-looking documents that incorporate impressive graphics such as charts and diagrams.

·         Give documents a consistent look by applying styles and themes that control the font, size, color, and effects of text and the page background.

·         Store and reuse ready-made content and formatted elements such as cover pages and sidebars.

·         Create personalized e-mail messages and mailings to multiple recipients without repetitive typing.

·         Make information in long documents accessible by compiling tables of contents, indexes, and bibliographies.

Throughout Unique Computer Institute this program by , we include discussions of each new feature that is likely to be useful to you and how and when to use it. Unique Computer Institute provided the following faculty for you.

You will be meet the following

Exploring Word

Working in the Word Environment, Opening, Moving Around in, and Closing Document, Displaying Different Views of a Document, Creating and Saving a Document, Previewing and Printing a Document

Customizing Word

Changing Default Program Options, Making Favorite Word Commands Easily Accessible, Making Commands Available with a Specific Document, Creating a Custom Keyboard Shortcut

Formatting and Editing

Selecting Text and Objects, Selecting with Command Buttons, Selecting with the Click-Shift-Click Method, Selecting with the Keyboard, Using the Clipboard, Setting Options for the Clipboard Task Pane, Repositioning and Resizing the Clipboard Task Pane, Using the Format Painter, Formatting Fonts, Using the Mini Toolbar, Previewing Formats. Changing Case, Applying Subscript and Superscript Formats, king and Growing Fonts, Clearing Formats, Underlining Text, Formatting Strikethrough Marks,  Adding Text Formats to the Quick Access Toolbar, Animating Text, Formatting Paragraphs, Adding Bullets and Numbering, Creating Multilevel Lists, Changing Line Spacing, Formatting with Styles, Using Quick Styles, Creating Your Own Styles, Formatting Styles Manually , Formatting Automatically As You Type, Saving Time Editing, Specifying the Spacing Between Sentences, Using the Repeat Command, Finding and Replacing Text, Working in Overtype Mod

Creating Documents More Efficiently

Working with Building Blocks, Inserting a Building Block, Adding a Building Block, Changing the Content of a Building Block, Changing the Properties of a Building Block, Sharing Building Blocks, Creating Cover Pages, Creating Tables, Using Quick Tables, Using the Table Grid, Drawing the Table Borders, Converting Text to a Table, Nesting Tables, Inserting an Excel Spreadsheet. Formatting Table Styles. Formatting Table Layouts. Adding and Deleting Rows and Columns. Merging and Splitting Cells and Tables. Changing the Cell Size. Aligning Text Within Cells. Wrapping Text Around a Table. Managing Table Data. Sorting Table Data. Repeating Header Rows. Converting a Table to Text. Using Formulas in Tables.  Numbering Table Rows. Working with Illustrations. Inserting Pictures, Inserting Clip Art,  Inserting Shapes, Inserting SmartArt, Inserting Charts, Using Links, Creating Hyperlinks, Inserting Bookmarks, Inserting Cross-References, Formatting Headers, Footers, and Page Numbers, Adding Building Blocks, Creating Different Headers and Footers in Each Section, Creating Different Headers and Footers for the First Page and Odd and Even Pages, Using Graphics to Enhance Text,  Adding a Signature Line, Creating Equations, Saving Documents with Equations, Using Symbols

Designing Page Layouts

Using Themes, applying a Theme, Modifying a Theme, Saving Customized Themes, Generating Filler Text, Changing Page Orientation and Paper Size, Setting Page Margins. Changing Margins for the Entire Document, Changing Default Margin Settings, Setting Margins for a Section in the Document, Setting Margins for a Portion of the Document, Adding a Gutter Setting, Formatting Mirror Margins, Formatting Margins for Printing Two Pages on One Sheet, Formatting Margins for a Booklet, Formatting Text in Columns,  Automatically Hyphenating Text,  Working with Document Sections, Creating a New Section,  Editing a Section Break,  Deleting a Section ,  Changing Vertical Text Alignment, Using Watermarks, Adding a Predesigned Watermark,  Creating a Custom Watermark,  Creating a Watermark with a Clipart Image,  Assigning a Watermark to Specific Pages, Removing a Watermark,  Adding Background Color to Pages,  Adding Borders to Pages, Indenting Paragraphs, Formatting a First Line Indent, Formatting a Full-Paragraph Indent, Formatting a Hanging Indent, Formatting a Negative Indent, Setting Tabs, Setting Tabs Using the Ruler, Setting Tab Stops Precisely, Adjusting Paragraph and Line Spacing,

Using Reference Features

Creating a Table of Contents, Creating a TOC Using Built-In Heading Styles, Adding More Entries to the TOC, Creating a TOC Using Custom Styles, Marking TOC Entries Manually, Displaying TOC Field Codes, Editing Field Codes, Updating a TOC, Removing a TOC, Creating Multiple TOCs in the Same Document, Using TC Fields to Create Multiple TOCs, Using Bookmarks to Create Multiple TOCs, Creating Footnotes and Endnotes, Inserting and Deleting a Footnote or an Endnote, Changing the Reference Mark Format, Restarting Reference Mark Numbering, Navigating Among Footnotes and Endnotes, Creating a Footnote or Endnote Continuation Notice, Converting Selected Notes to Footnotes or Endnotes, Converting All Notes to Footnotes or Endnotes, Creating Citations and Bibliographies, Choosing a Documentation Style, Inserting a Citation, Managing Sources, Generating a Bibliography, Displaying Bibliography Field Codes, Formatting Captions, Creating a Table of Figures, Formatting Cross-References, Creating a Cross-Reference, Displaying Cross-Reference Field Codes, Editing Cross-References, Creating an Index ,  Text for an Index Entry, Marking an Index Entry for a Range of Pages, Generating an Index, Updating an Index, Creating a Table of Authorities, Marking Citations for a Table of Authorities, Generating a Table of Authorities, Updating a Table of Authorities,

Creating Envelopes, Labels, and Merge Documents

Creating Envelopes and Labels, Printing an Address on an Envelope, Creating a Single Address Label, Creating a Full Page of the Same Label, Creating Mail Merge Documents, Starting the Mail Merge Process, Writing and Inserting Fields, Previewing Results, Completing the Merge, Merging to E-Mail,

Working with Others

Proofing Documents,  Checking Spelling and Grammar, Setting AutoFormat and AutoCorrect Options, Searching Local and Internet Services, Translating Text, Using Translation ScreenTips, Setting a Language for Proofing, Suppressing the Spelling and Grammar Check, Counting Words, Making Comments, Adding Comments, Editing and Deleting Comments, Tracking Changes, Displaying Tracked Changes and Comments, Displaying the Reviewing Pane, Printing Documents with Tracked Changes,  Accepting and Rejecting Changes, Comparing and Merging Documents,  Comparing Documents, Combining Documents,  Protecting Documents, Restricting Access to Modify Documents, Restricting Formatting and Editing, Removing Protection, Restricting Access for Opening or E-Mailing Documents, Sharing Documents, Removing Properties and Personal Information, Converting to PDF or XPS Format, Sending a PDF or XPS Attachment in an E-Mail

Creating and Using Macros

Displaying the Developer Tab, Creating Macros, Starting the Recording Process, Naming and Storing a Macro, Assigning a Shortcut to a Macro, Completing the Recording Process, Creating and Editing a Shortcut for an Existing Macro, Running a Macro, Editing a Macro, Renaming a Macro, Undoing a Macro, Deleting a Macro, Organizing Macros, Renaming a Macro Module, Copying a Macro Module, Deleting a Macro Module, Locking a Macro Project, Digitally Signing a Macro Project, Creating a Self-Signed Certificate, Signing a Macro Project, Obtaining a Digital Certificate, Setting Macro Security Options, Changing the Trust Center Settings,  Adding Signatures to the Trusted Publishers List,

Using Templates, Form Controls, and XML

Displaying the Developer Tab , Using Templates, Creating a New Document Based on a Template, Attaching a Template to a Document, Making a Template Global, Using a Document As a Template, Using Form Controls, Creating a Form with Content Controls,, Inserting Content Controls, Setting the Properties for Content Controls,  Adding Instructional Text, Grouping Content Controls, , Using Legacy Tools, Converting Controls to Word, Restricting Users from Editing the Document, Understanding XML, Using Schemas, Displaying XML Structure, Setting XML Options

Publishing Documents

Printing a Document, Using Duplex Printing, Printing a Booklet, Using Other Print Options, Preparing Documents for Electronic Distribution, Documents As a Template, Saving a Document in PDF or XPS Format, Saving a Document As a Web Page, Updating the Information in the Document Information Panel, Inspecting a Document, Encrypting a Document, Adding a Digital Signature to a Document, Document As Final, Running the Compatibility Checker, Publishing to a Blog, Publishing on a Document Management Server, Creating a Document Workspace, Creating a Web Page.

Excel

Our goal in present this application is to educate you, and in the process, make you more efficient on the job. The application contains everything that you need to know to learn from basics to advance of Excel and then move on to more advanced topics at your own pace. You’ll find many useful examples and lots of tips and tricks that We’ve accumulated.

It designed for beginning, intermediate, and advanced users. This program, covers all the essential components of Excel and provides clear and practical examples that you can adapt to your own needs. In this program, we’ve tried to maintain a good balance between the basics that every Excel user needs to know and the more complex topics that will appeal to power users.

Excel is, by far, the most popular spreadsheet tool. It is used by millions of end users each day to solve a wide range of problems. It provides solutions that span the gamut from simple list keeping to mission critical trading solutions.

Every financial department relies on it. Managers in business in every industry and at every level of the organization make decisions based on the numbers presented by and calculated in Excel.

Given how critical Excel is for business and users, it is not surprising that the need for better management, distribution, and incorporation of spreadsheets in larger applications is ever increasing.

WORKSHEET BASICS

Creating and Navigating Worksheets, Creating a Basic Worksheet, Editing Data, Navigating in Excel, Saving Files, Opening Files, 

Adding Information to Worksheets, Adding Different Types of Data, Quick Ways to Add Data, Moving Data Around a Worksheet, Selecting Cells, Moving Cells, Around, Adding and Moving Columns or Rows,

Managing Worksheets and Workbooks, Worksheets and Workbooks, Find and Replace, Spell Check,

Formatting Cells, Formatting Cell Values, Formatting Cell Appearance, Smart Ways to Apply Formatting,

Viewing and Printing Worksheets, Controlling Your View, Printing, Controlling Pagination, WORKSHEET POWER

Building Basic Formulas, creating a Basic Formula, Formula Shortcuts, Copying Formulas

Tables: List Management Made Easy, The Basics of Tables, Sorting and Filtering a Table,

Creating Basic Charts, Charting, Basic Tasks with Charts, Practical, Charting, Chart Type.

Formulas and Functions with Microsoft Office

Excel

Mastering Excel Ranges and Formulas

Getting the Most Out of Ranges, Using Range Names,          Building Basic Formulas,

Creating Advanced Formulas, Troubleshooting Formulas,

Harnessing the Power of Functions

Understanding Functions, Working with Text Functions,          Working with Logical and Information Functions, Working with Lookup Functions, Working with Date and Time Functions, Working with Math Functions, Working with Statistical Functions

Building Business Models

Analyzing Data with Tables, Business Modeling with PivotTables, Using Excel’s Business-Modeling Tools, Using Regression to Track Trends and Make Forecasts, Solving Complex Problems with Solver,

Building Financial Formulas

Building Loan Formulas, Building Investment Formulas, Building Discount Formulas

 Excel PivotTables and PivotCharts

 PivotTable Fundamentals

Understanding PivotTables and Charts, Understanding Data Sources for PivotTables, Using PivotTable Tools and Formatting,

PivotTables and Charts

Working with PivotTable Components, More About PivotTable Components, Understanding and Using Pivot Charts

Getting the Most out of PivotTables and Charts

Using PivotTables with Multidimensional Data, Getting Hard Data from a PivotTable, PivotTable Alternatives, Programming PivotTables with VBA

 Excel Services

Introducing Excel Services

Introduction to Excel Services, User and Administrator Cheat Sheet, Inside Excel Services, Programmability Options

Excel Web Services

Excel Web Services Reference, Building the Excel Services Library (ESL)

User Defined Functions

UDF Sample, UDF Reference, Client Support for Server UDFs

Excel Web Access  

Using Excel Web Access

Reusable Excel Web Services Projects

Utilizing Web Services in UDFs, Custom Web Services, RSS over Excel Services, Excel Services as an RTD Server, Real Time Data UDF, Directly Parameterized Workbooks, SQL Tables and SharePoint Lists, External Workbook References, Excel Services Workflows, EWA Projects, Excel Data Filter, Excel Services Mashup

Excel Power Programming with VBA 

 Some Essential Background

Excel Where It Came From, Excel in a Nutshell, Formula Tricks and, Techniques, Understanding Excel’s Files

Excel Application Development

 Spreadsheet Application, Essentials of Spreadsheet Application Development

 Understanding Visual Basic for Applications

Introducing Visual Basic for Applications, VBA Programming Fundamentals, working with VBA Sub Procedures, Creating Function Procedures, VBA Programming Examples and Techniques

 Working with User Forms

Custom Dialog Box Alternatives, Introducing UserForms, UserForm Examples, Advanced UserForm Techniques

 Advanced Programming Techniques

Developing Excel Utilities with VBA, Working with Pivot Tables, Working with Charts, Understanding Excel’s Events, Interacting with Other Applications, Creating and Using Add-Ins

 Developing Applications

Working with the Ribbon, Working with Shortcut Menus, Providing Help for Your Applications, Developing User-Oriented Applications

Compatibility Issues, Manipulating Files with VBA, Manipulating Visual Basic Components, Understanding Class Modulesrking with Colors 

Excel Data Analysis and Business Modelling 

Range Names, Lookup Functions, The INDEX Function, The MATCH Function, Text Functions, Dates and Date Functions, Evaluating Investments by Using Net Present Value Criteria, Internal Rate of Return, More Excel Financial Functions, Circular References, IF Statements, Time and Time Functions, The Paste, special Command, The Auditing Tool, Sensitivity Analysis with Data Tables, The Goal Seek Command, Using the Scenario Manager for Sensitivity Analysis, The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions, The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions, The OFFSET Function, The INDIRECT Function, Conditional Formatting, Sorting in Excel, Tables, Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes, An Introduction to Optimization with Excel Solver, Using Solver to Determine the Optimal Product Mix, Using Solver to Schedule Your Workforce, Using Solver to Solve Transportation or Distribution Problems, Using Solver for Capital Budgeting, Using Solver for Financial Planning, Using Solver to Rate Sports Teams, Importing Data from a Text File or Document, Importing Data from the Internet, alidating Data, Summarizing Data by Using Histograms, Summarizing Data by Using Descriptive Statistics, Using PivotTables to Describe Data, Summarizing Data with Database Statistical Functions, Filtering Data and Removing Duplicates, Consolidating Data, Creating Subtotals, Estimating Straight Line Relationships, Modeling Exponential Growth, The Power Curve,  Using Correlations to Summarize Relationships, Introduction to Multiple Regression, Incorporating Qualitative Factors into Multiple Regression, Modeling Nonlinearities and Interactions, Analysis of Variance: One-Way ANOVA, Randomized Blocks and Two-Way ANOVA , Using Moving Averages to Understand Time Series, Winter ’s Method, Forecasting in the Presence of Special Events, An Introduction to Random Variables, The Binomial, Hypergeometric, and Negative Binomial Random Variables, The Poisson and Exponential Random Variable, The Normal Random Variable,  Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project, Introduction to Monte Carlo Simulation, Calculating an Optimal Bid,  Simulating Stock Prices and Asset Allocation Modeling, Fun and Games: Simulating Gambling and Sporting Event Probabilities, Using Resampling to Analyze Data, Pricing Stock Options, Determining Customer Value, The Economic Order Quantity Inventory Model, Inventory Modeling with Uncertain Demand, Queuing Theory-The Mathematics of Waiting in Line, Estimating a Demand Curve, Pricing Products by Using Tie-Ins, Pricing Products by Using Subjectively Determined Demand, Nonlinear Pricing, Array Formulas and Functions

Access

This program for beginning, intermediate, and even advanced users of Microsoft Access. With any product, most users start at the beginning. This program by Unique Computer Institute   covers Microsoft Access in detail better. You’ll find this program by Unique Computer Institute helpful while working with Access, and that you enjoy the innovative style of a Wiley program by Unique Computer Institute.

If you’re new to the world of database management, this program by Unique Computer Institute has everything you need to get started with Microsoft Access. It then offers advanced topics for reference and study. Beginning developers should pay particular attention, where we cover the essential skills necessary for building successful and efficient databases. Your ability as a database designer is constantly judged by how well the applications you build perform, and how well they handle data entrusted to them by their users. The chapters in course won’t necessarily make you an expert database designer, but we guarantee you’ll be a better developer if you carefully read this material.

This program by Unique Computer Institute will take you through each subject step by step.

Exploring Access

Working in Access, Understanding Database Concepts, Opening an Existing Database, Exploring Tables, Exploring Queries, Exploring Forms, Exploring Reports, Exploring Other Access Objects, Previewing and Printing Access Objects

Creating a Database

Creating a Database from a Template, Creating a Table Manually, Creating a Table from a Template, Manipulating Table Columns and Rows

Populating a Database

Importing Information from Another Access Database, Importing Information from an Excel Worksheet, Importing or Linking to a SharePoint List, Collecting Data Through E-Mail, Importing Information from a Text File, Importing Information from an XML File, Importing Information from an HTML File, Importing Information from an Outlook Folder, Importing Information from a dBASE File

 Sharing and Reusing Information

 Exporting Information to Another Access Database, Exporting Information to Excel Exporting Information to a SharePoint List, Exporting Information to Word, Exporting Information to a Text File, Exporting Information to an XML File, Exporting Information to an HTML File, pying Information to Other Office Programs

Simplifying Data Entry by Using Forms

Creating a Form by Using the Form Tool, Refining Form Properties, Changing the Arrangement of a Form, Adding Controls to a Form, Entering Data in a Form by Using VBA , Creating a Form by Using an AutoForm,  Adding a Subform to a Form

Locating Specific Information

Sorting Information in a Table, Filtering Information in a Table, Filtering Information by Using a Form, Locating Information That Matches Multiple Criteria,  Creating a Query Manually, Creating a Query by Using a Wizard, Performing Calculations by Using a Query

Keeping Your Information Accurate

Restricting the Type of Data in a Field, Restricting the Amount of Data in a Field, Specifying the Format of Data in a Field, Restricting Data by Using Validation Rules, creating a Simple Lookup List, creating a Multi-Column Lookup List, Updating Information in a Table, Deleting Information from a Table, Preventing Database Problems

 Working with Reports

Creating a Report by Using a Wizard, Modifying Report Design, Creating a Report Manually, Modifying Report Content, Adding a Subreport to a Report, Previewing and Printing a Report

Making Your Database Easy to Use

Creating a Switchboard, Creating Custom Categories, Controlling the Features Available to Database Users, Making Favorite Access Commands Quickly Available,

Securing and Sharing Information

Assigning a Password to a Database, Preventing Changes to Database Code, Securing a Database for Distribution

Access Building

An Introduction to Database Development, Creating Access Tables, Designing Bulletproof Databases, Selecting Data with Queries, Using Operators and Expressions in Access, Working with Datasheet View, Creating Basic Access Forms, Working with Data on Access Forms, Chapter 9: Presenting Data with Access Reports

Programming Microsoft Access

VBA Programming Fundamentals, Mastering VBA Data Types and Procedures, Understanding the Access Event Model, Using Expressions in Queries and VBA Code, Accessing Data with VBA Code, Using the VBA Debugging Tools

More Advanced Access Techniques

Working with External Data, Importing and Exporting Data, Advanced Access Query Techniques, Advanced Access Form Techniques, Advanced Access Report Techniques, Building Multiuser Applications, Integrating Access with Other Applications, Integrating Access with SharePoint, Using ActiveX Controls, Handling Errors and Exceptions

Professional Database Development

Optimizing Access Applications, Advanced Data Access with VBA, Bulletproofing Access Applications, Securing Access Applications, Using the Windows API, Using the Access Replication Features, Object-Oriented Programming with VBA, Chapter 33: Reusing VBA, Code with Libraries, Customizing Access Ribbons, Distributing Access Applications, Using Access Macros

Access as an Enterprise Platform

Using XML in Access, SharePoint as a Data Source, Client/Server Concepts, SQL Server as an Access Companion, Upsizing Access Databases to SQL Server

PowerPoint

Whether you need to put together a quick presentation of sales figures for your management team or create a polished slide show for your company’s stockholders, PowerPoint can help you present your information efficiently and professionally.

PowerPoint is a presentation graphics program software that helps you create a slide show presentation and supplements, such as handouts and speaker’s notes. A slide show presentation is made up of a series of slides that can contain charts, diagrams, pictures, SmartArt graphs, bulleted lists, eye-catching text, multimedia video and sound clips, and more.

PowerPoint provides a variety of professionally designed templates, themes and style galleries to help you create great-looking presentations.

Provided program features by us.

PowerPoint is a full-featured presentation program that helps you quickly and efficiently develop dynamic, professional-looking presentations and then deliver them to an audience. You can use PowerPoint to:

• • Introduce an idea, proposal, organization, product, or process with professionally designed high-impact slides.
  • Use galleries of styles and formatting options to achieve the right combination of colors, fonts, and effects.
  • Bolster your arguments by easily adding pictures, shapes, and fancy display text.
  • Convey numeric data in easy-to-grasp ways with styled tables or visually compelling charts.
  • Use SmartArt graphics to create sophisticated diagrams that reflect processes, hierarchies, and other relationships.
  • Create custom layouts so that your presentation has a unique look and feel.

Collaborate with colleagues, giving and receiving feedback to ensure the best possible presentation.

PowerPoint

 Starting PowerPoint, Developing Presentation Content, Designing a Look, Drawing and Modifying Shapes , Inserting Pictures and Multimedia, Inserting Charts and Related Material, Creating a Web Presentation, Finalizing a Presentation and Its Supplements, Preparing a Slide Show,  Presenting a Slide Show ,  Reviewing and Securing a Presentation, Working Together on Office Documents, Customizing the Way You Work, Expanding PowerPoint Functionality

Building your Presentation

 A First Look at PowerPoint, Creating and Saving Presentation Files, Creating Slides and Text Boxes, Working with Layouts, Themes, and Masters,  Formatting Text, Formatting Paragraphs and Text Boxes, Correcting and Improving Text, Creating and Formatting Tables

Using Graphics and Multimedia Content

 Chapter 10 – Drawing and Formatting Objects, Creating SmartArt Diagrams, Using and Organizing Clip Art, Working with Photographic Images, Working with Charts, Incorporating Data from Other Programs, Adding Sound Effects, Music, and Soundtracks, Incorporating Motion Video, Creating Animation Effects and Transitions

Interfacing with Your Audience

 Creating Support Materials, preparing for a Live Presentation, Designing User-Interactive or Self-Running Presentations, preparing a Presentation for Mass Distribution, Sharing and Collaborating,

Financing Analysis

Presenting Content Without Bulleted Lists 

Outlook

This program of Unique Computer Institute provides the people for Understanding all of the Outlook features and putting them to work is the focus of Microsoft Office Outlook Inside Out. Outlook program is act mainly as how-to guides for users who want to study about the software. This approach also stay in workgroup managers and administrators when it comes to deployment, collaboration, server-side issues, and administration. Microsoft Office Outlook offers a comprehensive look at the features most people will use in Outlook and serves as an excellent reference for users who need to understand how to accomplish what they need to do. In addition, this program of Unique Computer Institute goes a step or two further, providing useful information to advanced users and IT professionals who need to understand the bigger picture. Whether you want to study Outlook for your own use, need to support Outlook on a peer-to-peer network, or are in charge of supporting Outlook under Microsoft Exchange Server, you’ll find the information and answers you need between the covers of Microsoft Office Outlook. This program of Unique Computer Institute makes some assumptions about the reader. You should be familiar with your client operating system, whether it’s Microsoft Windows. You should be comfortable working with a computer and have a good understanding of how to work with menus, dialog boxes, and other aspects of the user interface.

In short, Microsoft Office Outlook assumes that you’re an experienced computer user who might or might not have an understanding of Outlook and what it can do. The purpose of this program of Unique Computer Institute is to give you a comprehensive look at what Outlook can do, how to put Outlook to work, and how to manage Outlook at the user, workgroup, and server levels.

Office Outlook

Introducing Outlook, Getting Started with Outlook, Managing Contact Information, Sending E-Mail Messages, Handling E-Mail Messages,  Managing Your Inbox, Meetings Appointments, Events, and Meetings, Managing Your Calendar, Tracking Tasks, Gathering Information, Collaborating with Other People,  Working Away from Your Office, Customizing and Configuring Outlook 

Getting Started

Getting Started with Outlook, Installing and Using Outlook

Working with Email

Working with Email Accounts, Fundamentals of Email, Formatting Your Email Messages, Working with Advanced Email Message, Components and Editing Tools, Understanding Email Options, Dealing with Junk Email, Processing Messages with Rules

Managing Information

Managing Your Contacts, Working with the Calendar, Working with Schedules and Meetings, Working with Outlook Notes, Using the Journal, Keeping Track of Tasks, Making Use of RSS Feeds,

Getting the Most Out of Outlook

Making the Most of Outlook Categories, Working with Outlook, Folders and Data Files, Customizing Outlook to Suit the Way You Work, Managing Security Issues, Using Outlook with Other, Applications

Programming Outlook

Writing Macros and Visual Basic Code in Outlook, Getting Started with VBA, Understanding the Outlook Object Model, Programming Outlook with VBA: Some Examples, Working with Outlook Forms, Going Beyond Basic Forms

Additional Topics

Using Outlook with Exchange Server, Using Outlook with SharePoint

Visio

This application is for anyone who has an idea that he or she wants to put down on paper. It doesn’t matter who you are; somewhere, someone has a template you can use to start drawing quickly and has a set of stencils with shapes for your particular trade. The number of templates and stencils that Visio provides is nothing short of amazing. Visio is all about you. Instead of forcing you to jump through hoops, Visio helps you get that idea down on paper. This application is your guide to all of the cool features that Visio provides. If you want to get started creating drawings for your ideas quickly, this is the application to get.

With this in mind, Visio is designed to make you productive as quickly as possible. You find basic, useful information that helps you accomplish your goals. You find real world examples and figures that show you how to do something rather than just tell you. You find concise step by step instructions for accomplishing specific tasks rather than a lot of rambling text that fills space and means nothing to you. This application doesn’t provide everything to everyone. For example, even though Visio supports Visual Basic for Applications (VBA) so you can write programs to make it do even more, this application doesn’t discuss VBA. Visio focuses on user tasks; it makes you more productive, fast.

 Getting Started with Visio

 Starting Diagrams by Using Templates, Working Within the Visio Environment, Customizing the Visio Environment, Getting Visio and Diagram Help

Adding Shapes to Diagrams

Working with 1-D and 2-D Shapes, Adding Text to Shapes and the Drawing Page, Moving, Sizing, Rotating, and Copying Shapes, Working with Groups, Finding Shapes for Diagrams, Inserting Pictures into Diagrams

Formatting Shapes and Diagrams

Formatting Individual Shapes, Adding Decorative Elements to Diagrams, Applying Themes to Entire Diagrams

Connecting Shapes

Connecting Shapes in Flowcharts, Modifying Shape Connections, Changing the Layout of Connected Shapes

Creating Project Schedules

Creating Timelines to View Projects at a Glance, Exporting Timelines to Create Gantt Charts,  Tracking Project Details with Gantt Charts

Creating Organization Charts

Importing Data to Create Organization Charts, Storing and Displaying Employee Information in Organization Charts, Customizing the Layout of Organization Charts,

Laying Out Office Spaces

Creating Scaled Office Spaces, Adding Door, Window, and Furniture Shapes to Office Layouts, Organizing Shapes in Office Layouts by Using Layers

 Creating Network Diagrams

Connecting Shapes in Network Diagrams, Storing Information with Network Shapes, Creating Network Reports

Understanding Visio Fundamentals

Getting Started with Visio, Getting Started with Drawings, Working with Visio File, Working with Shapes, Connecting Shapes, Working with Text

Integrating Visio Drawings

Importing, Exporting, and Publishing to the Web, Linking Shapes with Data

Using Visio for Office Productivity

Collaborating with Others, Building Block Diagrams, Building Visio Flowcharts, Documenting Processes, Workflows, and Data Flows, Scheduling Projects with Visio, Documenting Brainstorming Sessions, Analyzing Results with PivotDiagrams

Using Visio in Information Technology

Modeling and Documenting Databases, Building UML Models, Building Software Development Diagrams, Mapping Web Sites, Creating Network Diagrams

Using Visio for Architecture and Engineering.

Working with Scaled Drawings, Creating and Managing Scaled Drawings , Laying Out Architectural and Engineering Plans, Planning Space and Managing Facilities, Integrating CAD and Visio, Working with Engineering Drawings

Customizing Stencils, Templates, and Shapes

Creating and Customizing Templates, Creating and Customizing Stencils, Creating and Customizing Shapes, Customizing Shapes Using ShapeSheets , Formatting with Styles, Customizing Toolbars and Menus

SharePoint

The mission of this application is to provide extensive knowledge to information workers and site managers that will empower them to become SharePoint Application champions in the organization. To complete the exercises in this application, you should have a basic comfort level using Microsoft Office application to create content and a general understanding of how to interact with a website through the browser. This application is intended as a starting point for any SharePoint user whether that user has never used SharePoint before or has some familiarity.

SharePoint is the server side connective tissue that binds the slippery client-side outputs of office workers into a manageable, searchable, and accessible information environment. Gone are the days when workers just organized their files in electronic folders and had to call the help desk every time something was deleted accidentally. SharePoint provides a self-service environment where office workers can take control of information – how it’s organized, who gets access to it, and how it’s displayed.

SharePoint Server

Getting Started with Microsoft Office SharePoint Server, Working with SharePoint Lists, Working with SharePoint Libraries, Managing and Customizing Lists and Libraries, Working with Workflow, Working with Content Types, Working with Web Parts, Working with Sites and Workspaces,  User Management, Audiences, and Profiles, Working with Forms Services, Working with Excel Services, Working with the Business Data Catalog, Getting Started with Web Content Management, Working with Search

SharePoint Products and Technologies Fundamentals

Overview of SharePoint Products and Technologies Administration

Deploying SharePoint Products and Technologies

 SharePoint Core Administration

Central Administration, Creating Site Collections Customizing Sites, Using Workflows and Information Management Policies, Implementing Security for SharePoint Products

Working with SharePoint Server

Deploying SharePoint Server Shared Services, Configuring SharePoint Server Portals, Configuring Office SharePoint Server Enterprise Content Management, Configuring Office SharePoint Server Excel Calculation Services, Configuring SharePoint Server Search and Indexing

SharePoint Performance and Operations

Scaling Out to a SharePoint Technologies Server Farm, Backup and Restore of SharePoint Products and Technologies, Logging and Processing Analysis

Exploring SharePoint’s Building Blocks

Introducing Sites and Site Content, Navigating SharePoint, Granting Access to SharePoint Managing Data with SharePoint, Managing Business Processes with SharePoint,

Improving Information Worker Collaboration and Productivity

Using SharePoint for Collaboration, Communicating with SharePoint, Using Portal Sites, Configuring Profiles and My Sites, Personalizing Sites, Searching the Enterprise,

Enterprise Applications for SharePoint

Exploring Document and Records Management, Publishing Web Content, Providing Access to Business Intelligence

Administering SharePoint

Administering and Monitoring SharePoint, Backing Up the Server

Accounting

Maintaining Company Data

• • Creating and Maintaining a Company
  • Loading a Company
  • Company Features

Accounting Features, Inventory Features, Statutory & Taxation, Audit Features,  Add-On Features

• • Configuration

Numeric Symbols, Accts / Inventory info, Voucher Entry, Invoice/Orders Entry, Banking Configuration, Printing, Data Configuration, Advanced Configuration, Product & Features, Multi Address, Enabling Multi Address, Use Multiple Addresses for Ledger Account, Print Multiple Addresses in Reports

• Accounting

o        Groups

Default Groups, Pre-defined Groups, Create, Alter, Delete Groups, Manage Groups in Multiple Companies, Group with Advanced Options, Ledgers, Bank Ledger, Party Ledger, Purchase/Sales Ledger, Voucher Types, Pre-defined Voucher Types, Multi User Voucher Numbering, Sales and Manufacturing Journal Voucher Types, Voucher Class, Cost Centre Class

o        Accounting Vouchers

Predefined Vouchers

         Contra Entry

Creating Contra Entry in Single Entry Mode, Creating Contra Entry in Double Entry Mode

         Payment Entry

Creating a Payment Entry, Creating a Payment Entry with Narration for each Entry, Creating a Payment Entry using Bank, Warn on Negative Cash Balance, Pre Allocate Bills for Payment/Receipt

         Journal Entry

Creating a Journal Entry, Allowing Cash Accounts in Journals

         Printing Payment, Receipt and Journal Vouchers based on Due Date

         Debit Note Entry

         Credit Note Entry

         Post-dated Cheque Entry

Optional & Non-Accounting Vouchers

         Memorandum Voucher

         Optional Vouchers

         Reversing Journals

         Post Dated Vouchers

o        Using Cost Categories and Cost Centres

o        Cost Categories

o        Cost Centres

o        Multi-currency

o        Using Multi-currency

o        Credit Limits

o        Budgets

Creating Budgets for Groups, Creating Budgets for Ledgers, Creating Budgets for Cost Centres, Viewing Budget Variance, Managing Scenarios

o         Interest Calculations

Interest Calculation based on Bank Date/Voucher Date, Including/excluding date of transaction for interest calculation, Book Entries and adjustment of interest

Inventory

o         Stock Items

o         Stock Groups

o         Stock Categories

o         Units of Measure

o         Godowns/Locations

Godown Summary/Location Summary, Manage Godowns/Locations for Third-Party, FAQs on Godowns/Locations

o         Bill of Materials for a Stock Item

o         Batches and Expiry Dates

o         Stock Journal Voucher Class

o         Manufacturing Journal Voucher Type

o         Inventory Vouchers

Receipt Note Voucher (GRN), Rejections In Voucher (Sales Returns), Delivery Note Voucher, Rejections Out Voucher (Purchase Returns), Material Out, Material In, Stock Journal Voucher, Physical Stock Voucher

o         Using Batchwise details

o         Using Mfg. and expiry dates

o         Reorder levels and Reorder Quantity

o         Price Levels

o         Price Lists

o         Item Cost Tracking

Item Cost Tracking in Transactions, Item Cost Analysis Reports, Job Work, Introduction to Job Work, Enabling Job Work, Creating Masters, Job Worker and Principal Manufacturers Ledgers, Voucher Types – Material Out and In, Stock Items – Finished Goods, Stock Item – Scrap/By-Products/Co-Products, Stock Items – Raw Materials

         Job Work Out Process (Transactions & Reports

         Job Work Out Transactions

Job Work Out Order (for a Stock Item without BOM), Job Work Out Order (for a stock Item with BOM), Transfer of Material towards a Job Order, Receipt of Finished Goods Against a Job Order, Accounting Purchase of Job Work Service, Payment to Job Worker

         Job Work Out Reports

         Order Outstanding

Orders, Components

         Job Work Registers

Material Movement Register

         Job Work Analysis

Issue Variance, Receipt Variance

         Job Work In Process (Transaction & Reports)

         Job Work In Transactions

Job Work In Order, Receipt of Material towards a Job Order, Transfer of Own Consumed Goods for Production, Manufacture of Finished Goods, Delivery of Finished Goods towards a Job Order, Raising Sales Bill for the Job Work, Receipts from Principal Manufacturer, Job Work In Reports

         Order Outstandings

Orders, Components

         Job Work Registers

Job Work In Orders Book, Material Out Register, Material In Register, Material Movement Register

         Job Work Analysis

Issue Variance, Receipt Variance

• • • Sales & Purchase

o         Sales

Creating a Sales Invoice, Configuring a Invoice, Printing a Sales Invoice, Allow Income Accounts in Sales Vouchers

o         Recording a Purchase Entry

o         Using different Actual and Billed Quantities

o         Using Zero Valued Entries

o         Point of Sale (POS)

Creating a POS Voucher Type without Voucher Class, Creating POS Voucher Type with Voucher Class, Creating a POS Invoice, Creating a POS Invoice with Multi-Mode Payment, Printing a POS Invoice, Displaying POS Register

o         Order Processing

         Enabling Order Processing

         Sales Order Processing

Creating a Sales Order

         Viewing Order Position

         Pre-Closure of Order

Closure from Order Voucher, Closure from Delivery/Receipt Note, Closure from Invoice

o         Using Additional Cost of Purchase

o         Using Tracking Numbers

• • • • Job Costing

o         Creating Purchase Vouchers

o         Creating Stock Journal Vouchers for Job Costing

o         Creating Manufacturing Journal for Job Costing

o         Creating Journal Vouchers for Job Costing

o         Creating Payment Vouchers for Job Costing

o         Creating Sales Voucher for Job Costing

o         Job Work Analysis Report

o         Materials Consumption Summary Report

o         Comparing Jobs or Projects

• • • • Reports

o         Modifying Reports

o         Display Financial Statements

         Display Balance Sheet

Configuring the Balance Sheet, Integrate Accounts with Inventory, Setting Closing stock manually in the Balance Sheet, Displaying Balance Sheet with different Stock Valuation methods

         Display Profit & Loss A/c

Display Profit & Loss Account, Configuring Profit & Loss Account, Income/Expense Statement instead of P&L?

         Display Receipts & Payments A/c

Display Receipts & Payment A/c, Configuring Receipts & Payments Account, Receipts & Payments Summary Reports

         Display Trial Balance

Trial Balance,  Configuration in Trial Balance

o         Display Registers & Ledgers

         Display Sales Register

Display Columnar Sales Register, Sales Register (Sales Day Book), Display Monthly Sales Summary, Display Extract of Sales Register, Display Sales Register with Profitability, Display Comparative Sales Register

         Display Cash Book

Display Cash Book, Display Multi-Column Cash Book

         Display Statement of Accounts

Statements of Accounts, List of Accounts (Chart of Accounts), Display Group Summary, Display Group Vouchers, Display Ledger Vouchers, Display Statistics

         Display Purchase Register

         Display Journal Register

         Credit Note Register

         Debit Note Register

         Payment Register

         Display Day Book

o         Display Inventory Reports & Statements

         Displaying Stock Summary

         Displaying Stock Items

Viewing Stock Item Vouchers, Stock Query, Stock Transfers Register, Physical Stock Register, Stock Cost Estimation

         Godown Location Stock Flow Reconciliation

         Movement Analysis

Stock Group Analysis, Stock Category Analysis, Stock Item Analysis, Group Analysis, Ledger Analysis, Transfer Analysis

         Stock Ageing Analysis

Stock Ageing Analysis, How to change default ageing period, Item Inward Details

         Sales and Purchase Orders

Sales Order Book, Sales Order Summary, Purchase Orders Book, Purchase Order Summary, Purchase Bills Pending, Sales Bills Pending, Reorder Status, Display Batch-wise Reports, Management Information System (MIS) Reports

         Receivables and Payables

Display Receivables, Display Payables, Ledger Outstandings Report, Group Outstandings Report , Ageing Analysis Report, Bill- Party-wise Outstandings Report, Configuring and Printing Reminder Letters, Configuring and Printing Confirmation Statements

         Cost Centre Reports

         Cash Flow 

         Fund Flow i

         Cash Flow Projection

Cash Flow Projection

         Ratio Analysis Report

Display Ratio Analysis Report, Principal Groups and key figures, Payment Performance of Sundry Debtors

         Exceptional Reports

Negative Stock, Negative Ledgers, Overdue Receivables, Overdue Payables, Display Memorandum Vouchers, Display Reversing Journals, Display Optional Vouchers, Display Cancelled Vouchers, Display Post Dated Vouchers, Email IDs, Excise Dealer

Banking

o         Setting up Banking Features

o         Creating Bank Ledgers

o         Creating Party Ledgers

o         Creating Payment Voucher with Voucher Class

o         Cash Deposit Slip

o         Payment Advice

o         Cheque Management

         Voucher Entry

         Cheque Deposit Slip

         Cheque Printing

         Configure Bank Ledgers and Print Cheques

         Printing a Self Cheque

         Disabling company name during cheque printing

         Printing Cheques Without Date

         Cheque Register

         Post Dated Cheques

         Creating a Post-dated Voucher

         Enabling Notional Bank

         Post-dated Summary

         Post-dated Issued

         Post-dated Received

         Post-dated Transactions

         Viewing Post-dated reports with or without Actuals

         Viewing Current and Final Balances

o         e-Payments

         Setting Security Control for e-Payments

         Providing Bank Details in a Party Ledger

         Sending Transactions to Bank from Voucher

         e-Payment Report

o         Bank Reconciliation

         Manual Bank Reconciliation

         Auto Bank Reconciliation – View and import or re-import Bank Statement

         Removing Opening BRS after Splitting the Company Data

o         Configure Bank Ledgers and Print Cheques

Statutory and Taxation

 Taxation – India

GST

         Activate GST for Your Company

         Regular

         Start Using for GST Compliance

         Setting Up GST Rates

         Creating GST Classification

         Updating Stock Items and Stock Groups for GST Compliance

         Updating a Service Ledger for GST Compliance

         Updating Sales and Purchase Ledgers for GST Compliance

         Updating Party GSTIN

         Creating GST Ledgers

         Creating Income and Expense Ledgers

         Providing GST Details

         Record Taxable Sales

         Record Purchases

         Record a Tax Payment

         Other Scenarios

         GSTR-1

         GSTR-2

         GSTR-3B

         GST Annual Computation

         File GSTR-9

         File GSTR-9C

         Other Reports

         Kerala Flood Cess

         Managing Kerala Flood Cess

         KFC Computation Report

         Filing Form KFC-A using

         Composition

         GST Registration Change

         GST Compliance for Composition Dealers

         Stock Items and Ledgers

         Tax Rate Setup

         Purchases

         Sales and Print Invoices

         Imports

         Purchase Returns

         Sales Returns

         Tax Liability

         GST CMP-08

         GSTR-4

         File GSTR-9A

         e-Way Bill

         Getting Started with Statutory and Taxation

         Define Statutory Details and Record Transactions

         Generate and File Returns

         Triangulate and Generate Returns

         Filling Form MSME-1 Using

Service Tax

         Getting started with Service Tax

         Other Configurations for Service Tax

         Defining Service Tax

         Defining Service Tax Rate at Company Level

         Defining Service Tax Rate at Ledger Level

         Defining Service Tax Rate at Group Level

         Defining Service Tax Rate at Stock Item Level

         Defining Service Tax in Voucher Type

         Masters

         Creating a Group with Service Tax Details

         Creating Service Purchase Ledger

         Creating Service Sales Ledger

         Creating Service Category

         Party Ledgers

         Creating Service Provider Ledger

         Creating Service Receiver Ledger

         Tax Ledgers

         Creating Common Tax Ledger

         Creating Service Tax Ledger

         Creating Education Cess Ledger

         Creating Secondary Education Cess Ledger

         Creating Swachh Bharat Cess Ledger

         Krishi Kalyan Cess Ledger

         Creating a Tax Unit

         Inventory Masters

         Creating Stock Group

         Creating Stock Item

         Configurations for Masters

         Transactions

         Sale of Service

         Purchase of Service

         Exports

         Pure Agent Services

         Sale of Service by Professionals

         Advance Receipt with Service Tax

         Sale of Service with Tax Abatement

         Exempted Services

         Input Service Distributor

         Voucher Class for Sales

         Recipient Liability

         Service Received from Non-taxable Territory

         Import of Services

         Reverse Charge

         Modifying Tax Details in Transactions

         Adjustment Entries

         Availing Input Credit

         Service Tax Adjustment Flags

         Adjustment Towards Advance Swachh Bharat Cess Paid

         Adjustment Towards Tax Paid but Service not Rendered

         Adjustment Towards Excess Swachh Bharat Cess Paid

         Payment

         Regular Payment

         Payment of Swachh Bharat Cess

         Arrears

         Advance Payment

         Recipient Liability

         Penalty

         Penalty on Swachh Bharat Cess

         Penalty on Krishi Kalyan Cess

         Interest

         Interest on Swachh Bharat Cess

         Interest on Krishi Kalyan Cess

         Late Fee

         Printing Invoice

         Reports

         Form ST3

         Summary of Vouchers

         Printing, Exporting and Validating Form ST-3 Report (Service Tax)

TDS

         Getting Started with TDS

         Configuring TDS

         Masters

         TDS Nature of Payment

         Creating Expense Ledger

         Creating TDS Party Ledger

         Creating TDS Ledger

         Creating Stock Item

         Creating Fixed Asset Ledger

         Other Configurations in Masters

         Transactions

         TDS on Expenses

         TDS on Advance Payment

         TDS at Lower Rate

         TDS at Zero Rate

         Accounting for Expenses, Deducting TDS Later

         Recording TDS Payment Transaction

         Reversal of Expenses with TDS

         TDS on Expenses with Inventory

         TDS on Fixed Assest

         TDS on Purchase of Software

         TDS on Transport

         TDS on Interest Payable or Paid

         TDS Reports

TCS

         Getting Started with TCS

         Other Configurations for TCS

         Masters

         TCS Nature of Goods

         Creating Party Ledger

         Creating Sales Ledger

         Creating Stock Item

         Creating TCS Ledger

         Other configurations

         Transactions

         Sales

         Sale of TCS Goods at Lower Rate

         Sale of TCS Goods at Zero Rate

         TCS on Purchases

         Payment of TCS

         Payment of TCS

         Payment of Late Fee

         Payment of Interest and Penalty

         Form 27EQ

         Statistics of Vouchers

         Collection Details

         Included Transactions

         Excluded Transactions

         Uncertain Transactions

         Payment Details

         Saving Form 27EQ

         Return Transaction Book

         File TCS Returns

         TCS Outstanding Report

         Challan Reconciliation