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

Udemy - Complete Microsoft Excel 2016 Beginner to Advanced Course

Size
2 GB
Seeders
1
Leechers
1
Files
98
Category
Added
at 11:22pm GMT+1
Infohash
4684917d448261c4138dcf1b2bb1b6ef1d9b0840
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Complete Microsoft Excel 2016 Beginner to Advanced Course



If You Need More Stuff, kindly Visit and Support Us -->> 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



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

File list
  • Udemy - Complete Microsoft Excel 2016 Beginner to Advanced Course
  • ~Get Your Files Here !/1. The Basics/1. Introduction.mp4 31.5 MB
  • ~Get Your Files Here !/1. The Basics/1. Introduction.srt 3.2 KB
  • ~Get Your Files Here !/1. The Basics/2. Cells, Colors and Text.mp4 128.2 MB
  • ~Get Your Files Here !/1. The Basics/2. Cells, Colors and Text.srt 14.1 KB
  • ~Get Your Files Here !/1. The Basics/3. Wrap Text, Numbers and Sheets.mp4 61.5 MB
  • ~Get Your Files Here !/1. The Basics/3. Wrap Text, Numbers and Sheets.srt 7.4 KB
  • ~Get Your Files Here !/1. The Basics/4. The Basics Quiz.html 167 B
  • ~Get Your Files Here !/1. The Basics/5. Assignment 1.html 171 B
  • ~Get Your Files Here !/10. View and Review/1. View tab.mp4 39.9 MB
  • ~Get Your Files Here !/10. View and Review/1. View tab.srt 3.7 KB
  • ~Get Your Files Here !/10. View and Review/2. Review your work.mp4 65.7 MB
  • ~Get Your Files Here !/10. View and Review/2. Review your work.srt 8.8 KB
  • ~Get Your Files Here !/10. View and Review/3. View and Review Quiz.html 167 B
  • ~Get Your Files Here !/10. View and Review/4. Assignment 10.html 171 B
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/1. Tables, Filtering and Sorting.mp4 109.6 MB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/1. Tables, Filtering and Sorting.srt 11.4 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/2. Inserting Columns and Rows.mp4 30 MB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/2. Inserting Columns and Rows.srt 2.7 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/3. Group and Ungroup.mp4 39.6 MB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/3. Group and Ungroup.srt 3.8 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/3.1 Excel June and July 2019 sales.xlsx 10.3 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/4. Slicer and Object.mp4 43 MB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/4. Slicer and Object.srt 3.5 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/4.1 Excel Events and Activities.xlsx 10 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/5. Formatting.mp4 114.3 MB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/5. Formatting.srt 12.4 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/5.1 Excel Format Table.xlsx 10.3 KB
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/6. Tables, Filtering, Columns, Rows and Formatting Quiz.html 167 B
  • ~Get Your Files Here !/2. Tables, Columns, Rows and Filtering Data/7. Assignment 2.html 171 B
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/1. Flash Fill.mp4 16.1 MB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/1. Flash Fill.srt 1.5 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/1.1 Excel Name and Surname.xlsx 8.7 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/2. Text to Columns.mp4 15.8 MB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/2. Text to Columns.srt 1.9 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/3. Concatenate.mp4 18.9 MB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/3. Concatenate.srt 2.1 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/4. Find, Replace and Go to.mp4 24.9 MB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/4. Find, Replace and Go to.srt 2.6 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/4.1 Excel Kids Birthday Party.xlsx 10 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/5. Drop down List.mp4 53.1 MB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/5. Drop down List.srt 4.6 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/5.1 Excel Employee Info.xlsx 10.2 KB
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/6. Text Shortcuts, Tools and Skills Quiz.html 167 B
  • ~Get Your Files Here !/3. Text Shortcuts, Tools and Skills/7. Assignment 3.html 171 B
  • ~Get Your Files Here !/4. Basic Formulas/1. Basic Formulas, Sum and Average.mp4 107.5 MB
  • ~Get Your Files Here !/4. Basic Formulas/1. Basic Formulas, Sum and Average.srt 9.9 KB
  • ~Get Your Files Here !/4. Basic Formulas/1.1 Excel Hotdog Sales.xlsx 9.2 KB
  • ~Get Your Files Here !/4. Basic Formulas/2. Subtotal.mp4 20.3 MB
  • ~Get Your Files Here !/4. Basic Formulas/2. Subtotal.srt 1.8 KB
  • ~Get Your Files Here !/4. Basic Formulas/2.1 Excel Hotdog Sales Subtotal.xlsx 9.3 KB
  • ~Get Your Files Here !/4. Basic Formulas/3. Countif.mp4 39.6 MB
  • ~Get Your Files Here !/4. Basic Formulas/3. Countif.srt 4 KB
  • ~Get Your Files Here !/4. Basic Formulas/4. Sumif.mp4 38.1 MB
  • ~Get Your Files Here !/4. Basic Formulas/4. Sumif.srt 3.4 KB
  • ~Get Your Files Here !/4. Basic Formulas/5. Basic Formulas Quiz.html 167 B
  • ~Get Your Files Here !/4. Basic Formulas/6. Assignment 4.html 171 B
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/1. Shapes and Effects.mp4 206.2 MB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/1. Shapes and Effects.srt 19.9 KB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/2. Insert a Picture.mp4 37.5 MB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/2. Insert a Picture.srt 3.2 KB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/3. Symbols, Equations and Text.mp4 58.1 MB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/3. Symbols, Equations and Text.srt 6.4 KB
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/4. Shapes and Pictures Quiz.html 167 B
  • ~Get Your Files Here !/5. Shapes, Pictures and Symbols/5. Assignment 5.html 171 B
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/1. Charts.mp4 70.5 MB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/1. Charts.srt 5.3 KB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/2. Forecast Sheet.mp4 67.1 MB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/2. Forecast Sheet.srt 5.4 KB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/2.1 Excel Games Sold.xlsx 9.8 KB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/3. Sparklines.mp4 42 MB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/3. Sparklines.srt 4.3 KB
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/4. Charts, Forecast Sheet and Sparklines Quiz.html 167 B
  • ~Get Your Files Here !/6. Charts, Forecast Sheet and Sparklines/5. Assignment 6.html 171 B
  • ~Get Your Files Here !/7. More About Formulas/1. Vlookup.mp4 43.1 MB
  • ~Get Your Files Here !/7. More About Formulas/1. Vlookup.srt 4.7 KB
  • ~Get Your Files Here !/7. More About Formulas/2. Index and Match.mp4 43.2 MB
  • ~Get Your Files Here !/7. More About Formulas/2. Index and Match.srt 3.6 KB
  • ~Get Your Files Here !/7. More About Formulas/2.1 Excel Hardware Store Tools Index and Match.xlsx 10 KB
  • ~Get Your Files Here !/7. More About Formulas/3. Absolute Cells.mp4 34.1 MB
  • ~Get Your Files Here !/7. More About Formulas/3. Absolute Cells.srt 2.7 KB
  • ~Get Your Files Here !/7. More About Formulas/3.1 Excel Hardware Store Tools Tax 2.xlsx 10.2 KB
  • ~Get Your Files Here !/7. More About Formulas/4. If.mp4 52.3 MB
  • ~Get Your Files Here !/7. More About Formulas/4. If.srt 5.6 KB
  • ~Get Your Files Here !/7. More About Formulas/4.1 Excel Score Tables.xlsx 10.8 KB
  • ~Get Your Files Here !/7. More About Formulas/5. Define Name.mp4 26.1 MB
  • ~Get Your Files Here !/7. More About Formulas/5. Define Name.srt 2.4 KB
  • ~Get Your Files Here !/7. More About Formulas/6. Tracing Precedents and Dependents.mp4 21.8 MB
  • ~Get Your Files Here !/7. More About Formulas/6. Tracing Precedents and Dependents.srt 1.9 KB
  • ~Get Your Files Here !/7. More About Formulas/6.1 Excel Hardware Store Tools Tax.xlsx 11.1 KB
  • ~Get Your Files Here !/7. More About Formulas/7. Error Checking, Show and Evaluate Formulas.mp4 26.8 MB
  • ~Get Your Files Here !/7. More About Formulas/7. Error Checking, Show and Evaluate Formulas.srt 2.8 KB
  • ~Get Your Files Here !/7. More About Formulas/8. More about Formulas Quiz.html 167 B
  • ~Get Your Files Here !/7. More About Formulas/9. Assignment 7.html 171 B
  • ~Get Your Files Here !/8. Pivot Table, Timeline and Query/1. Pivot Table.mp4 66.3 MB
  • ~Get Your Files Here !/8. Pivot Table, Timeline and Query/1. Pivot Table.srt 7 KB
  • ~Get Your Files Here !/8. Pivot Table, Timeline and Query/1.1 Assignment 8 Excel table 1.xlsx 10.4 KB
  • ~Get Your Files Here !/8. Pivot Table, Timeline and Query/2. Timeline.mp4 45.8 MB
  • ~Get Your Files Here !/8. Pivot Table, Timeline and Query/2. Timeline.srt 4.9 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.