1 1

vTutor

Microsoft Excel Pro (Training Only)

Microsoft Excel Pro (Training Only)

Tk 2,000.00 BDT
Tk 3,500.00 BDT Tk 2,000.00 BDT
Sale Sold out
Shipping calculated at checkout.


Microsoft Excel-এ দক্ষতা অর্জন করুন মাইক্রোসফট এরই সার্টিফিকেশনের মাধ্যমে !!! 

আমাদের comprehensive Certification Course টি মূলত Beginners এবং intermediate users-দের জন্য যা আপনাকে পরবর্তী স্টেপ "এক্সেলে এক্সপার্ট" হতে সহায়তা করবে!! 


এই কোর্সটি হতে আমরা যা যা শিখবো : 
১) Hands-On Training এর মাধ্যমে  Excel fundamental Idea থেকে শুরু করে advanced data analysis details! 

২) থাকছে Excel এর গুরুত্বপূর্ণ টপিক্স যেমন -  formulas, charts, pivot tables, conditional formatting, এবং data validation এবং আরো....

৩) এছাড়া আমাদের step-by-step approach নিশ্চিত করবে Excel-এর powerful features-গুলোর ওপর আপনার গভীর দক্ষতা।


এই কোর্স থেকে আপনি যা পাবেন  
★Real projects, 
★Expert guidance, এবং 
★Practice tests-এর এক্সেস, 


পুরো কোর্সটি Microsoft Excel Certification Exam-এর জন্য thorough প্রস্তুতি নিতে সাহায্য করবে। 
এই Certification অর্জন করলে, আপনার Excel দক্ষতা শুধুমাত্র প্রমাণিত হবে না, বরং বর্তমানের data-driven job market-এ আপনার credibility এবং marketability আরও বৃদ্ধি পাবে! 
ফ্রিল্যান্সিং এ এগিয়ে যেতে সহায়তা করবে এই সার্টিফিকেশন!

কোর্সটি পরিচালনা করবেন মাইক্রোসফট সার্টিফাইড ট্রেইনার জনাব মুত্তাকি ফারুক,  
তিনি পেশায় একজন ডেটা এনালিস্ট ও  vTutor Bangladesh সহপ্রতিষ্ঠাতা। Microsoft Excel এর ব্যাপারে তার রয়েছে দীর্ঘ ১ যুগের বেশি প্রশিক্ষনের অভিজ্ঞতা। 


মাইক্রোসফট এক্সেল সার্টিফিকেশন প্রিপারেশন (Microsoft Excel Pro) কোর্স কারিকুলাম: 

We will cover the topics:
Excel Associate: Exam MO-210
1. Manage Worksheets and Workbooks
* Import data into workbooks
* Navigate within workbooks
* Format worksheets and workbooks
* Customize options and views
* Prepare workbooks for collaboration and distribution
2. Manage Data Cells and Ranges
* Manipulate data in worksheets
* Format cells and ranges
* Define and reference named ranges
* Summarize data visually
3. Manage Tables and Table Data
* Create and format tables
* Modify tables
* Filter and sort table data
4. Perform Operations by using Formulas and Functions
* Insert references
* Calculate and transform data
* Format and modify text
5. Manage Charts
* Create charts
* Modify charts
* Format charts
Excel Expert: Exam MO-211
6. Manage Workbook Options and Settings
* Manage workbooks
* Prepare workbooks for collaboration
7. Manage and Format Data
* Fill cells based on existing data
* Format and validate data
* Apply advanced conditional formatting and filtering
8. Create Advanced Formulas and Macros
* Perform logical operations in formulas
* Look up data by using functions
* Use advanced date and time functions
* Perform data analysis
* Troubleshoot formulas
* Create and modify simple macros
9. Manage Advanced Charts and Tables
* Create and modify advanced charts
* Create and modify PivotTables
* Create and modify PivotCharts

View full details

Microsoft Certification Overview

The Microsoft Certification Program provides industry-leading assessments of skills and knowledge through a project-based testing system. A candidate earns an Official Microsoft Certification after attaining a passing mark in the examination. 

The internationally recognised certification, signed by Satya Nadella CEO of Microsoft, gives students a commanding competitive edge in today’s academic environments. Each certificate can waive up-to one credit in American universities including Harvard & Ivy League. 

Microsoft Office is a must know skill for any professional. In the job market the 3rd most required skill for hiring is Microsoft Office. MOS certificates helps in job placements all around the world beside boosting productivity & work quality by 70%. MOS certifications can make you job ready by adding a badge to your CV & also help compete in the freelance market by increasing credibility.

What Is MOS: Word Associate Office 2019: Exam MO-100

