microsoft-excel-2013-from-beginner-to-advanced-and-beyond

Creation Time	April 17, 2024, 1:41 p.m.
Last Access Time	Feb. 19, 2026, 4 a.m.
File Size	8.3 GB
Keywords	microsoft-excel-2013-from-beginner-to-advanced-and-beyond
Total Requests	371
Total Files	555
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

course-material/19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4 167.9 MB
course-material/18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4 144.0 MB
course-material/35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables.mp4 141.7 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder.mp4 121.1 MB
course-material/19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4 117.5 MB
course-material/19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4 110.2 MB
course-material/10 - Working with Excel Templates/002 Opening an Existing Template.mp4 105.7 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project.mp4 96.3 MB
course-material/35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window.mp4 95.5 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors.mp4 93.2 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!.mp4 87.7 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop.mp4 86.1 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information.mp4 85.4 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets.mp4 85.3 MB
course-material/18 - Excel PivotTables/001 Understanding Excel PivotTables.mp4 84.4 MB
course-material/09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4 81.7 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event.mp4 81.3 MB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt.mp4 79.6 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox.mp4 75.8 MB
course-material/36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop.mp4 75.3 MB
course-material/19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn.mp4 73.4 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop.mp4 73.0 MB
course-material/09 - Printing an Excel Worksheet/005 Adding Header and Footer Content.mp4 71.3 MB
course-material/08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts.mp4 70.7 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function.mp4 69.4 MB
course-material/10 - Working with Excel Templates/003 Creating a Custom Template.mp4 69.1 MB
course-material/19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships.mp4 69.1 MB
course-material/19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models.mp4 65.7 MB
course-material/06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4 62.1 MB
course-material/29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4 60.1 MB
course-material/18 - Excel PivotTables/007 Drilling Down into PivotTable Data.mp4 60.0 MB
course-material/08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart.mp4 59.9 MB
course-material/15 - Excel List Functions/007 Excel Function SUBTOTAL().mp4 59.3 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA.mp4 58.2 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop.mp4 56.1 MB
course-material/35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function.mp4 54.8 MB
course-material/08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart.mp4 54.7 MB
course-material/17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4 53.6 MB
course-material/25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4 53.5 MB
course-material/36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement.mp4 52.6 MB
course-material/25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4 52.4 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA.mp4 52.0 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 51.2 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop.mp4 51.0 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA.mp4 50.6 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties.mp4 49.6 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button.mp4 48.7 MB
course-material/36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop.mp4 48.7 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code.mp4 48.5 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form.mp4 48.2 MB
course-material/18 - Excel PivotTables/008 Creating PivotCharts.mp4 47.7 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet.mp4 47.3 MB
course-material/25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 47.1 MB
course-material/03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas.mp4 47.1 MB
course-material/15 - Excel List Functions/006 Excel Function DCOUNT().mp4 46.6 MB
course-material/17 - Importing and Exporting Data/007 Exporting Data to a Text File.mp4 46.4 MB
course-material/24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel.mp4 46.2 MB
course-material/17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel.mp4 45.8 MB
course-material/24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function.mp4 45.8 MB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images.mp4 45.6 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements.mp4 45.3 MB
course-material/06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands.mp4 44.6 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros.mp4 43.4 MB
course-material/09 - Printing an Excel Worksheet/004 Working with Page Layout View.mp4 42.5 MB
course-material/35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts.mp4 42.4 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property.mp4 41.7 MB
course-material/15 - Excel List Functions/001 Introduction to Excels Function DSUM().mp4 40.1 MB
course-material/25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4 39.9 MB
course-material/18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations.mp4 39.7 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers.mp4 39.7 MB
course-material/36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop.mp4 39.6 MB
course-material/10 - Working with Excel Templates/001 Intro to Excel Templates.mp4 39.5 MB
course-material/15 - Excel List Functions/004 Excel DSUM Function with AND Criteria.mp4 39.5 MB
course-material/08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet.mp4 39.5 MB
course-material/25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4 38.3 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open.mp4 37.8 MB
course-material/16 - Excel Data Validation/002 Creating an Excel Data Validation List.mp4 37.7 MB
course-material/08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart.mp4 37.7 MB
course-material/35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure.mp4 37.5 MB
course-material/36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition.mp4 37.4 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers.mp4 37.3 MB
course-material/09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview.mp4 36.8 MB
course-material/03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 36.1 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes.mp4 35.6 MB
course-material/19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot.mp4 35.5 MB
course-material/15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued.mp4 35.5 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event.mp4 34.9 MB
course-material/16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4 34.6 MB
course-material/15 - Excel List Functions/005 Excel Function DAVERAGE().mp4 34.3 MB
course-material/35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure.mp4 34.2 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro.mp4 34.0 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar.mp4 34.0 MB
course-material/06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting.mp4 33.3 MB
course-material/06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter.mp4 32.8 MB
course-material/16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation.mp4 32.6 MB
course-material/16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error.mp4 32.6 MB
course-material/03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel.mp4 32.1 MB
course-material/20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data.mp4 32.0 MB
course-material/09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells.mp4 31.6 MB
course-material/03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel.mp4 31.6 MB
course-material/03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel.mp4 31.5 MB
course-material/09 - Printing an Excel Worksheet/003 Excel Worksheet Margins.mp4 31.4 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text.mp4 31.2 MB
course-material/36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements.mp4 31.1 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure.mp4 30.8 MB
course-material/14 - Working with an Excel List/007 Format a List as a Table.mp4 30.8 MB
course-material/04 - Working with Basic Excel Functions/001 The structure of an Excel Function.mp4 30.5 MB
course-material/24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function.mp4 30.3 MB
course-material/35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE).mp4 30.3 MB
course-material/35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts.mp4 30.2 MB
course-material/03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles.mp4 30.0 MB
course-material/18 - Excel PivotTables/006 Modifying PivotTable Calculations.mp4 30.0 MB
course-material/26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function.mp4 29.9 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button.mp4 29.6 MB
course-material/24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges.mp4 29.6 MB
course-material/08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon.mp4 29.5 MB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes.mp4 29.2 MB
course-material/05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns.mp4 29.0 MB
course-material/16 - Excel Data Validation/003 Excel Decimal Data Validation.mp4 28.7 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method.mp4 28.6 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records.mp4 28.3 MB
course-material/05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet.mp4 28.1 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop.mp4 27.8 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls.mp4 27.4 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros.mp4 27.3 MB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder.mp4 27.2 MB
course-material/25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function.mp4 27.2 MB
course-material/35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information.mp4 27.0 MB
course-material/14 - Working with an Excel List/006 Creating Subtotals in a List.mp4 26.9 MB
course-material/25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4 26.7 MB
course-material/24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function.mp4 26.3 MB
course-material/06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values.mp4 26.1 MB
course-material/26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function.mp4 26.1 MB
course-material/24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range.mp4 26.0 MB
course-material/33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course.mp4 26.0 MB
course-material/02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface.mp4 25.7 MB
course-material/04 - Working with Basic Excel Functions/007 Using the AutoSum Command.mp4 25.7 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name.mp4 25.4 MB
course-material/06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells.mp4 25.3 MB
course-material/04 - Working with Basic Excel Functions/002 Working with the SUM() Function.mp4 25.1 MB
course-material/28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet.mp4 24.8 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder.mp4 24.3 MB
course-material/03 - Entering and Editing Text and Formulas/004 Working with Cell References.mp4 24.1 MB
course-material/04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions.mp4 24.0 MB
course-material/24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function.mp4 23.9 MB
course-material/33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros.mp4 23.3 MB
course-material/29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel.mp4 22.8 MB
course-material/18 - Excel PivotTables/005 Formatting PivotTable Data.mp4 22.6 MB
course-material/42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 22.6 MB
course-material/18 - Excel PivotTables/010 Filtering with the Slicer Tool.mp4 22.6 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet.mp4 22.5 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure.mp4 22.4 MB
course-material/42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function.mp4 22.1 MB
course-material/35 - Excel VBA Concepts/006 Excel VBA Modules.mp4 22.0 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4 22.0 MB
course-material/12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!.mp4 22.0 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code.mp4 21.7 MB
course-material/24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges.mp4 21.3 MB
course-material/01 - Microsoft Excel 101 Course Introduction/001 Ask Questions.mp4 21.1 MB
course-material/42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File.mp4 21.1 MB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report.mp4 21.0 MB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes.mp4 20.6 MB
course-material/06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting.mp4 20.6 MB
course-material/05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet.mp4 20.5 MB
course-material/18 - Excel PivotTables/004 Grouping PivotTable Data.mp4 20.5 MB
course-material/26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 20.4 MB
course-material/05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns.mp4 20.3 MB
course-material/32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103.mp4 20.1 MB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros.mp4 20.1 MB
course-material/05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells.mp4 19.5 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save.mp4 19.2 MB
course-material/22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!.mp4 19.1 MB
course-material/36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements.mp4 19.0 MB
course-material/20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows).mp4 19.0 MB
course-material/02 - Microsoft Excel Fundamentals/007 Saving an Excel Document.mp4 18.7 MB
course-material/35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code.mp4 18.6 MB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab.mp4 18.6 MB
course-material/29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool.mp4 18.5 MB
course-material/05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet.mp4 18.3 MB
course-material/06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued.mp4 17.9 MB
course-material/15 - Excel List Functions/003 Excel DSUM Function with OR Criteria.mp4 17.9 MB
course-material/20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool.mp4 17.1 MB
course-material/35 - Excel VBA Concepts/009 Including Excel VBA Comments.mp4 17.1 MB
course-material/42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import.mp4 17.0 MB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA.mp4 17.0 MB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User.mp4 16.7 MB
course-material/06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell.mp4 16.6 MB
course-material/14 - Working with an Excel List/001 Understanding Excel List Structure.mp4 16.5 MB
course-material/04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas.mp4 16.5 MB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas.mp4 15.9 MB
course-material/14 - Working with an Excel List/009 Removing Duplicates.mp4 15.3 MB
course-material/06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages.mp4 15.2 MB
course-material/02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp4 15.2 MB
course-material/14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates.mp4 15.2 MB
course-material/41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms.mp4 15.0 MB
course-material/02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen.mp4 14.3 MB
course-material/14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool.mp4 14.3 MB
course-material/29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel.mp4 14.3 MB
course-material/20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets.mp4 14.2 MB
course-material/17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4 13.9 MB
course-material/02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys.mp4 13.9 MB
course-material/14 - Working with an Excel List/004 Using Custom Sorts in an Excel List.mp4 13.8 MB
course-material/17 - Importing and Exporting Data/002 Importing Data from Text Files.mp4 13.8 MB
course-material/04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations.mp4 13.7 MB
course-material/24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range.mp4 13.2 MB
course-material/06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells.mp4 13.1 MB
course-material/18 - Excel PivotTables/009 Filtering PivotTable Data.mp4 13.1 MB
course-material/14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts.mp4 13.1 MB
course-material/02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar.mp4 12.8 MB
course-material/24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function.mp4 12.7 MB
course-material/02 - Microsoft Excel Fundamentals/005 More on the Excel Interface.mp4 12.5 MB
course-material/17 - Importing and Exporting Data/003 Importing Data from Microsoft Access.mp4 12.3 MB
course-material/42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File.mp4 12.2 MB
course-material/43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master.mp4 11.8 MB
course-material/28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password.mp4 11.7 MB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros.mp4 11.5 MB
course-material/42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard.mp4 11.4 MB
course-material/14 - Working with an Excel List/002 Sorting a List Using Single Level Sort.mp4 11.4 MB
course-material/42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property.mp4 11.3 MB
course-material/04 - Working with Basic Excel Functions/005 Working with the COUNT() Function.mp4 11.3 MB
course-material/27 - Auditing an Excel Worksheet/003 Working with the Watch Window.mp4 11.2 MB
course-material/27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas.mp4 11.2 MB
course-material/23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD.mp4 11.1 MB
course-material/05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet.mp4 11.0 MB
course-material/04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function.mp4 11.0 MB
course-material/02 - Microsoft Excel Fundamentals/001 Launching Excel.mp4 10.5 MB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros.mp4 10.5 MB
course-material/36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement.mp4 10.1 MB
course-material/42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data.mp4 9.5 MB
course-material/02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp4 9.5 MB
course-material/27 - Auditing an Excel Worksheet/004 Showing Formulas.mp4 9.3 MB
course-material/28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook.mp4 9.3 MB
course-material/20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas).mp4 9.1 MB
course-material/04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key.mp4 8.9 MB
course-material/01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp4 8.7 MB
course-material/42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import.mp4 8.5 MB
course-material/26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function.mp4 8.2 MB
course-material/17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel.mp4 8.2 MB
course-material/27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas.mp4 8.1 MB
course-material/01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion.mp4 7.7 MB
course-material/13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4 6.8 MB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel.mp4 6.1 MB
course-material/13 - Microsoft Excel 102 Course Introduction/NorthwindDB-IMPORT.accdb 2.9 MB
course-material/08 - Creating Basic Charts in Excel/007 PresentingDataEffectivelywithExcelCharts-01.pdf 291.7 KB
course-material/20 - Working with Large Sets of Excel Data/006 ManagingAndSummarizingLargeExcelDatasets-01.pdf 272.0 KB
course-material/35 - Excel VBA Concepts/003 ExcelMacrosAndVBA-PP.pptx 264.2 KB
course-material/21 - Excel 102 Additional Practice Exercises/001 COMPLETED-Excel102ExtraPractice-01.xlsx 258.9 KB
course-material/21 - Excel 102 Additional Practice Exercises/001 Excel102ExtraPractice-01.xlsx 244.0 KB
course-material/26 - Working with Excel's Text Based Functions/005 MasterExcelAdvancedFunctionsFormulas-01.pdf 238.0 KB
course-material/02 - Microsoft Excel Fundamentals/009 CommonExcelWindowsShortcuts-01.pdf 141.5 KB
course-material/13 - Microsoft Excel 102 Course Introduction/001 Excel102Exercises.xlsx 123.5 KB
course-material/31 - Excel 103 Additional Practice Exercises/001 COMPLETED-Excel103ExtraPractice-01.xlsx 95.3 KB
course-material/31 - Excel 103 Additional Practice Exercises/001 Excel103ExtraPractice-01.xlsx 92.6 KB
course-material/04 - Working with Basic Excel Functions/001 EXCEL-FUNCTIONS.pptx 87.1 KB
course-material/23 - Microsoft Excel 103 Course Introduction/001 Excel103-AdvancedExercises.xlsx 63.6 KB
course-material/11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel101ExtraPractice-01.xlsx 46.3 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/002 COM-QuarterlyReportForm-01.xlsm 44.5 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/002 COM-QuarterlyReport-01.xlsm 34.3 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/002 QuarterlyReportForm-01.xlsm 31.7 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 COM-CleaningUpData-01.xlsm 28.0 KB
course-material/13 - Microsoft Excel 102 Course Introduction/001 SalesData-TEXT-IMPORT.txt 25.9 KB
course-material/35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables_en.srt 25.3 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/001 QuarterlyReportForm-01.xlsm 24.5 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/002 QuarterlyReport.xlsm 23.1 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/002 COM-AutomateSumFunction-01.xlsm 22.6 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/002 COM-SortingRecords.xlsm 22.2 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder_en.srt 20.6 KB
course-material/03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas_en.srt 20.2 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/002 COM-InsertingAndFormattingText.xlsm 20.1 KB
course-material/35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window_en.srt 20.1 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/003 AutomateSumFunction.xlsx 19.8 KB
course-material/29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool_en.srt 18.9 KB
course-material/36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop_en.srt 18.8 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!_en.srt 18.6 KB
course-material/04 - Working with Basic Excel Functions/001 The structure of an Excel Function_en.srt 18.2 KB
course-material/03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt 18.0 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/004 InsertingAndFormattingText.xlsx 17.4 KB
course-material/26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function_en.srt 17.2 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors_en.srt 17.1 KB
course-material/25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function_en.srt 17.1 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information_en.srt 17.1 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/003 SortingRecords.xlsm 16.7 KB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt_en.srt 16.3 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets_en.srt 16.1 KB
course-material/36 - Working with Excel VBA Logic Statements/001 COM-ExcelVBALoops.xlsm 16.1 KB
course-material/19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs_en.srt 16.1 KB
course-material/10 - Working with Excel Templates/002 Opening an Existing Template_en.srt 16.0 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project_en.srt 15.7 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop_en.srt 15.6 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 CleaningUpData.xlsx 15.5 KB
course-material/25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function_en.srt 15.5 KB
course-material/35 - Excel VBA Concepts/003 COM-IntroToExcelVBACode-01.xlsm 15.3 KB
course-material/18 - Excel PivotTables/006 Modifying PivotTable Calculations_en.srt 15.3 KB
course-material/42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt 15.3 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/002 AutomateSumFunction.xlsx 15.2 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event_en.srt 15.2 KB
course-material/03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel_en.srt 15.1 KB
course-material/03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel_en.srt 15.0 KB
course-material/03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles_en.srt 15.0 KB
course-material/09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation_en.srt 14.9 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox_en.srt 14.8 KB
course-material/25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt 14.6 KB
course-material/03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel_en.srt 14.5 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Template-01.xlsx 14.5 KB
course-material/18 - Excel PivotTables/004 Grouping PivotTable Data_en.srt 14.4 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Count-01.xlsx 14.3 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-01.xlsx 14.3 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoSUM-01.xlsx 14.1 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AverageFunction-01.xlsx 14.1 KB
course-material/06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands_en.srt 14.0 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-MIN-MAXFunctions-01.xlsx 14.0 KB
course-material/17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel_en.srt 13.9 KB
course-material/36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement_en.srt 13.9 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoFill-01.xlsx 13.8 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-SUMFunction-01.xlsx 13.8 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-BasicFormulas-01.xlsx 13.7 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Headers-01.xlsx 13.7 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-ReferenceTypes-01.xlsx 13.7 KB
course-material/42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File_en.srt 13.6 KB
course-material/06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data_en.srt 13.3 KB
course-material/02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface_en.srt 13.3 KB
course-material/19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot_en.srt 13.1 KB
course-material/15 - Excel List Functions/007 Excel Function SUBTOTAL()_en.srt 13.1 KB
course-material/05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns_en.srt 13.0 KB
course-material/42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function_en.srt 12.9 KB
course-material/04 - Working with Basic Excel Functions/002 Working with the SUM() Function_en.srt 12.7 KB
course-material/04 - Working with Basic Excel Functions/007 Using the AutoSum Command_en.srt 12.7 KB
course-material/36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop_en.srt 12.6 KB
course-material/24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel_en.srt 12.6 KB
course-material/18 - Excel PivotTables/002 Creating an Excel PivotTable_en.srt 12.3 KB
course-material/25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt 12.0 KB
course-material/04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions_en.srt 12.0 KB
course-material/35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function_en.srt 11.9 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop_en.srt 11.9 KB
course-material/08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart_en.srt 11.9 KB
course-material/08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts_en.srt 11.9 KB
course-material/17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel_en.srt 11.5 KB
course-material/09 - Printing an Excel Worksheet/005 Adding Header and Footer Content_en.srt 11.5 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/002 InsertingAndFormattingText.xlsx 11.5 KB
course-material/17 - Importing and Exporting Data/007 Exporting Data to a Text File_en.srt 11.4 KB
course-material/25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt 11.4 KB
course-material/42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import_en.srt 11.3 KB
course-material/35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure_en.srt 11.2 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties_en.srt 11.2 KB
course-material/14 - Working with an Excel List/007 Format a List as a Table_en.srt 11.1 KB
course-material/05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet_en.srt 11.1 KB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder_en.srt 11.1 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/002 SortingRecords.xlsx 11.1 KB
course-material/28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet_en.srt 11.1 KB
course-material/35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts_en.srt 11.0 KB
course-material/29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool_en.srt 11.0 KB
course-material/10 - Working with Excel Templates/003 Creating a Custom Template_en.srt 10.9 KB
course-material/15 - Excel List Functions/006 Excel Function DCOUNT()_en.srt 10.9 KB
course-material/20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data_en.srt 10.9 KB
course-material/33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course_en.srt 10.8 KB
course-material/29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel_en.srt 10.8 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function_en.srt 10.5 KB
course-material/24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function_en.srt 10.4 KB
course-material/18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations_en.srt 10.3 KB
course-material/36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition_en.srt 10.3 KB
course-material/03 - Entering and Editing Text and Formulas/004 Working with Cell References_en.srt 10.0 KB
course-material/14 - Working with an Excel List/006 Creating Subtotals in a List_en.srt 9.9 KB
course-material/05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet_en.srt 9.9 KB
course-material/15 - Excel List Functions/004 Excel DSUM Function with AND Criteria_en.srt 9.9 KB
course-material/24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges_en.srt 9.8 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button_en.srt 9.8 KB
course-material/36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop_en.srt 9.8 KB
course-material/08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart_en.srt 9.8 KB
course-material/42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File_en.srt 9.7 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form_en.srt 9.7 KB
course-material/05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells_en.srt 9.6 KB
course-material/19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models_en.srt 9.6 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA_en.srt 9.6 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop_en.srt 9.5 KB
course-material/15 - Excel List Functions/001 Introduction to Excels Function DSUM()_en.srt 9.5 KB
course-material/25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function_en.srt 9.4 KB
course-material/16 - Excel Data Validation/002 Creating an Excel Data Validation List_en.srt 9.4 KB
course-material/05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns_en.srt 9.3 KB
course-material/03 - Entering and Editing Text and Formulas/007 OrderOfOperation-01.xlsx 9.3 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet_en.srt 9.2 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt 9.2 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA_en.srt 9.2 KB
course-material/16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation_en.srt 9.1 KB
course-material/33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros_en.srt 9.0 KB
course-material/36 - Working with Excel VBA Logic Statements/001 ExcelVBALoops.xlsx 8.9 KB
course-material/24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range_en.srt 8.9 KB
course-material/16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error_en.srt 8.8 KB
course-material/19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot_en.srt 8.8 KB
course-material/24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function_en.srt 8.8 KB
course-material/35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE)_en.srt 8.7 KB
course-material/26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt 8.7 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers_en.srt 8.6 KB
course-material/26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function_en.srt 8.5 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property_en.srt 8.4 KB
course-material/05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet_en.srt 8.2 KB
course-material/15 - Excel List Functions/005 Excel Function DAVERAGE()_en.srt 8.2 KB
course-material/14 - Working with an Excel List/001 Understanding Excel List Structure_en.srt 8.2 KB
course-material/19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot_en.srt 8.1 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method_en.srt 8.1 KB
course-material/06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting_en.srt 8.1 KB
course-material/25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function_en.srt 8.1 KB
course-material/09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview_en.srt 8.0 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code_en.srt 8.0 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop_en.srt 8.0 KB
course-material/19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships_en.srt 7.9 KB
course-material/17 - Importing and Exporting Data/002 Importing Data from Text Files_en.srt 7.9 KB
course-material/36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements_en.srt 7.9 KB
course-material/16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt 7.9 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar_en.srt 7.8 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA_en.srt 7.8 KB
course-material/24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges_en.srt 7.8 KB
course-material/24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function_en.srt 7.7 KB
course-material/29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel_en.srt 7.7 KB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes_en.srt 7.7 KB
course-material/06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values_en.srt 7.7 KB
course-material/04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas_en.srt 7.6 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements_en.srt 7.6 KB
course-material/35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure_en.srt 7.6 KB
course-material/35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts_en.srt 7.5 KB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA_en.srt 7.5 KB
course-material/06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter_en.srt 7.5 KB
course-material/20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets_en.srt 7.5 KB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images_en.srt 7.4 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro_en.srt 7.3 KB
course-material/24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function_en.srt 7.3 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes_en.srt 7.2 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers_en.srt 7.2 KB
course-material/02 - Microsoft Excel Fundamentals/007 Saving an Excel Document_en.srt 7.2 KB
course-material/18 - Excel PivotTables/007 Drilling Down into PivotTable Data_en.srt 7.0 KB
course-material/14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool_en.srt 7.0 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros_en.srt 7.0 KB
course-material/15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued_en.srt 6.9 KB
course-material/18 - Excel PivotTables/008 Creating PivotCharts_en.srt 6.9 KB
course-material/04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations_en.srt 6.9 KB
course-material/16 - Excel Data Validation/003 Excel Decimal Data Validation_en.srt 6.9 KB
course-material/02 - Microsoft Excel Fundamentals/005 More on the Excel Interface_en.srt 6.8 KB
course-material/18 - Excel PivotTables/001 Understanding Excel PivotTables_en.srt 6.8 KB
course-material/02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook_en.srt 6.7 KB
course-material/08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart_en.srt 6.6 KB
course-material/18 - Excel PivotTables/005 Formatting PivotTable Data_en.srt 6.6 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt 6.5 KB
course-material/08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet_en.srt 6.5 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open_en.srt 6.4 KB
course-material/14 - Working with an Excel List/004 Using Custom Sorts in an Excel List_en.srt 6.4 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt 6.3 KB
course-material/42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property_en.srt 6.3 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text_en.srt 6.3 KB
course-material/35 - Excel VBA Concepts/006 Excel VBA Modules_en.srt 6.1 KB
course-material/42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard_en.srt 6.0 KB
course-material/06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued_en.srt 6.0 KB
course-material/02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen_en.srt 6.0 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls_en.srt 6.0 KB
course-material/09 - Printing an Excel Worksheet/004 Working with Page Layout View_en.srt 6.0 KB
course-material/17 - Importing and Exporting Data/003 Importing Data from Microsoft Access_en.srt 5.9 KB
course-material/06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells_en.srt 5.9 KB
course-material/06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell_en.srt 5.8 KB
course-material/20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows)_en.srt 5.8 KB
course-material/14 - Working with an Excel List/009 Removing Duplicates_en.srt 5.8 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop_en.srt 5.7 KB
course-material/27 - Auditing an Excel Worksheet/003 Working with the Watch Window_en.srt 5.6 KB
course-material/09 - Printing an Excel Worksheet/003 Excel Worksheet Margins_en.srt 5.6 KB
course-material/09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells_en.srt 5.6 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name_en.srt 5.6 KB
course-material/27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas_en.srt 5.6 KB
course-material/10 - Working with Excel Templates/001 Intro to Excel Templates_en.srt 5.6 KB
course-material/06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages_en.srt 5.5 KB
course-material/28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook_en.srt 5.5 KB
course-material/05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet_en.srt 5.5 KB
course-material/02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar_en.srt 5.5 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure_en.srt 5.4 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder_en.srt 5.4 KB
course-material/18 - Excel PivotTables/009 Filtering PivotTable Data_en.srt 5.4 KB
course-material/20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool_en.srt 5.4 KB
course-material/18 - Excel PivotTables/010 Filtering with the Slicer Tool_en.srt 5.3 KB
course-material/14 - Working with an Excel List/002 Sorting a List Using Single Level Sort_en.srt 5.3 KB
course-material/20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas)_en.srt 5.3 KB
course-material/14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates_en.srt 5.3 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt 5.2 KB
course-material/04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function_en.srt 5.2 KB
course-material/19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn_en.srt 5.1 KB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros_en.srt 5.1 KB
course-material/08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon_en.srt 5.1 KB
course-material/14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts_en.srt 5.0 KB
course-material/06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting_en.srt 5.0 KB
course-material/07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes_en.srt 5.0 KB
course-material/36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements_en.srt 4.9 KB
course-material/04 - Working with Basic Excel Functions/005 Working with the COUNT() Function_en.srt 4.8 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import_en.srt 4.6 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet_en.srt 4.6 KB
course-material/24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range_en.srt 4.6 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records_en.srt 4.6 KB
course-material/35 - Excel VBA Concepts/009 Including Excel VBA Comments_en.srt 4.5 KB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros_en.srt 4.5 KB
course-material/06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells_en.srt 4.4 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros_en.srt 4.4 KB
course-material/28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password_en.srt 4.3 KB
course-material/42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data_en.srt 4.2 KB
course-material/27 - Auditing an Excel Worksheet/004 Showing Formulas_en.srt 4.2 KB
course-material/04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key_en.srt 4.1 KB
course-material/24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function_en.srt 4.1 KB
course-material/26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function_en.srt 4.1 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros_en.srt 4.0 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save_en.srt 4.0 KB
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt 4.0 KB
course-material/02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys_en.srt 4.0 KB
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User_en.srt 3.9 KB
course-material/35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code_en.srt 3.9 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab_en.srt 3.9 KB
course-material/27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas_en.srt 3.8 KB
course-material/15 - Excel List Functions/003 Excel DSUM Function with OR Criteria_en.srt 3.8 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure_en.srt 3.7 KB
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code_en.srt 3.6 KB
course-material/02 - Microsoft Excel Fundamentals/001 Launching Excel_en.srt 3.5 KB
course-material/17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt 3.4 KB
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report_en.srt 3.3 KB
course-material/12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!_en.srt 3.3 KB
course-material/35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information_en.srt 3.2 KB
course-material/01 - Microsoft Excel 101 Course Introduction/001 Ask Questions_en.srt 3.2 KB
course-material/02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document_en.srt 3.1 KB
course-material/17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel_en.srt 3.0 KB
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas_en.srt 3.0 KB
course-material/01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files_en.srt 2.8 KB
course-material/32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103_en.srt 2.6 KB
course-material/23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt 2.5 KB
course-material/22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!_en.srt 2.2 KB
course-material/36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement_en.srt 2.2 KB
course-material/13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt 2.2 KB
course-material/01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion_en.srt 2.2 KB
course-material/30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel_en.srt 2.1 KB
course-material/42 - Project #7 Importing Data from Text Files/001 April2015Sales.txt 1.8 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Nov2015Sales.txt 1.3 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Jan2015Sales.txt 1.2 KB
course-material/42 - Project #7 Importing Data from Text Files/001 May2015Sales.txt 1.2 KB
course-material/43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master_en.srt 1.2 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Mar2015Sales.txt 1.2 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Feb2015Sales.txt 1.2 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/012 Add Sheet Procedure Catch Errors.html 1.1 KB
course-material/42 - Project #7 Importing Data from Text Files/001 Dec2015Sales.txt 1.1 KB
course-material/41 - Project #6 Working with Excel VBA User Forms/012 AddSheetError-Solution-01.txt 890 bytes
[TGx]Downloaded from torrentgalaxy.to .txt 585 bytes
course-material/35 - Excel VBA Concepts/003 Intro to Excel VBA Exercise Files (DOWNLOAD).html 513 bytes
course-material/34 - Project #1 Using Excel's Macro Recorder Tool/002 Project #1 Section Exercise Files (DOWNLOAD).html 500 bytes
course-material/37 - Project #2 Moving Beyond the Basics and into VBA/002 Beyond the Basics Sort Project Exercise Files (DOWNLOAD).html 492 bytes
course-material/36 - Working with Excel VBA Logic Statements/001 Working with Excel VBA Logic Exercise Files (DOWNLOAD).html 488 bytes
course-material/41 - Project #6 Working with Excel VBA User Forms/002 Project #6 Working with Excel VBA User Forms Exercise Files (DOWNLOAD).html 473 bytes
course-material/39 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate Sum Function Exercise Files (DOWNLOAD).html 470 bytes
course-material/40 - Project #5 Bringing it All Together and a Weekly Report/002 Project #5 Final Report Loop Exercise Files (DOWNLOAD).html 462 bytes
course-material/38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 Project #3 Exercise Files (DOWNLOAD).html 460 bytes
[Hello].txt 381 bytes
course-material/20 - Working with Large Sets of Excel Data/006 Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD).html 323 bytes
course-material/26 - Working with Excel's Text Based Functions/005 Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD).html 288 bytes
course-material/11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel 101 - Practice What You've Learned (DOWNLOAD).html 259 bytes
course-material/21 - Excel 102 Additional Practice Exercises/001 Excel 102 - Practice What You've Learned (DOWNLOAD).html 259 bytes
course-material/31 - Excel 103 Additional Practice Exercises/001 Excel 103 - Practice What You've Learned (DOWNLOAD).html 259 bytes
course-material/08 - Creating Basic Charts in Excel/007 Microsoft Excel Charts Quick Guide (DOWNLOAD).html 256 bytes

microsoft-excel-2013-from-beginner-to-advanced-and-beyond

File List

Download Torrent

Related Resources

Copyright Infringement