Video description
Microsoft Certification (MOS) - Use your knowledge to become a Microsoft Office Specialist in Core Excel. This course will prepare you for the Microsoft Office Specialist Exam 77-727. The course provides an overview of the exam, the objective requirements set by Microsoft, tips on how to prepare and what to expect on the day of the test. It includes a comprehensive bank of test exercises which reflect the style of questions asked in the 77-727 Microsoft Core Excel exam. A comprehensive series of lectures are provided which cover every step needed to succeed.
Become a Microsoft Office Specialist and Enhance Your Career
Use your knowledge to obtain certified status
Understand the 77-727 Exam
Learn how to correctly prepare for the test
Get advice from a seasoned professional who knows how to pass the exam
Core Excel with the MOS 77-727 Exam
This course is suitable for people at all levels of proficiency in Microsoft Excel. If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the 77-727 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject. Every element of the objective domain for the 77-727 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam. When you pass the 77-727 exam, Microsoft issue you with the MOS, or Microsoft Office Specialist certification status, in core Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement. If you follow and complete the course and exercises you will optimize your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace.
What You Will Learn
- How to successfully pass the 77-727 Microsoft Certified Exam in Core Excel and become a Microsoft Office Specialist
- Be confident and competent in your use of Microsoft Excel for everyday business use
- Be ready to begin to study to become a certified Microsoft Office Specialist
- Guarantee potential Employers of your competence in Microsoft Excel
Audience
This course is for students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel, existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills.
About The Author
Dave Murphy: Dave Murphy - With over twenty years of experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the world’s largest companies, Dave Murphy changed his career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in business information systems at the Technological University, Dublin. His main interests are in Microsoft certifications, project management, and business process analysis.
Dave has a bachelor’s in science (Hons) from Trinity College, Dublin, and a master’s degree in computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in managing projects with Microsoft Project, is a MOS Master, and also a MOS examiner.
Publisher resources
Table of contents
- Chapter 1 : Introduction
- Chapter 2 : Introducing the Microsoft Excel User Interface
- Chapter 3 : 1.1 Create Worksheets and Workbooks
- Chapter 4 : 1.2 Navigate in Worksheets and Workbooks
- Chapter 5 : 1.3 Format Worksheets and Workbooks
- Chapter 6 : 1.4 Customise Options and Views for Worksheets and Workbooks
-
Chapter 7 : 1.5 Configure Worksheets and Workbooks for Distribution
- 1.5.1. Set a Print Area
- 1.5.2 save Workbooks in Alternative File Formats
- 1.5.3 Print All of Part of a Workbook
- 1.5.4 Set Print Scaling
- 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
- 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
- 1.5.7 Inspect a Workbook for Accessibility Issues
- 1.5.8 Inspect a Workbook for Compatibility Issues
- Exercises 1.5
- Chapter 8 : 2.1 Insert Data in Cells and Ranges
- Chapter 9 : 2.2. Format Cells and Ranges
- Chapter 10 : 2.3 Summarise and Organise Data
- Chapter 11 : 3.1 And 3.2 Create and Manage Tables
- Chapter 12 : 3.3 Filter and Sort a Table
- Chapter 13 : 4.1 Summarise Data by Using Functions
- Chapter 14 : 4.2 Perform Conditional Operations by Using Functions
- Chapter 15 : 4.3 Format and Modify Text by Using Functions
- Chapter 16 : 5.1 Create Charts
- Chapter 17 : 5.2 Format Charts
- Chapter 18 : 5.3 Insert and Format Objects
Product information
- Title: 77-727 Microsoft Excel Certification - MOS Excel Core Exam
- Author(s):
- Release date: February 2019
- Publisher(s): Packt Publishing
- ISBN: 9781838646264
You might also like
book
MOS Study Guide for Microsoft Excel Exam MO-200
Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise …
book
MOS Study Guide for Microsoft Excel Expert Exam MO-201
Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level …
video
Advanced Microsoft Excel 2013
In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond …
video
Microsoft Excel Beginners 2016
This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading …