Excel Basics [2020] + Advanced in Ms Excel 2019 & Office 365

Excel Basics [2020] + Advanced in Ms Excel 2019 & Office 365

Other
Size
2.5 GB
Seeders
9
Leechers
1
Files
79
Category
Other
Added
12/06/20 at 12:22pm GMT+1
Infohash
af78f6138f112ce5cb5adb0f9f6a9122efad92cf

Description


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

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

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
9.6 GB08/19/1963
2.4 GB10/02/2000