Certification training

77-72777-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

Prepare for your Microsoft exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

85Lectures
6h 7mDuration
MicrosoftVendor
77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation course cover Best seller
Microsoft certification training 77-727 85 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

17 sections, 85 lessons, and lecture-level duration details.

01 Introducing the Excel User Interface 9m
02 Essential Navigation Skills 10m
03 Entering Information 17m

01 1.1.1 Create a Workbook 3m
02 1.1.2 Importing Data from a Delimited Text File 5m
03 1.1.3 Add a Worksheet to an Existing Workbook 2m
04 1.1.4 Copy and Move a Worksheet 3m
05 Exercises Domain 1.1 8m

01 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element 8m
02 1.2.2 Named Ranges 4m
03 1.2.3 Insert and Remove hyperlinks 4m
04 Exercises Domain 1.2 8m

01 1.3.1 to 1.3.3 Changing Worksheet Characteristics 2m
02 1.3.4 Modify Page Setup 7m
03 1.3.5 Insert and Delete Columns or Rows (and Cells) 5m
04 1.3.6 Change Workbook Themes 2m
05 1.3.7 Adjust Row Height and Column Width 3m
06 1.3.8 Insert Headers and Footers 5m
07 Exercises Domain 1.3 7m

01 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows 2m
02 1.4.3 Customise the Quick Access Toolbar 2m
03 1.4.4 Change Workbook Views 3m
04 1.4.5 Change Window Views 8m
05 1.4.6 Modify Document Properties 2m
06 1.4.7 Change Magnification by using Zoom Tools 1m
07 1.4.8 Display Formulas 2m
08 Exercises Domain 1.4 5m

01 1.5.1 1m
02 1.5.2 Save Workbooks in Alternative File Formats 2m
03 1.5.3 Print All of Part of a Workbook 1m
04 1.5.4 Set Print Scaling 4m
05 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets 2m
06 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information 2m
07 1.5.7 Inspect a Workbook for Accessibility Issues 4m
08 1.5.8 Inspect a Workbook for Compatibility Issues 3m
09 Exercises 1.5 3m

01 2.1.1 Replace Data 3m
02 2.1.2 Cut, Copy or Paste Data 4m
03 2.1.3 Paste Data by using Special Paste Options 4m
04 2.1.4 Fill Cells by using Auto Fill 3m
05 2.1.5 Insert and Delete Cells 1m
06 Exercises Domain 2.1 6m

01 2.2.1 Merge Cells 2m
02 2.2.2 Modify Cell Alignment and Indentation 2m
03 2.2.3 Format Cells by using Format Painter 2m
04 2.2.4 Wrap Text Within Cells 1m
05 2.2.5 Apply Number Formats 7m
06 2.2.6 Apply Cell Formats 7m
07 2.2.7 Apply Cell Styles 2m
08 Exercises Domain 2.2 7m

01 2.3.1 Insert Sparklines 4m
02 2.3.2 and 2.3.3 Outline Data and Insert Subtotals 8m
03 2.3.4 Apply Conditional Formatting 5m
04 Exercises Domain 2.3 5m

01 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse 5m
02 3.1.3 Add or Remove Table rows and Columns 2m
03 3.2.1 to 3.2.3 Table Styles 2m
04 Exercises Domain 3.1 and 3.2 2m

01 3.3.1 Filter Records 5m
02 3.3.2 and 3.3.3 Sort Data 6m
03 3.3.4 Remove Duplicate Records 1m
04 Exercises Domain 3.3 4m

01 4.1.1 (Part I) Insert References 10m
02 4.1.1 (Part II) Absolute References 6m
03 4.1.2 Perform Calculations by using the SUM Function 5m
04 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions 4m
05 Exercises Domain 4.1 7m

01 4.2.1 Perform Logical Operations by using the IF Function 11m
02 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions 4m
03 Exercises Domain 4.2 9m

01 4.3.1 Format Text by using RIGHT, LEFT and MID Functions 8m
02 Exercises Domain 4.3 4m

01 5.1.1 Create a New Chart 4m
02 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns 1m
03 5.1.4 Analyse Data by using Quick Analysis 2m
04 Exercises Domain 5.1 3m

01 5.2.1 Resize Charts 2m
02 5.2.2 Add and Modify Chart Elements 2m
03 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts 2m
04 Exercises Domain 5.2 3m

01 5.3.1 Insert Text Boxes and Shapes 2m
02 5.3.2 Insert Images 3m
03 5.3.3 Modify Object Properties 10m
04 5.3.4 Add Alternative Text to Objects for Accessibility 1m
05 Exercises Domain 5.3 5m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.