The Microsoft Office Specialist: Word Associate Certification demonstrates competency in the correct application of the principle features of Word by creating and editing documents for a variety of purposes and situations. The exam covers the ability to create and maintain professional-looking reports, multicolumn newsletters, résumés, and business correspondence.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Word and can complete tasks independently

Microsoft Office Specialist Program certification exams use a performance-based format testing a candidate’s knowledge, skills and abilities using the Microsoft 365 Apps and Office 2019 programs:

  • Microsoft Office Specialist Program exam task instructions generally do not include the command name. For example, function names are avoided, and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The Microsoft Office Specialist Program exam format incorporates multiple projects as in the previous version, while using enhanced tools, functions, and features from the latest programs.

Exam Domain Details

Skill Assessment Domains

Manage documents (20-25%)

Navigate within documents

• Search for text

• Link to locations within documents

• Move to specific locations and objects in documents

• Show and hide formatting symbols and hidden text

Format documents

• Set up document pages

• Apply style sets

• Insert and modify headers and footers

• Configure page background elements

Save and share documents

• Save documents in alternative file formats

• Modify basic document properties

• Modify print settings

• Share documents electronically

Inspect documents for issues

• Locate and remove hidden properties and personal information

• Locate and correct accessibility issues

• Locate and correct compatibility issues

Insert and format text, paragraphs, and sections (20-25%)

Insert text and paragraphs

• Find and replace text

• Insert symbols and special characters Format text and paragraphs

• Apply text effects

• Apply formatting by using

Format Painter

• Set line and paragraph spacing and indentation

• Apply built-in styles to text

• Clear formatting

Create and configure document sections

• Format text in multiple columns

• Insert page, section, and column breaks

• Change page setup options for a section

Manage tables and lists (15-20%)

Create tables

• Convert text to tables

• Convert tables to text

• Create tables by specifying rows and columns

Modify tables

• Sort table data

• Configure cell margins and spacing

• Merge and split cells

• Resize tables, rows, and columns

• Split tables

• Configure a repeating row header

Create and modify lists

• Format paragraphs as numbered and bulleted lists

• Change bullet characters and number formats

• Define custom bullet characters and number formats

• Increase and decrease list levels

• Restart and continue list numbering

• Set starting number values

Create and manage references (5-10%)

Create and manage reference elements

• Insert footnotes and endnotes

• Modify footnote and endnote properties

• Create and modify bibliography citation sources

• Insert citations for bibliographies

Create and manage reference tables

• Insert tables of contents

• Customize tables of contents

• Insert bibliographies

Insert and format graphic elements (15-20%)

Insert illustrations and text boxes

• Insert shapes

• Insert pictures

• Insert 3D models

• Insert SmartArt graphics

• Insert screenshots and screen clippings

• Insert text boxes

Format illustrations and text boxes

• Apply artistic effects

• Apply picture effects and picture styles

• Remove picture backgrounds

• Format graphic elements

• Format SmartArt graphics

• Format 3D models

Add text to graphic elements

• Add and modify text in text boxes

• Add and modify text in shapes

• Add and modify SmartArt graphic content

Modify graphic elements

• Position objects

• Wrap text around objects

• Add alternative text to objects for accessibility

Manage document collaboration (5-10%)

Add and manage comments

• Add comments

• Review and reply to comments

• Resolve comments

• Delete comments

Manage change tracking

• Track changes

• Review tracked changes

• Accept and reject tracked changes

• Lock and unlock change tracking

MOS World Championship

Get Digital Badge

Endorsement From International Institutions

Image with text

Pair text with an image to focus on your chosen product, collection, or blog post. Add details on availability, style, or even provide a review.

  • Hassle-Free Exchanges

    Pair text with an image to focus on your chosen product, collection, or blog post. Add details on availability, style, or even provide a review.

Real Success Stories of MOS Certifications Inspiring Changes in Workforce Development

