Training Video Course

70-779: Analyzing and Visualizing Data with Microsoft Excel

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

Rating
4.49rating
Students
93
Duration
05:46:32 h
$16.49
$14.99

Curriculum for 70-779 Video Course

Name of Video Time
Play Video: Welcome
1. Welcome
01:30
Play Video: Introduction to Udemy
2. Introduction to Udemy
02:35
Name of Video Time
Play Video: Our first PivotTable
1. Our first PivotTable
07:47
Play Video: PivotTable Menus
2. PivotTable Menus
02:35
Play Video: Our first PivotChart
3. Our first PivotChart
05:35
Play Video: PivotChart Menus and An Introduction to Practice Activity 1
4. PivotChart Menus and An Introduction to Practice Activity 1
03:14
Play Video: Answer to Practice Activity 1
5. Answer to Practice Activity 1
04:29
Name of Video Time
Play Video: Source data requirements
1. Source data requirements
04:30
Play Video: Adding additional values
2. Adding additional values
05:01
Play Video: Recommended PivotTables
3. Recommended PivotTables
03:30
Play Video: Moving PivotTable
4. Moving PivotTable
03:22
Play Video: Refresh PivotTable - why it doesn't auto-update
5. Refresh PivotTable - why it doesn't auto-update
06:21
Play Video: Extracting data
6. Extracting data
05:03
Play Video: Sorting
7. Sorting
03:31
Play Video: Answer to Practice Activity 2
8. Answer to Practice Activity 2
01:51
Name of Video Time
Play Video: Adding additional row fields
1. Adding additional row fields
02:28
Play Video: Different layouts – Compact, Outline and Tabular
2. Different layouts – Compact, Outline and Tabular
06:38
Play Video: Blank Rows
3. Blank Rows
03:05
Play Video: Group Records
4. Group Records
04:43
Play Video: Showing or hiding additional detail - the +/- buttons
5. Showing or hiding additional detail - the +/- buttons
04:17
Play Video: Adding columns
6. Adding columns
05:06
Play Video: Adding page fields
7. Adding page fields
02:50
Play Video: Adding filters
8. Adding filters
09:35
Play Video: Changing source
9. Changing source
03:55
Play Video: Using a table source
10. Using a table source
04:07
Play Video: Final options
11. Final options
03:43
Play Video: Introduction to Practice Activity 3
12. Introduction to Practice Activity 3
02:07
Play Video: Answers to Practice Activity 3
13. Answers to Practice Activity 3
04:12
Name of Video Time
Play Video: Change aggregate (COUNT, MIN, MAX)
1. Change aggregate (COUNT, MIN, MAX)
08:26
Play Video: Repeat All
2. Repeat All
05:35
Play Video: Using Conditional Formatting to hide Repeat All
3. Using Conditional Formatting to hide Repeat All
03:43
Play Video: Grand Totals
4. Grand Totals
04:54
Play Video: Adding subtotals
5. Adding subtotals
09:08
Play Video: Show items with no data
6. Show items with no data
05:38
Play Video: Other field settings
7. Other field settings
05:02
Play Video: Answers to Practice Activity 4
8. Answers to Practice Activity 4
02:18
Name of Video Time
Play Video: Layout
1. Layout
09:13
Play Video: Totals & Filters, and Alt Text
2. Totals & Filters, and Alt Text
04:40
Play Video: Display
3. Display
03:35
Play Video: Print
4. Print
04:52
Play Video: Data
5. Data
11:24
Play Video: Answers to Practice Activity 5
6. Answers to Practice Activity 5
02:09
Name of Video Time
Play Video: Create slicers
1. Create slicers
03:08
Play Video: Identifying impossible options, and selecting more than one option at once.
2. Identifying impossible options, and selecting more than one option at once.
04:59
Play Video: Join to multiple PivotTables
3. Join to multiple PivotTables
05:45
Play Video: Options
4. Options
04:57
Play Video: Answer to Practice Activity 6
5. Answer to Practice Activity 6
03:35
Name of Video Time
Play Video: Aggregates
1. Aggregates
04:13
Play Video: Group by time period
2. Group by time period
05:39
Play Video: Timelines
3. Timelines
06:16
Play Video: Answer to Practice Activity 7
4. Answer to Practice Activity 7
03:50
Name of Video Time
Play Video: Formatting number values
1. Formatting number values
03:58
Play Video: Custom Formatting - number formatting
2. Custom Formatting - number formatting
11:45
Play Video: Custom Formatting - dates and text
3. Custom Formatting - dates and text
09:06
Play Video: Custom Formatting - sections and colors
4. Custom Formatting - sections and colors
08:26
Play Video: Conditional Formatting - Highlighting cells
5. Conditional Formatting - Highlighting cells
05:32
Play Video: Conditional Formatting - Data Bars and Color Sets
6. Conditional Formatting - Data Bars and Color Sets
06:32
Play Video: Formatting printing
7. Formatting printing
04:48
Play Video: Styles
8. Styles
04:10
Play Video: Answer to Practice Activity 8
9. Answer to Practice Activity 8
03:41
Name of Video Time
Play Video: Percentage of total
1. Percentage of total
07:59
Play Video: Percentage of total - Advanced
2. Percentage of total - Advanced
06:02
Play Video: Cumulative totals
3. Cumulative totals
05:21
Play Video: Index
4. Index
04:49
Play Video: Difference from
5. Difference from
03:11
Play Video: Calculated fields
6. Calculated fields
04:10
Play Video: Calculated Items
7. Calculated Items
05:43
Name of Video Time
Play Video: Relationship of PivotChart with PivotTable
1. Relationship of PivotChart with PivotTable
02:34
Play Video: Options and Styles
2. Options and Styles
02:54
Play Video: Bubble charts
3. Bubble charts
04:11
Name of Video Time
Play Video: Thank you for joining me
1. Thank you for joining me
01:30

