77-728 Complete Techniques for the MOS Excel Expert Exam [Video]
Video
Video
$161.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
$161.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
-
1.1 Manage Workbooks
-
1.2 Manage Workbook Review
-
Objective Domain 1 - Exercises & Solutions
-
2.1 Apply Custom Data Formats and Validation
-
2.2 Apply Advanced Conditional Formatting and Filtering
-
2.3 Create and Modify Custom Workbook Elements
- 2.3.1 Create Custom Colour Formats
- 2.3.2 Create and Modify Cell Styles
- 2.3.3 Create and Modify Custom Themes
- 2.3.4 (Part I) Create and Modify Simple Macros
- 2.3.4 (Part II) Create and Modify Simple Macros
- 2.3.5 (Part I) Insert and Configure Form Controls
- 2.3.5 (Part II) Insert and Configure Form Controls
- 2.3.5 (Part III) Insert and Configure Form Controls
-
2.4 Prepare a Workbook for Internationalization
-
Domain Objective 2 - Exercises & Solutions
-
3.1 Apply Functions in Formulas
-
3.2 Look up Data by using Functions
-
3.3 Apply Advanced Date and Time Functions
-
3.4 Perform Data Analysis and Business Intelligence
- Introduction to Domain Objective 3.4
- 3.4.1 (Part I) Connecting to Data with Power Pivot
- 3.4.1 (Part II) More on Power Pivot
- 3.4.1 (Part III) Measures
- 3.4.1 (Part IV) Get and Transform
- 3.4.2 Consolidate Data
- 3.4.3 Perform What-if Analysis by using Goal Seek and Scenario Manager
- 3.4.4 Cube Functions Part I
- 3.4.4 Cube Functions Part II
- 3.4.4 Cube Functions Part III
- 3.4.5 Calculate Data by using Financial Functions
-
3.5 Troubleshoot Formulas
-
3.6 Define Named Ranges and Objects
-
Domain Objective 3 - Exercises & Solutions
-
4.1 Create Advanced Charts
-
4.2 Create and Manage Pivot Tables
-
4.3 Create and Manage Pivot Charts
-
Domain Objective 4 - Exercises & Solutions
-
CUBE Function Questions
About this
video
This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft. Every aspect of the exam is covered in detail, together with exercises and solutions. This course is delivered by a University professor who has many years' experience in teaching Excel to undergraduate students and is also a Microsoft Office Specialist examiner. If you take this course and follow the guidelines provided, you will enhance your chances of obtaining this valuable qualification. Prove your skills by obtaining independent certification from Microsoft.
All the code files are placed at https://github.com/PacktPublishing/77-728-Complete-Techniques-for-the-MOS-Excel-Expert-Exam
- Publication date:
- February 2019
- Publisher
- Packt
- Duration
- 9 hours 18 minutes
- ISBN
- 9781838648084