磁石

[ WebToolTip.com ] Udemy - Microsoft Excel - From Beginner to Confident User

正在检测能否在线播放…

大小
1.6 GB
文件数
157
分类
视频
热度
846
最近活跃
25 分钟前

文件列表

  • Get Bonus Downloads Here.url180 B
  • ~Get Your Files Here !/1 - Getting started with Excel/1. The Excel Interface Tour.mp414.4 MB
  • ~Get Your Files Here !/1 - Getting started with Excel/2. Creating and Saving Workbooks.mp417.3 MB
  • ~Get Your Files Here !/1 - Getting started with Excel/3. FitMart_Sales_Data_2022_2024.xlsx460.7 KB
  • ~Get Your Files Here !/1 - Getting started with Excel/3. Navigating Worksheets Fast.mp427.1 MB
  • ~Get Your Files Here !/1 - Getting started with Excel/4. Adding and Renaming Sheets.mp414.1 MB
  • ~Get Your Files Here !/1 - Getting started with Excel/4. Sales Data_XL n CAD.xlsx12.0 KB
  • ~Get Your Files Here !/1 - Getting started with Excel/5. FitMart_Sales_Data_2022_2024.xlsx460.7 KB
  • ~Get Your Files Here !/1 - Getting started with Excel/5. Sales Data_XL n CAD.xlsx12.8 KB
  • ~Get Your Files Here !/1 - Getting started with Excel/5. Selecting Cells Like a Pro.mp428.6 MB
  • ~Get Your Files Here !/1 - Getting started with Excel/6. Undo Redo and Repeat.mp418.0 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/10. Cell Alignment and Wrapping.mp415.0 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/10. Cell Alignment and Wrapping.xlsx11.4 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/11. Bold Italic Colours and Borders.mp429.4 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/11. Cell Formatting.xlsx10.2 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/12. Column Width and Row Height Tricks.mp428.1 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/12. Column Width and Row Height Tricks.xlsx350.2 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/13. Copy Paste and Paste Special.xlsx17.4 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/13. Copy, Paste and Paste Special.mp428.6 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/14. Fill Handle and Flash Fill.mp419.7 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/14. Fill Handle and Flash Fill.xlsx11.6 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/15. Find and Replace Like a Pro.xlsx18.8 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/15. Find and Replace like a Pro.mp437.6 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/16. Freeze Panes and Split View.mp433.9 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/16. Freeze Panes and Split View.xlsx460.7 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/7. Typing and Editing Data.mp49.1 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/8. Number Text and Date Basics.mp48.5 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/8. Number Text and Date Basics.xlsx10.6 KB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/9. Custom Number Formats.mp436.6 MB
  • ~Get Your Files Here !/2 - Entering and Formatting Data/9. Custom Number Formats.xlsx11.7 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/17. How Formulas Work in Excel (Solved).xlsx10.2 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/17. How Formulas Work in Excel.mp420.5 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/17. How Formulas Work in Excel.xlsx9.7 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/18. S3C2 SUM Function.xlsx15.0 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/18. SUM Function.mp426.8 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/19. AVERAGE Function.mp421.2 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/19. S3C3_AVERAGE Function.xlsx17.2 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/20. COUNT Function.mp427.5 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/20. S3C4_COUNT Function.xlsx15.0 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/21. MAX Function.mp429.9 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/21. S3C5_MAX Function (Solved).xlsx16.5 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/21. S3C5_MAX Function.xlsx16.1 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/22. IF Function.mp417.7 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/22. S3C6 IF Function (Solved).xlsx10.4 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/22. S3C6 IF Function.xlsx9.9 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/23. Nested IF.mp421.7 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/23. S3C7_Nested IF (Solved).xlsx10.6 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/23. S3C7_Nested IF.xlsx10.1 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/24. COUNTIF Function.mp443.2 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/24. S3C8 COUNTIF (Solved).xlsx11.9 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/24. S3C8 COUNTIF.xlsx11.9 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/25. COUNTIFS Function.mp430.4 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/25. S3C9 COUNTIFS (Solved).xlsx11.7 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/25. S3C9 COUNTIFS.xlsx11.7 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/26. S3C10 SUMIF (Solved).xlsx13.0 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/26. S3C10 SUMIF.xlsx12.7 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/26. SUMIF Function.mp431.9 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/27. S3C11 SUMIFS (Solved).xlsx13.2 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/27. S3C11 SUMIFS.xlsx12.9 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/27. SUMIFS Function.mp438.1 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/28. AVERAGEIFS Function.mp444.2 MB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/28. S3C12 AVERAGEIFS (Solved).xlsx13.3 KB
  • ~Get Your Files Here !/3 - How Formulas Work in Excel/28. S3C12 AVERAGEIFS.xlsx12.9 KB
  • ~Get Your Files Here !/4 - References and Error Handling/29. Relative and Absolute References (Intro).mp427.8 MB
  • ~Get Your Files Here !/4 - References and Error Handling/29. S3C13_Absolute and Relative References.xlsx1.3 MB
  • ~Get Your Files Here !/4 - References and Error Handling/30. Relative and Absolute References.mp431.7 MB
  • ~Get Your Files Here !/4 - References and Error Handling/30. S3C13_Absolute and Relative References (Solved).xlsx1.3 MB
  • ~Get Your Files Here !/4 - References and Error Handling/30. S3C13_Absolute and Relative References_Practice file.xlsx1.3 MB
  • ~Get Your Files Here !/4 - References and Error Handling/31. Named Ranges.mp422.2 MB
  • ~Get Your Files Here !/4 - References and Error Handling/31. S4C3_Named Ranges (Solved).xlsx1.3 MB
  • ~Get Your Files Here !/4 - References and Error Handling/31. S4C3_Named Ranges_Practice file.xlsx1.3 MB
  • ~Get Your Files Here !/4 - References and Error Handling/32. Error Handling.mp413.8 MB
  • ~Get Your Files Here !/4 - References and Error Handling/32. S4C4_Error Handling (Solved).xlsx10.4 KB
  • ~Get Your Files Here !/4 - References and Error Handling/32. S4C4_Error Handling_Practice file.xlsx10.0 KB
  • ~Get Your Files Here !/4 - References and Error Handling/33. Logical Functions.mp427.7 MB
  • ~Get Your Files Here !/4 - References and Error Handling/33. S4C5_AND and OR (Solved).xlsx10.7 KB
  • ~Get Your Files Here !/4 - References and Error Handling/33. S4C5_AND and OR_Practice file.xlsx10.2 KB
  • ~Get Your Files Here !/5 - Working with Data/34. S5C1_Sort Data (Solved).xlsx12.0 KB
  • ~Get Your Files Here !/5 - Working with Data/34. S5C1_Sort Data_Practice file.xlsx12.1 KB
  • ~Get Your Files Here !/5 - Working with Data/34. Sort Data.mp424.0 MB
  • ~Get Your Files Here !/5 - Working with Data/35. Filter Data.mp422.6 MB
  • ~Get Your Files Here !/5 - Working with Data/35. S5C2_Filter Data (Solved).xlsx12.1 KB
  • ~Get Your Files Here !/5 - Working with Data/35. S5C2_Filter Data_Practice file.xlsx12.1 KB
  • ~Get Your Files Here !/5 - Working with Data/36. Advanced Filter.mp430.3 MB
  • ~Get Your Files Here !/5 - Working with Data/36. S5C3_Advanced Filter (Solved).xlsx12.0 KB
  • ~Get Your Files Here !/5 - Working with Data/36. S5C3_Advanced Filter_Practice file.xlsx11.1 KB
  • ~Get Your Files Here !/5 - Working with Data/37. Excel Table.mp422.0 MB
  • ~Get Your Files Here !/5 - Working with Data/37. S5C4_Excel Table (Solved).xlsx10.3 KB
  • ~Get Your Files Here !/5 - Working with Data/37. S5C4_Excel Table_Practice file.xlsx9.5 KB
  • ~Get Your Files Here !/5 - Working with Data/38. Remove duplicates.mp423.9 MB
  • ~Get Your Files Here !/5 - Working with Data/38. S5C5 Remove duplicates (Solved).xlsx18.1 KB
  • ~Get Your Files Here !/5 - Working with Data/38. S5C5 Remove duplicates_Practice file.xlsx18.5 KB
  • ~Get Your Files Here !/5 - Working with Data/39. S5C6_Text to Columns (Solved).xlsx12.2 KB
  • ~Get Your Files Here !/5 - Working with Data/39. S5C6_Text to Columns_Practice file.xlsx11.5 KB
  • ~Get Your Files Here !/5 - Working with Data/39. Text to Columns.mp417.8 MB
  • ~Get Your Files Here !/5 - Working with Data/40. Data Validation.mp432.3 MB
  • ~Get Your Files Here !/5 - Working with Data/40. S3C7_Data Validation (Solved).xlsx11.4 KB
  • ~Get Your Files Here !/5 - Working with Data/40. S3C7_Data Validation_Practice file.xlsx10.4 KB
  • ~Get Your Files Here !/5 - Working with Data/41. Conditional Formatting Basics.mp433.0 MB
  • ~Get Your Files Here !/5 - Working with Data/41. S5C8_Conditional Formatting (Solved).xlsx18.2 KB
  • ~Get Your Files Here !/5 - Working with Data/41. S5C8_Conditional Formatting_Practice file.xlsx12.1 KB
  • ~Get Your Files Here !/5 - Working with Data/42. Conditional Formatting with Formulas.mp435.7 MB
  • ~Get Your Files Here !/5 - Working with Data/42. S5C9_Conditional Formatting with Formulas (Solved).xlsx12.6 KB
  • ~Get Your Files Here !/5 - Working with Data/42. S5C9_Conditional Formatting with Formulas_Practice file.xlsx12.3 KB
  • ~Get Your Files Here !/5 - Working with Data/43. Protecting Sheets and Cells.mp436.2 MB
  • ~Get Your Files Here !/5 - Working with Data/43. S5C10_Protecting worksheets (Solved).xlsx14.9 KB
  • ~Get Your Files Here !/5 - Working with Data/43. S5C10_Protecting worksheets_Practice file.xlsx14.5 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/44. S6C1_VLOOKUP Function (Solved).xlsx27.2 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/44. S6C1_VLOOKUP Function.xlsx26.8 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/44. VLOOKUP Function.mp447.9 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/45. S6C2_VLOOKUP Pitfalls (Solved).xlsx27.4 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/45. S6C2_VLOOKUP Pitfalls.xlsx27.2 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/45. VLOOKUP Pitfalls.mp424.0 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/46. HLOOKUP Function.mp416.9 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/46. S6C3_HLOOKUP Function (Solved).xlsx10.3 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/46. S6C3_HLOOKUP Function.xlsx10.3 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/47. INDEX MATCH Formula.mp455.8 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/47. S6C4_INDEX MATCH Formula (Solved).xlsx27.3 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/47. S6C4_INDEX MATCH Formula.xlsx26.9 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/48. S6C5_XLOOKUP Function (Solved).xlsx27.3 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/48. S6C5_XLOOKUP Function.xlsx26.9 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/48. XLOOKUP Function.mp451.7 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/49. S6C6_S6C6 XLOOKUP Returning Multiple Values (Solved).xlsx27.8 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/49. S6C6_S6C6 XLOOKUP Returning Multiple Values.xlsx26.9 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/49. XLOOKUP Returning Multiple Values.mp423.3 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/50. 2 Way Lookup using INDEX MATCH.mp430.4 MB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/50. S6C7_2 Way Lookup using INDEX MATCH (Solved).xlsx10.8 KB
  • ~Get Your Files Here !/6 - Lookup and Reference Functions/50. S6C7_2 Way Lookup using INDEX MATCH.xlsx10.2 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/51. Choosing the Right Chart Type.mp423.8 MB
  • ~Get Your Files Here !/7 - Charts and Visualisation/51. S1C1 Choosing the Right Chart Type.xlsx29.0 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/52. Creating a Column Bar Chart.mp419.2 MB
  • ~Get Your Files Here !/7 - Charts and Visualisation/52. S8C2 Creating a Column Bar Chart (Solved).xlsx16.4 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/52. S8C2 Creating a Column Bar Chart.xlsx11.3 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/53. Pie and Doughnut Charts.mp420.7 MB
  • ~Get Your Files Here !/7 - Charts and Visualisation/53. S8C4 Pie and Doughnut Charts (Solved).xlsx20.2 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/53. S8C4 Pie and Doughnut Charts.xlsx11.2 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/54. Combo Charts.mp416.4 MB
  • ~Get Your Files Here !/7 - Charts and Visualisation/54. S8C5 Combo Charts (Solved).xlsx16.5 KB
  • ~Get Your Files Here !/7 - Charts and Visualisation/54. S8C5 Combo Charts.xlsx11.4 KB
  • ~Get Your Files Here !/8 - PivotTables/55. Sales Data.xlsx18.0 KB
  • ~Get Your Files Here !/8 - PivotTables/55. What is a PivotTable.mp416.9 MB
  • ~Get Your Files Here !/8 - PivotTables/56. Creating your first PivotTable.mp437.6 MB
  • ~Get Your Files Here !/8 - PivotTables/56. Sales Data (Solved).xlsx26.2 KB
  • ~Get Your Files Here !/8 - PivotTables/56. Sales Data.xlsx17.9 KB
  • ~Get Your Files Here !/8 - PivotTables/57. Grouping Dates in a PivotTable.mp428.3 MB
  • ~Get Your Files Here !/8 - PivotTables/57. Sales Data (Solved).xlsx26.0 KB
  • ~Get Your Files Here !/8 - PivotTables/57. Sales Data.xlsx17.9 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/58. Dynamic Arrays and the Spill.mp414.4 MB
  • ~Get Your Files Here !/9 - Dynamic Arrays/58. S10C1 Dynamic Arrays and the Spill (Solved).xlsx11.2 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/58. S10C1 Dynamic Arrays and the Spill.xlsx10.2 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/59. FILTER Function.mp473.3 MB
  • ~Get Your Files Here !/9 - Dynamic Arrays/59. S10C2_FILTER Function (Solved).xlsx24.6 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/59. S10C2_FILTER Function.xlsx21.8 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/60. S10C2_SORT and SORTBY Functions (Solved).xlsx23.4 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/60. S10C2_SORT and SORTBY Functions.xlsx17.7 KB
  • ~Get Your Files Here !/9 - Dynamic Arrays/60. SORT and SORTBY.mp443.8 MB
  • ~Get Your Files Here !/Bonus Resources.txt70 B

相关资源

举报这个资源