Advanced Microsoft Training IN Nepal

---

Basic computer knowledge is needed for all types of entry-level job today. It is important to know at least to run day to day operation in a computer using Microsoft any other simple task. Basic computer skill is of essential in both personal and professional life.

            Microsoft training is Nepal has designed this Microsoft training package focusing the professionals who are handling day to day office tasks with the use of basic office package software including Word, Excel, and PowerPoint. MS Excel lets you learn advance excel with the most advance tutorial which covers depth lessons on how to use various Excel formulas, Table and charts for managing small to large scale business process. MS Word is the most popular word processing software. In this training, participants will be given an overview of the different features of Microsoft Word. Participants will learn to use Microsoft Word to produce professional-looking documents. MS PowerPoint helps participants will get an opportunity to learn how to create a PowerPoint presentation functions covered in the session are how to create a slide, add content (text, graphics, object and picture to start a show.

We offer you on building jobholder’s confidence in Microsoft Office programs. Microsoft Excel training helps to work with calculations, data entry, and data analysis. Microsoft PowerPoint training helps in building slides and presentations for seminars, workshops, meeting and so on. This package is targeted for data analysts, business managers, accounts, research scientists, students and other professionals for enhancing their analytical skill and strategic decision making ability.  It also helps to make trainees familiar with advance Microsoft package features that are useful in performing complex business operations and overall management functions.

            Microsoft training in Nepal provides advance office package training. If anybody wants to join on the separate course on individual software like Advance MS Word, Advance MS Excel, this is also possible with us. Microsoft training is Nepal has certification paths for many technical job roles. Microsoft certified trainers have completed rigorous training and have met stringent technical certification requirements and the learning partners offer a breadth of solutions to suit your learning needs, empowering you to achieve your training goals.

             Microsoft Certified Trainers, can be confident that your skills will be accurate, complete and up to date.  It also can take you from the start of your career to its pinnacle. Certification can increase your visibility, differentiate you from peers and validate your skills and knowledge.

 

Course Outline - Advanced Microsoft Training IN Nepal

---

Time: 1.5 hrs/day

Course Duration: 1.5 months

Access Introduction

Database concepts and terminology

• Database terminology and concepts
• Exploring the Access environment
• Planning and designing databases
• Getting help
• Closing a database and Access

Access Basics

• Exploring Tables
• Exploring Forms
• Examining Queries
• Exploring Reports

Creating a Database

• Create a new Database
• Creating a Table
• Entering Field Names and Data Types
• Add a Primary Key
• Enter Records into a Table

Working with Fields and Records

• Modify a table design
• Find values in a table
• Filter Records
• Sort Records

Querying Tables

• Create, run, sort and save queries
• Modify query results
• Use Comparison Operators AND, OR, NOT, BETWEEN
• Find record with empty fields
• Create queries from more than one table
• Creating a Summary query

Creating and using Forms

• Create a form automatically
• Create a form with the Form Wizard
• Modify a Form in Design View
• Find, sort and filter records when using a Form

Creating and using Reports

• Create reports with the Report Wizard from tables or queries
• Group records in a report and summarize data
• Modify and print reports

Importing, Exporting and Linking Objects

• Importing from Excel
• Importing Objects from Access
• Exporting Objects to Access
• Linking Access Tables
• Linked Table Manger

Access Intermediate

Creating a relational database

• Set relationships between tables
• Relationship types
• Referential integrity between tables

Working with Related Tables

• The Lookup Wizard
• Using Design view to modify Lookup field properties

Defining data entry rules

• Use the Input Mask wizard
• Setting field properties

Use advanced query features

• Join tables in queries
• Joining tables in design view
• Using the Query Wizard
• Create calculated fields
• Create action queries

Create advanced queries

• Find duplicate records
• Find unmatched records in different tables
• Create cross-tab queries
• Use parameter queries
• Using indexes to speed up sorting and filtering data in tables

Creating advanced form design

• Use contros to add graphics to a form
• Image controls & unbound object frame controls
• Adding calculations in a form
• Aligning controls in a form
• Adding a combo box to search records
• Tab order

Use advanced report features

• Creating customised headers and footers
• Set properties to group data

Access Advanced

Creating advanced forms

• Build a form based on joined tables
• Use functions to automate form data entry
• Add tab controls to a form
• Inserting and reordering pages
• Renaming a page
• Adding fields
• Insert a subform and change subform properties
• Create and use group controls in forms

Creating macros and automation

• Build a standard Switchboard
• Adding a new Switchboard page
• Setting the Switchboard to Auto Open
• Unrestricting views
• Create a macro to automate tasks
• Creating the macro
• Editing the macro
• Attach macros to events of database objects

Exploring Access SQL

• Identify different clauses in SQL statements
• Selecting specific fields
• Selecting All fields in a table
• Selecting fields with a criteria
• SQL Statement to display matching data
• SQL Statement to display matching data and all data from primary table
• Attaching an SQL statement to a database object
• Creating a Union Query

Use hyperlinks, attachments and embedded objects

• Create and work with hyperlink fields
• Create and work with attachment fields
• Create and use embedded object fields

Manage and split a database

• Use Analyze Performance
• Save a database to an earlier version
• Default blank database version
• Split a database

Protect and customize a database

• Open a database as exclusive
• Set a database password
• Remove a database password
• Use Access options to custom a database
• The Options dialog box
• Quick Reference: Acccess Shortcuts

 

Excel VBA

---

Time: 1.5 hrs/day

Course Duration: 1.5 months

VBA Introduction

Recording Macros

• Recording and Running Macros
• Recording a Macro
• Running a Macro
• Adding a Macro/Procedure to the Quick Access Toolbar
• The Personal Macro Workbook
• Saving the Personal Macros
• Editing a Personal Macro
• Assigning Personal Macros to the Toolbar

Working with the Visual Basic Editor

• Introducing Visual Basic for Applications
• Editing Macros in Visual Basic Editor
• Understanding the Development Environment
• Protect/Lock Excel VBA Code
• Using Help

Developing with Procedures

• Understanding and Creating Modules
• Defining Procedures
• Creating a Sub-Procedure
• Working Using the Code Editor

Managing Program Execution

• Defining Control-Of-Flow structures
• Using the IfEnd If Decision Structures
• Using the Select CaseEnd Select Structure
• Using the DoLoop Structure
• Using The ForNext Structure
• Using the For EachNext Structure
• Guidelines for Use Of Control-Of-Flow Structures

 

Debugging the Code

• Understanding Errors
• Using Debugging Tools
• Identifying the Value of Expressions
• How to Step Through Code
• Working with Break Mode during Run Mode
• Using the Immediate Window

Understanding Objects

• Defining Objects
• Examining the Excel Object Hierarchy
• Defining Collections
• Referencing Objects in a Collection
• Using the Object Browser
• Working with Properties
• The With Statement
• Working With Methods
• Event Procedures

VBA Intermediate

Using Intrinsic Functions, Variables and Expressions

• Defining Expressions and Statements
• Expressions
• Statements
• How to Declare Variables
• Naming Variables
• Assigning Values To Variables
• Declaring Variables Explicitly
• Determining Data Types
• Programming with Variable Scope
• Harnessing Intrinsic Functions
• Defining Constants and Using Intrinsic Constants
• Using Intrinsic Constants

Creating User Defined Functions

• Creating a Function Procedure
• Calling a UDF
• Using a function within an Excel Workbook

Message Boxes and Input Boxes

• Adding Message Boxes
• Notes Error! Bookmark not defined
• Return Values
• Notes Error! Bookmark not defined
• Using Input Boxes
• Notes Error! Bookmark not defined
• How to Declare and Use Object Variables

Handling Errors

• Defining VBA’s Error Trapping Options
• Capturing Errors with the On Error Statement
• Determining the Err Object
• Coding an Error-Handling Routine
• Notes Error! Bookmark not defined
• Using Inline Error Handling
• Notes Error! Bookmark not defined

Creating Forms and Controls

• Defining UserForms
• Utilising the Toolbox
• Using UserForm Properties, Events And Methods
• Properties
• Notes Error! Bookmark not defined
• Events
• Methods
• Understanding Controls
• Naming Conventions
• Setting Control Properties in the Properties Window
• Notes Error! Bookmark not defined
• Using the Label Control
• Using the Text Box Control
• Using the Command Button Control
• Using the Combo Box Control
• Using the Frame Control
• Using Option Button Controls
• Using Control Appearance
• Setting the Tab Order
• Filling a Control
• Adding Code to Controls
• How to Launch a Form in Code

VBA Advanced

Working with Ranges

• What is a Range?
• Range Property of the Application
• Cells Property
• The SpecialCells Method
• Naming Ranges
• Working with Collections

Charts

• Creating charts from worksheet data
• Key Properties and methods of the chart object
• Creating Charts from Arrays

PivotTable Object

• Understanding PivotTables
• Creating A PivotTable
• Procedure
• Using the PivotTable Wizard Method
• Using PivotFields

Working with Arrays

• What is an Array
• Array Sizes
• One Dimensional Arrays
• Arrays with Multiple Dimensions
• A word about index numbers
• Ubound and Lbound
• Saving arrays in names

Triggers and Events

• Workbook Events
• Worksheet Events
• Timer Controlled Macro

Working with Text Files

• Importing a Text File
• FileStream

Working with Procedures and Parameters

• Procedure Arguments
• Passing Arguments
• Optional Arguments
• Default Values
• Passing arguments by value and reference

Active X Data Objects

• Key Objects
• A word about the connection string

Creating Add-Ins

• VBA Password Protection
• About Macro Security
• Macro security settings and their effects
• Change Macro Security Settings

Class Modules

• What can be done with Class Modules?
• Why use Class Modules?
• What is a Class?
• How Does a Class Module Work?
• Key Elements in a class module
• Property Get and Let Procedures
• Referring to user defined Objects in Code
• Using IntelliSense™
• Programming Techniques
• Best Practice for Excel Programming

 

ADVANCED EXCEL

---

Advanced Excel Course Content

Time: 1.5 hrs/day

Course Duration: 1.5 months

Working with Dates

• Dates and time in Excel
• Inserting and formatting dates
• Entering date functions
• Using dates in formulas

Working with Tables

• What is a Table?
• Creating Tables
• Changing the Table Range
• Inserting Table Columns
• Inserting Table Rows
• Deleting Rows or Columns
• Creating a Table Total Row
• Sorting and Filtering Tables
• Sorting Data in a Table
• What is an AutoFilter?
• Custom AutoFilters
• Removing Filters
• Filtering with Wildcard Characters
• Using an Advanced Filter
• Creating Subtotals
• FlashFill
• Use Slicers to filter tables

Working With Charts

• Creating a Chart
• Manipulating a Chart
• Moving and resizing a chart
• Adding a chart title
• Adding a chart Axis title
• Changing the Type of Chart
• Formatting a Chart
• Recommended Charts
• Quick Analysis Option
• Chart formatting control

Conditional Formulas and Formatting

• The IF function
• Using the Function Library
• Manually entering a function
• Conditional Formatting
• Applying Conditional Formatting
• Creating a Conditional Formatting Rule
• Removing Conditional Formatting
• Using the Manage Rules Option
• Adding Conditional Formatting using the Quick analysis tool

Using Logical Functions

• Working with Names and Ranges
• What Are Range Names?
• Defining and Using Range Names
• Using Logical Functions
• Using the Function Library
• Manually entering a function
• The IF function
• The AND Function
• The OR Function
• Working with Nested Functions
• Nested IF functions
• Applying Logical Functions

Working with Lookup Functions

• Using VLOOKUP to Find Data
• How to Find an Exact Match with VLOOKUP
• Finding the Closest Match with VLOOKUP
• How to use the MATCH Function
• Index Function
• Lookup using Match and Index Function

Working with Multiple Worksheets and Workbooks

• Using Multiple Worksheets
• Navigating between sheets
• Creating -D formulas
• Consolidating data
• Linking your workbooks
• Linking Workbooks
• Using the Paste Link option
• Creating a formula to link workbooks
• Controlling link updates
• Manually update all of the links or none of the links in a workbook
• Manually update only some of the links to other workbooks
• Dealing with Broken Links

Documenting and Auditing

• Comments
• Adding, editing and deleting comments
• The Formula Auditing Group
• Excel Workbook and Worksheet Protection
• Protecting your Worksheets
• Unlocking Cells

Advanced List Management

• Validating Your Data
• Creating Data Validation Settings
• Using Database Functions
• Creating a Criteria Range
• Entering the Database Function

PivotTables and PivotCharts

• What is a PivotTable?
• Preparing Data to Create a PivotTable
• Creating a PivotTable
• Quick Analysis
• Adding Fields to the PivotTable
• Creating a PivotTable Frame (Classic PivotTable Layout)
• Rearranging PivotTable Data
• Hiding and Showing Field Data
• The PivotTable Tools Ribbon
• Modifying Calculations and Data Area Display
• Formatting a PivotTable
• Refreshing a PivotTable
• Time Grouping in PivotTables (Excel )
• Using Slicers to Manipulate PivotTables
• Use Timelines with Pivot Data
• Creating a PivotChart

Using ‘What-If’ Analysis Tools

• Using Scenarios in Excel
• Creating a Scenario
• Using Goal Seek
• Using Solver
• Checking Solver Installation
• Setting Solver Parameters

Macros

• What is a macro?
• Creating a macro
• The Developer Ribbon
• Recording a macro
• Playing a Macro
• Macro Security
• More Macro Tasks
• Recording a Relative Reference Macro
• Running a Relative Reference Macro
• Assigning a Keystroke to a Macro
• Copying a Macro from a Workbook or Template

Working with Large Worksheets

• Viewing and Organising Spreadsheet Data
• The Zoom Feature
• Hide rows and columns
• Using Automatic Outlining
• Grouping Data Manually
• Printing Large Worksheets
• Print Titles
• Page Break Preview
• Inserting a Page Break
• Printing Multiple Sheets

Using Templates

• What is a Template?
• Creating a Workbook from a Template
• Creating a Template

 

Office Package

Time: 1.5 hrs/day

Course Duration: 1.5 months

General knowledge about computer

• Hardware
• Software
• Install and uninstall software
• Control panel, system property, services, process
• Typing method

Operating system

• Definition
• Function
• Evolution of OS

Microsoft word

• Getting Started
• Editing Documents
• Moving and Copying Text
• Formatting Characters and Paragraphs
• Creating and Managing Tables
• Controlling Page Layout
• Using Proofing Tools
• Web Features
• Working with sections and columns
• Working with Graphics
• Templates

Microsoft excel

• Getting Started
• Entering and Editing Data
• Modifying a Worksheet
• Using Functions
• Formatting Worksheets
• Working With Charts
• Printing Workbooks

Microsoft power point

• PowerPoint Basics
• Building New Presentations
• Formatting and Proofing
• Using Drawing Tools
• Working with WordArt and ClipArt
• Using Tables and Charts
• Enhancing Presentations
• Delivering Presentations

Microsoft access

• Introduction & Overview

Microsoft outlook

• Introduction & Overview

Microsoft publisher

• Microsoft publisher 2013
• creating a publication
• Text formatting
• page formatting
• Pictures
• Arranging objects
• Personalising the publication
• Tables
• Text boxes
• Master pages
• Publisher customisation options
• Proofing & printing

Scanning & printing

• Scan required document
• Setting the pixel of scanned image
• Setting the default location for storage
• Printing the document
• Photocopy the required document

Surfing internet

• Introduction to the www
• Concept of cloud storage and servers
• How to find the required material in web
• Search engine working mechanism
• Download files from internet and save in local computer

Basic webpage designing

• Introduction to html
• Basic html tags
• Working with fonts
• Display images in your web page
• Hyperlink the internal and external link