Udemy - Microsoft Excel Quick Replay

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size292.8 MB
  • Uploaded Byfreecoursewb
  • Downloads65
  • Last checkedNov. 27th '21
  • Date uploadedNov. 25th '21
  • Seeders 4
  • Leechers4

Infohash : 14FD55307A2BE2D01917562722794FD6D9778939

Microsoft Excel Quick Replay



https://CourseMega.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 19 lectures (30m) | Size: 288.4 MB
Spend 30 minutes than several hours to learn or repeat most often used Excel functions
What you'll learn:
Filter and sort columns
Block row and column using $
Use conditional formatting
Use if function
Use text functions like left, right, mid
Creating a basic pivot table, pivot table chart
Creating a basic table (automatically and manually)
Vlookup function
Countif function
Countifs function
Nesting functions - how to connect a several functions in one cell
How to create a basic Macro
Counta function
Iferror function - using with vlookup function

Requirements
You have to have basic knowledge about Microsoft Excel
My course was prepared on Microsoft Excel 2013

Description
If you want to spend only 30 minutes than several hours to learn or repeat most often used Excel functions, you are in the right place!

In this course I will explain :

Files:

[ CourseMega.com ] Udemy - Microsoft Excel Quick Replay
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Filter and sort
    • 1. Filter and sort text, amount, date.mp4 (14.5 MB)
    • 1. Filter and sort text, amount, date.srt (1.4 KB)
    • 1.1 Filter and sort.xlsx (10.5 KB)
    10. Countifs
    • 1. Countifs.mp4 (4.5 MB)
    • 1. Countifs.srt (1.5 KB)
    • 1.1 Countifs.xlsx (10.4 KB)
    11. Nesting functions
    • 1. Nesting functions.mp4 (25.1 MB)
    • 1. Nesting functions.srt (1.3 KB)
    • 1.1 Nesting functions.xlsx (11.7 KB)
    12. Macro
    • 1. Macro.mp4 (23.9 MB)
    • 1. Macro.srt (1.7 KB)
    • 1.1 Macro.xlsx (11.0 KB)
    13. Counta function
    • 1. Counta.mp4 (10.7 MB)
    • 1. Counta.srt (0.9 KB)
    • 1.1 Counta.xlsx (10.4 KB)
    14. Iferror function
    • 1. Iferror.mp4 (15.7 MB)
    • 1. Iferror.srt (1.1 KB)
    • 1.1 Iferror.xlsx (10.6 KB)
    2. Row and column blocking using $
    • 1. Multiplication table.mp4 (2.8 MB)
    • 1. Multiplication table.srt (1.2 KB)
    • 1.1 Row and column blocking.xlsx (10.0 KB)
    • 2. Change currency.mp4 (35.2 MB)
    • 2. Change currency.srt (2.5 KB)
    • 2.1 Change currency.xlsx (10.8 KB)
    3. Conditional formatting
    • 1. Conditional formatting amounts.mp4 (8.3 MB)
    • 1. Conditional formatting amounts.srt (1.2 KB)
    • 1.1 Conditional formatting.xlsx (9.6 KB)
    • 2. Conditional formatting colors.mp4 (14.5 MB)
    • 2. Conditional formatting colors.srt (1.6 KB)
    • 2.1 Conditional formatting - color.xlsx (10.4 KB)
    4. If function
    • 1. If - commission checking.mp4 (16.4 MB)
    • 1. If - commission checking.srt (1.6 KB)
    • 1.1 If.xlsx (10.3 KB)
    • 2. If - invoices.mp4 (9.5 MB)
    • 2. If - invoices.srt (0.7 KB)
    • 2.1 If invoices.xlsx (10.4 KB)
    5. Text functions
    • 1. Left, right.mp4 (10.1 MB)
    • 1. Left, right.srt (1.5 KB)
    • 1.1 Left, right.xlsx (9.7 KB)
    • 2. MID.mp4 (10.5 MB)
    • 2. MID.srt (1.7 KB)
    • 2.1 Part of text.xlsx (9.7 KB)
    6. Pivot table
    • 1. Pivot table.mp4 (14.1 MB)
    • 1. Pivot table.srt (1.7 KB)
    • 1.1 Pivot table.xlsx (10.9 KB)
    • 2. Pivot table - chart.mp4 (9.9 MB)
    • 2. Pivot table - chart.srt (0.8 KB)
    • 2.1 Pivot table - chart.xlsx (10.9 KB)
    7. Creating a basic chart
    • 1. Creating a chart.mp4 (12.0 MB)
    • 1. Creating a chart.srt (1.4 KB)
    • 1.1 Creating a chart.xlsx (9.8 KB)
    8. Vlookup function
    • 1. Vlookup.mp4 (43.1 MB)
    • 1. Vlookup.srt (3.3 KB)
    • 1.1 Vlookup.xlsx (11.4 KB)
    9. Countif function
    • 1. Countif.mp4 (11.9 MB)
    • 1. Countif.srt (1.2 KB)
    • 1.1 Countif.xlsx (10.4 KB)
    • Bonus Resources.txt (0.3 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