Udemy - Microsoft Excel - The Complete Training for Beginners

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size2.8 GB
  • Uploaded Byfreecoursewb
  • Downloads60
  • Last checkedJan. 22nd '22
  • Date uploadedJan. 21st '22
  • Seeders 10
  • Leechers15

Infohash : 09FF2531BFBD4BA6B44E2A85898217392758925A

Microsoft Excel - The Complete Training for Beginners



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 78 lectures (6h 24m) | Size: 2.65 GB

Excel Step by Step Tutorial, Excellent for Beginners - Excel Commands, Formula, Functions - Uses with Example

What you'll learn
if you are a beginner and not knowing excel , this course is perfectly suited for you, after the completion, you will be an excel professional
step by step training. In each tools and options, detailed description with example. So the learners can simply learn each topics
excel ribbon - learn each tabs and their various commands - their uses with example
different type of cell reference - learn their uses with example
excel calculations - in worksheet area - learn simple and complex calculations
Excel functions - learn functions in each category, which are essential for an office or a business, learn each one and their uses with example
can learn excel advanced tools like pivot table and chart, table, data validation, scenario, consolidate, macro etc...
can learn excel advanced functions Lookup, Index and Match, their uses with detailed example
each video tutorial, will have an index at the beginning of the video, so the learners can simply find out their commands or function without much effort

Requirements
anyone who has a basic knowledge in computer can join this course

Files:

