Excel 2016 Core Microsoft Specialist
Audience: On completion of MOS 77-727 Excel 2016 Core exam candidates will have a fundamental understanding of Excel 2016 and the ability to complete tasks independently. Earners have proven they can create and edit a workbook with multiple sheets, and use graphic elements to represent data visually including professional-looking budgets, financial statements, performance charts, and data-entry logs. Excel earners include students, business professionals, clerical workers, bookkeepers, educators, and others.
The straightforward Excel evaluation challenges individuals to complete a comprehensive project that depicts real-world functionality with project and standards-based outcome testing.
All our Microsoft Office Specialist MOS training materials are published by CCL Learning
Titles include Access 2016, Word 2016 Core, Word 2016 Expert, Excel 2016 Core, Excel 2016 Expert, Outlook 2016 Core and PowerPoint 2016 Core, seven titles to collect.
These manuals can be purchase from ourselves as part of the official study MOS 2016 kit or manual only – you do not need to attend our courses to purchase these fantastic manuals.
Manuals for other Office versions are available – Office 2010 and 2013, coming soon Office 2019 and office 365
To purchase please complete our order form – once order has been received you will receive an order confirmation and invoice.
Exam Vouchers: Our MOS exam vouchers includes a thirty day retake.
Certification Guide: Spiral bound study manuals are Published by CCI Learning. Manual contents are separated into lessons, at completion of each lesson there is a summary and review questions.
Exam kit 77-727 includes, exam voucher + thirty day retake, Powerpoint Core Certification Guide and Gmetrix test prep – read more
Vouchers and Exam Kits rates includes exam test centre fees
77-727 Excel Core Exam Certification
Mouse MOS Test Venue
You will need to sit your exam at an authorised test centre. Mouse Training London is a Microsoft Office MOS test centre and available to schedule your exam seven days a week. We accept exam vouchers as purchased from us or other other suppliers.
For group bookings MOS testing is now available at your office.
okings MOS testing is now available at your office, there is no need to attend our test centre.
77-727 Excel 2016 Core Exam Course Outline
Accreditations Available: Microsoft Office Specialist & CPD Excel Core
Course Duration: 2/3 days, our three day course includes option to sit the Excel Core exam.
Course Types: Group bookings, public courses and 1-2-1 sessions
Course Location: This Microsoft Excel Specialist Core exam 77-727 training course can be delivered either at our London training venue or at your offices.
At Course Completion
Modify Slides, Handouts, and Notes
- Change the slide master theme or background
- Modify slide master content
- Create a slide layout
- Modify a slide layout
- Modify the handout master
- Modify the notes master
Order and Group Slides
- Create sections
- Modify slide order
- Rename sections
Change Presentation Options and Views
- Change slide size
- Change views of a presentation
- Set file properties
Configure a Presentation for Print
- Print all or part of a presentation
- Print notes pages
- Print handouts
- Print in colour, grayscale, or black and white
Configure and Present a Slide Show
- Create custom slide shows
- Configure slide show options
- Rehearse slide show timing
- Present a slide show by using Presenter View
Insert and Format Text
- Insert text on a slide
- Apply formatting and styles to text
- Art styles to text
- Format text in multiple columns
- Create bulleted and numbered lists
- Insert hyperlinks
Insert and Format Shapes and Text Boxes
- Insert or replace shapes
- Insert text boxes
- Resize shapes and text boxes
- Format shapes and text boxes
- Apply styles to shapes and text boxes
Insert and Format Images
- Insert images
- Resize and crop images
- Apply styles and effects
Order and Group Objects
- Order objects
- Align objects
- Group objects
- Display alignment tools
Insert and Format Tables
- Create a table
- Insert and delete table rows and columns
- Apply table styles
- Import a table
Insert and Format Tables
- Create a chart
- Import a chart
- Change the Chart Type
- Add a legend to a chart
- Change the chart style of a chart
Insert and Format SmartArt graphics
- Create SmartArt graphics
- Convert lists to SmartArt graphics
- Add shapes to SmartArt graphics
- Reorder shapes in SmartArt graphics
- Change the colour of SmartArt graphics
Insert and Manage Media
- Insert audio and video clips
- Configure media playback options
- Adjust media window size
- Set the video start and stop time
- Set media timing options
Apply Slide Transitions
- Insert slide transitions
- Set transition effect options
Animate Slide Content
- Apply animations to objects
- Apply animations to text
- Set animation effect options
- Set animation paths
Timing for Transitions and Animations
- Set transition effect duration
- Configure transition start and finish options
- Reorder animations on a slide
Merge Content from Multiple Presentations
- Inset slides from another presentation
- Compare two presentations
- Insert comments
- Review comments
- Protect a presentation
- Inspect a presentation
- Proof a presentation
- Preserve presentation content
- Export presentations to other formats
Further Accreditations – MOS Master
Microsoft Office Master 2016 earners masterfully use the basic and advanced features of MOS 2016 applications.
MOS 2016 Master is the highest MOS Certification.
Master candidates demonstrate a broader and deeper expertise of Excel, Word, PowerPoint, and Access or Outlook. They have achieved an elite certificate recognized worldwide.
Required Courses for office 2016 Master
Optional Courses for Office 2016 Master – Choose 1
Key Excel 2016 Core Topics Covered
Introducing Excel, learn how Excel works, understand how to move within Excel, create a workbook, enter data into a worksheet and work with files.
Constructing Cell Data, learn how to make changes to data in the worksheets, change the structure, and addadd and remove worksheets in the workbook.
Using Formulas, learn about formulas – what they are,how they work, how to inser simple formulas and use built-in functions to create some formulas.
Formatting the worksheet, learn how to use a variety of methods to format cells in a worksheet to emphasize different worksheet areas.
Viewing and Printing Workbooks, learn how to change the views in preparation for printing worksheets, Print and preview worksheets and customise the page setup for printing worksheets.
Working with Charts and Graphics, you will learn to work with charts work with different types of graphics images including shapes and pictures.
Organising Data, you will will look at various methods of organising data to improve your ability to analyze it.
Using Data Tools, you willlearn about a variety of Excel Data to include importing and exporting data between other applications, searching worksheets for a value, using hyperlinks, and making workbooks more accessible.