Training Video Course

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

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The 77-727 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 77-727 test with flying colors.

Rating
4.49rating
Students
91
Duration
06:07:00 h
$16.49
$14.99

Curriculum for 77-727 Video Course

Name of Video Time
Play Video: Introducing the Excel User Interface
1. Introducing the Excel User Interface
9:00
Play Video: Essential Navigation Skills
2. Essential Navigation Skills
10:00
Play Video: Entering Information
3. Entering Information
17:00
Name of Video Time
Play Video: 1.1.1 Create a Workbook
1. 1.1.1 Create a Workbook
3:00
Play Video: 1.1.2 Importing Data from a Delimited Text File
2. 1.1.2 Importing Data from a Delimited Text File
5:00
Play Video: 1.1.3 Add a Worksheet to an Existing Workbook
3. 1.1.3 Add a Worksheet to an Existing Workbook
2:00
Play Video: 1.1.4 Copy and Move a Worksheet
4. 1.1.4 Copy and Move a Worksheet
3:00
Play Video: Exercises Domain 1.1
5. Exercises Domain 1.1
8:00
Name of Video Time
Play Video: 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
8:00
Play Video: 1.2.2 Named Ranges
2. 1.2.2 Named Ranges
4:00
Play Video: 1.2.3 Insert and Remove hyperlinks
3. 1.2.3 Insert and Remove hyperlinks
4:00
Play Video: Exercises Domain 1.2
4. Exercises Domain 1.2
8:00
Name of Video Time
Play Video: 1.3.1 to 1.3.3 Changing Worksheet Characteristics
1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics
2:00
Play Video: 1.3.4 Modify Page Setup
2. 1.3.4 Modify Page Setup
7:00
Play Video: 1.3.5 Insert and Delete Columns or Rows (and Cells)
3. 1.3.5 Insert and Delete Columns or Rows (and Cells)
5:00
Play Video: 1.3.6 Change Workbook Themes
4. 1.3.6 Change Workbook Themes
2:00
Play Video: 1.3.7 Adjust Row Height and Column Width
5. 1.3.7 Adjust Row Height and Column Width
3:00
Play Video: 1.3.8 Insert Headers and Footers
6. 1.3.8 Insert Headers and Footers
5:00
Play Video: Exercises Domain 1.3
7. Exercises Domain 1.3
7:00
Name of Video Time
Play Video: 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
2:00
Play Video: 1.4.3 Customise the Quick Access Toolbar
2. 1.4.3 Customise the Quick Access Toolbar
2:00
Play Video: 1.4.4 Change Workbook Views
3. 1.4.4 Change Workbook Views
3:00
Play Video: 1.4.5 Change Window Views
4. 1.4.5 Change Window Views
8:00
Play Video: 1.4.6 Modify Document Properties
5. 1.4.6 Modify Document Properties
2:00
Play Video: 1.4.7 Change Magnification by using Zoom Tools
6. 1.4.7 Change Magnification by using Zoom Tools
1:00
Play Video: 1.4.8 Display Formulas
7. 1.4.8 Display Formulas
2:00
Play Video: Exercises Domain 1.4
8. Exercises Domain 1.4
5:00
Name of Video Time
Play Video: 1.5.1. Set a Print Area
1. 1.5.1. Set a Print Area
1:00
Play Video: 1.5.2 Save Workbooks in Alternative File Formats
2. 1.5.2 Save Workbooks in Alternative File Formats
2:00
Play Video: 1.5.3 Print All of Part of a Workbook
3. 1.5.3 Print All of Part of a Workbook
1:00
Play Video: 1.5.4 Set Print Scaling
4. 1.5.4 Set Print Scaling
4:00
Play Video: 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
2:00
Play Video: 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
2:00
Play Video: 1.5.7 Inspect a Workbook for Accessibility Issues
7. 1.5.7 Inspect a Workbook for Accessibility Issues
4:00
Play Video: 1.5.8 Inspect a Workbook for Compatibility Issues
8. 1.5.8 Inspect a Workbook for Compatibility Issues
3:00
Play Video: Exercises 1.5
9. Exercises 1.5
3:00
Name of Video Time
Play Video: 2.1.1 Replace Data
1. 2.1.1 Replace Data
3:00
Play Video: 2.1.2 Cut, Copy or Paste Data
2. 2.1.2 Cut, Copy or Paste Data
4:00
Play Video: 2.1.3 Paste Data by using Special Paste Options
3. 2.1.3 Paste Data by using Special Paste Options
4:00
Play Video: 2.1.4 Fill Cells by using Auto Fill
4. 2.1.4 Fill Cells by using Auto Fill
3:00
Play Video: 2.1.5 Insert and Delete Cells
5. 2.1.5 Insert and Delete Cells
1:00
Play Video: Exercises Domain 2.1
6. Exercises Domain 2.1
6:00
Name of Video Time
Play Video: 2.2.1 Merge Cells
1. 2.2.1 Merge Cells
2:00
Play Video: 2.2.2 Modify Cell Alignment and Indentation
2. 2.2.2 Modify Cell Alignment and Indentation
2:00
Play Video: 2.2.3 Format Cells by using Format Painter
3. 2.2.3 Format Cells by using Format Painter
2:00
Play Video: 2.2.4 Wrap Text Within Cells
4. 2.2.4 Wrap Text Within Cells
1:00
Play Video: 2.2.5 Apply Number Formats
5. 2.2.5 Apply Number Formats
7:00
Play Video: 2.2.6 Apply Cell Formats
6. 2.2.6 Apply Cell Formats
7:00
Play Video: 2.2.7 Apply Cell Styles
7. 2.2.7 Apply Cell Styles
2:00
Play Video: Exercises Domain 2.2
8. Exercises Domain 2.2
7:00
Name of Video Time
Play Video: 2.3.1 Insert Sparklines
1. 2.3.1 Insert Sparklines
4:00
Play Video: 2.3.2 and 2.3.3 Outline Data and Insert Subtotals
2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals
8:00
Play Video: 2.3.4 Apply Conditional Formatting
3. 2.3.4 Apply Conditional Formatting
5:00
Play Video: Exercises Domain 2.3
4. Exercises Domain 2.3
5:00
Name of Video Time
Play Video: 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
5:00
Play Video: 3.1.3 Add or Remove Table rows and Columns
2. 3.1.3 Add or Remove Table rows and Columns
2:00
Play Video: 3.2.1 to 3.2.3 Table Styles
3. 3.2.1 to 3.2.3 Table Styles
2:00
Play Video: Exercises Domain 3.1 and 3.2
4. Exercises Domain 3.1 and 3.2
2:00
Name of Video Time
Play Video: 3.3.1 Filter Records
1. 3.3.1 Filter Records
5:00
Play Video: 3.3.2 and 3.3.3 Sort Data
2. 3.3.2 and 3.3.3 Sort Data
6:00
Play Video: 3.3.4 Remove Duplicate Records
3. 3.3.4 Remove Duplicate Records
1:00
Play Video: Exercises Domain 3.3
4. Exercises Domain 3.3
4:00
Name of Video Time
Play Video: 4.1.1 (Part I) Insert References
1. 4.1.1 (Part I) Insert References
10:00
Play Video: 4.1.1 (Part II) Absolute References
2. 4.1.1 (Part II) Absolute References
6:00
Play Video: 4.1.2 Perform Calculations by using the SUM Function
3. 4.1.2 Perform Calculations by using the SUM Function
5:00
Play Video: 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
4:00
Play Video: Exercises Domain 4.1
5. Exercises Domain 4.1
7:00
Name of Video Time
Play Video: 4.2.1 Perform Logical Operations by using the IF Function
1. 4.2.1 Perform Logical Operations by using the IF Function
11:00
Play Video: 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
4:00
Play Video: Exercises Domain 4.2
3. Exercises Domain 4.2
9:00
Name of Video Time
Play Video: 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
8:00
Play Video: Exercises Domain 4.3
2. Exercises Domain 4.3
4:00
Name of Video Time
Play Video: 5.1.1 Create a New Chart
1. 5.1.1 Create a New Chart
4:00
Play Video: 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
1:00
Play Video: 5.1.4 Analyse Data by using Quick Analysis
3. 5.1.4 Analyse Data by using Quick Analysis
2:00
Play Video: Exercises Domain 5.1
4. Exercises Domain 5.1
3:00
Name of Video Time
Play Video: 5.2.1 Resize Charts
1. 5.2.1 Resize Charts
2:00
Play Video: 5.2.2 Add and Modify Chart Elements
2. 5.2.2 Add and Modify Chart Elements
2:00
Play Video: 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
2:00
Play Video: Exercises Domain 5.2
4. Exercises Domain 5.2
3:00
Name of Video Time
Play Video: 5.3.1 Insert Text Boxes and Shapes
1. 5.3.1 Insert Text Boxes and Shapes
2:00
Play Video: 5.3.2 Insert Images
2. 5.3.2 Insert Images
3:00
Play Video: 5.3.3 Modify Object Properties
3. 5.3.3 Modify Object Properties
10:00
Play Video: 5.3.4 Add Alternative Text to Objects for Accessibility
4. 5.3.4 Add Alternative Text to Objects for Accessibility
1:00
Play Video: Exercises Domain 5.3
5. Exercises Domain 5.3
5:00