Download Microsoft 70-779 Exam Questions & Answers

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

Microsoft 70-779 Premium Bundle
$59.97
$39.97

70-779 Premium Bundle

  • Premium File: 101 Questions & Answers. Last update: Aug 9, 2020
  • Training Course: 71 Video Lectures
  • Study Guide: 427 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
Get Unlimited Access to ALL Premium Files

70-779 Premium Bundle

Microsoft 70-779 Premium Bundle
  • Premium File: 101 Questions & Answers. Last update: Aug 9, 2020
  • Training Course: 71 Video Lectures
  • Study Guide: 427 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$59.97
$39.97
Get Unlimited Access to ALL Premium Files

Free 70-779 Exam Questions & 70-779 Dumps

File Name Size Votes
File Name
microsoft.passcertification.70-779.v2019-10-15.by.edward.60q.vce
Size
3.01 MB
Votes
3
File Name
microsoft.test-king.70-779.v2019-09-17.by.noah.57q.vce
Size
2.86 MB
Votes
3
File Name
microsoft.excel.pass4sureexam.70-779.v2018-09-20.by.mateo.20q.vce
Size
1.81 MB
Votes
2

Comments (0)

Add Comment

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

Add Comment

Purchase Individually

70-779  Premium File
70-779
Premium File
101 Q&A
$32.99 $29.99
70-779  Training Course
70-779
Training Course
101 Lectures
$16.49 $14.99
70-779  Study Guide
70-779
Study Guide
101 Pages
$16.49 $14.99

Microsoft Training Courses

