Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Learn microsoft excel pivot tables - Beginner To Expert Course

Other
Size
2.6 GB
Seeders
0
Leechers
0
Files
98
Category
Other
Added
at 7:24pm GMT+1
Infohash
6b8ed80d7dac439ed95b7f5d385c0fe046540968
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
Learn microsoft excel pivot tables:Beginner To Expert Course



https://DevCourseWeb.com

Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 48 lectures (4h 25m) | Size: 2.65 GB

Sourcing data, Cleansing it, and Analyzing it through microsoft excel pivot tables, Professional reporting of data

What you'll learn
Querying large amounts of data in many user-friendly ways.
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.
Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data enabling you to focus on just the information you want
Presenting concise, attractive, and annotated online or printed reports.

Requirements
Excel 2016 or above You should be able to work with data in Excel and do basic reporting

File list
  • Udemy - Learn microsoft excel pivot tables - Beginner To Expert Course
  • ~Get Your Files Here !/1. Introduction/1. Why is pivot important.mp4 15.6 MB
  • ~Get Your Files Here !/1. Introduction/1. Why is pivot important.srt 1.9 KB
  • ~Get Your Files Here !/1. Introduction/10. Classwork.mp4 29.9 MB
  • ~Get Your Files Here !/1. Introduction/10. Classwork.srt 1.9 KB
  • ~Get Your Files Here !/1. Introduction/10.1 1-10 classwork.xlsx 2.7 MB
  • ~Get Your Files Here !/1. Introduction/10.2 1-10 classwork.xlsx 2.7 MB
  • ~Get Your Files Here !/1. Introduction/2. Pivot is very important program.mp4 46.1 MB
  • ~Get Your Files Here !/1. Introduction/2. Pivot is very important program.srt 2.6 KB
  • ~Get Your Files Here !/1. Introduction/3. How to creat a pivot.mp4 52 MB
  • ~Get Your Files Here !/1. Introduction/3. How to creat a pivot.srt 2.6 KB
  • ~Get Your Files Here !/1. Introduction/4. Pivot table.mp4 40.2 MB
  • ~Get Your Files Here !/1. Introduction/4. Pivot table.srt 3.9 KB
  • ~Get Your Files Here !/1. Introduction/5. Pivot general review.mp4 14.3 MB
  • ~Get Your Files Here !/1. Introduction/5. Pivot general review.srt 1.3 KB
  • ~Get Your Files Here !/1. Introduction/6. Creating a table and coping or moving it.mp4 43.4 MB
  • ~Get Your Files Here !/1. Introduction/6. Creating a table and coping or moving it.srt 3.5 KB
  • ~Get Your Files Here !/1. Introduction/7. Refreshing and updating tables.mp4 27.3 MB
  • ~Get Your Files Here !/1. Introduction/7. Refreshing and updating tables.srt 1.9 KB
  • ~Get Your Files Here !/1. Introduction/8. How can we save source data in pivot.mp4 58.2 MB
  • ~Get Your Files Here !/1. Introduction/8. How can we save source data in pivot.srt 5.7 KB
  • ~Get Your Files Here !/1. Introduction/9. How to apply filters in pivot.mp4 45.3 MB
  • ~Get Your Files Here !/1. Introduction/9. How to apply filters in pivot.srt 4.8 KB
  • ~Get Your Files Here !/2. Get started with Pivot/1. Changing formats.mp4 49 MB
  • ~Get Your Files Here !/2. Get started with Pivot/1. Changing formats.srt 4.9 KB
  • ~Get Your Files Here !/2. Get started with Pivot/2. Fill in blanked cells.mp4 24.2 MB
  • ~Get Your Files Here !/2. Get started with Pivot/2. Fill in blanked cells.srt 3 KB
  • ~Get Your Files Here !/2. Get started with Pivot/3. Changing layout.mp4 44 MB
  • ~Get Your Files Here !/2. Get started with Pivot/3. Changing layout.srt 4.4 KB
  • ~Get Your Files Here !/2. Get started with Pivot/4. Changing source data in pivot.mp4 28 MB
  • ~Get Your Files Here !/2. Get started with Pivot/4. Changing source data in pivot.srt 2.2 KB
  • ~Get Your Files Here !/2. Get started with Pivot/5. Changing the title of rows or columns.mp4 22 MB
  • ~Get Your Files Here !/2. Get started with Pivot/5. Changing the title of rows or columns.srt 2 KB
  • ~Get Your Files Here !/2. Get started with Pivot/6. Conditional formatting.mp4 45.2 MB
  • ~Get Your Files Here !/2. Get started with Pivot/6. Conditional formatting.srt 3.8 KB
  • ~Get Your Files Here !/2. Get started with Pivot/7. Advanced conditional formatting.mp4 72.7 MB
  • ~Get Your Files Here !/2. Get started with Pivot/7. Advanced conditional formatting.srt 5 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/1. How to data sort in pivot.mp4 49.9 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/1. How to data sort in pivot.srt 4.1 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/2. Creating filter on lables.mp4 34.5 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/2. Creating filter on lables.srt 2.7 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/3. Creating filters using asterisk and questions mark.mp4 53.8 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/3. Creating filters using asterisk and questions mark.srt 5.3 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/4. Combined filters on pivot.mp4 36.3 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/4. Combined filters on pivot.srt 3 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/5. Date based display settings.mp4 42.4 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/5. Date based display settings.srt 3.9 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/6. Apply a filter using time line.mp4 29 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/6. Apply a filter using time line.srt 2.9 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/7. Combining time line and slicer to creat more complex filters.mp4 19.2 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/7. Combining time line and slicer to creat more complex filters.srt 1.5 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/8. Report filter page.mp4 29.3 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/8. Report filter page.srt 2.7 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/9. Class work at the end of chapter.mp4 43.4 MB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/9. Class work at the end of chapter.srt 2.8 KB
  • ~Get Your Files Here !/3. Filtering in Pivot Tables/9.1 Class work at the end of chapter.xlsx 2.5 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/1. Basic calculations in pivot such as addition,average.mp4 59.8 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/1. Basic calculations in pivot such as addition,average.srt 4.1 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/2. Removing errors in sum colculations.mp4 46.2 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/2. Removing errors in sum colculations.srt 2.9 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/3. Total percentage.mp4 71.8 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/3. Total percentage.srt 6.4 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/3.1 Class Work 3-4.xlsx 20.2 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/4. Calculating pivot table values.mp4 46.7 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/4. Calculating pivot table values.srt 3.5 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/4.1 Class Work 4-4.xlsx 21.6 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/5. Different from in pivot.mp4 36.3 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/5. Different from in pivot.srt 3.3 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/5.1 Class Work 4-5.xlsx 23.6 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/6. Running total.mp4 28.3 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/6. Running total.srt 2.4 KB
  • ~Get Your Files Here !/4. Calculations in Pivot/7. Using calculating field for complex calculations.mp4 31.6 MB
  • ~Get Your Files Here !/4. Calculations in Pivot/7. Using calculating field for complex calculations.srt 3 KB
  • ~Get Your Files Here !/5. Charts in Pivot/1. Drawing a simple bar graph.mp4 58 MB
  • ~Get Your Files Here !/5. Charts in Pivot/1. Drawing a simple bar graph.srt 4.5 KB
  • ~Get Your Files Here !/5. Charts in Pivot/10. End of chapter exercise and creating a dashboard with the help of charts.mp4 76.8 MB
  • ~Get Your Files Here !/5. Charts in Pivot/10. End of chapter exercise and creating a dashboard with the help of charts.srt 4.6 KB
  • ~Get Your Files Here !/5. Charts in Pivot/10.1 Datasets for practice.xlsx 38.6 KB
  • ~Get Your Files Here !/5. Charts in Pivot/10.2 End of season training.xlsx 69.6 KB
  • ~Get Your Files Here !/5. Charts in Pivot/2. Dual bargraph.mp4 30 MB
  • ~Get Your Files Here !/5. Charts in Pivot/2. Dual bargraph.srt 2.5 KB
  • ~Get Your Files Here !/5. Charts in Pivot/3. Pie chart.mp4 27.4 MB
  • ~Get Your Files Here !/5. Charts in Pivot/3. Pie chart.srt 3 KB
  • ~Get Your Files Here !/5. Charts in Pivot/4. Bar chart.mp4 30.3 MB
  • ~Get Your Files Here !/5. Charts in Pivot/4. Bar chart.srt 2.5 KB
  • ~Get Your Files Here !/5. Charts in Pivot/5. Time line chart.mp4 39.1 MB
  • ~Get Your Files Here !/5. Charts in Pivot/5. Time line chart.srt 3.6 KB
  • ~Get Your Files Here !/5. Charts in Pivot/6. Changing the type of chart.mp4 22.3 MB
  • ~Get Your Files Here !/5. Charts in Pivot/6. Changing the type of chart.srt 1.9 KB
  • ~Get Your Files Here !/5. Charts in Pivot/7. Area chart.mp4 34.2 MB
  • ~Get Your Files Here !/5. Charts in Pivot/7. Area chart.srt 3.1 KB
  • ~Get Your Files Here !/5. Charts in Pivot/8. Beautification of charts.mp4 83.2 MB
  • ~Get Your Files Here !/5. Charts in Pivot/8. Beautification of charts.srt 7 KB
  • ~Get Your Files Here !/5. Charts in Pivot/9. Applying slicers and time lines to multiple pivot charts.mp4 45.1 MB
  • ~Get Your Files Here !/5. Charts in Pivot/9. Applying slicers and time lines to multiple pivot charts.srt 3.3 KB
  • ~Get Your Files Here !/6. Case Study/1. Introducing the chapter.mp4 15.4 MB
  • ~Get Your Files Here !/6. Case Study/1. Introducing the chapter.srt 1.2 KB
  • ~Get Your Files Here !/6. Case Study/2. Case study 1.mp4 188.3 MB
  • ~Get Your Files Here !/6. Case Study/2. Case study 1.srt 14.8 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
1.4 GB30
7.5 GB01
4.8 GB01