| 1. Basic Formulas, Sum and Average.mp4 | 107.5 MB | ||
| 1. Basic Formulas, Sum and Average.srt | 9.9 KB | ||
| 1. Charts.mp4 | 70.5 MB | ||
| 1. Charts.srt | 5.3 KB | ||
| 1. Flash Fill.mp4 | 16.1 MB | ||
| 1. Flash Fill.srt | 1.5 KB | ||
| 1. Goal Seek.mp4 | 14.9 MB | ||
| 1. Goal Seek.srt | 1.4 KB | ||
| 1. Introduction.mp4 | 31.5 MB | ||
| 1. Introduction.srt | 3.2 KB | ||
| 1. Pivot Table.mp4 | 66.3 MB | ||
| 1. Pivot Table.srt | 7 KB | ||
| 1. Shapes and Effects.mp4 | 206.2 MB | ||
| 1. Shapes and Effects.srt | 19.9 KB | ||
| 1. Tables, Filtering and Sorting.mp4 | 109.6 MB | ||
| 1. Tables, Filtering and Sorting.srt | 11.4 KB | ||
| 1. View tab.mp4 | 39.9 MB | ||
| 1. View tab.srt | 3.7 KB | ||
| 1. Vlookup.mp4 | 43.1 MB | ||
| 1. Vlookup.srt | 4.7 KB | ||
| 1.1 Assignment 8 Excel table 1.xlsx | 10.4 KB | ||
| 1.1 Excel Hotdog Sales.xlsx | 9.2 KB | ||
| 1.1 Excel Name and Surname.xlsx | 8.7 KB | ||
| 1.1 Excel Test Percentage.xlsx | 8.6 KB | ||
| 2. Cells, Colors and Text.mp4 | 128.2 MB | ||
| 2. Cells, Colors and Text.srt | 14.1 KB | ||
| 2. Data Table.mp4 | 31 MB | ||
| 2. Data Table.srt | 3.1 KB | ||
| 2. Forecast Sheet.mp4 | 67.1 MB | ||
| 2. Forecast Sheet.srt | 5.4 KB | ||
| 2. Index and Match.mp4 | 43.2 MB | ||
| 2. Index and Match.srt | 3.6 KB | ||
| 2. Insert a Picture.mp4 | 37.5 MB | ||
| 2. Insert a Picture.srt | 3.2 KB | ||
| 2. Inserting Columns and Rows.mp4 | 30 MB | ||
| 2. Inserting Columns and Rows.srt | 2.7 KB | ||
| 2. Review your work.mp4 | 65.7 MB | ||
| 2. Review your work.srt | 8.8 KB | ||
| 2. Subtotal.mp4 | 20.3 MB | ||
| 2. Subtotal.srt | 1.8 KB | ||
| 2. Text to Columns.mp4 | 15.8 MB | ||
| 2. Text to Columns.srt | 1.9 KB | ||
| 2. Timeline.mp4 | 45.8 MB | ||
| 2. Timeline.srt | 4.9 KB | ||
| 2.1 Excel Car Tyres Table.xlsx | 10.4 KB | ||
| 2.1 Excel Games Sold.xlsx | 9.8 KB | ||
| 2.1 Excel Hardware Store Tools Index and Match.xlsx | 10 KB | ||
| 2.1 Excel Hotdog Sales Subtotal.xlsx | 9.3 KB | ||
| 3. Absolute Cells.mp4 | 34.1 MB | ||
| 3. Absolute Cells.srt | 2.7 KB | ||
| 3. Concatenate.mp4 | 18.9 MB | ||
| 3. Concatenate.srt | 2.1 KB | ||
| 3. Countif.mp4 | 39.6 MB | ||
| 3. Countif.srt | 4 KB | ||
| 3. Group and Ungroup.mp4 | 39.6 MB | ||
| 3. Group and Ungroup.srt | 3.8 KB | ||
| 3. Query.mp4 | 61.1 MB | ||
| 3. Query.srt | 6.6 KB | ||
| 3. Scenario Manager.mp4 | 31.9 MB | ||
| 3. Scenario Manager.srt | 3.8 KB | ||
| 3. Sparklines.mp4 | 42 MB | ||
| 3. Sparklines.srt | 4.3 KB | ||
| 3. Symbols, Equations and Text.mp4 | 58.1 MB | ||
| 3. Symbols, Equations and Text.srt | 6.4 KB | ||
| 3. View and Review Quiz.html | 204.8 B | ||
| 3. Wrap Text, Numbers and Sheets.mp4 | 61.5 MB | ||
| 3. Wrap Text, Numbers and Sheets.srt | 7.4 KB | ||
| 3.1 Excel Hardware Store Tools Tax 2.xlsx | 10.2 KB | ||
| 3.1 Excel Hotdog Sales 2.xlsx | 9.3 KB | ||
| 3.1 Excel June and July 2019 sales.xlsx | 10.3 KB | ||
| 3.1 Excel Vehicle Stock.xlsx | 9.7 KB | ||
| 3.2 Excel Vehicles Sold.xlsx | 10.1 KB | ||
| 4. Assignment 10.html | 204.8 B | ||
| 4. Charts, Forecast Sheet and Sparklines Quiz.html | 204.8 B | ||
| 4. Consolidate.mp4 | 57.8 MB | ||
| 4. Consolidate.srt | 5.7 KB | ||
| 4. Find, Replace and Go to.mp4 | 24.9 MB | ||
| 4. Find, Replace and Go to.srt | 2.6 KB | ||
| 4. If.mp4 | 52.3 MB | ||
| 4. If.srt | 5.6 KB | ||
| 4. Pivot Table, Timeline and Query Quiz.html | 204.8 B | ||
| 4. Shapes and Pictures Quiz.html | 204.8 B | ||
| 4. Slicer and Object.mp4 | 43 MB | ||
| 4. Slicer and Object.srt | 3.5 KB | ||
| 4. Sumif.mp4 | 38.1 MB | ||
| 4. Sumif.srt | 3.4 KB | ||
| 4. The Basics Quiz.html | 204.8 B | ||
| 4.1 Excel Events and Activities.xlsx | 10 KB | ||
| 4.1 Excel Kids Birthday Party.xlsx | 10 KB | ||
| 4.1 Excel Score Tables.xlsx | 10.8 KB | ||
| 4.1 Excel Warm Beverages.xlsx | 12.4 KB | ||
| 5. Assignment 1.html | 204.8 B | ||
| 5. Assignment 5.html | 204.8 B | ||
| 5. Assignment 6.html | 204.8 B | ||
| 5. Assignment 8.html | 204.8 B | ||
| 5. Basic Formulas Quiz.html | 204.8 B | ||
| 5. Define Name.mp4 | 26.1 MB | ||
| 5. Define Name.srt | 2.4 KB | ||
| 5. Drop down List.mp4 | 53.1 MB | ||
| 5. Drop down List.srt | 4.6 KB | ||
| 5. Formatting.mp4 | 114.3 MB | ||
| 5. Formatting.srt | 12.4 KB | ||
| 5. What If Analysis and Consolidate quiz..html | 204.8 B | ||
| 5.1 Excel Employee Info.xlsx | 10.2 KB | ||
| 5.1 Excel Format Table.xlsx | 10.3 KB | ||
| 6. Assignment 4.html | 204.8 B | ||
| 6. Assignment 9.html | 204.8 B | ||
| 6. Tables, Filtering, Columns, Rows and Formatting Quiz.html | 204.8 B | ||
| 6. Text Shortcuts, Tools and Skills Quiz.html | 204.8 B | ||
| 6. Tracing Precedents and Dependents.mp4 | 21.8 MB | ||
| 6. Tracing Precedents and Dependents.srt | 1.9 KB | ||
| 6.1 Excel Hardware Store Tools Tax.xlsx | 11.1 KB | ||
| 7. Assignment 2.html | 204.8 B | ||
| 7. Assignment 3.html | 204.8 B | ||
| 7. Error Checking, Show and Evaluate Formulas.mp4 | 26.8 MB | ||
| 7. Error Checking, Show and Evaluate Formulas.srt | 2.8 KB | ||
| 8. More about Formulas Quiz.html | 204.8 B | ||
| 9. Assignment 7.html | 204.8 B | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 120 total files | |||
Complete Microsoft Excel 2016 Beginner to Advanced Course
https://DevCourseWeb.com
Duration: 4h 38m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 1.98 GB
Genre: eLearning | Language: English
Formulas, Tables, Charts, Colors, Shapes, Effects, Concatenate, Consolidate, Drop down lists, Timelines, Query and more.
What you'll learn
In this course you will learn about the basic Excel skills all the way to the advanced tools and functions.
Learn how to use cells, the ribbon and work with rows and columns. Work with charts, tables, shapes and use filtering and formatting.
Learn Formulas for functions such as sum, sumif, countif, average, index, match, and more.
Learn how to sort information on tables or on different sheets.
Learn how to use and edit shapes and edit imported pictures.
Learn multiple shortcuts and how to review your work.
Instructions will be spoken and there will also be text on screen for each step.
Requirements
Know how to open Excel and the basics of using a computer. The course will even show you how to open a new workbook in Excel.
Description
Learn about the basics, such as opening a new workbook, using the ribbon and using cells and sheets.
Learn the commonly used formulas and functions to solve mathematical problems and figure out values.
Learn how to use Tables, Pivot Tables, filtering information and formatting cells.
Learn about Text tools, colors, gradients and effects.
Learn how to use the Data Tools.
Learn how to insert shapes and images and add effects to them and change colors.
Learn how to create and use Charts.
Learn how to use Concatenate, Consolidate, Flash fill and make drop down lists.
Learn how to use What if Analysis tools (Data tables, Goal seek and Scenario Manager)
Learn how to create a timeline.
Learn how to use the Query feature.
Learn about reviewing your work and using basic features like zoom and checking spelling.
Learn shortcuts that allow you to do work quicker.
Includes 10 Practice Assignments and Quizzes.
Course is in English with English text instructions on screen during videos.
Who this course is for
Beginner and Intermediate Excel users. Those who want to learn about using spreadsheets to store and edit information.
Homepage
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 2 weeks | 12 | 1 | |
| 3.8 GB | freecoursewb | 2 weeks | 23 | 3 | |
| 3.3 GB | freecoursewb | 2 weeks | 7 | 5 | |
|
Udemy - Form 1003 (URLA) Masterclass - Complete Mortgage Application Posted by
freecoursewb in Other
|
354.4 MB | freecoursewb | 2 weeks | 10 | 3 |
| 547.3 MB | freecoursewb | 2 weeks | 45 | 1 |
All Comments