Managing Microsoft SharePoint Server 2016 Training Course
70-339
Managing Microsoft SharePoint Server 2016
$14.99
Designing and Deploying Microsoft Exchange Server 2016 Training Course
70-345
Designing and Deploying Microsoft Exchange Server 2016
$14.99
Installing and Configuring Windows Server 2012 Training Course
70-410
Installing and Configuring Windows Server 2012
$14.99
Administering Windows Server 2012 Training Course
70-411
Administering Windows Server 2012
$14.99
Configuring Advanced Windows Server 2012 Services Training Course
70-412
Configuring Advanced Windows Server 2012 Services
$14.99
MCSE Designing and Implementing a Server Infrastructure Training Course
70-413
MCSE Designing and Implementing a Server Infrastructure
$14.99
MCSE Implementing an Advanced Server Infrastructure Training Course
70-414
MCSE Implementing an Advanced Server Infrastructure
$14.99
Upgrading Your Skills to MCSA Windows Server 2012 Training Course
70-417
Upgrading Your Skills to MCSA Windows Server 2012
$14.99
MCSA Querying Microsoft SQL Server 2012/2014 Training Course
70-461
MCSA Querying Microsoft SQL Server 2012/2014
$14.99
MCSA Administering Microsoft SQL Server 2012/2014 Databases Training Course
70-462
MCSA Administering Microsoft SQL Server 2012/2014 Databases
$14.99
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Training Course
70-463
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
$14.99
Developing Microsoft SQL Server 2012/2014 Databases Training Course
70-464
Developing Microsoft SQL Server 2012/2014 Databases
$14.99
Designing Database Solutions for Microsoft SQL Server 2012 Training Course
70-465
Designing Database Solutions for Microsoft SQL Server 2012
$14.99
Implementing Data Models and Reports with Microsoft SQL Server 2012 Training Course
70-466
Implementing Data Models and Reports with Microsoft SQL Server 2012
$14.99
Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Training Course
70-467
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
$14.99
MCSD Programming in HTML5 with JavaScript and CSS3 Training Course
70-480
MCSD Programming in HTML5 with JavaScript and CSS3
$14.99
MCSD Programming in C# Training Course
70-483
MCSD Programming in C#
$14.99
MCSD Developing ASP.NET MVC Web Applications Training Course
70-486
MCSD Developing ASP.NET MVC Web Applications
$14.99
MCSD Developing Windows Azure and Web Services Training Course
70-487
MCSD Developing Windows Azure and Web Services
$14.99
Installation, Storage, and Compute with Windows Server 2016 Training Course
70-740
Installation, Storage, and Compute with Windows Server 2016
$14.99
MCSA Networking with Windows Server 2016 Training Course
70-741
MCSA Networking with Windows Server 2016
$14.99
Identity with Windows Server 2016 Training Course
70-742
Identity with Windows Server 2016
$14.99
Upgrading Your Skills to MCSA: Windows Server 2016 Training Course
70-743
Upgrading Your Skills to MCSA: Windows Server 2016
$14.99
Securing Windows Server 2016 Training Course
70-744
Securing Windows Server 2016
$14.99
Querying Data with Transact-SQL Training Course
70-761
Querying Data with Transact-SQL
$14.99
Developing SQL Databases Training Course
70-762
Developing SQL Databases
$14.99
Administering a SQL Database Infrastructure Training Course
70-764
Administering a SQL Database Infrastructure
$14.99
Provisioning SQL Databases Training Course
70-765
Provisioning SQL Databases
$14.99
Implementing a SQL Data Warehouse Training Course
70-767
Implementing a SQL Data Warehouse
$14.99
Developing SQL Data Models Training Course
70-768
Developing SQL Data Models
$14.99
Analyzing and Visualizing Data with Microsoft Power BI Training Course
70-778
Analyzing and Visualizing Data with Microsoft Power BI
$14.99
Analyzing and Visualizing Data with Microsoft Excel Training Course
70-779
Analyzing and Visualizing Data with Microsoft Excel
$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
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
Designing and Implementing an Azure AI Solution Training Course
AI-100
Designing and Implementing an Azure AI Solution
$14.99
Microsoft Azure Administrator Training Course
AZ-103
Microsoft Azure Administrator
$14.99
Microsoft Azure Administrator (beta) Training Course
AZ-104
Microsoft Azure Administrator (beta)
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-203
Developing Solutions for Microsoft Azure
$14.99
Developing Solutions for Microsoft Azure (beta) Training Course
AZ-204
Developing Solutions for Microsoft Azure (beta)
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-300
Microsoft Azure Architect Technologies
$14.99
Microsoft Azure Architect Design Training Course
AZ-301
Microsoft Azure Architect Design
$14.99
Microsoft Azure Architect Technologies (beta) Training Course
AZ-303
Microsoft Azure Architect Technologies (beta)
$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
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Implementing an Azure Data Solution Training Course
DP-200
Implementing an Azure Data Solution
$14.99
Designing an Azure Data Solution Training Course
DP-201
Designing an Azure Data Solution
$14.99
Microsoft Dynamics 365 for Customer Service Training Course
MB-230
Microsoft Dynamics 365 for Customer Service
$14.99
Microsoft Dynamics CRM 2016 Customization and Configuration Training Course
MB2-712
Microsoft Dynamics CRM 2016 Customization and Configuration
$14.99
Microsoft Dynamics 365 Customization and Configuration Training Course
MB2-716
Microsoft Dynamics 365 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 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
Deploying Microsoft 365 Teamwork Training Course
MS-300
Deploying Microsoft 365 Teamwork
$14.99
Deploying SharePoint Server Hybrid Training Course
MS-301
Deploying SharePoint Server Hybrid
$14.99
Microsoft 365 Security Administration Training Course
MS-500
Microsoft 365 Security Administration
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 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.