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
Microsoft outlook
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
Since Microsoft usage is one of the basic requirement for most of the job profiles. It is not just used by individuals but is also very important for organizations and companies as well. Microsoft Training Package in Nepal helps you in operation of day to day activities like Word, Excel, and PowerPoint which are the crucial knowledge required in for students to professionals.
Why Microsoft Training is important?
Microsoft Training in Nepal helps you to build your career in more digital form. If you are fluent with Microsoft programs, you will obviously be an expert in building the chart. For business analysts and financial professionals creating the chart of the organizations or companies is the most crucial part of work in order to support any kind of data and source you need to figure out the information on chart. The benefits doesn’t limit only n chart it has wider scope and the demand is high in market.
Microsoft Training Package in Nepal provides you the certificate after completion of training which describes that the individual is competitive in today’s job market and deserve the handsome benefits along with salary in job. The training also helps employee to be more formal, updated about the latest demand and the technology required in job and be innovative in the field which they work for. It enables the employee to increase their work productivity, credibility with their working environment including clients and colleagues. The certificate directly helps you to get SORT listed in most of the companies as it measures your computer skills and knowledge which are crucial in any company.
Career Opportunities
Microsoft Training package in Nepal takes you to the world of opportunities. Besides making your daily work more effective and efficient Microsoft training package opens up great career prospects for you. The demand and the scope is increasing in wider range so Microsoft Training Package in Nepal is established in order to provide some expert training in Microsoft, you can vouch for challenging leadership and analytical roles with your MS credential. You can demand for the hike for salary and promotion for post with your expertise to fluently use of Microsoft Program towards better business strategy and get succeed on whatever you do.
Hence, these are the benefits you get after receiving the certificate on your hand. So feel free to contact us and enjoy the opportunities after holding the certificate.