|  

Excel Formulas: Data Transformation and Analysis Done Right
Size :1.4 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :1EB980DBA00D012AF6CAA5700795BB167DAFB48B

Torrent File Contents

Excel Formulas: Data Transformation and Analysis Done Right
  [TutsNode.net] - 2. Data Transformation using Text Functions/5. SEARCH.mp4
  -  135.31 MB

  TutsNode.net.txt
  -  63 Bytes

  [TGx]Downloaded from torrentgalaxy.buzz .txt
  -  585 Bytes

  [TutsNode.net] - 2. Data Transformation using Text Functions/1. Text Functions - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 2. Data Transformation using Text Functions/9. Text Functions - Assignment.html
  -  213 Bytes

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/1. Logical Functions and Conditional Aggregates.html
  -  213 Bytes

  [TutsNode.net] - 4. Date Functions/1. Date Functions - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 5. Look Up Functions/1. Look Up Functions - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 6. What-If Analysis/1. What If Analysis - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 7. Pivot Tables and Charts/1. Pivot Tables and Charts - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 8. Dashboards in Excel/1. Dashboards - An Overview.html
  -  213 Bytes

  [TutsNode.net] - 8. Dashboards in Excel/8. Create a Dashboard.html
  -  213 Bytes

  .pad/0
  -  188.57 KB

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/6. SUMIFS.mp4
  -  70.41 MB

  .pad/1
  -  93.06 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/7. Simple Text Functions.mp4
  -  67.37 MB

  .pad/2
  -  133.49 KB

  [TutsNode.net] - 5. Look Up Functions/3. VLOOKUP Rules.mp4
  -  67.24 MB

  .pad/3
  -  264.22 KB

  [TutsNode.net] - 7. Pivot Tables and Charts/2. Plan your Pivots.mp4
  -  67.05 MB

  .pad/4
  -  464.79 KB

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/3. ANDOR.mp4
  -  64.49 MB

  .pad/5
  -  12.13 KB

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/2. IF Statement.mp4
  -  60.03 MB

  .pad/6
  -  479.49 KB

  [TutsNode.net] - 7. Pivot Tables and Charts/4. Pivot Charts.mp4
  -  58.22 MB

  .pad/7
  -  287.9 KB

  [TutsNode.net] - 5. Look Up Functions/2. VLOOKUP.mp4
  -  56.17 MB

  .pad/8
  -  334.27 KB

  [TutsNode.net] - 5. Look Up Functions/4. INDEX and MATCH.mp4
  -  53.97 MB

  .pad/9
  -  26.78 KB

  [TutsNode.net] - 8. Dashboards in Excel/5. Charts on a Dashboard.mp4
  -  46.79 MB

  .pad/10
  -  214.59 KB

  [TutsNode.net] - 8. Dashboards in Excel/7. In-Cell Horizontal Bars.mp4
  -  46.75 MB

  .pad/11
  -  257.85 KB

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/4. IFERROR.mp4
  -  46.57 MB

  .pad/12
  -  436.17 KB

  [TutsNode.net] - 8. Dashboards in Excel/4. Values from Pivots.mp4
  -  45.19 MB

  .pad/13
  -  313.89 KB

  [TutsNode.net] - 3. Logical Functions and Conditional Aggregates/5. SUMIF.mp4
  -  42.97 MB

  .pad/14
  -  32.34 KB

  [TutsNode.net] - 5. Look Up Functions/5. XLOOKUP.mp4
  -  42.43 MB

  .pad/15
  -  68.08 KB

  [TutsNode.net] - 6. What-If Analysis/2. Scenario Manager.mp4
  -  41.48 MB

  .pad/16
  -  24.84 KB

  [TutsNode.net] - 4. Date Functions/5. WORKDAY.mp4
  -  40.36 MB

  .pad/17
  -  143.67 KB

  [TutsNode.net] - 8. Dashboards in Excel/6. Top N.mp4
  -  40.34 MB

  .pad/18
  -  166.89 KB

  [TutsNode.net] - 6. What-If Analysis/4. Data Table.mp4
  -  38.92 MB

  .pad/19
  -  86.31 KB

  [TutsNode.net] - 7. Pivot Tables and Charts/3. Formatting your Pivot Table.mp4
  -  38.68 MB

  .pad/20
  -  329.81 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/2. LEFTRIGHT.mp4
  -  34.1 MB

  .pad/21
  -  409.99 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/4. FIND.mp4
  -  32.46 MB

  .pad/22
  -  45.17 KB

  [TutsNode.net] - 4. Date Functions/3. EDATE and EOMONTH.mp4
  -  32.25 MB

  .pad/23
  -  254.21 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/6. SUBSTITUTE.mp4
  -  30.24 MB

  .pad/24
  -  261.2 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/8. VALUE.mp4
  -  26.26 MB

  .pad/25
  -  244.96 KB

  [TutsNode.net] - 8. Dashboards in Excel/3. Slicers.mp4
  -  26.23 MB

  .pad/26
  -  280.45 KB

  [TutsNode.net] - 8. Dashboards in Excel/2. Introduction to Dashboards.mp4
  -  18.12 MB

  .pad/27
  -  392.05 KB

  [TutsNode.net] - 6. What-If Analysis/3. Goal Seek.mp4
  -  16 MB

  .pad/28
  -  507.69 KB

  [TutsNode.net] - 4. Date Functions/6. NETWORKDAYS.mp4
  -  14.33 MB

  .pad/29
  -  176.54 KB

  [TutsNode.net] - 4. Date Functions/2. DATEVALUE.mp4
  -  13.65 MB

  .pad/30
  -  360.31 KB

  [TutsNode.net] - 2. Data Transformation using Text Functions/3. MID.mp4
  -  13.34 MB

  .pad/31
  -  165.28 KB

  [TutsNode.net] - 4. Date Functions/4. DATEDIF.mp4
  -  13.09 MB

  .pad/32
  -  418.75 KB

  [TutsNode.net] - 1. Course Introduction/1. Course Introduction.mp4
  -  8.7 MB



