Udemy - Microsoft Excel Essentials: Level 2 - Intermediate/Advanced [Course Drive]

seeders: 1 leechers: 2
Added 6 years ago by coursedrive in Other
Downloaded 9 times.
1337x.to
Udemy - Microsoft Excel Essentials: Level 2 - Intermediate/Advanced [Course Drive]

Torrent Contents Size: 1.92 GB

Udemy - Microsoft Excel Essentials: Level 2 - Intermediate/Advanced [Course Drive]
Course Downloaded from coursedrive.org.txt
TXT
538 B
Microsoft Excel Essentials Level 2 - IntermediateAdvanced
01 Welcome To The Course
001 Welcome And Thank You For Choosing This Course.mp4
MP4
14.89 MB
Must Read.txt
TXT
540 B
Visit Coursedrive.org.url
URL
124 B
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates
002 Proof Of Concept.mp4
MP4
19.2 MB
003 Planning Ahead.mp4
MP4
7.94 MB
004 Creating Our Data Entry Screen.mp4
MP4
12.95 MB
005 Custom Formatting Dates And Times.mp4
MP4
14.44 MB
006 Simple Calculations With Time.mp4
MP4
6.09 MB
007 More Useful Calculations With Time.mp4
MP4
27.89 MB
008 Its About Time And Dates.mp4
MP4
19.09 MB
009 Adding With Time.mp4
MP4
12.07 MB
010 Creating A Template From An Image.mp4
MP4
41.27 MB
011 Importing A Template From An Existing Excel File.mp4
MP4
15.83 MB
012 Converting Time To A Decimal.mp4
MP4
27.82 MB
013 A Little Bit Of Simple Data Entry.mp4
MP4
15.95 MB
014 Simple Conditional Formatting For A Cleaner View.mp4
MP4
25.17 MB
015 Calculating Time Out Of House Using Travel Time.mp4
MP4
29.38 MB
016 Simple Logical Testing And Nested Logical Testing.mp4
MP4
38.97 MB
017 Building Complex Text Strings With A Formula.mp4
MP4
75.86 MB
018 A Tick Box Exercise Of Sorts.mp4
MP4
44 MB
019 Auto-Populating Check Boxes.mp4
MP4
48.48 MB
020 PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4
MP4
9.75 MB
021 Defining A Working Area And Protecting Your Work.mp4
MP4
23.85 MB
022 PRACTICE EXERCISE 2 - Set Up A Working Area And Limit User Entry.mp4
MP4
5.34 MB
attached_files
002 Proof Of Concept
Time-Sheet-Expenses-Master.xlsx
XLSX
152.75 KB
008 Its About Time And Dates
It-s-About-Time.xlsx
XLSX
10.35 KB
010 Creating A Template From An Image
Time-Sheet-Blank.jpg
JPG
122.7 KB
011 Importing A Template From An Existing Excel File
Expenses-Form.xlsx
XLSX
20.66 KB
03 Project 2 - Building A Database With Excel
023 Simple VLOOKUPs.mp4
MP4
11.59 MB
024 Step1 Get Some Data In And Split It.mp4
MP4
33.97 MB
025 Using Data Validation To Get The Right Input.mp4
MP4
17.86 MB
026 Lets Build Our Database.mp4
MP4
28.28 MB
027 Importing Data From A Text File.mp4
MP4
12.78 MB
028 Importing Data From A Word File.mp4
MP4
19.55 MB
029 Pulling Data From Multiple Sources.mp4
MP4
11.22 MB
030 Using OTHER Look-Ups To Look Up.mp4
MP4
28.34 MB
031 LOOKUP From A LOOKUP With No Intermediary Step.mp4
MP4
10.02 MB
032 Data Arrays Dont Have To Start At A1.mp4
MP4
18.95 MB
033 Some Common Reasons VLook-Ups Fail.mp4
MP4
18.25 MB
034 One Inherent Flaw In Vlook-Up.mp4
MP4
7.53 MB
035 POWER USER - A Breakdown Of Looking Up Backwards.mp4
MP4
17.37 MB
036 POWER USER - The Other Way Of Looking Up Backwards.mp4
MP4
19.7 MB
037 Backwards Look-Ups In Action.mp4
MP4
22.53 MB
038 POWER USER - Dealing With Inconsistencies In User Entry.mp4
MP4
58.14 MB
039 POWER USER - Fuzzy VLOOKUPs.mp4
MP4
21.76 MB
040 POWER USER - VLOOKUPs With Multiple Inputs.mp4
MP4
53.61 MB
041 POWER USER - Looking Up From Multiple Inputs Using An Array Formula.mp4
MP4
27.16 MB
042 VLOOKUPs Brother...HLOOKUP.mp4
MP4
18.67 MB
043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp.mp4
MP4
62.17 MB
044 What To Look For When THAT Formula Didnt Work.mp4
MP4
19.16 MB
045 The Fastest Way To Modify Your Column Numbers.mp4
MP4
27.16 MB
046 POWER USER - Vlook-Ups With Moving Columns.mp4
MP4
7.51 MB
047 Putting It All Together.mp4
MP4
47.54 MB
048 The Finishing Touch How Many Records Did I Find.mp4
MP4
24.29 MB
attached_files
023 Simple VLOOKUPs
Simple-VLOOKUPS.xlsx
XLSX
9.26 KB
024 Step1 Get Some Data In And Split It
HR-Database-Master.xlsx
XLSX
61.36 KB
HR-File.xlsx
XLSX
24.29 KB
027 Importing Data From A Text File
Department-Structure.txt
TXT
7.79 KB
028 Importing Data From A Word File
Addresses.docx
DOCX
14.44 KB
037 Backwards Look-Ups In Action
Looking-Up-Backwards.xlsx
XLSX
10.42 KB
039 POWER USER - Fuzzy VLOOKUPs
Fuzzy-VLook-Ups.xlsx
XLSX
10.53 KB
040 POWER USER - VLOOKUPs With Multiple Inputs
Lookup-Up-From-Multiple-Inputs.xlsx
XLSX
20.65 KB
043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp
Returning-Multiple-Results.xlsx
XLSX
14.04 KB
046 POWER USER - Vlook-Ups With Moving Columns
VLOOKUPS-With-Moving-Columns.xlsx
XLSX
9.39 KB
04 Section 3 Named Ranges
049 A Simple Static Named Range Using A Single Cell.mp4
MP4
12.08 MB
050 Creating A Named Range Using A Range Of Cells.mp4
MP4
9.52 MB
051 Using Row Labels To Name Multiple Ranges.mp4
MP4
10.8 MB
052 POWER USER - A Magic Trick Using Row And Column Labels.mp4
MP4
17.32 MB
053 POWER USER - Dynamic Named Ranges.mp4
MP4
26.54 MB
054 POWER USER - What To Do With Dynamic Names Ranges With Titles.mp4
MP4
14.19 MB
055 3035 - POWER USER - Dynamic Charts.mp4
MP4
48.6 MB
056 3040 - Horizontal Dynamic Named Ranges For Charts.mp4
MP4
42.61 MB
ReadMe.txt
TXT
538 B
Visit Coursedrive.org.url
URL
124 B
attached_files
049 A Simple Static Named Range Using A Single Cell
Static-Named-Ranges.xlsx
XLSX
12.81 KB
053 POWER USER - Dynamic Named Ranges
Dynamic-Named-Ranges.xlsx
XLSX
11.03 KB
055 3035 - POWER USER - Dynamic Charts
Dynamic-Charts.xlsx
XLSX
18.21 KB
056 3040 - Horizontal Dynamic Named Ranges For Charts
Horizontal-Dynamic-Named-Ranges.xlsx
XLSX
19.37 KB
05 Project 4 - What Can I Have For Dinner
057 Welcome to What Can I Have For Dinner or...What Would I Use THAT for.mp4
MP4
2.89 MB
058 Hyperlinking To A Different Sheet In The Same Workbook.mp4
MP4
11.93 MB
059 Creating Our First Macro.mp4
MP4
19.86 MB
060 Assigning A Macro To A Button.mp4
MP4
13.96 MB
061 Creating A List For Our Dropdown Using A Dynamic Named Range.mp4
MP4
7.47 MB
062 Using A Conditional Format To Know When A Value Is Missing.mp4
MP4
15.4 MB
063 Copying Conditional Formats And Creating Our Drop Downs.mp4
MP4
10.16 MB
064 Building Our Formula...INDIRECT Function.mp4
MP4
8.98 MB
065 Building Strings For Indirect Sheet And Cell References.mp4
MP4
27.95 MB
066 Its A One Or A Zero.mp4
MP4
8.84 MB
067 Working The Percentages And Adding Traffic Lights.mp4
MP4
13.99 MB
068 POWER USER - The HYPERLINK Function And Problem.mp4
MP4
18.69 MB
069 Exercise 1 - Fill In The Blanks.mp4
MP4
3.44 MB
070 Exercise 2 - Pretty It Up With A Macro.mp4
MP4
6.41 MB
071 Exercise 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp4
MP4
7.25 MB
attached_files
058 Hyperlinking To A Different Sheet In The Same Workbook
What-To-Have-For-Dinner.xlsx
XLSX
41.59 KB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans
072 Creating A Gantt Chart Using A Worksheet.mp4
MP4
33.12 MB
073 Building The First Part Of Our Logical Test.mp4
MP4
25.58 MB
074 Multiple Logical Tests At Once Using AND.mp4
MP4
63.04 MB
075 Conditional Formatting...Where The Magic Happens.mp4
MP4
39.18 MB
076 Gantt Charts Using The Built In Charting Tools.mp4
MP4
35.74 MB
attached_files
072 Creating A Gantt Chart Using A Worksheet
Gantt-Charts.xlsx
XLSX
31.31 KB
07 Bonus Section - Just For Fun
077 How I Created Randomly Generated License Plate Numbers.mp4
MP4
30.82 MB
ReadMe.txt
TXT
538 B
Visit Coursedrive.org.url
URL
124 B
08 Student Questions Answered
078 Calls Text Data - Or How To Return a Column Title If Value is 1.mp4
MP4
15.3 MB
079 Calls Text Data 2 - This Time Using Text.mp4
MP4
34.27 MB
080 Extracting Phone Numbers From A Cell.mp4
MP4
8.29 MB
081 What Is The CHOOSE Function Really Used For.mp4
MP4
40.53 MB
082 Casing And Text Functions.mp4
MP4
14.37 MB
083 Dynamic Charting From A Drop Down.mp4
MP4
37.34 MB
084 Extracting a Unique List And Summing The Money.mp4
MP4
13.42 MB
085 SUMIF With Dynamic Sum Range.mp4
MP4
16.63 MB
086 Vlookups With Pictures.mp4
MP4
20.29 MB
attached_files
078 Calls Text Data - Or How To Return a Column Title If Value is 1
1.0-Calls-Text-Data.xlsx
XLSX
11.34 KB
080 Extracting Phone Numbers From A Cell
3.0-Extracting-Phone-Numbers-From-A-Cell.xlsx
XLSX
8.86 KB
081 What Is The CHOOSE Function Really Used For
CHOOSE-Function.xlsx
XLSX
16.64 KB
082 Casing And Text Functions
Casing.xlsx
XLSX
9.62 KB
083 Dynamic Charting From A Drop Down
5-Dynamic-Tables.xlsx
XLSX
16.57 KB
085 SUMIF With Dynamic Sum Range
SUMIF-With-Dynamic-Sum-Range-Column-Completed.xlsx
XLSX
12.1 KB
SUMIF-With-Dynamic-Sum-Range-Column-Data-Set.xlsx
XLSX
11.57 KB
086 Vlookups With Pictures
VLookUps-With-Pictures-After.xlsx
XLSX
410.4 KB
VLookUps-With-Pictures-Before.xlsx
XLSX
205.81 KB
09 Thank You - Your Special Bonus
087 Get Your Next Course Now.pdf
PDF
301.53 KB
ReadMe.txt
TXT
538 B
Visit Coursedrive.org.url
URL
124 B
attached_files
087 Get Your Next Course Now
Level-2-Get-Your-Next-Course.pdf
PDF
301.53 KB
ReadMe.txt
TXT
538 B
Visit Coursedrive.org.url
URL
124 B
Visit Coursedrive.org.url
URL
124 B

Description

Related Torrents

Location

Trackers

Tracker name
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://9.rarbg.to:2730/announce
udp://9.rarbg.to:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.cyberia.is:6969/announce
udp://retracker.lanta-net.ru:2710/announce
udp://9.rarbg.to:2770/announce
udp://9.rarbg.me:2730/announce
udp://eddie4.nl:6969/announce
udp://tracker.mg64.net:6969/announce
udp://open.demonii.si:1337/announce
udp://tracker.zer0day.to:1337/announce
udp://tracker.tiny-vps.com:6969/announce
udp://ipv6.tracker.harry.lu:80/announce
udp://9.rarbg.me:2740/announce
udp://9.rarbg.me:2770/announce
udp://denis.stalker.upeer.me:6969/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.moeking.me:6969/announce
udp://exodus.desync.com:6969/announce
udp://9.rarbg.to:2740/announce
udp://9.rarbg.to:2720/announce
udp://tracker.justseed.it:1337/announce
udp://tracker.torrent.eu.org:451/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.open-internet.nl:6969/announce
udp://torrentclub.tech:6969/announce
udp://open.stealth.si:80/announce
http://tracker.tfile.co:80/announce
Torrent hash: