| 1. General Shortcuts.mp4 | 38.1 MB | ||
| 1. General Shortcuts.srt | 3.6 KB | ||
| 1. Get the Most Out of This Course.mp4 | 14.4 MB | ||
| 1. Get the Most Out of This Course.srt | 3.7 KB | ||
| 1. Goodbye.mp4 | 1.4 MB | ||
| 1. Goodbye.srt | 716 B | ||
| 1. Highlight Max Value on a Chart.mp4 | 269.4 MB | ||
| 1. Highlight Max Value on a Chart.srt | 40.5 KB | ||
| 1. PivotTable Made Easy.mp4 | 271.5 MB | ||
| 1. PivotTable Made Easy.srt | 24.5 KB | ||
| 1. Relative vs Absolute Cell References.mp4 | 59 MB | ||
| 1. Relative vs Absolute Cell References.srt | 8.1 KB | ||
| 1.1 Highlight Max Value on a Chart - Completed.xlsx | 23.2 KB | ||
| 1.1 MacOS Keyboard Shortcuts.html | 204 B | ||
| 1.1 PivotTable.xlsx | 83.9 KB | ||
| 1.2 PivotTable - Completed.xlsx | 140.9 KB | ||
| 1.2 Windows Keyboard Shortcuts.html | 204 B | ||
| 1.3 Keyboard Shortcuts.pdf | 151.6 KB | ||
| 2. Conditional Formatting.mp4 | 122.2 MB | ||
| 2. Conditional Formatting.srt | 12.1 KB | ||
| 2. How To Set The English Display Language.mp4 | 20.9 MB | ||
| 2. How To Set The English Display Language.srt | 2.8 KB | ||
| 2. PivotTable From Multiple Tables.mp4 | 111.2 MB | ||
| 2. PivotTable From Multiple Tables.srt | 12.9 KB | ||
| 2. Shortcuts for Navigation.mp4 | 46 MB | ||
| 2. Shortcuts for Navigation.srt | 3.4 KB | ||
| 2. Working with Dates.mp4 | 232 MB | ||
| 2. Working with Dates.srt | 27 KB | ||
| 2.1 Conditional Formatting.xlsx | 10.6 KB | ||
| 2.1 Date Functions.xlsx | 18 KB | ||
| 2.1 English Language Pack.html | 204 B | ||
| 2.1 PivotTable From Multiple Tables.xlsx | 40.5 KB | ||
| 2.2 Conditional Formatting - Completed.xlsx | 19.7 KB | ||
| 2.2 Date Functions - Completed.xlsx | 26.3 KB | ||
| 2.2 PivotTable From Multiple Tables - Completed.xlsx | 412.4 KB | ||
| 3. Getting Started With Excel.mp4 | 234.3 MB | ||
| 3. Getting Started With Excel.srt | 30.2 KB | ||
| 3. Map Charts.mp4 | 214.3 MB | ||
| 3. Map Charts.srt | 35.2 KB | ||
| 3. SUM(), SUMIF(), SUMIFS().mp4 | 77.3 MB | ||
| 3. SUM(), SUMIF(), SUMIFS().srt | 7.6 KB | ||
| 3. Shortcuts for Data Entry.mp4 | 64.2 MB | ||
| 3. Shortcuts for Data Entry.srt | 5.5 KB | ||
| 3.1 Map Charts - Completed.xlsx | 683.1 KB | ||
| 3.1 SUMIF.xlsx | 12.4 KB | ||
| 3.2 Map Charts.xlsx | 14.4 KB | ||
| 3.3 us-regions.jpg?042148 | 84.9 KB | ||
| 3.4 Adobe Color Harmony Rules.html | 102 B | ||
| 4. Bar Chart With Icons.mp4 | 165.7 MB | ||
| 4. Bar Chart With Icons.srt | 21.9 KB | ||
| 4. Formatting Shortcuts.mp4 | 41.8 MB | ||
| 4. Formatting Shortcuts.srt | 3.4 KB | ||
| 4. MIN(), MAX(), AVERAGE(), COUNT().mp4 | 95.1 MB | ||
| 4. MIN(), MAX(), AVERAGE(), COUNT().srt | 10.6 KB | ||
| 4.1 MIN-MAX-AVERAGE-COUNT.xlsx | 13.3 KB | ||
| 4.1 icon-dog.png | 2.3 KB | ||
| 4.2 Simple Icon Chart - Completed.xlsx | 22.6 KB | ||
| 4.3 icon-cat.png | 2.8 KB | ||
| 5. Progress Chart In Infographic Style.mp4 | 239.2 MB | ||
| 5. Progress Chart In Infographic Style.srt | 39.3 KB | ||
| 5. Selection Shortcuts.mp4 | 29.2 MB | ||
| 5. Selection Shortcuts.srt | 2.1 KB | ||
| 5. VLOOKUP(), HLOOKUP().mp4 | 90.3 MB | ||
| 5. VLOOKUP(), HLOOKUP().srt | 11.8 KB | ||
| 5.1 VLOOKUP-HLOOKUP.xlsx | 13 KB | ||
| 5.1 icon-male-inverse.png | 2.1 KB | ||
| 5.2 Male Female Icon Chart - Completed.xlsx | 25.9 KB | ||
| 5.2 VLOOKUP-HLOOKUP - Completed.xlsx | 14.8 KB | ||
| 5.3 Adobe Color Harmony Rules.html | 102 B | ||
| 5.4 icon-female-inverse.png | 2.2 KB | ||
| 6. INDEX(), MATCH(), XLOOKUP().mp4 | 59.5 MB | ||
| 6. INDEX(), MATCH(), XLOOKUP().srt | 7.9 KB | ||
| 6. Shortcuts for Formulas.mp4 | 29.8 MB | ||
| 6. Shortcuts for Formulas.srt | 2.4 KB | ||
| 6.1 INDEX-MATCH-XLOOKUP - Completed.xlsx | 14.1 KB | ||
| 6.2 INDEX-MATCH-XLOOKUP.xlsx | 13.7 KB | ||
| 7. Miscellaneous Shortcuts.mp4 | 39.8 MB | ||
| 7. Miscellaneous Shortcuts.srt | 2.5 KB | ||
| TutsNode.com.txt | 102 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614 B | ||
| ▲ 80 total files | |||

Description
In this special Microsoft Excel [2020] Beginner course you can learn the most important features of Excel focusing on data visualization and productivity. I’m using the version Ms Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016 versions.
In the first section you can learn Excel basics in 30 minutes if you’re a beginner. Then I’m going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience. We will also discover Excel’s conditional formatting feature.
I dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.
I created a section for the most frequently used Excel functions. You will find lots of real-world examples in these lectures.
In the last section we’re getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to learn it, but I’ll make it simple for you. We’re going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables.
By taking this course you can really take your Excel skills to way above the average.
Don’t worry, if you’re an absolute beginner. I’ll explain everything step by step.
If you’re already familiar with Excel, I’m pretty sure I can show you new, interesting things.
Please watch the Intro video to see what you can expect from this course. If you like it, enroll in quickly.
Who this course is for:
Students who want to stand out with special Excel knowledge
Requirements
The course was recorded with Microsoft Excel 2019 which is similar to Office 365 Excel version
Most features work in Excel 2010/2013/2016 or I show you alternative
Last Updated 11/2020
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 5 days | 25 | 12 | |
| 2.7 GB | freecoursewb | 5 days | 26 | 11 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 2 weeks | 1 | 11 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 2 weeks | 2 | 56 |
| 3.8 GB | freecoursewb | 2 weeks | 30 | 5 |
All Comments