[] Udemy - Microsoft Excel - Excel from Beginner to Advanced 收录时间:2020-08-18 15:04:04 文件大小:12GB 下载次数:23 最近下载:2021-01-23 03:00:46 磁力链接: magnet:?xt=urn:btih:ab9fed98b2b957a474139103670880083475b47c 立即下载 复制链接 文件列表 3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4 213MB 27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4 189MB 3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 173MB 23. Working with Excel's Lookup Functions/1. Microsoft Excel VLOOKUP() Function.mp4 170MB 23. Working with Excel's Lookup Functions/3. Microsoft Excel INDEX() Function.mp4 168MB 16. Importing and Exporting Data/4. NEW VERSION -- Import Data From Text Files into Excel.mp4 163MB 4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4 162MB 22. Working with Excel's Conditional Functions/6. Nesting Functions with Excel.mp4 157MB 23. Working with Excel's Lookup Functions/6. Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 155MB 14. Excel List Functions/7. Excel Function SUBTOTAL().mp4 154MB 3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4 151MB 3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4 151MB 3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4 148MB 3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4 146MB 23. Working with Excel's Lookup Functions/7. Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4 130MB 14. Excel List Functions/6. Excel Function DCOUNT().mp4 128MB 23. Working with Excel's Lookup Functions/5. Microsoft Excel INDEX() and MATCH() Function Combined.mp4 120MB 22. Working with Excel's Conditional Functions/9. Using Excel's SUMIF() Function.mp4 120MB 5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4 120MB 16. Importing and Exporting Data/5. NEW VERSION -- Import Data From a Database into Excel.mp4 120MB 2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.mp4 116MB 16. Importing and Exporting Data/7. Exporting Data to a Text File.mp4 116MB 4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4 114MB 15. Excel Data Validation/2. Creating an Excel Data Validation List.mp4 113MB 4. Working with Basic Excel Functions/7. Using the AutoSum Command.mp4 112MB 5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4 112MB 14. Excel List Functions/1. Introduction to Excels Function DSUM().mp4 111MB 14. Excel List Functions/4. Excel DSUM Function with AND Criteria.mp4 109MB 15. Excel Data Validation/1. Understanding the Need for Excel Data Validation.mp4 103MB 4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4 102MB 3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4 102MB 15. Excel Data Validation/4. Adding a Custom Excel Data Validation Error.mp4 100MB 14. Excel List Functions/5. Excel Function DAVERAGE().mp4 98MB 22. Working with Excel's Conditional Functions/2. Advantages and Disadvantages of Excel Name Ranges.mp4 96MB 14. Excel List Functions/2. Excel DSUM Function Single Criteria Continued.mp4 95MB 23. Working with Excel's Lookup Functions/2. Microsoft Excel HLOOKUP() Function.mp4 95MB 6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp4 95MB 22. Working with Excel's Conditional Functions/10. Using Excel's IFERROR() Function.mp4 94MB 15. Excel Data Validation/5. Dynamic Formulas by Using Excel Data Validation Techniques.mp4 93MB 22. Working with Excel's Conditional Functions/5. Excel's IF() Function with a Name Range.mp4 91MB 22. Working with Excel's Conditional Functions/4. Using Excel's IF() Function.mp4 90MB 5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.mp4 90MB 15. Excel Data Validation/3. Excel Decimal Data Validation.mp4 89MB 5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp4 86MB 5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp4 85MB 22. Working with Excel's Conditional Functions/7. Nesting Excels AND() Function within the IF() Function.mp4 82MB 23. Working with Excel's Lookup Functions/4. Microsoft Excel MATCH() Function.mp4 81MB 28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp4 79MB 5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.mp4 79MB 2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.mp4 79MB 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4 78MB 24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp4 76MB 13. Working with an Excel List/7. Format a List as a Table.mp4 75MB 2. Microsoft Excel Fundamentals/7. Saving an Excel Document.mp4 75MB 22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp4 74MB 9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp4 74MB 4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.mp4 73MB 26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp4 71MB 7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp4 71MB 13. Working with an Excel List/6. Creating Subtotals in a List.mp4 69MB 10. Working with Excel Templates/2. Opening an Existing Template.mp4 68MB 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp4 67MB 38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 66MB 19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp4 64MB 27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp4 64MB 2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.mp4 63MB 24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp4 61MB 38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp4 61MB 4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.mp4 60MB 8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp4 57MB 38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp4 57MB 6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp4 56MB 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp4 56MB 8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp4 56MB 8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp4 56MB 2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.mp4 55MB 36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp4 55MB 2. Microsoft Excel Fundamentals/5. More on the Excel Interface.mp4 55MB 24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 53MB 13. Working with an Excel List/1. Understanding Excel List Structure.mp4 53MB 17. Excel PivotTables/2. Creating an Excel PivotTable.mp4 53MB 10. Working with Excel Templates/3. Creating a Custom Template.mp4 52MB 6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp4 52MB 33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp4 52MB 7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp4 51MB 14. Excel List Functions/3. Excel DSUM Function with OR Criteria.mp4 50MB 9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp4 50MB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4 50MB 31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp4 49MB 2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.mp4 49MB 8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp4 49MB 19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp4 48MB 7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp4 48MB 4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp4 48MB 36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp4 47MB 4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp4 47MB 5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.mp4 47MB 7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp4 45MB 22. Working with Excel's Conditional Functions/3. Editing an Excel Name Range.mp4 44MB 28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp4 44MB 27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp4 44MB 22. Working with Excel's Conditional Functions/8. Using Excel's COUNTIF() Function.mp4 43MB 9. Printing an Excel Worksheet/3. Working with Page Layout View.mp4 43MB 32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp4 43MB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4 43MB 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp4 43MB 38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp4 42MB 6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp4 41MB 31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp4 41MB 13. Working with an Excel List/9. Removing Duplicates.mp4 41MB 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp4 41MB 17. Excel PivotTables/7. Creating PivotCharts.mp4 40MB 17. Excel PivotTables/1. Understanding Excel PivotTables.mp4 40MB 28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp4 40MB 33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp4 39MB 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp4 38MB 19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp4 38MB 32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp4 37MB 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp4 37MB 8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp4 37MB 39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp4 37MB 29. Congratulations!/1. Congratulations on Completing the Microsoft Excel 103.mp4 37MB 16. Importing and Exporting Data/6. Microsoft Excel Legacy Import Options for New Excel Versions.mp4 37MB 4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.mp4 37MB 6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp4 37MB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4 37MB 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp4 37MB 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp4 36MB 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp4 36MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp4 36MB 19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp4 36MB 17. Excel PivotTables/5. Formatting PivotTable Data.mp4 36MB 16. Importing and Exporting Data/1. Importing Data Into Microsoft Excel.mp4 36MB 32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4 35MB 25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp4 35MB 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp4 35MB 16. Importing and Exporting Data/2. Importing Data from Text Files.mp4 35MB 38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp4 35MB 20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp4 34MB 9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp4 34MB 27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp4 34MB 28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp4 34MB 17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4 34MB 33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp4 34MB 2. Microsoft Excel Fundamentals/1. Launching Excel.mp4 34MB 6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp4 33MB 38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp4 33MB 30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp4 32MB 38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp4 32MB 17. Excel PivotTables/8. Filtering PivotTable Data.mp4 32MB 17. Excel PivotTables/4. Grouping PivotTable Data.mp4 32MB 16. Importing and Exporting Data/3. Importing Data from Microsoft Access.mp4 31MB 6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp4 30MB 6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp4 30MB 2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.mp4 29MB 31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Oops! I Need to Edit My Macro.mp4 28MB 32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4 28MB 8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp4 28MB 37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp4 27MB 25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp4 27MB 1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp4 27MB 21. Microsoft Excel 103 Course Introduction/1. Excel 103 Course Exercise Files -- DOWNLOAD.mp4 26MB 38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4 26MB 26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp4 26MB 35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp4 26MB 25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp4 25MB 37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp4 24MB 37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4 24MB 6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp4 24MB 38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp4 24MB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp4 23MB 32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp4 23MB 25. Auditing an Excel Worksheet/4. Showing Formulas.mp4 23MB 12. Microsoft Excel 102 Course Introduction/1. Excel 102 Course Exercise Files -- DOWNLOAD.mp4 23MB 26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp4 22MB 32. Excel VBA Concepts/1. Excel VBA Concepts.mp4 22MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp4 22MB 19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp4 22MB 31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp4 22MB 24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp4 21MB 9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp4 21MB 33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp4 21MB 35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 20MB 36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp4 20MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp4 19MB 33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp4 18MB 28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp4 18MB 35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp4 18MB 10. Working with Excel Templates/1. Intro to Excel Templates.mp4 18MB 37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp4 15MB 30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp4 15MB 33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp4 15MB 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp4 14MB 31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp4 13MB 37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp4 12MB 35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp4 12MB 33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp4 12MB 37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp4 12MB 37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp4 12MB 36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp4 11MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp4 11MB 37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4 10MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp4 10MB 32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp4 9MB 37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp4 9MB 31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp4 9MB 35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp4 7MB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp4 7MB 32. Excel VBA Concepts/3. Excel VBA Modules.mp4 5MB 12. Microsoft Excel 102 Course Introduction/1.2 NorthwindDB-IMPORT.zip 468KB 2. Microsoft Excel Fundamentals/9.1 CommonExcelWindowsShortcuts-01.pdf 143KB 12. Microsoft Excel 102 Course Introduction/1.1 Excel102Exercises.xlsx 124KB 4. Working with Basic Excel Functions/1.1 EXCEL FUNCTIONS.pptx 87KB 21. Microsoft Excel 103 Course Introduction/1.1 Excel103-AdvancedExercises.xlsx 64KB 30. Microsoft Excel Macros and VBA Course Introduction/3.2 QuarterlyReportForm-01.xlsm 30KB 30. Microsoft Excel Macros and VBA Course Introduction/3.6 QuarterlyReport.xlsm 26KB 12. Microsoft Excel 102 Course Introduction/1.3 SalesData-TEXT-IMPORT.txt 25KB 37. Project #6 Working with Excel VBA User Forms/1.1 QuarterlyReportForm-01.xlsm 24KB 30. Microsoft Excel Macros and VBA Course Introduction/3.3 SortingRecords.xlsm 22KB 30. Microsoft Excel Macros and VBA Course Introduction/3.7 CleaningUpData.xlsx 21KB 30. Microsoft Excel Macros and VBA Course Introduction/3.5 AutomateSumFunction.xlsx 20KB 35. Project #4 Using VBA to Automate Excel Formulas/2.1 AutomateSumFunction.xlsx 20KB 30. Microsoft Excel Macros and VBA Course Introduction/3.1 AutomateFormulas.xlsx 19KB 24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.srt 18KB 30. Microsoft Excel Macros and VBA Course Introduction/3.4 InsertingAndFormattingText.xlsx 17KB 31. Project #1 Using Excel's Macro Recorder Tool/2.1 InsertingAndFormattingText.xlsx 17KB 3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.srt 17KB 33. Project #2 Moving Beyond the Basics and into VBA/2.1 SortingRecords.xlsm 17KB 30. Microsoft Excel Macros and VBA Course Introduction/3.8 SortingRecords.xlsx 16KB 27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.srt 16KB 23. Working with Excel's Lookup Functions/1. Microsoft Excel VLOOKUP() Function.srt 15KB 4. Working with Basic Excel Functions/1. The structure of an Excel Function.srt 15KB 3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).srt 15KB 1. Microsoft Excel 101 Course Introduction/2.4 MonthlyBudget-Template-01.xlsx 15KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.srt 14KB 1. Microsoft Excel 101 Course Introduction/2.11 MonthlyBudget-Count-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.2 MonthlyBudget-01.xlsx 14KB 23. Working with Excel's Lookup Functions/3. Microsoft Excel INDEX() Function.srt 14KB 1. Microsoft Excel 101 Course Introduction/2.7 MonthlyBudget-AutoSUM-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.3 MonthlyBudget-AverageFunction-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.6 MonthlyBudget-MIN-MAXFunctions-01.xlsx 14KB 9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.srt 14KB 1. Microsoft Excel 101 Course Introduction/2.1 MonthlyBudget-AutoFill-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.9 MonthlyBudget-SUMFunction-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.10 MonthlyBudget-BasicFormulas-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.8 MonthlyBudget-Headers-01.xlsx 14KB 1. Microsoft Excel 101 Course Introduction/2.5 MonthlyBudget-ReferenceTypes-01.xlsx 14KB 23. Working with Excel's Lookup Functions/6. Microsoft Excel INDEX() and MATCH() Function Combined Continued.srt 14KB 33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.srt 13KB 32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.srt 13KB 3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.srt 13KB 36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.srt 13KB 3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.srt 13KB 3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.srt 12KB 6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.srt 12KB 38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.srt 12KB 37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.srt 12KB 3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.srt 12KB 36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.srt 12KB 13. Working with an Excel List/7. Format a List as a Table.srt 12KB 22. Working with Excel's Conditional Functions/6. Nesting Functions with Excel.srt 12KB 16. Importing and Exporting Data/4. NEW VERSION -- Import Data From Text Files into Excel.srt 12KB 28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.srt 12KB 26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.srt 12KB 37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.srt 11KB 27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.srt 11KB 19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.srt 11KB 27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.srt 11KB 2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.srt 11KB 38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.srt 11KB 5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.srt 11KB 31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.srt 11KB 38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.srt 11KB 35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.srt 11KB 4. Working with Basic Excel Functions/7. Using the AutoSum Command.srt 11KB 32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.srt 10KB 4. Working with Basic Excel Functions/2. Working with the SUM() Function.srt 10KB 13. Working with an Excel List/6. Creating Subtotals in a List.srt 10KB 14. Excel List Functions/7. Excel Function SUBTOTAL().srt 10KB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.srt 10KB 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.srt 10KB 4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.srt 10KB 7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.srt 10KB 23. Working with Excel's Lookup Functions/7. Creating a Dynamic HLOOKUP() with the MATCH() Function.srt 9KB 23. Working with Excel's Lookup Functions/5. Microsoft Excel INDEX() and MATCH() Function Combined.srt 9KB 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.srt 9KB 16. Importing and Exporting Data/7. Exporting Data to a Text File.srt 9KB 17. Excel PivotTables/2. Creating an Excel PivotTable.srt 9KB 3. Entering and Editing Text and Formulas/7.1 OrderOfOperation-01.xlsx 9KB 38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.srt 9KB 33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.srt 9KB 24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.srt 9KB 16. Importing and Exporting Data/5. NEW VERSION -- Import Data From a Database into Excel.srt 9KB 33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.srt 9KB 24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.srt 9KB 5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.srt 9KB 22. Working with Excel's Conditional Functions/9. Using Excel's SUMIF() Function.srt 9KB 32. Excel VBA Concepts/6. Understanding Excel VBA Variables.srt 9KB 10. Working with Excel Templates/2. Opening an Existing Template.srt 9KB 14. Excel List Functions/6. Excel Function DCOUNT().srt 9KB 13. Working with an Excel List/1. Understanding Excel List Structure.srt 9KB 35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.srt 8KB 3. Entering and Editing Text and Formulas/4. Working with Cell References.srt 8KB 30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.srt 8KB 38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.srt 8KB 16. Importing and Exporting Data/2. Importing Data from Text Files.srt 8KB 23. Working with Excel's Lookup Functions/2. Microsoft Excel HLOOKUP() Function.srt 8KB 14. Excel List Functions/1. Introduction to Excels Function DSUM().srt 8KB 27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.srt 8KB 6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.srt 8KB 15. Excel Data Validation/2. Creating an Excel Data Validation List.srt 8KB 5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.srt 8KB 35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.srt 8KB 8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.srt 8KB 8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.srt 8KB 32. Excel VBA Concepts/7. Building Logic with an IF Statement.srt 8KB 28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.srt 8KB 19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.srt 8KB 22. Working with Excel's Conditional Functions/2. Advantages and Disadvantages of Excel Name Ranges.srt 8KB 5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.srt 8KB 22. Working with Excel's Conditional Functions/5. Excel's IF() Function with a Name Range.srt 8KB 7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.srt 8KB 37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.srt 8KB 14. Excel List Functions/4. Excel DSUM Function with AND Criteria.srt 8KB 22. Working with Excel's Conditional Functions/4. Using Excel's IF() Function.srt 8KB 5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.srt 8KB 8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.srt 8KB 15. Excel Data Validation/4. Adding a Custom Excel Data Validation Error.srt 8KB 30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.srt 7KB 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.srt 7KB 8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.srt 7KB 15. Excel Data Validation/1. Understanding the Need for Excel Data Validation.srt 7KB 17. Excel PivotTables/4. Grouping PivotTable Data.srt 7KB 9. Printing an Excel Worksheet/4. Adding Header and Footer Content.srt 7KB 10. Working with Excel Templates/3. Creating a Custom Template.srt 7KB 22. Working with Excel's Conditional Functions/10. Using Excel's IFERROR() Function.srt 7KB 17. Excel PivotTables/5. Formatting PivotTable Data.srt 7KB 14. Excel List Functions/2. Excel DSUM Function Single Criteria Continued.srt 7KB 14. Excel List Functions/5. Excel Function DAVERAGE().srt 7KB 23. Working with Excel's Lookup Functions/4. Microsoft Excel MATCH() Function.srt 7KB 17. Excel PivotTables/7. Creating PivotCharts.srt 7KB 5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.srt 7KB 7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.srt 7KB 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.srt 7KB 4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.srt 7KB 15. Excel Data Validation/5. Dynamic Formulas by Using Excel Data Validation Techniques.srt 7KB 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.srt 7KB 6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.srt 7KB 22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.srt 7KB 9. Printing an Excel Worksheet/3. Working with Page Layout View.srt 6KB 37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.srt 6KB 16. Importing and Exporting Data/3. Importing Data from Microsoft Access.srt 6KB 6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.srt 6KB 31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Oops! I Need to Edit My Macro.srt 6KB 2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.srt 6KB 2. Microsoft Excel Fundamentals/7. Saving an Excel Document.srt 6KB 13. Working with an Excel List/9. Removing Duplicates.srt 6KB 19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).srt 6KB 25. Auditing an Excel Worksheet/3. Working with the Watch Window.srt 6KB 15. Excel Data Validation/3. Excel Decimal Data Validation.srt 6KB 25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.srt 6KB 4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.srt 6KB 7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.srt 6KB 17. Excel PivotTables/8. Filtering PivotTable Data.srt 6KB 26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.srt 6KB 22. Working with Excel's Conditional Functions/7. Nesting Excels AND() Function within the IF() Function.srt 6KB 37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.srt 6KB 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.srt 6KB 19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.srt 6KB 33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.srt 6KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.srt 6KB 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.srt 6KB 19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).srt 6KB 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.srt 5KB 2. Microsoft Excel Fundamentals/5. More on the Excel Interface.srt 5KB 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.srt 5KB 17. Excel PivotTables/1. Understanding Excel PivotTables.srt 5KB 38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.srt 5KB 28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.srt 5KB 31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.srt 5KB 37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.srt 5KB 35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.srt 5KB 37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.srt 5KB 6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.srt 5KB 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.srt 5KB 32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.srt 5KB 38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.srt 5KB 17. Excel PivotTables/9. Filtering with the Slicer Tool.srt 5KB 37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.srt 5KB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.srt 5KB 32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).srt 5KB 36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.srt 5KB 8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.srt 5KB 33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.srt 5KB 33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.srt 5KB 2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.srt 5KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.srt 5KB 32. Excel VBA Concepts/1. Excel VBA Concepts.srt 5KB 28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.srt 5KB 6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.srt 5KB 9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.srt 5KB 26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.srt 4KB 5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.srt 4KB 4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.srt 4KB 4. Working with Basic Excel Functions/5. Working with the COUNT() Function.srt 4KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.srt 4KB 25. Auditing an Excel Worksheet/4. Showing Formulas.srt 4KB 2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.srt 4KB 36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.srt 4KB 24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.srt 4KB 6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.srt 4KB 37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.srt 4KB 38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.srt 4KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.srt 4KB 31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.srt 4KB 25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.srt 4KB 22. Working with Excel's Conditional Functions/3. Editing an Excel Name Range.srt 4KB 2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.srt 4KB 33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.srt 4KB 6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.srt 4KB 8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.srt 4KB 14. Excel List Functions/3. Excel DSUM Function with OR Criteria.srt 4KB 22. Working with Excel's Conditional Functions/8. Using Excel's COUNTIF() Function.srt 3KB 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.srt 3KB 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.srt 3KB 38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.srt 3KB 6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.srt 3KB 9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.srt 3KB 31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.srt 3KB 4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.srt 3KB 35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.srt 3KB 16. Importing and Exporting Data/6. Microsoft Excel Legacy Import Options for New Excel Versions.srt 3KB 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.srt 3KB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.srt 3KB 31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.srt 3KB 2. Microsoft Excel Fundamentals/1. Launching Excel.srt 3KB 32. Excel VBA Concepts/3. Excel VBA Modules.srt 3KB 16. Importing and Exporting Data/1. Importing Data Into Microsoft Excel.srt 2KB 2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.srt 2KB 20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.srt 2KB 28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.srt 2KB 1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.srt 2KB 10. Working with Excel Templates/1. Intro to Excel Templates.srt 2KB 29. Congratulations!/1. Congratulations on Completing the Microsoft Excel 103.srt 2KB 39. Course Wrap Up/2. BONUS! - Special Offer! Discount on Any of my Courses!.html 2KB 21. Microsoft Excel 103 Course Introduction/1. Excel 103 Course Exercise Files -- DOWNLOAD.srt 2KB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.srt 2KB 12. Microsoft Excel 102 Course Introduction/1. Excel 102 Course Exercise Files -- DOWNLOAD.srt 2KB 38. Project #7 Importing Data from Text Files/1.6 April2015Sales.txt 2KB 39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.srt 1KB 38. Project #7 Importing Data from Text Files/1.5 Nov2015Sales.txt 1KB 38. Project #7 Importing Data from Text Files/1.3 Jan2015Sales.txt 1KB 38. Project #7 Importing Data from Text Files/1.4 May2015Sales.txt 1KB 38. Project #7 Importing Data from Text Files/1.7 Mar2015Sales.txt 1KB 38. Project #7 Importing Data from Text Files/1.2 Feb2015Sales.txt 1KB 38. Project #7 Importing Data from Text Files/1.1 Dec2015Sales.txt 1KB 30. Microsoft Excel Macros and VBA Course Introduction/3. Course Exercise Files - Download these First!.html 387B 2. Microsoft Excel Fundamentals/10. Excel Fundamentals Quiz.html 167B 3. Entering and Editing Text and Formulas/8. Entering and Editing Text and Formulas Quiz.html 167B 4. Working with Basic Excel Functions/10. Basic Excel Functions Quiz.html 167B 5. Modifying an Excel Worksheet/8. Modifying Worksheets Quiz.html 167B 6. Formatting Data in an Excel Worksheet/10. Formatting Data Quiz.html 167B 8. Creating Basic Charts in Excel/7. Working with Excel Charts Quiz.html 167B 9. Printing an Excel Worksheet/6. Printing and Excel Worksheet Quiz.html 167B 14. Excel List Functions/[DesireCourse.Net].url 51B 25. Auditing an Excel Worksheet/[DesireCourse.Net].url 51B 3. Entering and Editing Text and Formulas/[DesireCourse.Net].url 51B 33. Project #2 Moving Beyond the Basics and into VBA/[DesireCourse.Net].url 51B [DesireCourse.Net].url 51B 14. Excel List Functions/[CourseClub.Me].url 48B 25. Auditing an Excel Worksheet/[CourseClub.Me].url 48B 3. Entering and Editing Text and Formulas/[CourseClub.Me].url 48B 33. Project #2 Moving Beyond the Basics and into VBA/[CourseClub.Me].url 48B [CourseClub.Me].url 48B