Microsoft Excel Essentials Level Intermediate Advanced | 9AFD890537E9445A34F300D8154C3219B9C02D87

Microsoft Excel Essentials Level Intermediate Advanced

Name	Microsoft Excel Essentials Level 2 - Intermediate Advanced	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	2.1 GB
Total Files	129
Hash	9AFD890537E9445A34F300D8154C3219B9C02D87

/.../02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/
017 Building Complex Text Strings With A Formula.mp4	79.5 MB
002 Proof Of Concept.mp4	20.1 MB
003 Planning Ahead.mp4	8.3 MB
004 Creating Our Data Entry Screen.mp4	13.6 MB
005 Custom Formatting Dates And Times.mp4	15.1 MB
006 Simple Calculations With Time.mp4	6.4 MB
007 More Useful Calculations With Time.mp4	29.2 MB
008 Its About Time And Dates.mp4	20.0 MB
009 Adding With Time.mp4	12.7 MB
010 Creating A Template From An Image.mp4	43.3 MB
011 Importing A Template From An Existing Excel File.mp4	16.6 MB
012 Converting Time To A Decimal.mp4	29.2 MB
013 A Little Bit Of Simple Data Entry.mp4	16.7 MB
014 Simple Conditional Formatting For A Cleaner View.mp4	26.4 MB
015 Calculating Time Out Of House Using Travel Time.mp4	30.8 MB
016 Simple Logical Testing And Nested Logical Testing.mp4	40.9 MB
018 A Tick Box Exercise Of Sorts.mp4	46.1 MB
019 Auto-Populating Check Boxes.mp4	50.8 MB
020 PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4	10.2 MB
021 Defining A Working Area And Protecting Your Work.mp4	25.0 MB
022 PRACTICE EXERCISE 2 - Set Up A Working Area And Limit User Entry.mp4	5.6 MB
/
Visit Coursedrive.org.url	0.1 KB
Course Downloaded from coursedrive.org.txt	0.5 KB
/Microsoft Excel Essentials Level 2 - IntermediateAdvanced/
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../01 Welcome To The Course/
001 Welcome And Thank You For Choosing This Course.mp4	15.6 MB
Must Read.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../002 Proof Of Concept/
Time-Sheet-Expenses-Master.xlsx	156.4 KB
/.../008 Its About Time And Dates/
It-s-About-Time.xlsx	10.6 KB
/.../010 Creating A Template From An Image/
Time-Sheet-Blank.jpg	125.6 KB
/.../011 Importing A Template From An Existing Excel File/
Expenses-Form.xlsx	21.2 KB
/.../03 Project 2 - Building A Database With Excel/
023 Simple VLOOKUPs.mp4	12.1 MB
024 Step1 Get Some Data In And Split It.mp4	35.6 MB
025 Using Data Validation To Get The Right Input.mp4	18.7 MB
026 Lets Build Our Database.mp4	29.7 MB
027 Importing Data From A Text File.mp4	13.4 MB
028 Importing Data From A Word File.mp4	20.5 MB
029 Pulling Data From Multiple Sources.mp4	11.8 MB
030 Using OTHER Look-Ups To Look Up.mp4	29.7 MB
031 LOOKUP From A LOOKUP With No Intermediary Step.mp4	10.5 MB
032 Data Arrays Dont Have To Start At A1.mp4	19.9 MB
033 Some Common Reasons VLook-Ups Fail.mp4	19.1 MB
034 One Inherent Flaw In Vlook-Up.mp4	7.9 MB
035 POWER USER - A Breakdown Of Looking Up Backwards.mp4	18.2 MB
036 POWER USER - The Other Way Of Looking Up Backwards.mp4	20.7 MB
037 Backwards Look-Ups In Action.mp4	23.6 MB
038 POWER USER - Dealing With Inconsistencies In User Entry.mp4	61.0 MB
039 POWER USER - Fuzzy VLOOKUPs.mp4	22.8 MB
040 POWER USER - VLOOKUPs With Multiple Inputs.mp4	56.2 MB
041 POWER USER - Looking Up From Multiple Inputs Using An Array Formula.mp4	28.5 MB
042 VLOOKUPs Brother...HLOOKUP.mp4	19.6 MB
043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp.mp4	65.2 MB
044 What To Look For When THAT Formula Didnt Work.mp4	20.1 MB
045 The Fastest Way To Modify Your Column Numbers.mp4	28.5 MB
046 POWER USER - Vlook-Ups With Moving Columns.mp4	7.9 MB
047 Putting It All Together.mp4	49.8 MB
048 The Finishing Touch How Many Records Did I Find.mp4	25.5 MB
/.../023 Simple VLOOKUPs/
Simple-VLOOKUPS.xlsx	9.5 KB
/.../024 Step1 Get Some Data In And Split It/
HR-Database-Master.xlsx	62.8 KB
HR-File.xlsx	24.9 KB
/.../027 Importing Data From A Text File/
Department-Structure.txt	8.0 KB
/.../028 Importing Data From A Word File/
Addresses.docx	14.8 KB
/.../037 Backwards Look-Ups In Action/
Looking-Up-Backwards.xlsx	10.7 KB
/.../039 POWER USER - Fuzzy VLOOKUPs/
Fuzzy-VLook-Ups.xlsx	10.8 KB
/.../040 POWER USER - VLOOKUPs With Multiple Inputs/
Lookup-Up-From-Multiple-Inputs.xlsx	21.1 KB
/.../043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp/
Returning-Multiple-Results.xlsx	14.4 KB
/.../046 POWER USER - Vlook-Ups With Moving Columns/
VLOOKUPS-With-Moving-Columns.xlsx	9.6 KB
/.../04 Section 3 Named Ranges/
049 A Simple Static Named Range Using A Single Cell.mp4	12.7 MB
050 Creating A Named Range Using A Range Of Cells.mp4	10.0 MB
051 Using Row Labels To Name Multiple Ranges.mp4	11.3 MB
052 POWER USER - A Magic Trick Using Row And Column Labels.mp4	18.2 MB
053 POWER USER - Dynamic Named Ranges.mp4	27.8 MB
054 POWER USER - What To Do With Dynamic Names Ranges With Titles.mp4	14.9 MB
055 3035 - POWER USER - Dynamic Charts.mp4	51.0 MB
056 3040 - Horizontal Dynamic Named Ranges For Charts.mp4	44.7 MB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../049 A Simple Static Named Range Using A Single Cell/
Static-Named-Ranges.xlsx	13.1 KB
/.../053 POWER USER - Dynamic Named Ranges/
Dynamic-Named-Ranges.xlsx	11.3 KB
/.../055 3035 - POWER USER - Dynamic Charts/
Dynamic-Charts.xlsx	18.6 KB
/.../056 3040 - Horizontal Dynamic Named Ranges For Charts/
Horizontal-Dynamic-Named-Ranges.xlsx	19.8 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	3.0 MB
058 Hyperlinking To A Different Sheet In The Same Workbook.mp4	12.5 MB
059 Creating Our First Macro.mp4	20.8 MB
060 Assigning A Macro To A Button.mp4	14.6 MB
061 Creating A List For Our Dropdown Using A Dynamic Named Range.mp4	7.8 MB
062 Using A Conditional Format To Know When A Value Is Missing.mp4	16.1 MB
063 Copying Conditional Formats And Creating Our Drop Downs.mp4	10.7 MB
064 Building Our Formula...INDIRECT Function.mp4	9.4 MB
065 Building Strings For Indirect Sheet And Cell References.mp4	29.3 MB
066 Its A One Or A Zero.mp4	9.3 MB
067 Working The Percentages And Adding Traffic Lights.mp4	14.7 MB
068 POWER USER - The HYPERLINK Function And Problem.mp4	19.6 MB
069 Exercise 1 - Fill In The Blanks.mp4	3.6 MB
070 Exercise 2 - Pretty It Up With A Macro.mp4	6.7 MB
071 Exercise 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp4	7.6 MB
/.../058 Hyperlinking To A Different Sheet In The Same Workbook/
What-To-Have-For-Dinner.xlsx	42.6 KB
/.../06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/
072 Creating A Gantt Chart Using A Worksheet.mp4	34.7 MB
073 Building The First Part Of Our Logical Test.mp4	26.8 MB
074 Multiple Logical Tests At Once Using AND.mp4	66.1 MB
075 Conditional Formatting...Where The Magic Happens.mp4	41.1 MB
076 Gantt Charts Using The Built In Charting Tools.mp4	37.5 MB
/.../072 Creating A Gantt Chart Using A Worksheet/
Gantt-Charts.xlsx	32.1 KB
/.../07 Bonus Section - Just For Fun/
077 How I Created Randomly Generated License Plate Numbers.mp4	32.3 MB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../08 Student Questions Answered/
078 Calls Text Data - Or How To Return a Column Title If Value is 1.mp4	16.0 MB
079 Calls Text Data 2 - This Time Using Text.mp4	35.9 MB
080 Extracting Phone Numbers From A Cell.mp4	8.7 MB
081 What Is The CHOOSE Function Really Used For.mp4	42.5 MB
082 Casing And Text Functions.mp4	15.1 MB
083 Dynamic Charting From A Drop Down.mp4	39.2 MB
084 Extracting a Unique List And Summing The Money.mp4	14.1 MB
085 SUMIF With Dynamic Sum Range.mp4	17.4 MB
086 Vlookups With Pictures.mp4	21.3 MB
/.../078 Calls Text Data - Or How To Return a Column Title If Value is 1/
1.0-Calls-Text-Data.xlsx	11.6 KB
/.../080 Extracting Phone Numbers From A Cell/
3.0-Extracting-Phone-Numbers-From-A-Cell.xlsx	9.1 KB
/.../081 What Is The CHOOSE Function Really Used For/
CHOOSE-Function.xlsx	17.0 KB
/.../082 Casing And Text Functions/
Casing.xlsx	9.8 KB
/.../083 Dynamic Charting From A Drop Down/
5-Dynamic-Tables.xlsx	17.0 KB
/.../085 SUMIF With Dynamic Sum Range/
SUMIF-With-Dynamic-Sum-Range-Column-Completed.xlsx	12.4 KB
SUMIF-With-Dynamic-Sum-Range-Column-Data-Set.xlsx	11.9 KB
/.../086 Vlookups With Pictures/
VLookUps-With-Pictures-After.xlsx	420.3 KB
VLookUps-With-Pictures-Before.xlsx	210.7 KB
/.../09 Thank You - Your Special Bonus/
087 Get Your Next Course Now.pdf	308.8 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../087 Get Your Next Course Now/
Level-2-Get-Your-Next-Course.pdf	308.8 KB
Total files 129