17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Excel Formulas Data Transformation And Analysis Done Right
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
188.6 KB
.pad/1
93.1 KB
.pad/10
214.6 KB
.pad/11
257.9 KB
.pad/12
436.2 KB
.pad/13
313.9 KB
.pad/14
32.3 KB
.pad/15
68.1 KB
.pad/16
24.8 KB
.pad/17
143.7 KB
.pad/18
166.9 KB
.pad/19
86.3 KB
.pad/2
133.5 KB
.pad/20
329.8 KB
.pad/21
410 KB
.pad/22
45.2 KB
.pad/23
254.2 KB
.pad/24
261.2 KB
.pad/25
245 KB
.pad/26
280.4 KB
.pad/27
392 KB
.pad/28
507.7 KB
.pad/29
176.5 KB
.pad/3
264.2 KB
.pad/30
360.3 KB
.pad/31
165.3 KB
.pad/32
418.8 KB
.pad/4
464.8 KB
.pad/5
12.1 KB
.pad/6
479.5 KB
.pad/7
287.9 KB
.pad/8
334.3 KB
.pad/9
26.8 KB
TutsNode.net.txt
63 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/1. Course Introduction/1. Course Introduction.mp4
8.7 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/1. Text Functions - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/2. LEFTRIGHT.mp4
34.1 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/3. MID.mp4
13.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/4. FIND.mp4
32.5 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/5. SEARCH.mp4
135.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/6. SUBSTITUTE.mp4
30.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/7. Simple Text Functions.mp4
67.4 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/8. VALUE.mp4
26.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/2. Data Transformation using Text Functions/9. Text Functions - Assignment.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/1. Logical Functions and Conditional Aggregates.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/2. IF Statement.mp4
60 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/3. ANDOR.mp4
64.5 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/4. IFERROR.mp4
46.6 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/5. SUMIF.mp4
43 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/3. Logical Functions and Conditional Aggregates/6. SUMIFS.mp4
70.4 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/1. Date Functions - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/2. DATEVALUE.mp4
13.6 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/3. EDATE and EOMONTH.mp4
32.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/4. DATEDIF.mp4
13.1 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/5. WORKDAY.mp4
40.4 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/4. Date Functions/6. NETWORKDAYS.mp4
14.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/5. Look Up Functions/1. Look Up Functions - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/5. Look Up Functions/2. VLOOKUP.mp4
56.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/5. Look Up Functions/3. VLOOKUP Rules.mp4
67.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/5. Look Up Functions/4. INDEX and MATCH.mp4
54 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/5. Look Up Functions/5. XLOOKUP.mp4
42.4 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/6. What-If Analysis/1. What If Analysis - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/6. What-If Analysis/2. Scenario Manager.mp4
41.5 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/6. What-If Analysis/3. Goal Seek.mp4
16 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/6. What-If Analysis/4. Data Table.mp4
38.9 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/7. Pivot Tables and Charts/1. Pivot Tables and Charts - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/7. Pivot Tables and Charts/2. Plan your Pivots.mp4
67 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/7. Pivot Tables and Charts/3. Formatting your Pivot Table.mp4
38.7 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/7. Pivot Tables and Charts/4. Pivot Charts.mp4
58.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/1. Dashboards - An Overview.html
213 B
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/2. Introduction to Dashboards.mp4
18.1 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/3. Slicers.mp4
26.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/4. Values from Pivots.mp4
45.2 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/5. Charts on a Dashboard.mp4
46.8 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/6. Top N.mp4
40.3 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/7. In-Cell Horizontal Bars.mp4
46.7 MB
[TutsNode.net] - Excel Formulas Data Transformation and Analysis Done Right/8. Dashboards in Excel/8. Create a Dashboard.html