MOS certification gives people the skills and confidence to succeed in the workforce.

  • Cimarron Correctional Facility - Oklahoma, USA

    “Demand for the program is high and I find that once an inmate earns one certification,
    they are motivated to earn another one.”

    Steve Holley
    Computer Instructor at CCF

    Read More 

  • Ediya Coffee - Seoul, South Korea

    “In our daily work life, using Microsoft Office is the most required skills. Microsoft Office Specialist is the proper certification that will allow us to evaluate employee’s performance on Microsoft Excel, PowerPoint and Word software in the workplace.” - Byeong- wook Lee, Manager, Ediya Coffee Corp.

    Read More 

  • Fundación Paco Puerto - Spain

    “There are two main benefits of offering MOS certification,” said Cantador. “First, Students gain a professionally recognized qualification that is valued by employers. Second, Paco Puerto is authorised to deliver Microsoft exams, which helps to motivate the trainers and also makes us a center of reference.”

    Read More 

  • OfficeTeam - The world’s leader in professional staffing for office support jobs.

    OfficeTeam, a Robert Half Company, is the division handling administrative staffing. We spoke with Brandi Britton, district president of OfficeTeam, to learn about the most in-demand skills for administrative professionals and how Microsoft Office Specialist certification can help job seekers stand out.

    Read More 

  • Sojitz Corporation - Japan

    “Studying for MOS certification allows the new recruits to understand what baseline skills they are expected to have in the office so they can prepare themselves accordingly. We also hope the MOS training opportunity further motivates our new employees to build up their computing skills.”

    Mr. Shogo Miyamoto
    MOS Excel-certified member

    Human Resources & General Affairs Department

    Read More 
1 5
Read More

What will the MOS Program bring to a College & University?

For postsecondary

  1. A comprehensive, cost-effective way to help students develop in-demand skills
  2. A pre-qualification tool for admitting students to individual departments
  3. Embedded digital literacy within all programs and curriculum
  4. Stronger courses, programs, and students
  5. State-of-the-art learning and course offerings

Real Success Stories of MOS Certifications Transforming Student Careers in Higher Education

Students & teachers praise the power of MOS Certifications & how it can have positive impact on a student's career in higher education.

  • Bellevue College - Washington, USA

    “Achieving the Microsoft Office Specialist certification enhanced my job and career opportunities.”

    Jin-Mei Wang
    Student
    Bellevue College

    Read More 

  • Northwest Iowa Community College - Iowa, USA

    Northwest Iowa Community College Validates Microsoft Office Skills in Administrative Office Assistant Program.

    Read More 

  • Troy University - Alabama, USA

    Troy University College of Business Equips All Students with Microsoft Excel Certifications.

    Read More 

  • Singapore Polytechnic - Singapore

    “Being certified definitely gave me an advantage,” says Lye. “Being proficient in using advanced tools and formulas in Excel allowed me to deliver the results the company was seeking.”


    Christopher Lye
    Integrated Events and Project
    Management Graduate.
    2013 National Academic Skills Challenge winner

    Read More 

  • Kookmin University - Seoul, South Korea

    “MOS is a very useful and suitable tool to help students gain hands-on experience. The class leading to MOS certification gives students a clear goal so they can focus on the course more than ever before.”

    Seung-Il Ahn
    Kookmin University Administrator

    Read More 
1 5

Certiport is working with Microsoft Learning to give Canadian SAIT Polytechnic student Caroline Weilinger a unique academic and personal growth experience with the Career Factor online reality show. Weilinger has set her sights on earning Microsoft Office Specialist certification for multiple applications.

What will the MOS Program bring to a school K-12?

For K-12

  1. Enhanced reputation and prominence through higher learning standards
  2. Leading-edge curriculum
  3. Opportunities to qualify for additional funding
  4. Embedded digital literacy within all programs and curriculum
  5. Stronger courses, programs, and students
  6. State-of-the-art learning and course offerings

Real Success Stories of MOS Certifications Preparing Students in School K-12

Students get exposed to higher learning standards and get quipped with knowledge and skills that help them adapt to the real world.

  • ILLINOIS CHSD 218 - Illinois, USA

    “If they go to work and have MOS on their resume, it will open doors. If they go to college, it is going to help them be successful.”

    Frank LaMantia
    Curriculum Director of CTE

    Read More 

  • Certiadria - Skopje, North Macedonia

    Macedonian Primary Teachers Increase Digital Literacy with Microsoft Office Specialist Certification.

    Read More 

  • Marshfield High School - Massachusetts, USA

    “What I love about MOS and GMetrix is it they are aligned to both state and national standards. I can help my students earn an industry- valued credential while meeting requirements for assessment and technology.”

    Kathleen Bandera
    Teacher
    Marshfield High School

    Read More 

  • Public Schools Of North Carolina - North Carolina, USA

    “The Microsoft IT Academy allows students to prove to employers they have a specific skill that is in demand.”

    Aaron Fleming
    Director of Career and Technical Education (CTE)
    Lee County Public Schools.

    Read More 

  • Xavier High School - Iowa, USA

    As a result of these certifications, Xavier students are equipped with valuable 21st century skills,”

    Tom Keating,
    Principal
    Xavier High School

    Read More 

  • Shaw High School Masters Microsoft Office Certifications - Georgia, USA

    Shaw is the only school in Muscogee County to achieve a 100 percent pass rate for the Business and Technology End of Pathway assessment three years in a row.

    Read More 
1 6