by Dave Murphy | Publisher: Packt Publishing | Release Date: February 2019 | ISBN: 9781838646264

MOS Core Excel - 77-727 : Complete Techniques for Exam SuccessAbout This VideoSuitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this course is aimed at you obtaining certification status from Microsoft bypassing the 77-727 exam.In DetailMicrosoft 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 CareerUse your knowledge to obtain certified statusUnderstand the 77-727 ExamLearn how to correctly prepare for the testGet advice from a seasoned professional who knows how to pass the examCore Excel with the MOS 77-727 ExamThis 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.

1. Chapter 1 : Introduction
   • What is the Microsoft Office Specialist (MOS) Certification? 00:04:14
   • Understanding the Objective Domain 00:03:21
   • How is the exam be conducted and what will it be like? 00:05:43
2. Chapter 2 : Introducing the Microsoft Excel User Interface
   • Introducing the Excel User Interface 00:08:38
   • Essential Navigation Skills 00:10:00
   • Entering Information 00:17:10
3. Chapter 3 : 1.1 Create Worksheets and Workbooks
   • 1.1.1 Create a Workbook 00:02:54
   • 1.1.2 Importing Data from a Delimited Text File 00:05:04
   • 1.1.3 Add a Worksheet to an Existing Workbook 00:02:00
   • 1.1.4 Copy and Move a Worksheet 00:03:01
   • Exercises Domain 1.1 00:07:53
4. Chapter 4 : 1.2 Navigate in Worksheets and Workbooks
   • 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element 00:07:47
   • 1.2.2 Named Ranges 00:04:09
   • 1.2.3 Insert and Remove hyperlinks 00:03:47
   • Exercises Domain 1.2 00:07:52
5. Chapter 5 : 1.3 Format Worksheets and Workbooks
   • 1.3.1 to 1.3.3 Changing Worksheet Characteristics 00:02:11
   • 1.3.4 Modify Page Setup 00:06:34
   • 1.3.5 Insert and Delete Columns or Rows (and Cells) 00:05:08
   • 1.3.6 Change Workbook Themes 00:01:55
   • 1.3.7 Adjust Row Height and Column Width 00:02:56
   • 1.3.8 Insert Headers and Footers 00:05:28
   • Exercises Domain 1.3 00:06:32
6. Chapter 6 : 1.4 Customise Options and Views for Worksheets and Workbooks
   • 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows 00:02:09
   • 1.4.4 Change Workbook Views 00:03:14
   • 1.4.5 Change Window Views 00:07:58
   • 1.4.6 Modify Document Properties 00:02:24
   • 1.4.7 Change Magnification by using Zoom Tools 00:01:12
   • 1.4.8 Display Formulas 00:01:35
   • Exercises Domain 1.4 00:05:04
7. Chapter 7 : 1.5 Configure Worksheets and Workbooks for Distribution
   • 1.5.1. Set a Print Area 00:01:11
   • 1.5.2 save Workbooks in Alternative File Formats 00:02:16
   • 1.5.3 Print All of Part of a Workbook 00:01:23
   • 1.5.4 Set Print Scaling 00:03:27
   • 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets 00:01:57
   • 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information 00:02:16
   • 1.5.7 Inspect a Workbook for Accessibility Issues 00:03:32
   • 1.5.8 Inspect a Workbook for Compatibility Issues 00:02:33
   • Exercises 1.5 00:03:22
8. Chapter 8 : 2.1 Insert Data in Cells and Ranges
   • 2.1.1 Replace Data 00:02:53
   • 2.1.2 Cut, Copy or Paste Data 00:03:47
   • 2.1.3 Paste Data by using Special Paste Options 00:04:26
   • 2.1.4 Fill Cells by using Auto Fill 00:02:45
   • 2.1.5 Insert and Delete Cells 00:01:18
   • Exercises Domain 2.1 00:05:48
9. Chapter 9 : 2.2. Format Cells and Ranges
   • 2.2.1 Merge Cells 00:01:57
   • 2.2.2 Modify Cell Alignment and Indentation 00:01:51
   • 2.2.3 Format Cells by using Format Painter 00:01:36
   • 2.2.4 Wrap Text within Cells 00:01:16
   • 2.2.5 Apply Number Formats 00:06:50
   • 2.2.6 Apply Cell Formats 00:06:33
   • 2.2.7 Apply Cell Styles 00:02:23
   • Exercises Domain 2.2 00:07:06
10. Chapter 10 : 2.3 Summarise and Organise Data
    • 2.3.4 Apply Conditional Formatting 00:05:09
    • Exercises Domain 2.3 00:04:56
11. Chapter 11 : 3.1 And 3.2 Create and Manage Tables
    • 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse 00:05:03
    • 3.1.3 Add or Remove Table rows and Columns 00:01:28
    • 3.2.1 to 3.2.3 Table Styles 00:02:03
    • Exercises Domain 3.1 and 3.2 00:02:28
12. Chapter 12 : 3.3 Filter and Sort a Table
    • 3.3.1 Filter Records 00:04:50
    • 3.3.2 and 3.3.3 Sort Data 00:05:26
    • 3.3.4 Remove Duplicate Records 00:01:11
    • Exercises Domain 3.3 00:04:25
13. Chapter 13 : 4.1 Summarise Data by Using Functions
    • 4.1.1 (Part I) Insert References 00:09:06
    • 4.1.1 (Part II) Absolute References 00:07:22
    • 4.1.2 Perform Calculations by using the SUM Function 00:05:00
    • 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions 00:03:26
    • 2.3.2 Outline Data 00:04:39
    • 2.3.3 Insert Subtotals 00:01:30
    • Exercises Domain 4.1 00:07:16
14. Chapter 14 : 4.2 Perform Conditional Operations by Using Functions
    • 4.2.1 Perform Logical Operations by using the IF Function 00:10:20
    • 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions 00:03:37
    • Exercises Domain 4.2 00:08:55
15. Chapter 15 : 4.3 Format and Modify Text by Using Functions
    • 4.3.1 Format Text by using RIGHT, LEFT and MID Functions 00:07:20
    • Exercises Domain 4.3 00:04:29
16. Chapter 16 : 5.1 Create Charts
    • 5.1.1 Create a New Chart 00:03:39
    • 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns 00:01:05
    • 5.1.4 Analyse Data by using Quick Analysis 00:02:24
    • 2.3.1 Insert Sparklines 00:03:56
    • Exercises Domain 5.1 00:03:23
17. Chapter 17 : 5.2 Format Charts
    • 5.2.1 Resize Charts 00:01:43
    • 5.2.2 Add and Modify Chart Elements 00:01:56
    • 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts 00:01:29
    • Exercises Domain 5.2 00:03:27
18. Chapter 18 : 5.3 Insert and Format Objects
    • 5.3.1 Insert Text Boxes and Shapes 00:02:13
    • 5.3.2 Insert Images 00:03:15
    • 5.3.3 Modify Object Properties 00:10:08
    • 5.3.4 Add Alternative Text to Objects for Accessibility 00:00:53
    • Exercises Domain 5.3 00:05:20