Analyzing and Visualizing Data with Microsoft Excel Video Course

70-779: Analyzing and Visualizing Data with Microsoft Excel

Your Microsoft 70-779 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-779 certification test. Ace your Microsoft 70-779 at the first attempt and obtain the Analyzing and Visualizing Data with Microsoft Excel credential with ease.

# of Students
86
# of Lectures
71
Course Length
5 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-779 Video Course

Introduction

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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

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

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address