Download Microsoft 77-727 Exam Questions & Answers

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

Microsoft 77-727 Premium Bundle
$69.97
$49.99

77-727 Premium Bundle

  • Premium File: 35 Questions & Answers. Last update: Sep 14, 2020
  • Training Course: 85 Video Lectures
  • Study Guide: 200 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
Get Unlimited Access to ALL Premium Files

77-727 Premium Bundle

Microsoft 77-727 Premium Bundle
  • Premium File: 35 Questions & Answers. Last update: Sep 14, 2020
  • Training Course: 85 Video Lectures
  • Study Guide: 200 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$69.97
$49.99
Get Unlimited Access to ALL Premium Files

Free 77-727 Exam Questions & 77-727 Dumps

File Name Size Votes
File Name
microsoft.train4sure.77-727.v2019-06-25.by.jakao.15q.vce
Size
5.01 MB
Votes
3

Comments (0)

Add Comment

Please post your comments about 77-727 Exams. Don't share your email address asking for 77-727 braindumps or 77-727 exam pdf files.

Add Comment

Purchase Individually

77-727  Premium File
77-727
Premium File
35 Q&A
$43.99 $39.99
77-727  Training Course
77-727
Training Course
35 Lectures
$16.49 $14.99
77-727  Study Guide
77-727
Study Guide
35 Pages
$16.49 $14.99

Microsoft Certifications

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.