|  

Learn Microsoft Excel from A-Z: Beginner To Expert Course
Size :4.8 GB
Peers : Seeders : 0      Leechers : 0
Added : 2 years ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :ABB86E1890E119F2B5A61E10623F986210FD69D2

Torrent File Contents

Learn Microsoft Excel from A-Z: Beginner To Expert Course
  [TutsNode.net] - 21 - Welcome to Excel VBA/113 - Recording a Macro.mp4
  -  89.92 MB

  TutsNode.net.txt
  -  63 Bytes

  [TutsNode.net] - 11 - Working with Excel Datasets/56 - ExcelPracticexlsx
  -  57.95 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/81 - PowerPivotDataTablesxlsx
  -  16.3 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/152 - Personal Branding English.vtt
  -  9.62 KB

  .pad/0
  -  291 Bytes

  [TutsNode.net] - 11 - Working with Excel Datasets/63 - Finding & Removing Duplicate Values.mp4
  -  85.21 MB

  [TutsNode.net] - 21 - Welcome to Excel VBA/111 - VBAPracticexlsx
  -  32.64 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/98 - Extracting Specific Text using LEN & SEARCH English.vtt
  -  13.09 KB

  [TutsNode.net] - 23 - Writing VBA Code/118 - Referencing a Range English.vtt
  -  12.53 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/110 - Solver Tool English.vtt
  -  10.38 KB

  [TutsNode.net] - 27 - Excel User Forms/139 - Adding Controls to UserForms English.vtt
  -  10.23 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/42 - Grab User’s Attention using Illustrations English.vtt
  -  9.48 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/23 - The SUM Function English.vtt
  -  9.35 KB

  [TutsNode.net] - 2 - Getting Started with Excel/7 - Finding & Opening Microsoft Excel English.vtt
  -  1.44 KB

  [TutsNode.net] - 23 - Writing VBA Code/121 - If Then Else Statement English.vtt
  -  9.32 KB

  [TutsNode.net] - 12 - Excel Database Functions/64 - The SUMIF Function English.vtt
  -  9.29 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/148 - Getting Started with Freelancing English.vtt
  -  9.03 KB

  [TutsNode.net] - 23 - Writing VBA Code/123 - Creating User Defined Functions English.vtt
  -  8.92 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/21 - Relative vs Absolute Cell References English.vtt
  -  8.91 KB

  [TutsNode.net] - 2 - Getting Started with Excel/10 - Excel Interface Continued English.vtt
  -  1.67 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/90 - VLOOKUP Function English.vtt
  -  8.87 KB

  [TutsNode.net] - 2 - Getting Started with Excel/11 - Excel Workbook vs Excel Worksheet English.vtt
  -  2.75 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/113 - Recording a Macro English.vtt
  -  8.85 KB

  [TutsNode.net] - 13 - Excel Data Validation/73 - Complex Validation Dependent Drop Down List English.vtt
  -  8.83 KB

  [TutsNode.net] - 25 - Excel VBA Loops/130 - For Next Loop English.vtt
  -  8.58 KB

  [TutsNode.net] - 2 - Getting Started with Excel/13 - Customizing the Excel Quick Access Toolbar English.vtt
  -  2.89 KB

  [TutsNode.net] - 14 - Excel PivotTables/78 - Creating Pivot Charts & Utilizing Slicers English.vtt
  -  8.38 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/151 - How to Get Your First Client English.vtt
  -  8.37 KB

  [TutsNode.net] - 26 - Triggering Macros/134 - Form Controls vs ActiveX Controls English.vtt
  -  8.29 KB

  [TutsNode.net] - 2 - Getting Started with Excel/15 - Excel Shortcut Keys English.vtt
  -  2.26 KB

  [TutsNode.net] - 12 - Excel Database Functions/65 - The DSUM Function English.vtt
  -  8.29 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/16 - Creating Excel Labels English.vtt
  -  2.99 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/83 - How to Create PowerPivot KPI’s English.vtt
  -  8.15 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/63 - Finding & Removing Duplicate Values English.vtt
  -  7.74 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/27 - Moving & Copying Data English.vtt
  -  7.74 KB

  [TutsNode.net] - 27 - Excel User Forms/143 - UserForm ComboBoxes English.vtt
  -  7.62 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/47 - Formatting Elements of a Chart English.vtt
  -  7.55 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/20 - Order of Operations English.vtt
  -  7.55 KB

  [TutsNode.net] - 13 - Excel Data Validation/69 - Creating a Drop Down List with Data Validation English.vtt
  -  7.53 KB

  [TutsNode.net] - 9 - Excels Printing Options/51 - Excels Page Layout View English.vtt
  -  7.46 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/150 - Top Freelance Websites English.vtt
  -  7.44 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/39 - Creating Styles for Formatting Efficiency English.vtt
  -  7.32 KB

  [TutsNode.net] - 23 - Writing VBA Code/122 - Worksheet Functions inside VBA English.vtt
  -  7.24 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/97 - LEFT RIGHT and MID Function English.vtt
  -  7.22 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/41 - The Power of Conditional Formatting English.vtt
  -  7.14 KB

  [TutsNode.net] - 12 - Excel Database Functions/66 - DSUM Function Cont English.vtt
  -  6.95 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/48 - Modifying the Data Type & Location of a Chart English.vtt
  -  6.92 KB

  [TutsNode.net] - 14 - Excel PivotTables/76 - Grouping & Filtering PivotTable Data English.vtt
  -  6.87 KB

  [TutsNode.net] - 26 - Triggering Macros/137 - Fun with VBA Events English.vtt
  -  6.82 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/25 - The AVERAGE Function English.vtt
  -  2.29 KB

  [TutsNode.net] - 12 - Excel Database Functions/67 - The SUBTOTAL Function English.vtt
  -  6.78 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/129 - Debugging & Error Handling Cont English.vtt
  -  6.72 KB

  [TutsNode.net] - 27 - Excel User Forms/142 - Passing Option Buttons to Desired Cells English.vtt
  -  6.71 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/87 - Nesting Multiple IF Functions English.vtt
  -  6.63 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/147 - Creating an Excel Resume English.vtt
  -  6.59 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/62 - Converting Datasets into Tables English.vtt
  -  6.59 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/44 - Create Compelling Graphics with SmartArt English.vtt
  -  6.49 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/31 - Renaming Moving & Deleting Excel Worksheets English.vtt
  -  6.49 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/35 - Formatting Fonts and Cell Background Color English.vtt
  -  6.49 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/18 - Formatting Date Values in Excel English.vtt
  -  6.42 KB

  [TutsNode.net] - 22 - The VBA Language/115 - Modules and Procedures English.vtt
  -  6.38 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/37 - Formatting Data Appropriately English.vtt
  -  6.36 KB

  [TutsNode.net] - 13 - Excel Data Validation/71 - Adding Custom Alerts to Data Validation English.vtt
  -  6.35 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/81 - Creating Relationships between Data Tables English.vtt
  -  6.32 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/128 - Debugging & Error Handling English.vtt
  -  6.2 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/33 - Protecting the Structure of a Workbook English.vtt
  -  2.58 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/92 - HLOOKUP Function English.vtt
  -  6.18 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/34 - Adding a Workbook Password to Open File English.vtt
  -  2.61 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/19 - Building Basic Formulas in Excel English.vtt
  -  6.18 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/153 - Networking Dos and Donts English.vtt
  -  6.17 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/108 - Goal Seek in Excel English.vtt
  -  6.17 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/99 - Combining Text with CONCATENATE English.vtt
  -  6.16 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/61 - Creating Subtotals within a Dataset English.vtt
  -  6.13 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/154 - Importance of Having a Website English.vtt
  -  6.13 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/107 - Excel’s Scenario Manager Tool English.vtt
  -  6.07 KB

  [TutsNode.net] - 14 - Excel PivotTables/75 - Modifying Excel PivotTables English.vtt
  -  6.01 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/28 - Insert & Delete RowsColumns English.vtt
  -  6 KB

  [TutsNode.net] - 25 - Excel VBA Loops/131 - Do Until Loop English.vtt
  -  5.98 KB

  [TutsNode.net] - 14 - Excel PivotTables/74 - Creating an Excel Pivot Table English.vtt
  -  5.93 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/100 - Quick Tips & Other Text Based Functions English.vtt
  -  5.92 KB

  [TutsNode.net] - 27 - Excel User Forms/141 - Passing TextBox Values to Desired Cells English.vtt
  -  5.88 KB

  [TutsNode.net] - 23 - Writing VBA Code/124 - User Defined Functions within VBA Scripts English.vtt
  -  5.81 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/36 - Adding Cell Borders English.vtt
  -  5.8 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/4 - Microsoft Excel Marketplace English.vtt
  -  5.78 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/2 - What is Microsoft Excel English.vtt
  -  5.75 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/26 - COUNT Functions English.vtt
  -  5.75 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/49 - Little Slice of Pie Charts English.vtt
  -  5.74 KB

  [TutsNode.net] - 22 - The VBA Language/116 - Objects Methods and Properties English.vtt
  -  5.73 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/6 - Microsoft Excel Job Types English.vtt
  -  5.55 KB

  [TutsNode.net] - 10 - Benefits of Using Excel Templates/55 - How to Create an Excel Template English.vtt
  -  5.55 KB

  [TutsNode.net] - 13 - Excel Data Validation/70 - Different Types of Excel Data Validation English.vtt
  -  5.55 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/46 - Changing the Chart Design English.vtt
  -  2.31 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/149 - How to Become an Excel Freelancer English.vtt
  -  5.51 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/43 - Customizing Icons English.vtt
  -  5.35 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/125 - Find Last Row of Data English.vtt
  -  5.32 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/104 - 3D Referencing in Formulas English.vtt
  -  5.28 KB

  [TutsNode.net] - 9 - Excels Printing Options/50 - Print Preview Options English.vtt
  -  5.25 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/60 - Applying Filters to Datasets English.vtt
  -  5.22 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/32 - Adding Protection to Specific Cells English.vtt
  -  5.21 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/29 - Adjusting the Width & Height of Cells English.vtt
  -  5.19 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/95 - INDEX and MATCH Combined English.vtt
  -  5.04 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/30 - Hiding and Unhiding Excel Rows and Columns English.vtt
  -  4.96 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/24 - The MIN & MAX Function English.vtt
  -  4.86 KB

  [TutsNode.net] - 9 - Excels Printing Options/52 - Printing a Specific Range of Cells English.vtt
  -  2.9 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/84 - Excel’s IF Function English.vtt
  -  4.83 KB

  [TutsNode.net] - 9 - Excels Printing Options/53 - Converting Spreadsheets to PDF Files English.vtt
  -  2.64 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/94 - MATCH Function English.vtt
  -  4.8 KB

  [TutsNode.net] - 10 - Benefits of Using Excel Templates/54 - Why Create an Excel Template English.vtt
  -  1.66 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/3 - Who This Course is For English.vtt
  -  4.75 KB

  [TutsNode.net] - 23 - Writing VBA Code/119 - InputBox & MsgBox English.vtt
  -  4.75 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/85 - IF Function with AND Criteria English.vtt
  -  4.74 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/93 - INDEX Function English.vtt
  -  4.72 KB

  [TutsNode.net] - 22 - The VBA Language/117 - Excel VBA Variables English.vtt
  -  4.62 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/86 - IF Function with OR Criteria English.vtt
  -  4.57 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/57 - How to Sort Data in Excel English.vtt
  -  2.99 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/1 - Excel from AZ Course Section Overview English.vtt
  -  4.53 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/58 - MultiLevel Sorting English.vtt
  -  2.72 KB

  [TutsNode.net] - 27 - Excel User Forms/146 - UserForms and Protected Sheets English.vtt
  -  4.5 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/59 - Custom Sorting Datasets in Excel English.vtt
  -  2.79 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/127 - With Statement English.vtt
  -  4.48 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/101 - Tracing Precedents & Dependents in Formulas English.vtt
  -  4.46 KB

  [TutsNode.net] - 2 - Getting Started with Excel/8 - Excels Start Screen English.vtt
  -  4.45 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/82 - Using Data Models to Create PivotTables English.vtt
  -  4.42 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/109 - Compare Results with Excel Data Tables English.vtt
  -  4.37 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/96 - TwoWay Lookup with INDEX and MATCH English.vtt
  -  4.23 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/38 - The Magic behind Excels Format Painter English.vtt
  -  4.21 KB

  [TutsNode.net] - 2 - Getting Started with Excel/12 - Saving & Opening Excel Documents English.vtt
  -  4.21 KB

  [TutsNode.net] - 23 - Writing VBA Code/120 - Using Variables in VBA Code English.vtt
  -  4.17 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/56 - How to Prepare Data for Analysis English.vtt
  -  4.17 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/17 - Entering Numeric Values in Excel English.vtt
  -  4.07 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/89 - Key Benefits of Named Ranges English.vtt
  -  3.94 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/88 - The COUNTIF Function English.vtt
  -  3.91 KB

  [TutsNode.net] - 2 - Getting Started with Excel/14 - Customizing the Excel Ribbon English.vtt
  -  3.86 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/79 - What is PowerPivot English.vtt
  -  3.79 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/112 - A Look Inside the Visual Basic Editor VBE English.vtt
  -  3.79 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/40 - Merging Cells for a Cleaner Look English.vtt
  -  3.72 KB

  [TutsNode.net] - 13 - Excel Data Validation/68 - What is Excel Data Validation English.vtt
  -  2.02 KB

  [TutsNode.net] - 26 - Triggering Macros/133 - Assigning Macros to Shapes English.vtt
  -  3.7 KB

  [TutsNode.net] - 2 - Getting Started with Excel/9 - Explaining the Excel Interface English.vtt
  -  3.69 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/91 - The Beauty of Excel’s IFERROR Function English.vtt
  -  3.62 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/5 - Microsoft Excel Job Opportunities English.vtt
  -  3.59 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/22 - Excel Functions Explained English.vtt
  -  3.48 KB

  [TutsNode.net] - 27 - Excel User Forms/144 - Clearing Values from UserForm Controls English.vtt
  -  2.72 KB

  .pad/1
  -  15 Bytes

  [TutsNode.net] - 23 - Writing VBA Code/118 - Referencing a Range.mp4
  -  80.4 MB

  [TutsNode.net] - 25 - Excel VBA Loops/132 - For Each Loop English.vtt
  -  3.43 KB

  [TutsNode.net] - 26 - Triggering Macros/135 - Worksheet Events English.vtt
  -  3.36 KB

  [TutsNode.net] - 27 - Excel User Forms/138 - Creating an Excel UserForm English.vtt
  -  3.31 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/45 - The Commonly used Column Chart English.vtt
  -  3.21 KB

  [TutsNode.net] - 13 - Excel Data Validation/72 - Creating a Dynamic Drop Down List English.vtt
  -  3.03 KB

  [TutsNode.net] - 27 - Excel User Forms/140 - How to Show an UserForm English.vtt
  -  2.99 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/126 - Find Last Column of Data English.vtt
  -  2.96 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/106 - How to Freeze Panes in Excel English.vtt
  -  2.96 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/105 - Utilizing the Watch Window in Excel English.vtt
  -  2.93 KB

  [TutsNode.net] - 14 - Excel PivotTables/77 - Drilling Down into PivotTable Data English.vtt
  -  2.11 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/103 - Grouping Data English.vtt
  -  2.91 KB

  [TutsNode.net] - 26 - Triggering Macros/136 - Workbook Events English.vtt
  -  2.68 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/111 - The Power Behind Excel VBA English.vtt
  -  2.65 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/114 - Saving & Opening a MacroEnabled Workbook English.vtt
  -  2.08 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/102 - Showing Formulas English.vtt
  -  2.06 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/80 - Activating the Excel PowerPivot AddIn English.vtt
  -  1.62 KB

  [TutsNode.net] - 27 - Excel User Forms/145 - How to Close an UserForm English.vtt
  -  1.58 KB

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

  .pad/2
  -  570.05 KB

  [TutsNode.net] - 14 - Excel PivotTables/78 - Creating Pivot Charts & Utilizing Slicers.mp4
  -  70.97 MB

  .pad/3
  -  30.27 KB

  [TutsNode.net] - 27 - Excel User Forms/139 - Adding Controls to UserForms.mp4
  -  69.44 MB

  .pad/4
  -  569.32 KB

  [TutsNode.net] - 23 - Writing VBA Code/121 - If Then Else Statement.mp4
  -  68.89 MB

  .pad/5
  -  109.33 KB

  [TutsNode.net] - 26 - Triggering Macros/137 - Fun with VBA Events.mp4
  -  68.82 MB

  .pad/6
  -  186.97 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/98 - Extracting Specific Text using LEN & SEARCH.mp4
  -  66.25 MB

  .pad/7
  -  771.11 KB

  [TutsNode.net] - 23 - Writing VBA Code/123 - Creating User Defined Functions.mp4
  -  63.44 MB

  .pad/8
  -  576.14 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/110 - Solver Tool.mp4
  -  61.59 MB

  .pad/9
  -  422.41 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/42 - Grab User’s Attention using Illustrations.mp4
  -  58.54 MB

  .pad/10
  -  472.08 KB

  [TutsNode.net] - 27 - Excel User Forms/143 - UserForm ComboBoxes.mp4
  -  58.54 MB

  .pad/11
  -  474.46 KB

  [TutsNode.net] - 26 - Triggering Macros/134 - Form Controls vs ActiveX Controls.mp4
  -  58.51 MB

  .pad/12
  -  497.66 KB

  [TutsNode.net] - 12 - Excel Database Functions/64 - The SUMIF Function.mp4
  -  58.33 MB

  .pad/13
  -  684.59 KB

  [TutsNode.net] - 14 - Excel PivotTables/76 - Grouping & Filtering PivotTable Data.mp4
  -  58.27 MB

  .pad/14
  -  752.12 KB

  [TutsNode.net] - 25 - Excel VBA Loops/130 - For Next Loop.mp4
  -  57.99 MB

  .pad/15
  -  8.49 KB

  [TutsNode.net] - 12 - Excel Database Functions/65 - The DSUM Function.mp4
  -  52.34 MB

  .pad/16
  -  671.16 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/152 - Personal Branding.mp4
  -  51.95 MB

  .pad/17
  -  55.18 KB

  [TutsNode.net] - 12 - Excel Database Functions/66 - DSUM Function Cont.mp4
  -  51.57 MB

  .pad/18
  -  436.71 KB

  [TutsNode.net] - 23 - Writing VBA Code/122 - Worksheet Functions inside VBA.mp4
  -  51.27 MB

  .pad/19
  -  742.46 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/56 - How to Prepare Data for Analysis.mp4
  -  50.5 MB

  .pad/20
  -  509.83 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/90 - VLOOKUP Function.mp4
  -  49.55 MB

  .pad/21
  -  459.59 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/83 - How to Create PowerPivot KPI’s.mp4
  -  48.75 MB

  .pad/22
  -  253.84 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/151 - How to Get Your First Client.mp4
  -  48.11 MB

  .pad/23
  -  915.34 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/148 - Getting Started with Freelancing.mp4
  -  46.53 MB

  .pad/24
  -  486.25 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/27 - Moving & Copying Data.mp4
  -  45.58 MB

  .pad/25
  -  432.02 KB

  [TutsNode.net] - 27 - Excel User Forms/142 - Passing Option Buttons to Desired Cells.mp4
  -  44.82 MB

  .pad/26
  -  187.53 KB

  [TutsNode.net] - 14 - Excel PivotTables/75 - Modifying Excel PivotTables.mp4
  -  44.55 MB

  .pad/27
  -  460.45 KB

  [TutsNode.net] - 23 - Writing VBA Code/124 - User Defined Functions within VBA Scripts.mp4
  -  43.75 MB

  .pad/28
  -  256.3 KB

  [TutsNode.net] - 14 - Excel PivotTables/74 - Creating an Excel Pivot Table.mp4
  -  42.89 MB

  .pad/29
  -  110.26 KB

  [TutsNode.net] - 13 - Excel Data Validation/73 - Complex Validation Dependent Drop Down List.mp4
  -  42.55 MB

  .pad/30
  -  456.47 KB

  [TutsNode.net] - 9 - Excels Printing Options/51 - Excels Page Layout View.mp4
  -  42.43 MB

  .pad/31
  -  583.35 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/129 - Debugging & Error Handling Cont.mp4
  -  42.34 MB

  .pad/32
  -  676.75 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/47 - Formatting Elements of a Chart.mp4
  -  42.07 MB

  .pad/33
  -  951.03 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/62 - Converting Datasets into Tables.mp4
  -  40.23 MB

  .pad/34
  -  790.66 KB

  [TutsNode.net] - 27 - Excel User Forms/141 - Passing TextBox Values to Desired Cells.mp4
  -  39.99 MB

  .pad/35
  -  8.79 KB

  [TutsNode.net] - 12 - Excel Database Functions/67 - The SUBTOTAL Function.mp4
  -  39.86 MB

  .pad/36
  -  139.97 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/99 - Combining Text with CONCATENATE.mp4
  -  39.72 MB

  .pad/37
  -  287.01 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/128 - Debugging & Error Handling.mp4
  -  39.41 MB

  .pad/38
  -  599.32 KB

  [TutsNode.net] - 25 - Excel VBA Loops/131 - Do Until Loop.mp4
  -  39.35 MB

  .pad/39
  -  660.79 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/23 - The SUM Function.mp4
  -  38.65 MB

  .pad/40
  -  355.79 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/106 - How to Freeze Panes in Excel.mp4
  -  38.46 MB

  .pad/41
  -  548.96 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/48 - Modifying the Data Type & Location of a Chart.mp4
  -  37.93 MB

  .pad/42
  -  70.21 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/41 - The Power of Conditional Formatting.mp4
  -  37.52 MB

  .pad/43
  -  492.72 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/97 - LEFT RIGHT and MID Function.mp4
  -  37.16 MB

  .pad/44
  -  860.56 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/125 - Find Last Row of Data.mp4
  -  36.19 MB

  .pad/45
  -  829.08 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/44 - Create Compelling Graphics with SmartArt.mp4
  -  36.04 MB

  .pad/46
  -  983.17 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/21 - Relative vs Absolute Cell References.mp4
  -  35.98 MB

  .pad/47
  -  16.58 KB

  [TutsNode.net] - 27 - Excel User Forms/146 - UserForms and Protected Sheets.mp4
  -  35.84 MB

  .pad/48
  -  160.48 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/61 - Creating Subtotals within a Dataset.mp4
  -  35.24 MB

  .pad/49
  -  782.64 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/87 - Nesting Multiple IF Functions.mp4
  -  34.99 MB

  .pad/50
  -  10 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/49 - Little Slice of Pie Charts.mp4
  -  34.85 MB

  .pad/51
  -  157.15 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/39 - Creating Styles for Formatting Efficiency.mp4
  -  34.59 MB

  .pad/52
  -  421.75 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/81 - Creating Relationships between Data Tables.mp4
  -  34.44 MB

  .pad/53
  -  573.92 KB

  [TutsNode.net] - 13 - Excel Data Validation/69 - Creating a Drop Down List with Data Validation.mp4
  -  33.82 MB

  .pad/54
  -  184.21 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/92 - HLOOKUP Function.mp4
  -  33.35 MB

  .pad/55
  -  670.29 KB

  [TutsNode.net] - 22 - The VBA Language/116 - Objects Methods and Properties.mp4
  -  33.22 MB

  .pad/56
  -  802.68 KB

  [TutsNode.net] - 13 - Excel Data Validation/71 - Adding Custom Alerts to Data Validation.mp4
  -  32.88 MB

  .pad/57
  -  118.27 KB

  [TutsNode.net] - 23 - Writing VBA Code/119 - InputBox & MsgBox.mp4
  -  32.74 MB

  .pad/58
  -  264.79 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/104 - 3D Referencing in Formulas.mp4
  -  32.21 MB

  .pad/59
  -  808.8 KB

  [TutsNode.net] - 18 - Text Based Functions in Excel/100 - Quick Tips & Other Text Based Functions.mp4
  -  31.65 MB

  .pad/60
  -  361.06 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/149 - How to Become an Excel Freelancer.mp4
  -  31.51 MB

  .pad/61
  -  505.09 KB

  [TutsNode.net] - 7 - How to Insert Images and Shapes/43 - Customizing Icons.mp4
  -  31.43 MB

  .pad/62
  -  583.25 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/147 - Creating an Excel Resume.mp4
  -  31.43 MB

  .pad/63
  -  585.66 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/20 - Order of Operations.mp4
  -  31.4 MB

  .pad/64
  -  618.73 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/94 - MATCH Function.mp4
  -  31.31 MB

  .pad/65
  -  710.99 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/150 - Top Freelance Websites.mp4
  -  30.47 MB

  .pad/66
  -  545.33 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/108 - Goal Seek in Excel.mp4
  -  30.24 MB

  .pad/67
  -  779.01 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/114 - Saving & Opening a MacroEnabled Workbook.mp4
  -  29.99 MB

  .pad/68
  -  7.3 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/107 - Excel’s Scenario Manager Tool.mp4
  -  29.94 MB

  .pad/69
  -  57.92 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/37 - Formatting Data Appropriately.mp4
  -  29.55 MB

  .pad/70
  -  463.36 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/95 - INDEX and MATCH Combined.mp4
  -  28.74 MB

  .pad/71
  -  264.49 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/28 - Insert & Delete RowsColumns.mp4
  -  28.21 MB

  .pad/72
  -  811.79 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/86 - IF Function with OR Criteria.mp4
  -  28.18 MB

  .pad/73
  -  838.18 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/85 - IF Function with AND Criteria.mp4
  -  28.15 MB

  .pad/74
  -  865.66 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/31 - Renaming Moving & Deleting Excel Worksheets.mp4
  -  28.15 MB

  .pad/75
  -  866.93 KB

  [TutsNode.net] - 23 - Writing VBA Code/120 - Using Variables in VBA Code.mp4
  -  28.13 MB

  .pad/76
  -  887.26 KB

  [TutsNode.net] - 26 - Triggering Macros/133 - Assigning Macros to Shapes.mp4
  -  28.06 MB

  .pad/77
  -  962.23 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/4 - Microsoft Excel Marketplace.mp4
  -  27.87 MB

  .pad/78
  -  134.72 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/153 - Networking Dos and Donts.mp4
  -  27.59 MB

  .pad/79
  -  414.93 KB

  [TutsNode.net] - 10 - Benefits of Using Excel Templates/55 - How to Create an Excel Template.mp4
  -  27.59 MB

  .pad/80
  -  417.85 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/127 - With Statement.mp4
  -  27.08 MB

  .pad/81
  -  943.57 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/60 - Applying Filters to Datasets.mp4
  -  26.92 MB

  .pad/82
  -  81.88 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/29 - Adjusting the Width & Height of Cells.mp4
  -  26.92 MB

  .pad/83
  -  83.34 KB

  [TutsNode.net] - 13 - Excel Data Validation/70 - Different Types of Excel Data Validation.mp4
  -  26.87 MB

  .pad/84
  -  137.34 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/26 - COUNT Functions.mp4
  -  26.8 MB

  .pad/85
  -  205.32 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/101 - Tracing Precedents & Dependents in Formulas.mp4
  -  26.2 MB

  .pad/86
  -  817.85 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/35 - Formatting Fonts and Cell Background Color.mp4
  -  26.09 MB

  .pad/87
  -  936.43 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/18 - Formatting Date Values in Excel.mp4
  -  25.99 MB

  .pad/88
  -  10.67 KB

  [TutsNode.net] - 25 - Excel VBA Loops/132 - For Each Loop.mp4
  -  25.63 MB

  .pad/89
  -  376.56 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/93 - INDEX Function.mp4
  -  25.56 MB

  .pad/90
  -  454.51 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/2 - What is Microsoft Excel.mp4
  -  25.55 MB

  .pad/91
  -  461.23 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/84 - Excel’s IF Function.mp4
  -  25.52 MB

  .pad/92
  -  495.41 KB

  [TutsNode.net] - 26 - Triggering Macros/135 - Worksheet Events.mp4
  -  25.3 MB

  .pad/93
  -  717.9 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/6 - Microsoft Excel Job Types.mp4
  -  24.41 MB

  .pad/94
  -  602.48 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/30 - Hiding and Unhiding Excel Rows and Columns.mp4
  -  24.37 MB

  .pad/95
  -  646.74 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/36 - Adding Cell Borders.mp4
  -  24.34 MB

  .pad/96
  -  675.14 KB

  [TutsNode.net] - 22 - The VBA Language/115 - Modules and Procedures.mp4
  -  24.22 MB

  .pad/97
  -  800.92 KB

  [TutsNode.net] - 28 - Starting a Career in Excel/154 - Importance of Having a Website.mp4
  -  24.11 MB

  .pad/98
  -  913.25 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/32 - Adding Protection to Specific Cells.mp4
  -  23.89 MB

  .pad/99
  -  111.32 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/96 - TwoWay Lookup with INDEX and MATCH.mp4
  -  23.33 MB

  .pad/100
  -  686.97 KB

  [TutsNode.net] - 27 - Excel User Forms/144 - Clearing Values from UserForm Controls.mp4
  -  23.16 MB

  .pad/101
  -  861.7 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/89 - Key Benefits of Named Ranges.mp4
  -  22.27 MB

  .pad/102
  -  749.05 KB

  [TutsNode.net] - 20 - Excel’s “What If” Tools/109 - Compare Results with Excel Data Tables.mp4
  -  22.17 MB

  .pad/103
  -  849.35 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/19 - Building Basic Formulas in Excel.mp4
  -  21.9 MB

  .pad/104
  -  100.55 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/82 - Using Data Models to Create PivotTables.mp4
  -  21.87 MB

  .pad/105
  -  132.07 KB

  [TutsNode.net] - 27 - Excel User Forms/140 - How to Show an UserForm.mp4
  -  21.82 MB

  .pad/106
  -  185.74 KB

  [TutsNode.net] - 9 - Excels Printing Options/50 - Print Preview Options.mp4
  -  20.96 MB

  .pad/107
  -  36.57 KB

  [TutsNode.net] - 16 - Excels Conditional Functions/88 - The COUNTIF Function.mp4
  -  20.94 MB

  .pad/108
  -  62.27 KB

  [TutsNode.net] - 24 - Important VBA Tools and Logic/126 - Find Last Column of Data.mp4
  -  20.34 MB

  .pad/109
  -  675.86 KB

  [TutsNode.net] - 22 - The VBA Language/117 - Excel VBA Variables.mp4
  -  20.31 MB

  .pad/110
  -  703.87 KB

  [TutsNode.net] - 17 - Excels Lookup Functions/91 - The Beauty of Excel’s IFERROR Function.mp4
  -  20.18 MB

  .pad/111
  -  842.97 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/24 - The MIN & MAX Function.mp4
  -  19.91 MB

  .pad/112
  -  90.03 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/40 - Merging Cells for a Cleaner Look.mp4
  -  19.85 MB

  .pad/113
  -  157.77 KB

  [TutsNode.net] - 27 - Excel User Forms/138 - Creating an Excel UserForm.mp4
  -  19.77 MB

  .pad/114
  -  233.06 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/3 - Who This Course is For.mp4
  -  19.54 MB

  .pad/115
  -  466.03 KB

  [TutsNode.net] - 2 - Getting Started with Excel/14 - Customizing the Excel Ribbon.mp4
  -  19.17 MB

  .pad/116
  -  844.82 KB

  [TutsNode.net] - 6 - Visually Pleasing Cell Formatting/38 - The Magic behind Excels Format Painter.mp4
  -  19.11 MB

  .pad/117
  -  911.5 KB

  [TutsNode.net] - 26 - Triggering Macros/136 - Workbook Events.mp4
  -  18.15 MB

  .pad/118
  -  868.67 KB

  [TutsNode.net] - 2 - Getting Started with Excel/12 - Saving & Opening Excel Documents.mp4
  -  17.83 MB

  .pad/119
  -  177.29 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/1 - Excel from AZ Course Section Overview.mp4
  -  17.79 MB

  .pad/120
  -  211.6 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/103 - Grouping Data.mp4
  -  17.25 MB

  .pad/121
  -  770.28 KB

  [TutsNode.net] - 1 - Excel from AZ Course Introduction/5 - Microsoft Excel Job Opportunities.mp4
  -  17.2 MB

  .pad/122
  -  822.92 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/45 - The Commonly used Column Chart.mp4
  -  16.63 MB

  .pad/123
  -  380.7 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/105 - Utilizing the Watch Window in Excel.mp4
  -  16.56 MB

  .pad/124
  -  452.92 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/58 - MultiLevel Sorting.mp4
  -  16.52 MB

  .pad/125
  -  489.63 KB

  [TutsNode.net] - 13 - Excel Data Validation/72 - Creating a Dynamic Drop Down List.mp4
  -  16.21 MB

  .pad/126
  -  810.44 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/57 - How to Sort Data in Excel.mp4
  -  16.2 MB

  .pad/127
  -  816.97 KB

  [TutsNode.net] - 11 - Working with Excel Datasets/59 - Custom Sorting Datasets in Excel.mp4
  -  16.04 MB

  .pad/128
  -  980.18 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/112 - A Look Inside the Visual Basic Editor VBE.mp4
  -  15.84 MB

  .pad/129
  -  162.89 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/17 - Entering Numeric Values in Excel.mp4
  -  15.71 MB

  .pad/130
  -  298.68 KB

  [TutsNode.net] - 2 - Getting Started with Excel/8 - Excels Start Screen.mp4
  -  14.72 MB

  .pad/131
  -  281.78 KB

  [TutsNode.net] - 21 - Welcome to Excel VBA/111 - The Power Behind Excel VBA.mp4
  -  14.64 MB

  .pad/132
  -  366.68 KB

  [TutsNode.net] - 14 - Excel PivotTables/77 - Drilling Down into PivotTable Data.mp4
  -  14.5 MB

  .pad/133
  -  517.01 KB

  [TutsNode.net] - 9 - Excels Printing Options/52 - Printing a Specific Range of Cells.mp4
  -  14.47 MB

  .pad/134
  -  546.41 KB

  [TutsNode.net] - 9 - Excels Printing Options/53 - Converting Spreadsheets to PDF Files.mp4
  -  14.24 MB

  .pad/135
  -  774.32 KB

  [TutsNode.net] - 2 - Getting Started with Excel/13 - Customizing the Excel Quick Access Toolbar.mp4
  -  14.05 MB

  .pad/136
  -  969.24 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/22 - Excel Functions Explained.mp4
  -  13.81 MB

  .pad/137
  -  190.23 KB

  [TutsNode.net] - 2 - Getting Started with Excel/9 - Explaining the Excel Interface.mp4
  -  13.77 MB

  .pad/138
  -  238.43 KB

  [TutsNode.net] - 8 - Visualize Data with Charts/46 - Changing the Chart Design.mp4
  -  12.7 MB

  .pad/139
  -  303 KB

  [TutsNode.net] - 27 - Excel User Forms/145 - How to Close an UserForm.mp4
  -  12.1 MB

  .pad/140
  -  925.27 KB

  [TutsNode.net] - 19 - Auditing Formulas & Custom Views in Excel/102 - Showing Formulas.mp4
  -  11.76 MB

  .pad/141
  -  249.14 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/79 - What is PowerPivot.mp4
  -  11.29 MB

  .pad/142
  -  723.64 KB

  [TutsNode.net] - 3 - Values Referencing and Formulas/16 - Creating Excel Labels.mp4
  -  11.04 MB

  .pad/143
  -  980.16 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/34 - Adding a Workbook Password to Open File.mp4
  -  10.82 MB

  .pad/144
  -  181.32 KB

  [TutsNode.net] - 5 - Adjusting Excel Worksheets/33 - Protecting the Structure of a Workbook.mp4
  -  10.67 MB

  .pad/145
  -  333.89 KB

  [TutsNode.net] - 4 - Intro to Excel Functions/25 - The AVERAGE Function.mp4
  -  10.64 MB

  .pad/146
  -  370.84 KB

  [TutsNode.net] - 2 - Getting Started with Excel/11 - Excel Workbook vs Excel Worksheet.mp4
  -  10.06 MB

  .pad/147
  -  963.89 KB

  [TutsNode.net] - 13 - Excel Data Validation/68 - What is Excel Data Validation.mp4
  -  9.59 MB

  .pad/148
  -  417.92 KB

  [TutsNode.net] - 10 - Benefits of Using Excel Templates/54 - Why Create an Excel Template.mp4
  -  8.41 MB

  .pad/149
  -  605.7 KB

  [TutsNode.net] - 2 - Getting Started with Excel/15 - Excel Shortcut Keys.mp4
  -  8.18 MB

  .pad/150
  -  842.83 KB

  [TutsNode.net] - 2 - Getting Started with Excel/10 - Excel Interface Continued.mp4
  -  7.92 MB

  .pad/151
  -  77.91 KB

  [TutsNode.net] - 15 - Excels PowerPivot AddIn/80 - Activating the Excel PowerPivot AddIn.mp4
  -  7.79 MB

  .pad/152
  -  210.78 KB

  [TutsNode.net] - 2 - Getting Started with Excel/7 - Finding & Opening Microsoft Excel.mp4
  -  4.39 MB



Torrent Description


Description

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course

In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!

Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.

The course covers 4 main areas:


1: INTRO TO EXCEL

This intro section gives you a full introduction to Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.

Intro to Microsoft Excel
Excel Industry and Marketplace
Excel Job Opportunities
Getting Started with Excel
Excel Functions

2: INTERMEDIATE EXCEL

This section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.

Data Visualization
Datasets
Databases
Data Validation
PivotTables
Conditional Functions
Lookup Functions
Formulas, + more!

3: EXCEL MACROS & VBA

This section gives you a full introduction to the Excel Macros and VBA with hands-on step by step training.

VBA Language
VBA Code
VBA Loops
Macros
User Forms

4: STARTING AN EXCEL CAREER

This section gives you a full introduction to starting a career as an Excel Programmer with hands-on step by step training.

Creating a Resume
Freelancing + Freelance websites
How To Get Your 1st Client
Personal Branding
Importance of Having a Website
Networking

By the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.
Who this course is for:

Students who want to learn and master microsoft excel

Requirements

basic computer skills

Last Updated 12/2020