Microsoft Excel Pro (Training + Certification)
Microsoft Excel Pro (Training + Certification)
এই কোর্সের সাথে সার্টিফিকেশন পরীক্ষা দেবার সুযোগ থাকার জন্য আপনি পাচ্ছেন,
মাইক্রোসফট এক্সেল এসোসিয়েট অথবা
মাইক্রোসফট এক্সেল এক্সপার্ট যেকোন একটি পরীক্ষা দেবার অসাধারণ সুযোগ।
পাশাপাশি মূল পরীক্ষার আগে একটি প্রাকটিস টেস্ট বা মক পরীক্ষা দেবার সুযোগ।
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
Collapsible content
Microsoft Certification Overview
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.
Microsoft’s certification programs provide a clear path to success for learners and helps them acquire the technology skills needed to be successful in their student life and career endeavours.
Get Endorsed by Microsoft's CEO
Get your certificate signed and endorsed by Microsoft Global CEO, Satya Narayana Nadella
Evidence from Around the World Proves that Microsoft Certifications Increases Employability
With Microsoft certifications, educators and employers have a full pathway approach to closing the skills gap. Students are able to leverage learning and instructional materials, preparatory assessment exams, and industry - recognized Microsoft certifications to ensure future success in today’s technology-driven learning and workforce environments.
Collapsible content
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.
Study Shows Productivity at Workplaces Increases by 70% with MOS Certifications
This research study highlights the value of Microsoft Office Specialist (MOS) certification and shows that certified students and employees become more productive as proficiency in Microsoft Office increases.
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
Read More“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 -
Ediya Coffee - Seoul, South Korea
Read More“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.
-
Fundación Paco Puerto - Spain
Read More“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.”
-
OfficeTeam - The world’s leader in professional staffing for office support jobs.
Read MoreOfficeTeam, 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.
-
Sojitz Corporation - Japan
Read More“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
Collapsible content
What will the MOS Program bring to a College & University?
For postsecondary
- A comprehensive, cost-effective way to help students develop in-demand skills
- A pre-qualification tool for admitting students to individual departments
- Embedded digital literacy within all programs and curriculum
- Stronger courses, programs, and students
- 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
Read More“Achieving the Microsoft Office Specialist certification enhanced my job and career opportunities.”
Jin-Mei Wang
Student
Bellevue College -
Northwest Iowa Community College - Iowa, USA
Read MoreNorthwest Iowa Community College Validates Microsoft Office Skills in Administrative Office Assistant Program.
-
Troy University - Alabama, USA
Read MoreTroy University College of Business Equips All Students with Microsoft Excel Certifications.
-
Singapore Polytechnic - Singapore
Read More“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 -
Kookmin University - Seoul, South Korea
Read More“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
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.
Collapsible content
What will the MOS Program bring to a school K-12?
For K-12
- Enhanced reputation and prominence through higher learning standards
- Leading-edge curriculum
- Opportunities to qualify for additional funding
- Embedded digital literacy within all programs and curriculum
- Stronger courses, programs, and students
- 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
Read More“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 -
Certiadria - Skopje, North Macedonia
Read MoreMacedonian Primary Teachers Increase Digital Literacy with Microsoft Office Specialist Certification.
-
Marshfield High School - Massachusetts, USA
Read More“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 -
Public Schools Of North Carolina - North Carolina, USA
Read More“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. -
Xavier High School - Iowa, USA
Read MoreAs a result of these certifications, Xavier students are equipped with valuable 21st century skills,”
Tom Keating,
Principal
Xavier High School -
Shaw High School Masters Microsoft Office Certifications - Georgia, USA
Read MoreShaw 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.