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 Excel 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 16, 2021
  • 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 16, 2021
  • 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.pass4sures.77-727.v2021-08-24.by.austin.12q.vce
Size
3.62 MB
Votes
1
File Name
microsoft.actualtests.77-727.v2021-04-30.by.maddison.12q.vce
Size
3.62 MB
Votes
2

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 Training Courses

Technology Literacy for Educators Training Course
62-193
Technology Literacy for Educators
$14.99
Excel 2013 Training Course
77-420
Excel 2013
$14.99
Excel 2016: Core Data Analysis, Manipulation, and Presentation Training Course
77-727
Excel 2016: Core Data Analysis, Manipulation, and Presentation
$14.99
SharePoint 2010 Training Course
77-886
SharePoint 2010
$14.99
Windows Operating System Fundamentals Training Course
98-349
Windows Operating System Fundamentals
$14.99
Software Development Fundamentals Training Course
98-361
Software Development Fundamentals
$14.99
Database Fundamentals Training Course
98-364
Database Fundamentals
$14.99
Windows Server Administration Fundamentals Training Course
98-365
Windows Server Administration Fundamentals
$14.99
Networking Fundamentals Training Course
98-366
Networking Fundamentals
$14.99
Security Fundamentals Training Course
98-367
Security Fundamentals
$14.99
Introduction to Programming Using Python Training Course
98-381
Introduction to Programming Using Python
$14.99
Microsoft Azure AI Fundamentals Training Course
AI-900
Microsoft Azure AI Fundamentals
$14.99
Microsoft Azure Administrator Training Course
AZ-104
Microsoft Azure Administrator
$14.99
Configuring and Operating Windows Virtual Desktop on Microsoft Azure Training Course
AZ-140
Configuring and Operating Windows Virtual Desktop on Microsoft Azure
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-204
Developing Solutions for Microsoft Azure
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-303
Microsoft Azure Architect Technologies
$14.99
Microsoft Azure Architect Design Training Course
AZ-304
Microsoft Azure Architect Design
$14.99
Microsoft Azure DevOps Solutions Training Course
AZ-400
Microsoft Azure DevOps Solutions
$14.99
Microsoft Azure Security Technologies Training Course
AZ-500
Microsoft Azure Security Technologies
$14.99
Microsoft Azure Fundamentals Training Course
AZ-900
Microsoft Azure Fundamentals
$14.99
Analyzing Data with Microsoft Power BI Training Course
DA-100
Analyzing Data with Microsoft Power BI
$14.99
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Data Engineering on Microsoft Azure Training Course
DP-203
Data Engineering on Microsoft Azure
$14.99
Microsoft Azure Data Fundamentals Training Course
DP-900
Microsoft Azure Data Fundamentals
$14.99
Microsoft Dynamics 365 for Sales Training Course
MB-210
Microsoft Dynamics 365 for Sales
$14.99
Microsoft Dynamics 365 for Customer Service Training Course
MB-230
Microsoft Dynamics 365 for Customer Service
$14.99
Microsoft Dynamics 365 for Field Service Training Course
MB-240
Microsoft Dynamics 365 for Field Service
$14.99
Microsoft Dynamics 365: Core Finance and Operations Training Course
MB-300
Microsoft Dynamics 365: Core Finance and Operations
$14.99
Microsoft Dynamics 365 Finance Training Course
MB-310
Microsoft Dynamics 365 Finance
$14.99
Microsoft Dynamics CRM 2016 Customization and Configuration Training Course
MB2-712
Microsoft Dynamics CRM 2016 Customization and Configuration
$14.99
Windows 10 Training Course
MD-100
Windows 10
$14.99
Managing Modern Desktops Training Course
MD-101
Managing Modern Desktops
$14.99
Microsoft Excel (Excel and Excel 2019) Training Course
MO-200
Microsoft Excel (Excel and Excel 2019)
$14.99
Microsoft 365 Identity and Services Training Course
MS-100
Microsoft 365 Identity and Services
$14.99
Microsoft 365 Mobility and Security Training Course
MS-101
Microsoft 365 Mobility and Security
$14.99
Microsoft 365 Messaging Training Course
MS-203
Microsoft 365 Messaging
$14.99
Microsoft 365 Security Administration Training Course
MS-500
Microsoft 365 Security Administration
$14.99
Managing Microsoft Teams Training Course
MS-700
Managing Microsoft Teams
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 Fundamentals
$14.99
Microsoft Power Platform App Maker Training Course
PL-100
Microsoft Power Platform App Maker
$14.99
Microsoft Power Platform Functional Consultant Training Course
PL-200
Microsoft Power Platform Functional Consultant
$14.99
Microsoft Power Platform Fundamentals Training Course
PL-900
Microsoft Power Platform Fundamentals
$14.99
Microsoft Security, Compliance, and Identity Fundamentals Training Course
SC-900
Microsoft Security, Compliance, and Identity Fundamentals
$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.