Torrent Description


Description

If you are a working professional or a fresh graduate, join me in this exciting course on Excel. It will help you upgrade your Excel skills from beginner to advanced with a short learning curve. As of February 2023, I have delivered in-person training to over 2,000 working professionals in skills across office productivity, programming, databases, analytics, and cloud computing, enabling rapid implementation of new skill sets.

Feedback from Professionals of in-person Training

Mitchell El-Haddad, Group Demand Planning Manager, NFPC, Dubai

“I was very impressed with the facilitation, the knowledge of the trainer and his attention to detail in Excel”

Farah Ben Hamouda, Central Bank, UAE, Dubai

“The trainer was very experienced and he was explaining very well and accepted questions”

Course Curriculum

Text Functions
Conditional Statements
Date Functions
Look Up Functions
What-If Analysis
Pivots and Charts
Dashboards

What this course contains

7 Sections with Easy-to-follow instructional videos
7 Exercise Worksheets
5 Assignments

Software Required

You will need Excel 2016 or above to follow all instructions in this course
This course discusses the use of XLOOKUP which requires versions from Excel 2019

Guaranteed Course Outcome

You will build an excellent command over the practical use of Excel functions.
You will be able to combine Excel functions with ease to solve spreadsheet problems.
You will be able to accurately analyze your data using pivots and charts.
You can implement Dashboards like a pro.

Is Excel still relevant in the Year 2023?

Yes, Excel is still one of the most widely used spreadsheet software applications in the world. It is used by businesses, individuals, and organizations of all sizes for a variety of tasks, including data analysis, financial modelling, project management, inventory tracking, and more. A large number of professionals have developed expertise in Excel over the years, making it an invaluable tool for any business or organization.
Who this course is for:

Working Professional with Beginner Skills in Excel

Requirements

Beginner to Intermediate Skills in Excel
Excel Formatting Skills
Working knowledge of Aggregate Functions like SUM, COUNT, AVG etc
Basic understanding of Excel Charts

Last Updated 2/2023