[ DevCourseWeb.com ] Udemy - Microsoft Excel - The Complete Training for Beginners
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - Excel - An Introduction
    • 001 Introduction.mp4 (15.9 MB)
    02 - Excel Basics
    • 001 Worksheet Area and calculations-A.mp4 (11.4 MB)
    • 002 Worksheet Area and calculations-B.mp4 (34.0 MB)
    • 003 Worksheet Area and calculations-C.mp4 (19.4 MB)
    • 004 Lab Assignment.mp4 (10.6 MB)
    • 004 worksheet-content.pdf (138.1 KB)
    • 004 worksheetarea01.xlsx (18.3 KB)
    03 - Cell Reference
    • 001 Cell Reference - A.mp4 (46.8 MB)
    • 002 Cell Reference - B.mp4 (38.7 MB)
    • 003 Lab Assignment.mp4 (11.1 MB)
    • 003 cell-ref-content.pdf (136.5 KB)
    • 003 cell-reference.xlsx (15.7 KB)
    • 003 cell-reference02.xlsx (14.1 KB)
    04 - Formula Bar
    • 001 Formula Bar - 1.mp4 (39.8 MB)
    • 002 Formula Bar - 2.mp4 (38.9 MB)
    • 003 Formula Bar - 3.mp4 (29.3 MB)
    • 004 Formula Bar - 4.mp4 (49.1 MB)
    05 - Excel Ribbon and Tabs
    • 001 Introduction.mp4 (18.6 MB)
    • 002 Home Tab - A.mp4 (49.9 MB)
    • 003 Home Tab - B.mp4 (24.1 MB)
    • 004 Home Tab - C.mp4 (34.2 MB)
    • 005 Home Tab - D.mp4 (81.5 MB)
    • 006 Home Tab - E.mp4 (36.7 MB)
    • 007 Home Tab - F.mp4 (41.8 MB)
    • 008 Home Tab - G.mp4 (31.9 MB)
    • 009 Home Tab -H.mp4 (60.3 MB)
    • 010 Home tab - Lab Assignment - conditional formatting.mp4 (2.9 MB)
    • 010 cond-format01.xlsx (10.4 KB)
    • 010 home-content.pdf (62.6 KB)
    • 011 Insert Tab - Other Features.mp4 (35.5 MB)
    • 012 Insert Tab - Table.mp4 (67.0 MB)
    • 013 Page Layout - A.mp4 (82.7 MB)
    • 014 Page Layout - B.mp4 (106.8 MB)
    • 015 Data Tab - A.mp4 (83.3 MB)
    • 016 Data Tab - B -Scenario Manager.mp4 (46.0 MB)
    • 017 Data Tab - B - Scenario Lab Assignment.mp4 (3.3 MB)
    • 017 scenario.xlsx (9.4 KB)
    • 018 Data Tab - C - Consolidate.mp4 (39.8 MB)
    • 018 consolidate01.xlsx (21.4 KB)
    • 019 Data Tab - D - Data Validation -1.mp4 (32.3 MB)
    • 020 Data Tab - E - Data Validation - 2.mp4 (33.4 MB)
    • 020 data-validation.xlsx (10.9 KB)
    • 021 Data Tab - F - Subtotal and Group.mp4 (39.3 MB)
    • 022 Data Tab - Subtotal and Group - Lab Assignment.mp4 (6.4 MB)
    • 022 group-and-subtotal.xlsx (10.1 KB)
    • 023 Review Tab - A.mp4 (53.2 MB)
    • 024 View Tab - A.mp4 (65.9 MB)
    • 025 View Tab - B.mp4 (62.9 MB)
    • 026 File Menu.mp4 (25.8 MB)
    06 - Excel Functions
    • 001 Functions and Their Category.mp4 (46.2 MB)
    • 002 Mathematical functions - Group A.mp4 (20.6 MB)
    • 003 Mathematical functions - Group B.mp4 (27.2 MB)
    • 004 Mathematical functions - Group C.mp4 (54.9 MB)
    • 005 Mathematical functions - Group D.mp4 (43.9 MB)
    • 006 Mathematical function - Lab Assignment - 1.mp4 (3.8 MB)
    • 006 sum-function.xlsx (11.1 KB)
    • 007 Mathematical function - Lab Assignment - 2.mp4 (4.5 MB)
    • 007 sumif-function.xlsx (10.6 KB)
    • 008 Mathematical function - Lab Assignment -3.mp4 (7.6 MB)
    • 008 product-functions.xlsx (11.3 KB)
    • 009 Statistical Functions - Group A.mp4 (64.3 MB)
    • 010 Statistical Functions - Group B.mp4 (55.4 MB)
    • 011 Statistical Functions - Group C.mp4 (36.5 MB)
    • 012 Statistical - Lab Assignment - 1.mp4 (9.0 MB)
    • 012 count-functions.xlsx (11.7 KB)
    • 013 Statistical - Lab Assignment - 2.mp4 (9.6 MB)
    • 013 average-function01.xlsx (13.6 KB)
    • 014 Logical Functions - Group A.mp4 (49.2 MB)
    • 015 Logical - Lab Assignment.mp4 (12.7 MB)
    • 015 logical01.xlsx (16.0 KB)
    • 016 Date and Time Functions - Group A.mp4 (41.7 MB)
    • 017 Financial Functions - Group A.mp4 (56.2 MB)
    • 018 Financial - Lab Assignment.mp4 (10.7 MB)
    • 018 pmt-functions01.xlsx (9.4 KB)
    07 - Excel Charts
    • 001 Excel Chart - Setup - A.mp4 (45.2 MB)
    • 002 Excel Chart - Setup - B.mp4 (66.2 MB)
    • 003 Excel Chart - 1.mp4 (71.2 MB)
    • 004 Chart01.xlsx (11.8 KB)
    • 004 Excel Chart - 2.mp4 (21.0 MB)
    • 004 chart04.xlsx (9.8 KB)
    08 - Pivot Table
    • 001 Pivot Table - 1.mp4 (46.8 MB)
    • 002 Pivot Table - 2.mp4 (43.5 MB)
    • 003 Pivot Chart - Introduction.mp4 (27.2 MB)
    • 004 Pivot Chart - A.mp4 (48.5 MB)
    • 005 Pivot Chart - B.mp4 (30.7 MB)
    • 006 Pivot Chart - C.mp4 (38.9 MB)
    • 007 Lab Assignment.mp4 (13.5 MB)
    • 007 pivot-table.xlsx (93.7 KB)
    09 - Excel Macro
    • 001 Macro - 1.mp4 (54.2 MB)
    • 002 Macro - 2.mp4 (38.5 MB)
    • 003 Macro - Lab Assign.mp4 (7.1 MB)
    • 003 macro01.xlsx (11.0 KB)
    • 003 macro06.xlsx (13.2 KB)
    10 - Excel Lookup - Advanced Functions
    • 001 Excel HLookup function - uses with example.mp4 (25.6 MB)
    • 002 Excel VLookup function - uses with example.mp4 (36.6 MB)
    • 003 Excel Index and Match - uses with example.mp4 (19.3 MB)
    11 - Excel Keyboard Shortcuts
    • 001 Keyboard Shortcuts - Introduction.mp4 (8.8 MB)
    • 002 Keyboard Shortcuts -for Navigation.mp4 (38.8 MB)
    • 003 Keyboard Shortcuts -for Row, Column and Cells.mp4 (57.8 MB)
    • 004 Keyboard Shortcuts -for File and Clipboard operations.mp4 (41.0 MB)
    • 005 Keyboard Shortcuts -for Table and Formula.mp4 (50.4 MB)
    • Bonus Resources.txt (0.4 KB)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce