77-727 Microsoft Excel Certification - MOS Excel Core Exam [Video]
Video
Video
$116.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$116.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterIntroduction
-
Introducing the Microsoft Excel User Interface
-
1.1 Create Worksheets and Workbooks
-
1.2 Navigate in Worksheets and Workbooks
-
1.3 Format Worksheets and Workbooks
-
1.4 Customise Options and Views for Worksheets and Workbooks
-
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
-
2.1 Insert Data in Cells and Ranges
-
2.2. Format Cells and Range
-
2.3 Summarise and Organise Data
-
3.1 And 3.2 Create and Manage Tables
-
3.3 Filter and Sort a Table
-
4.1 Summarise Data by Using Functions
-
4.2 Perform Conditional Operations by Using Functions
-
4.3 Format and Modify Text by Using Functions
-
5.1 Create Charts
-
5.2 Format Charts
-
5.3 Insert and Format Objects
About this
video
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.
- Publication date:
- February 2019
- Publisher
- Packt
- Duration
- 6 hours 15 minutes
- ISBN
- 9781838646264