• +91 9261 2110 03
  • ptaimp@gmail.com
  • Mon - Sat: 8:00 - 20:00
Microsoft Office Certification
Upgrade your skills & reach to a successful career
Enroll Now

Microsoft Office Certification

A complete program on Microsoft Excel & its application in real corporate world

%
Job Oriented Program
+
Private Banks & MNC's
%
Global Presence

Microsoft Office Specialist 2016

Program Highlights

Microsoft Excel Specialist

Exam 77-727

Excel 2016: Core Data Analysis, Manipulation, and Presentation

MOS 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills and abilities using the MOS 2016 programs
Download MOS Excel 2016 Exam 77-727 Details

Create worksheets and workbooks
Create a workbook, import data from a delimited text file, add a worksheet to an existing workbook, copy and move a worksheet
Navigate in worksheets and workbooks
Search for data within a workbook; navigate to a named cell, range, or workbook element; insert and remove hyperlinks
Format worksheets and workbooks
Change worksheet tab color, rename a worksheet, change worksheet order, modify page setup, insert and delete columns or rows, change workbook themes, adjust row height and column width, insert headers and footers
Customize options and views for worksheets and workbooks
Hide or unhide worksheets, hide or unhide columns and rows, customize the Quick Access Toolbar, change workbook views, change window views, modify document properties, change magnification by using zoom tools, display formulas
Configure worksheets and workbooks for distribution
Set a print area, save workbooks in alternative file formats, print all or part of a workbook, set print scaling, display repeating row and column titles on multi page worksheets, inspect a workbook for hidden properties or personal information, inspect a workbook for accessibility issues, inspect a workbook for compatibility issues

Insert data in cells and ranges
Replace data; cut, copy, or paste data; paste data by using special paste options; fill cells by using Auto Fill; insert and delete cells

Format cells and ranges
Merge cells, modify cell alignment and indentation, format cells by using Format Painter, wrap text within cells, apply number formats, apply cell formats, apply cell styles
Summarize and organize data
Insert spark lines, outline data, insert subtotals, apply conditional formatting

Create and manage tables
Create an Excel table from a cell range, convert a table to a cell range, add or remove table rows and columns
Manage table styles and options
Apply styles to tables, configure table style options, insert total rows
Filter and sort a table
Filter records, sort data by multiple columns, change sort order, remove duplicate records

Create charts
Create a new chart, add additional data series, switch between rows and columns in source data, analyze data by using Quick Analysis
Format graphic elements
Resize charts, add and modify chart elements, apply chart layouts and styles, move charts to a chart sheet
Insert and format objects
Insert text boxes and shapes, insert images, modify object properties, add alternative text to objects for accessibility

Microsoft Office Expert 2016

Program Highlights

Microsoft Excel Expert

Exam 77-728

Microsoft Excel 2016 Expert: Interpreting Data for Insights

Expert-level candidates for the Microsoft Excel 2016 exam have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the program’s features.
Download MOE Excel 2016 Exam 77-728 Details

Apply custom data formats and validation
Create custom number formats, populate cells by using advanced Fill Series options, configure data validation
Apply advanced conditional formatting and filtering
Create custom conditional formatting rules, create conditional formatting rules that use formulas, manage conditional formatting rules
Create and modify custom workbook elements
Create custom color formats, create and modify cell styles, create and modify custom themes, create and modify simple macros, insert and configure form controls
Prepare a workbook for internationalization
Display data in multiple international formats, apply international currency formats, manage multiple options for +Body and +Heading fonts

Apply functions in formulas
Perform logical operations by using AND, OR, and NOT functions; perform logical operations by using nested functions; perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions
Look up data by using functions
Look up data by using the VLOOKUP function, look up data by using the HLOOKUP function, look up data by using the MATCH function, look up data by using the INDEX function
Apply advanced date and time functions
Reference the date and time by using the NOW and TODAY functions, serialize numbers by using date and time functions
Perform data analysis and business intelligence
Reference the date and time by using the NOW and TODAY functions; import, transform, combine, display, and connect to data; consolidate data; perform what-if analysis by using Goal Seek and Scenario Manager; use cube functions to get data out of the Excel data model; calculate data by using financial functions
Troubleshoot formulas
Trace precedence and dependence, monitor cells and formulas by using the Watch Window, validate formulas by using error checking rules, evaluate formulas
Define named ranges and objects
Name cells, name data ranges, name tables, manage named ranges and objects

 Create advanced charts
Add trendlines to charts, create dual-axis charts, save a chart as a template
Create and manage PivotTables
Create PivotTables, modify field selections and options, create slicers, group PivotTable data, reference data in a PivotTable by using the GETPIVOTDATA function, add calculated fields, format data
Create and manage PivotCharts
Create PivotCharts, manipulate options in existing PivotCharts, apply styles to PivotCharts, drill down into PivotChart details

Get Admission/Fees Details

* For more Details Call +91 9261211003 or Mail Us: ptaimp@gmail.com

Certification Partners

Microsoft Office Certification

Microsoft Office Certification is now get a reorganization in the field of analytical field of banking & finance for those looking to demonstrate proficiency in one or more Office programs. Productivity certification is for those looking to use Microsoft Office and deploy Microsoft Office cloud and hybrid solutions. Differentiate yourself with this competency as a proven expert in Office skills.

Certiport Testing Centre

Certiport, a Pearson VUE business, was established in 1997 and is now the leading provider of certification exam development, delivery, and program management services. Certiport exams are delivered through an expansive network of over 14,000 Certiport Authorized Testing Centers worldwide. Certiport delivers more than three million exams each year through the secondary, post-secondary, workforce, and corporate technology markets in 148 countries and 26 languages.

Why Us?

100% Job Oriented

Industry Expert Faculty

Live Interships

About Programs

Professional Programs

Certified Financial Planner is an ace program for those who wants to become financial doctor for every individual who want to strengthen our financial goals and help them to achieve . Certified Financial Planner program covers Investment Planning, analytical skills, retirement planning, tax planning, estate planning, risk & insurance planning

Read More

Chartered Market Technician are ideal for those professionals who want to explore in depth knowledge & practical implication of Technical Analysis & investment Analysis. Professional Training Academy design the preparation in modules which make them easier for student to understand the concept in practical. Our Institute provide the real time market and portfolio exposure to all CMT students to develop their independent research.

Read More

Blended Programs

Professional Training Academy introduced Certified Market Professional program for those who want to start their career in the field of Stock Markets, Portfolio Management, Equity Research & Derivative Analyst. Certified Market Professionals are required by stock brokers, investment firms & wealth Management Companies.
Read More

Professional Training Academy offers Certified Banking Professional which incorporate Financial Analysis, Wealth Management, Banking & Financial Services under the aegis of International Certification Partners. Curriculum design, study material provision, and examination are the unmatched within competitors.

Read More

In order to address the need of qualified Credit professionals in the industry and leverage our experience in Credit Advisory domain, Professional Training Academy “Course for Credit professionals” which is designed to prepare for a career in Banking & Finance specially Credit.

Read More

Professional Training Academy is establish and first introduced program in their training journey is Technical Analysis. Certified Technical Professional is program which is best suited for those who are already in markets or want to start trading or investment in the markets. This program provide all practical and conceptual understanding to deal with financial markets.

ReadMore

Certifications Programs

NISM Certification creates a common Threshold knowledge benchmark for all associated person registered as investment advisers, partners and representatives of investment advisers, under SEBI(Investment Advisers) Regulations, 2013 and offers investment advisory services. Know the basics of investment advisory, steps in the advisory process, making and implementation of financial plan. Understand how to evaluate different products, their suitability.Get oriented to the Income tax, Wealth tax and legalities of Estate.Understanding the structure and performance of securities markets & importance of assets allocation & portfolio management.

Read More

NISM Certification are designed for professionals employed in various segments of the Indian securities markets. These examinations are mandatory as a vocational qualification by SEBI for all employees of Intermediaries. NISM Certification main aim to provide conceptual understanding of financial markets & mechanism of capital markets.

Read More

Microsoft Office Certification provide analytical skills for those who are looking to use Microsoft Office. Differentiate yourself with this competency as a proven expert in Office Skills. Microsoft Office Certification provide a extra edge to the candidate which prove her expertise in the use of Microsoft office .Get hired, demonstrate clear business impact, and advance your skills. Microsoft offers a wide range of online certification programs designed to take your career to the next level.

Read More

Cambridge Business English Certification target different levels. The Content for each exam is based on every day work and business tasks and is designed to develop your business English skills.Cambridge English is a unique approach to teaching, learning and assessing English. It combines the experience and expertise of Cambridge English Language Assessment.Cambridge English is driven by world-class research and a profound commitment to delivering educational excellence,providing increased opportunities for learners and teachers, offering value to teachers, educational institutions and employers,promoting language learning to benefit society as a whole.

Read More

Digital Marketing Programs

Certified Digital Marketing Professional is an complete program for those who want to handle their own website or want to start an business online . Digipro provide every aspect of digital marketing to equip them to handle their website marketing independently.

Read More

Professional Diploma in Digital Marketing is ideal for those who want to become digital marketing professional or managers in the digital marketing agencies and want to manage all aspect of digital marketing under his control. As digital marketing agencies or independent companies requires lot of expertise, knowledge and work experience in a digital marketing manager.

Read More

For More Query Contact Us

Professional Programs

  • Certified Financial Planner
  • Chartered Market Technician

Blended Programs

  • Certified Market Professional
  • Certified Banking Professional
  • Certified Credit Professional
  • Certified Technical Professional

Certifications programs

  • Registered Investment Adviser
  • NISM Certification
  • Microsoft Office Specialist
  • Cambridge Business English

Digital Marketing

  • Certified Digital Marketing Professional
  • Professional Diploma In Digital Marketing

Visit Us

  • Professional Training Academy
  • ptaimp@gmail.com
  • +919261211003
  • +911414020051

© 2018 All rights reserved