Udemy - Microsoft Excel - Excel from Beginner to Advanced 2022-7

Creation Time	Jan. 23, 2024, 6:14 a.m.
Last Access Time	July 7, 2024, 2:49 a.m.
File Size	8.5 GB
Keywords	2022-7 from Beginner - Excel Udemy to Microsoft Advanced
Total Requests	2
Total Files	547
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables.mp4 188.9 MB
09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4 161.5 MB
24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel.mp4 156.9 MB
04 - Working with Basic Excel Functions/001 The structure of an Excel Function.mp4 154.7 MB
19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4 150.9 MB
06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4 137.2 MB
34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder.mp4 135.2 MB
17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4 129.3 MB
02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface.mp4 112.9 MB
39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function.mp4 111.1 MB
29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4 109.1 MB
33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course.mp4 106.6 MB
16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation.mp4 103.3 MB
37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project.mp4 102.2 MB
19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4 99.0 MB
36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement.mp4 98.8 MB
25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4 98.0 MB
25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4 96.3 MB
10 - Working with Excel Templates/002 Opening an Existing Template.mp4 90.0 MB
25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 88.8 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop.mp4 86.4 MB
25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4 83.0 MB
34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text.mp4 76.4 MB
18 - Excel PivotTables/004 Grouping PivotTable Data.mp4 75.7 MB
19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4 74.3 MB
30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder.mp4 72.7 MB
24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function.mp4 70.6 MB
18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4 70.4 MB
18 - Excel PivotTables/001 Understanding Excel PivotTables.mp4 70.1 MB
39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA.mp4 69.3 MB
25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4 68.7 MB
17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel.mp4 68.0 MB
41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop.mp4 67.5 MB
17 - Importing and Exporting Data/007 Exporting Data to a Text File.mp4 65.9 MB
10 - Working with Excel Templates/001 Intro to Excel Templates.mp4 64.3 MB
18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations.mp4 63.9 MB
18 - Excel PivotTables/007 Drilling Down into PivotTable Data.mp4 61.5 MB
09 - Printing an Excel Worksheet/005 Adding Header and Footer Content.mp4 60.9 MB
37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors.mp4 60.1 MB
39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 59.7 MB
37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information.mp4 59.0 MB
09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells.mp4 58.1 MB
03 - Entering and Editing Text and Formulas/004 Working with Cell References.mp4 57.7 MB
37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox.mp4 56.6 MB
03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas.mp4 55.8 MB
34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!.mp4 53.5 MB
14 - Working with an Excel List/001 Understanding Excel List Structure.mp4 53.0 MB
14 - Working with an Excel List/007 Format a List as a Table.mp4 52.9 MB
24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function.mp4 52.3 MB
19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships.mp4 51.9 MB
07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt.mp4 49.9 MB
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 48.2 MB
29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel.mp4 48.2 MB
42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function.mp4 47.8 MB
41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop.mp4 47.8 MB
14 - Working with an Excel List/006 Creating Subtotals in a List.mp4 45.4 MB
41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event.mp4 45.1 MB
41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open.mp4 42.9 MB
07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images.mp4 42.5 MB
42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 42.0 MB
35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window.mp4 41.9 MB
36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop.mp4 40.9 MB
02 - Microsoft Excel Fundamentals/007 Saving an Excel Document.mp4 40.8 MB
26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function.mp4 40.5 MB
18 - Excel PivotTables/008 Creating PivotCharts.mp4 39.8 MB
26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 39.4 MB
25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4 39.1 MB
03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel.mp4 38.6 MB
03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel.mp4 38.1 MB
05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet.mp4 37.0 MB
10 - Working with Excel Templates/003 Creating a Custom Template.mp4 37.0 MB
03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles.mp4 36.9 MB
15 - Excel List Functions/007 Excel Function SUBTOTAL().mp4 36.5 MB
01 - Microsoft Excel 101 Course Introduction/001 Ask Questions.mp4 36.4 MB
34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button.mp4 36.3 MB
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 35.7 MB
14 - Working with an Excel List/002 Sorting a List Using Single Level Sort.mp4 34.6 MB
06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands.mp4 33.7 MB
20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data.mp4 33.7 MB
02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen.mp4 33.6 MB
03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 33.5 MB
18 - Excel PivotTables/006 Modifying PivotTable Calculations.mp4 33.3 MB
02 - Microsoft Excel Fundamentals/001 Launching Excel.mp4 33.1 MB
08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts.mp4 33.0 MB
30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros.mp4 32.5 MB
41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure.mp4 32.4 MB
39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records.mp4 32.4 MB
30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA.mp4 31.7 MB
41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties.mp4 31.4 MB
20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows).mp4 31.3 MB
28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet.mp4 31.1 MB
15 - Excel List Functions/006 Excel Function DCOUNT().mp4 30.8 MB
04 - Working with Basic Excel Functions/002 Working with the SUM() Function.mp4 30.8 MB
42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import.mp4 30.8 MB
08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart.mp4 30.7 MB
04 - Working with Basic Excel Functions/007 Using the AutoSum Command.mp4 30.6 MB
02 - Microsoft Excel Fundamentals/005 More on the Excel Interface.mp4 30.3 MB
25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function.mp4 30.1 MB
26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function.mp4 29.6 MB
14 - Working with an Excel List/009 Removing Duplicates.mp4 29.1 MB
14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates.mp4 27.7 MB
03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel.mp4 27.7 MB
40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA.mp4 27.5 MB
01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp4 27.3 MB
36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop.mp4 26.9 MB
15 - Excel List Functions/004 Excel DSUM Function with AND Criteria.mp4 26.4 MB
15 - Excel List Functions/001 Introduction to Excels Function DSUM().mp4 26.3 MB
14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts.mp4 26.2 MB
41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form.mp4 26.0 MB
16 - Excel Data Validation/002 Creating an Excel Data Validation List.mp4 25.8 MB
39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property.mp4 25.8 MB
20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool.mp4 25.8 MB
37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros.mp4 25.7 MB
05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet.mp4 25.6 MB
40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code.mp4 25.6 MB
27 - Auditing an Excel Worksheet/003 Working with the Watch Window.mp4 25.4 MB
19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models.mp4 25.3 MB
08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart.mp4 25.0 MB
34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes.mp4 25.0 MB
35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function.mp4 25.0 MB
29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool.mp4 24.1 MB
24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges.mp4 24.0 MB
05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns.mp4 23.9 MB
40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop.mp4 23.8 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers.mp4 23.7 MB
05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet.mp4 23.5 MB
15 - Excel List Functions/005 Excel Function DAVERAGE().mp4 23.4 MB
01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion.mp4 23.3 MB
40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA.mp4 23.2 MB
05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns.mp4 23.2 MB
16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error.mp4 23.2 MB
17 - Importing and Exporting Data/003 Importing Data from Microsoft Access.mp4 23.0 MB
15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued.mp4 22.8 MB
12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!.mp4 22.8 MB
02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp4 22.8 MB
42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File.mp4 22.6 MB
14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool.mp4 22.2 MB
35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts.mp4 22.1 MB
16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4 22.1 MB
35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure.mp4 22.0 MB
37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements.mp4 22.0 MB
36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop.mp4 21.4 MB
17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4 21.3 MB
42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File.mp4 21.1 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers.mp4 21.0 MB
06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values.mp4 20.8 MB
36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition.mp4 20.6 MB
04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions.mp4 20.5 MB
42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import.mp4 20.5 MB
06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting.mp4 20.4 MB
16 - Excel Data Validation/003 Excel Decimal Data Validation.mp4 20.4 MB
19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn.mp4 20.3 MB
29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel.mp4 20.3 MB
34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro.mp4 20.3 MB
09 - Printing an Excel Worksheet/004 Working with Page Layout View.mp4 20.1 MB
42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard.mp4 19.8 MB
04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas.mp4 19.8 MB
35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure.mp4 19.6 MB
32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103.mp4 19.6 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop.mp4 19.5 MB
30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros.mp4 19.3 MB
34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar.mp4 19.2 MB
17 - Importing and Exporting Data/002 Importing Data from Text Files.mp4 19.1 MB
20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets.mp4 18.6 MB
28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password.mp4 18.6 MB
06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter.mp4 18.5 MB
41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event.mp4 18.5 MB
22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!.mp4 18.3 MB
41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button.mp4 18.3 MB
41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms.mp4 17.6 MB
05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells.mp4 17.5 MB
18 - Excel PivotTables/005 Formatting PivotTable Data.mp4 17.4 MB
24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range.mp4 17.2 MB
36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements.mp4 17.1 MB
07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes.mp4 16.6 MB
24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function.mp4 16.6 MB
08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet.mp4 16.5 MB
04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations.mp4 16.5 MB
08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart.mp4 16.0 MB
35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts.mp4 15.9 MB
35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE).mp4 15.8 MB
41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls.mp4 15.8 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder.mp4 15.6 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros.mp4 15.6 MB
27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas.mp4 15.4 MB
33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros.mp4 15.4 MB
37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method.mp4 15.4 MB
06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells.mp4 15.1 MB
24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function.mp4 15.0 MB
42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data.mp4 14.9 MB
06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued.mp4 14.9 MB
06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell.mp4 14.4 MB
14 - Working with an Excel List/004 Using Custom Sorts in an Excel List.mp4 14.2 MB
19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot.mp4 14.1 MB
34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros.mp4 14.0 MB
24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges.mp4 13.9 MB
02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar.mp4 13.7 MB
09 - Printing an Excel Worksheet/003 Excel Worksheet Margins.mp4 13.4 MB
41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet.mp4 13.3 MB
18 - Excel PivotTables/010 Filtering with the Slicer Tool.mp4 13.3 MB
06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages.mp4 13.2 MB
02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp4 13.0 MB
20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas).mp4 13.0 MB
05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet.mp4 12.7 MB
08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon.mp4 12.7 MB
40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure.mp4 12.5 MB
28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook.mp4 12.5 MB
09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview.mp4 12.4 MB
35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information.mp4 12.4 MB
42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property.mp4 12.2 MB
15 - Excel List Functions/003 Excel DSUM Function with OR Criteria.mp4 12.2 MB
34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code.mp4 12.2 MB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4 12.0 MB
30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel.mp4 11.9 MB
35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code.mp4 11.8 MB
18 - Excel PivotTables/009 Filtering PivotTable Data.mp4 11.7 MB
35 - Excel VBA Concepts/006 Excel VBA Modules.mp4 11.6 MB
02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys.mp4 11.6 MB
07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes.mp4 11.4 MB
37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User.mp4 11.3 MB
06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting.mp4 11.3 MB
39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas.mp4 11.2 MB
41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name.mp4 11.1 MB
06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells.mp4 11.1 MB
27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas.mp4 11.1 MB
34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab.mp4 11.1 MB
26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function.mp4 10.7 MB
37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save.mp4 10.5 MB
36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements.mp4 10.3 MB
40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report.mp4 10.2 MB
04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key.mp4 10.0 MB
27 - Auditing an Excel Worksheet/004 Showing Formulas.mp4 9.9 MB
04 - Working with Basic Excel Functions/005 Working with the COUNT() Function.mp4 9.5 MB
04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function.mp4 9.4 MB
35 - Excel VBA Concepts/009 Including Excel VBA Comments.mp4 9.3 MB
24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function.mp4 8.1 MB
24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range.mp4 8.0 MB
23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD.mp4 6.3 MB
17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel.mp4 5.7 MB
36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement.mp4 5.4 MB
13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4 4.1 MB
43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master.mp4 3.0 MB
13 - Microsoft Excel 102 Course Introduction/001 NorthwindDB-IMPORT.zip 467.8 KB
35 - Excel VBA Concepts/003 ExcelMacrosAndVBA-PP.pptx 264.2 KB
21 - Excel 102 Additional Practice Exercises/001 COMPLETED-Excel102ExtraPractice-01.xlsx 247.8 KB
21 - Excel 102 Additional Practice Exercises/001 Excel102ExtraPractice-01.xlsx 234.5 KB
02 - Microsoft Excel Fundamentals/009 CommonExcelWindowsShortcuts-01.pdf 141.5 KB
13 - Microsoft Excel 102 Course Introduction/001 Excel102Exercises.xlsx 123.5 KB
31 - Excel 103 Additional Practice Exercises/001 COMPLETED-Excel103ExtraPractice-01.xlsx 95.3 KB
31 - Excel 103 Additional Practice Exercises/001 Excel103ExtraPractice-01.xlsx 92.6 KB
04 - Working with Basic Excel Functions/001 EXCEL-FUNCTIONS.pptx 87.1 KB
23 - Microsoft Excel 103 Course Introduction/001 Excel103-AdvancedExercises.xlsx 63.6 KB
11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel101ExtraPractice-01.xlsx 46.3 KB
41 - Project #6 Working with Excel VBA User Forms/002 COM-QuarterlyReportForm-01.xlsm 44.5 KB
40 - Project #5 Bringing it All Together and a Weekly Report/002 COM-QuarterlyReport-01.xlsm 34.3 KB
41 - Project #6 Working with Excel VBA User Forms/002 QuarterlyReportForm-01.xlsm 31.7 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 COM-CleaningUpData-01.xlsm 28.0 KB
13 - Microsoft Excel 102 Course Introduction/001 SalesData-TEXT-IMPORT.txt 25.9 KB
41 - Project #6 Working with Excel VBA User Forms/001 QuarterlyReportForm-01.xlsm 24.5 KB
35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables_en.srt 23.9 KB
40 - Project #5 Bringing it All Together and a Weekly Report/002 QuarterlyReport.xlsm 23.1 KB
39 - Project #4 Using VBA to Automate Excel Formulas/002 COM-AutomateSumFunction-01.xlsm 22.6 KB
37 - Project #2 Moving Beyond the Basics and into VBA/002 COM-SortingRecords.xlsm 22.2 KB
34 - Project #1 Using Excel's Macro Recorder Tool/002 COM-InsertingAndFormattingText.xlsm 20.1 KB
39 - Project #4 Using VBA to Automate Excel Formulas/003 AutomateSumFunction.xlsx 19.8 KB
03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas_en.srt 18.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder_en.srt 18.3 KB
36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop_en.srt 18.1 KB
35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window_en.srt 17.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/004 InsertingAndFormattingText.xlsx 17.4 KB
26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function_en.srt 17.2 KB
29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool_en.srt 16.8 KB
37 - Project #2 Moving Beyond the Basics and into VBA/003 SortingRecords.xlsm 16.7 KB
34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!_en.srt 16.6 KB
36 - Working with Excel VBA Logic Statements/001 COM-ExcelVBALoops.xlsm 16.1 KB
19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs_en.srt 16.1 KB
25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function_en.srt 15.7 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 CleaningUpData.xlsx 15.5 KB
25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function_en.srt 15.5 KB
04 - Working with Basic Excel Functions/001 The structure of an Excel Function_en.srt 15.5 KB
37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors_en.srt 15.4 KB
35 - Excel VBA Concepts/003 COM-IntroToExcelVBACode-01.xlsm 15.3 KB
39 - Project #4 Using VBA to Automate Excel Formulas/002 AutomateSumFunction.xlsx 15.2 KB
03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt 15.1 KB
41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop_en.srt 15.1 KB
37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information_en.srt 15.0 KB
07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt_en.srt 14.9 KB
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 14.7 KB
25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt 14.6 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Template-01.xlsx 14.5 KB
10 - Working with Excel Templates/002 Opening an Existing Template_en.srt 14.5 KB
03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel_en.srt 14.4 KB
18 - Excel PivotTables/006 Modifying PivotTable Calculations_en.srt 14.4 KB
03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel_en.srt 14.4 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Count-01.xlsx 14.3 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-01.xlsx 14.3 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoSUM-01.xlsx 14.1 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AverageFunction-01.xlsx 14.1 KB
09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation_en.srt 14.0 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-MIN-MAXFunctions-01.xlsx 14.0 KB
03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles_en.srt 13.9 KB
37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project_en.srt 13.9 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoFill-01.xlsx 13.8 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-SUMFunction-01.xlsx 13.8 KB
41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event_en.srt 13.8 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-BasicFormulas-01.xlsx 13.7 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Headers-01.xlsx 13.7 KB
01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-ReferenceTypes-01.xlsx 13.7 KB
42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt 13.6 KB
03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel_en.srt 13.0 KB
37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox_en.srt 12.9 KB
24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel_en.srt 12.6 KB
36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement_en.srt 12.4 KB
17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel_en.srt 12.3 KB
42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File_en.srt 12.2 KB
06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data_en.srt 12.1 KB
18 - Excel PivotTables/004 Grouping PivotTable Data_en.srt 12.0 KB
06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands_en.srt 12.0 KB
42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function_en.srt 12.0 KB
04 - Working with Basic Excel Functions/002 Working with the SUM() Function_en.srt 11.9 KB
08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts_en.srt 11.7 KB
19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot_en.srt 11.5 KB
36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop_en.srt 11.5 KB
05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns_en.srt 11.5 KB
02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface_en.srt 11.5 KB
15 - Excel List Functions/007 Excel Function SUBTOTAL()_en.srt 11.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/002 InsertingAndFormattingText.xlsx 11.5 KB
04 - Working with Basic Excel Functions/007 Using the AutoSum Command_en.srt 11.2 KB
14 - Working with an Excel List/007 Format a List as a Table_en.srt 11.1 KB
30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder_en.srt 11.1 KB
37 - Project #2 Moving Beyond the Basics and into VBA/002 SortingRecords.xlsx 11.1 KB
28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet_en.srt 11.1 KB
08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart_en.srt 11.0 KB
29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool_en.srt 11.0 KB
25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt 11.0 KB
20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data_en.srt 10.9 KB
35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function_en.srt 10.9 KB
29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel_en.srt 10.8 KB
25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt 10.8 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop_en.srt 10.7 KB
18 - Excel PivotTables/002 Creating an Excel PivotTable_en.srt 10.4 KB
04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions_en.srt 10.2 KB
10 - Working with Excel Templates/003 Creating a Custom Template_en.srt 10.1 KB
05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet_en.srt 10.0 KB
14 - Working with an Excel List/006 Creating Subtotals in a List_en.srt 9.9 KB
41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties_en.srt 9.9 KB
17 - Importing and Exporting Data/007 Exporting Data to a Text File_en.srt 9.9 KB
42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import_en.srt 9.8 KB
36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition_en.srt 9.8 KB
15 - Excel List Functions/006 Excel Function DCOUNT()_en.srt 9.7 KB
24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function_en.srt 9.7 KB
39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function_en.srt 9.7 KB
19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models_en.srt 9.6 KB
18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations_en.srt 9.5 KB
17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel_en.srt 9.4 KB
09 - Printing an Excel Worksheet/005 Adding Header and Footer Content_en.srt 9.3 KB
03 - Entering and Editing Text and Formulas/007 OrderOfOperation-01.xlsx 9.3 KB
35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts_en.srt 9.1 KB
03 - Entering and Editing Text and Formulas/004 Working with Cell References_en.srt 9.1 KB
42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File_en.srt 9.0 KB
25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function_en.srt 8.9 KB
36 - Working with Excel VBA Logic Statements/001 ExcelVBALoops.xlsx 8.9 KB
36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop_en.srt 8.9 KB
08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart_en.srt 8.9 KB
35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure_en.srt 8.8 KB
34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button_en.srt 8.8 KB
39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt 8.8 KB
41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop_en.srt 8.7 KB
26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt 8.7 KB
33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course_en.srt 8.6 KB
05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns_en.srt 8.6 KB
24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range_en.srt 8.5 KB
26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function_en.srt 8.5 KB
15 - Excel List Functions/001 Introduction to Excels Function DSUM()_en.srt 8.4 KB
05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells_en.srt 8.4 KB
24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges_en.srt 8.3 KB
40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA_en.srt 8.3 KB
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 8.2 KB
16 - Excel Data Validation/002 Creating an Excel Data Validation List_en.srt 8.2 KB
14 - Working with an Excel List/001 Understanding Excel List Structure_en.srt 8.2 KB
41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form_en.srt 8.1 KB
24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function_en.srt 8.1 KB
39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA_en.srt 8.1 KB
33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros_en.srt 7.9 KB
05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet_en.srt 7.9 KB
17 - Importing and Exporting Data/002 Importing Data from Text Files_en.srt 7.9 KB
16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error_en.srt 7.8 KB
15 - Excel List Functions/004 Excel DSUM Function with AND Criteria_en.srt 7.8 KB
24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function_en.srt 7.7 KB
29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel_en.srt 7.7 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers_en.srt 7.7 KB
30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA_en.srt 7.5 KB
20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets_en.srt 7.5 KB
16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation_en.srt 7.5 KB
05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet_en.srt 7.4 KB
35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE)_en.srt 7.4 KB
39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property_en.srt 7.4 KB
25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function_en.srt 7.4 KB
36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements_en.srt 7.3 KB
16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt 7.3 KB
15 - Excel List Functions/005 Excel Function DAVERAGE()_en.srt 7.2 KB
06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting_en.srt 7.1 KB
19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships_en.srt 7.1 KB
40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop_en.srt 7.1 KB
14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool_en.srt 7.0 KB
40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA_en.srt 7.0 KB
40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code_en.srt 7.0 KB
15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued_en.srt 7.0 KB
06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values_en.srt 6.9 KB
19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot_en.srt 6.9 KB
06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter_en.srt 6.9 KB
04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas_en.srt 6.9 KB
07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images_en.srt 6.9 KB
37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method_en.srt 6.7 KB
19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot_en.srt 6.7 KB
24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges_en.srt 6.7 KB
07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes_en.srt 6.7 KB
37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements_en.srt 6.7 KB
34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro_en.srt 6.6 KB
04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations_en.srt 6.6 KB
37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros_en.srt 6.6 KB
18 - Excel PivotTables/005 Formatting PivotTable Data_en.srt 6.6 KB
18 - Excel PivotTables/007 Drilling Down into PivotTable Data_en.srt 6.5 KB
35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure_en.srt 6.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes_en.srt 6.4 KB
24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function_en.srt 6.4 KB
14 - Working with an Excel List/004 Using Custom Sorts in an Excel List_en.srt 6.4 KB
09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview_en.srt 6.3 KB
02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook_en.srt 6.3 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers_en.srt 6.2 KB
35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts_en.srt 6.2 KB
02 - Microsoft Excel Fundamentals/007 Saving an Excel Document_en.srt 6.1 KB
34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar_en.srt 6.1 KB
16 - Excel Data Validation/003 Excel Decimal Data Validation_en.srt 6.0 KB
42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard_en.srt 6.0 KB
41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt 6.0 KB
18 - Excel PivotTables/001 Understanding Excel PivotTables_en.srt 5.9 KB
17 - Importing and Exporting Data/003 Importing Data from Microsoft Access_en.srt 5.9 KB
41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open_en.srt 5.9 KB
18 - Excel PivotTables/008 Creating PivotCharts_en.srt 5.9 KB
08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart_en.srt 5.8 KB
20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows)_en.srt 5.8 KB
14 - Working with an Excel List/009 Removing Duplicates_en.srt 5.8 KB
02 - Microsoft Excel Fundamentals/005 More on the Excel Interface_en.srt 5.7 KB
27 - Auditing an Excel Worksheet/003 Working with the Watch Window_en.srt 5.7 KB
41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls_en.srt 5.6 KB
27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas_en.srt 5.6 KB
42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property_en.srt 5.5 KB
41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure_en.srt 5.5 KB
08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet_en.srt 5.5 KB
28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook_en.srt 5.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text_en.srt 5.5 KB
41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt 5.4 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop_en.srt 5.4 KB
20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool_en.srt 5.4 KB
09 - Printing an Excel Worksheet/004 Working with Page Layout View_en.srt 5.3 KB
14 - Working with an Excel List/002 Sorting a List Using Single Level Sort_en.srt 5.3 KB
20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas)_en.srt 5.3 KB
14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates_en.srt 5.3 KB
35 - Excel VBA Concepts/006 Excel VBA Modules_en.srt 5.2 KB
09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells_en.srt 5.2 KB
06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells_en.srt 5.2 KB
06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell_en.srt 5.2 KB
19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn_en.srt 5.1 KB
30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros_en.srt 5.1 KB
06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued_en.srt 5.1 KB
14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts_en.srt 5.0 KB
09 - Printing an Excel Worksheet/003 Excel Worksheet Margins_en.srt 4.9 KB
02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen_en.srt 4.9 KB
41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name_en.srt 4.9 KB
18 - Excel PivotTables/010 Filtering with the Slicer Tool_en.srt 4.9 KB
02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar_en.srt 4.8 KB
07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes_en.srt 4.7 KB
04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function_en.srt 4.6 KB
05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet_en.srt 4.6 KB
10 - Working with Excel Templates/001 Intro to Excel Templates_en.srt 4.6 KB
04 - Working with Basic Excel Functions/005 Working with the COUNT() Function_en.srt 4.6 KB
18 - Excel PivotTables/009 Filtering PivotTable Data_en.srt 4.5 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder_en.srt 4.5 KB
30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros_en.srt 4.5 KB
39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records_en.srt 4.4 KB
36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements_en.srt 4.4 KB
06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages_en.srt 4.3 KB
28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password_en.srt 4.3 KB
42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import_en.srt 4.3 KB
06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting_en.srt 4.2 KB
41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt 4.2 KB
24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range_en.srt 4.2 KB
27 - Auditing an Excel Worksheet/004 Showing Formulas_en.srt 4.2 KB
08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon_en.srt 4.1 KB
26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function_en.srt 4.1 KB
41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet_en.srt 4.1 KB
42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data_en.srt 4.0 KB
02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys_en.srt 4.0 KB
27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas_en.srt 3.8 KB
06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells_en.srt 3.8 KB
35 - Excel VBA Concepts/009 Including Excel VBA Comments_en.srt 3.8 KB
15 - Excel List Functions/003 Excel DSUM Function with OR Criteria_en.srt 3.8 KB
04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key_en.srt 3.7 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros_en.srt 3.7 KB
37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save_en.srt 3.7 KB
24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function_en.srt 3.7 KB
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt 3.5 KB
40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure_en.srt 3.5 KB
34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code_en.srt 3.4 KB
34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros_en.srt 3.4 KB
34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab_en.srt 3.3 KB
35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code_en.srt 3.3 KB
37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User_en.srt 3.2 KB
35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information_en.srt 3.0 KB
01 - Microsoft Excel 101 Course Introduction/001 Ask Questions_en.srt 3.0 KB
40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report_en.srt 3.0 KB
17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt 2.9 KB
02 - Microsoft Excel Fundamentals/001 Launching Excel_en.srt 2.8 KB
12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!_en.srt 2.8 KB
39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas_en.srt 2.7 KB
02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document_en.srt 2.7 KB
17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel_en.srt 2.5 KB
36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement_en.srt 2.3 KB
32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103_en.srt 2.3 KB
22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!_en.srt 2.2 KB
01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files_en.srt 2.2 KB
30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel_en.srt 2.1 KB
23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt 2.0 KB
13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt 1.8 KB
42 - Project #7 Importing Data from Text Files/001 April2015Sales.txt 1.8 KB
01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion_en.srt 1.8 KB
42 - Project #7 Importing Data from Text Files/001 Nov2015Sales.txt 1.3 KB
42 - Project #7 Importing Data from Text Files/001 Jan2015Sales.txt 1.2 KB
42 - Project #7 Importing Data from Text Files/001 May2015Sales.txt 1.2 KB
43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master_en.srt 1.2 KB
42 - Project #7 Importing Data from Text Files/001 Mar2015Sales.txt 1.2 KB
42 - Project #7 Importing Data from Text Files/001 Feb2015Sales.txt 1.2 KB
41 - Project #6 Working with Excel VBA User Forms/012 Add Sheet Procedure Catch Errors.html 1.1 KB
42 - Project #7 Importing Data from Text Files/001 Dec2015Sales.txt 1.1 KB
41 - Project #6 Working with Excel VBA User Forms/012 AddSheetError-Solution-01.txt 890 bytes
35 - Excel VBA Concepts/003 Intro to Excel VBA Exercise Files (DOWNLOAD).html 513 bytes
34 - Project #1 Using Excel's Macro Recorder Tool/002 Project #1 Section Exercise Files (DOWNLOAD).html 500 bytes
37 - Project #2 Moving Beyond the Basics and into VBA/002 Beyond the Basics Sort Project Exercise Files (DOWNLOAD).html 492 bytes
36 - Working with Excel VBA Logic Statements/001 Working with Excel VBA Logic Exercise Files (DOWNLOAD).html 488 bytes
41 - Project #6 Working with Excel VBA User Forms/002 Project #6 Working with Excel VBA User Forms Exercise Files (DOWNLOAD).html 473 bytes
39 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate Sum Function Exercise Files (DOWNLOAD).html 470 bytes
40 - Project #5 Bringing it All Together and a Weekly Report/002 Project #5 Final Report Loop Exercise Files (DOWNLOAD).html 462 bytes
38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 Project #3 Exercise Files (DOWNLOAD).html 460 bytes
11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel 101 - Practice What You've Learned (DOWNLOAD).html 259 bytes
21 - Excel 102 Additional Practice Exercises/001 Excel 102 - Practice What You've Learned (DOWNLOAD).html 259 bytes
31 - Excel 103 Additional Practice Exercises/001 Excel 103 - Practice What You've Learned (DOWNLOAD).html 259 bytes

Udemy - Microsoft Excel - Excel from Beginner to Advanced 2022-7

File List

Download Torrent

Related Resources

Copyright Infringement