Coursezone net Learn Excel 2016 Intermediate Level Beyond the Basics

Coursezone net Learn Excel 2016 Intermediate Level Beyond the Basics

Name	[Coursezone.net] Learn Excel 2016 Intermediate Level - Beyond the Basics	DOWNLOAD Copy Link
Total Size	1.8 GB
Total Files	47
Hash	1E8DB9606672160547DBA8077DBDB3C3D0E243A9

/01 Excel Intermediate Introduction/
001 Course Introduction.mp4	20.0 MB
002 Essential Information for a Successful Training Experience.html	3.4 KB
003 Course Exercise Files.html	1.6 KB
004 Course Support Files.html	1.6 KB
005 Reviewing Excel Terminology.mp4	45.3 MB
006 Tips and Tricks in the Ribbon.mp4	23.9 MB
007 Escaping the Mouse Trap.mp4	45.4 MB
008 Common Hotkeys.mp4	38.6 MB
009 Special Hotkey Commands.mp4	38.4 MB
010 Defining Your Excel View.mp4	46.6 MB
/attached files/
003 Excel-E6-Intermediate-Exercise-Files.zip	1.7 MB
004 Excel-E6-Intermediate-Support-Files.zip	2.4 MB
/02 Indexing and Lookups/
011 Defining Lookups and Arrays.mp4	22.4 MB
012 Using VLOOKUP and HLOOKUP.mp4	43.9 MB
013 Using MATCH.mp4	36.1 MB
014 Using INDEX.mp4	31.4 MB
015 Mixing LOOKUPS INDEX and MATCH.mp4	59.3 MB
/03 Named Ranges/
016 What is Important to You.mp4	22.0 MB
017 Simple and Quick Name Definitions.mp4	31.4 MB
018 Accessing and Using the Name Manager.mp4	24.1 MB
019 What can Names do.mp4	65.7 MB
/04 Dynamic Formula/
020 What is a Reference.mp4	18.3 MB
021 Using Indirect.mp4	57.5 MB
022 Using Offset.mp4	39.1 MB
023 Using Row Column and Cell.mp4	35.6 MB
024 Creating Dynamic Named Ranges.mp4	66.1 MB
025 Best Practices Regarding Dynamic Functions.mp4	55.2 MB
026 Colon Operator.mp4	17.9 MB
/05 Charts and Graphs/
027 Charts and Graphs Terminology.mp4	68.8 MB
028 Line Scatter and Bar Charts.mp4	76.7 MB
029 Radar and Surface Plots.mp4	19.7 MB
030 Waterfall Pie and Sunburst Charts.mp4	45.6 MB
031 The Box and Whisper Plot and Histograms (Statistical).mp4	40.8 MB
032 Chart Formatting In Detail.mp4	36.5 MB
033 Mixing Chart Types.mp4	21.1 MB
034 The Bing Maps App.mp4	38.6 MB
/06 Working with Data/
035 How Do You Know If Youre Working With Data.mp4	79.3 MB
036 Introducing Data Tables.mp4	91.6 MB
037 Excel Data Model Relationships.mp4	51.9 MB
038 Data Slicers.mp4	40.4 MB
039 Pivot Tables.mp4	79.5 MB
040 Power Query Get And Transform.mp4	79.0 MB
041 Pivot Charts.mp4	38.8 MB
042 The GETPIVOTDATA Function.mp4	50.7 MB
043 Course Conclusion.mp4	28.9 MB
044 Bonus Lecture - Next Steps.html	11.8 KB
/
Visit CourseZone.net.url	0.1 KB
Total files 47