 与常规的入门课程不同，
这个课程深入讲解了Excel专业使用者所用的高级工具和技巧，
提供了非常清晰的演示和真实的案例研究。
这个课程的结构并非线性，
你可以在各个部分之间自由导航，
接触到独立且自含的视频演示，
实现快速、碎片化的学习。
课程涵盖了六个类别——生产力、格式化、公式、可视化、数据透视表和分析——每个演示从简单开始，
难度逐渐提高。
这个有转变性的课程着重于可读性和易理解性，
确保Excel爱好者，
无论他们的专业技能如何，
都可以从初学者顺利过渡到专业人士。
Unlike conventional introductions, this course delves into advanced tools and techniques used by Excel professionals, offering crystal-clear demos and real-world case studies.
Featuring a non-linear structure, you can freely navigate between sections, accessing independent and self-contained video demos for quick, bite-sized learning.
Covering six categories – Productivity, Formatting, Formula, Visualization, Pivot Table, and Analytics – each demo starts simple and gradually advances in complexity.
With a focus on readability and ease of understanding, this transformative course ensures that Excel enthusiasts, regardless of their expertise, can seamlessly transition from beginners to pros.
│ └─Excel Pro Tips
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─1.Getting Started
│ │ 01.Course Structure & Outline.mp4
│ │ 02.Setting Expectations.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─2.Excel Productivity Tips
│ │ 03.Introduction.mp4
│ │ 04.Customizing the Excel Footer.mp4
│ │ 05.Navigating Excel Workbooks with CTRL Shortcuts.mp4
│ │ 06.Accessing Excel Ribbon Tools with ALT Key Tips.mp4
│ │ 07.Accessing Excel's 'Go To' Special Options.mp4
│ │ 08.Removing Blank Rows in Excel Worksheets.mp4
│ │ 09.Creating Drop-Down Menus in Excel with Data Validation.mp4
│ │ 10.Filling in Patterns with Autofill & Flash Fill.mp4
│ │ 11.Customizing the Excel Ribbon Tools.mp4
│ │ 12.Splitting Text to Columns in Excel.mp4
│ │ 13.Synchronous Scrolling Across Multiple Excel Workbooks.mp4
│ │ 14.Extracting Unique Values from a List in Excel.mp4
│ │ 15.Using Named Range & Table References in Excel Formulas.mp4
│ │ 16.Protecting Cells & Formulas in Excel Workbooks.mp4
│ │ 17.Multi-Level Row & Column Sorting.mp4
│ │ 18.Configuring Advanced Filter Criteria in Excel.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─3.Excel Formatting Tips
│ │ 19.Introduction.mp4
│ │ 20.Excel Formatting Shortcuts.mp4
│ │ 21.Snapping Objects to the Excel Grid.mp4
│ │ 22.Hiding Excel Workbook Elements.mp4
│ │ 23.Replicating Formats & Styles with Excel's Format Painter.mp4
│ │ 24.Colour & Border Design Tips in Excel.mp4
│ │ 25.Freezing Panes in Excel Worksheets.mp4
│ │ 26.Centering Across a Selection.mp4
│ │ 27.Creating an 'Invisible' Format.mp4
│ │ 28.Zip Codes & Phone Numbers.mp4
│ │ 29.Grouping Worksheet Columns & Rows.mp4
│ │ 30.Formatting Excel Errors with IFERROR.mp4
│ │ 31.Converting Excel Text to Dates.mp4
│ │ 32.Creating Dynamic Formats with Excel Formulas.mp4
│ │ 33.Advanced Excel Number Formats.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─4.Excel Formula Tips
│ │ 34.Introduction.mp4
│ │ 35.Manual vs. Automatic Calculation Modes in Excel.mp4
│ │ 36.Adding Line Breaks to Excel Formulas.mp4
│ │ 37.Converting Units of Measurement with Excel Formulas.mp4
│ │ 38.Building Real-Time Tools with TODAY & NOW Functions.mp4
│ │ 39.Excel Formula Auditing Tools.mp4
│ │ 40.Designing Pivot-Style Reports with Excel Formulas.mp4
│ │ 41.Counting Words in Excel with LEN & SUBSTITUTE Functions.mp4
│ │ 42.Configuring Dependent Drop-Down Menus with INDIRECT.mp4
│ │ 43.Creating Custom Hyperlinks Between Excel Worksheets.mp4
│ │ 44.Using Approximate Match VLOOKUP Functions.mp4
│ │ 45.Randomizing a Selection with OFFSET & RANDBETWEEN Functions.mp4
│ │ 46.Combining INDEX & MATCH Functions.mp4
│ │ 47.Finding Matching Items Across Lists in Excel.mp4
│ │ 48.Counting Duplicate Values with SUMPRODUCT.mp4
│ │ 49.Using Many-to-Many Lookups in Excel.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─5.Excel Visualization Tips
│ │ 50.Introduction.mp4
│ │ 51.Configuring Excel Chart Properties (Move & Size).mp4
│ │ 52.Managing Hidden Chart Source Data in Excel Worksheets.mp4
│ │ 53.Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365).mp4
│ │ 54.Customizing Excel Charts to Tell a Story.mp4
│ │ 55.Adding Sparklines to Worksheet Cells.mp4
│ │ 56.Designing Custom Chart Templates in Excel.mp4
│ │ 57.Building Excel Heat Maps Using Colour Scales.mp4
│ │ 58.Analysing Distribution with Histograms.mp4
│ │ 59.Goal Pacing with Custom Excel Gauge Charts.mp4
│ │ 60.Highlighting Time Periods with Combo Charts.mp4
│ │ 61.Configuring Dynamic Chart Source Ranges.mp4
│ │ 62.Creating Interactivity with Excel Form Controls.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─6.Excel Pivot Table Tips
│ │ 63.Introduction.mp4
│ │ 64.Customizing the Pivot Table Field List.mp4
│ │ 65.Autofitting Column Width in Pivot Tables.mp4
│ │ 66.Pivot Table Outline & Tabular Layouts.mp4
│ │ 67.Counting Non-Numerical Fields Using Pivots.mp4
│ │ 68.Grouping & Ungrouping Dates with Pivot Tables.mp4
│ │ 69.Enabling Multiple Pivot Table Filters.mp4
│ │ 70.Grouping Values into Buckets with Pivot Tables.mp4
│ │ 71.Adding Value Calculations to Pivot Tables.mp4
│ │ 72.Configuring Pivot Table Errors & Empty Items.mp4
│ │ 73.Configuring Pivot Table Slicers & Timelines.mp4
│ │ 74.Advanced Pivot Table Conditional Formatting.mp4
│ │ 75.Removing & Reviving Pivot Table Source Data.mp4
│ │ 76.Adding Custom Sort Lists in Excel.mp4
│ │ 77.Solve Order & List Formula Reports.mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ ├─7.Excel Analytics Tips
│ │ 78.Introduction.mp4
│ │ 79.Excel Quick Analysis Tools.mp4
│ │ 80.Comparing Outcomes Using the Scenario Manager.mp4
│ │ 81.Solving Simple Optimizations with Goal Seek.mp4
│ │ 82.Creating Basic Forecasts in Excel.mp4
│ │ 83.Building an Outlier Detection Tool in Excel.mp4
│ │ 84.Generating Automated Data Tables.mp4
│ │ 85.Connecting & Transforming Data with Power Query.mp4
│ │ 86.Creating Relational Data Models in Excel.mp4
│ │ 87.Accessing the Data Model with CUBE Functions.mp4
│ │ 88.Building a Monte Carlo Simulation in Excel.mp4
│ │ 89.Advanced Optimization with Solver.mp4
│ │ 90.Excel Analysis ToolPak (Preview).mp4
│ │ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ │ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
│ │
│ └─Exercise Files
│ Excel_Pro_Tips.pdf
│ Excel_Pro_Tips.xlsx
│ Excel_Pro_Tips_COMPLETE.xlsx
│ kickstarter_projects.csv
│ 点击进入 外贸跨境出海培训教程网站 - CHUHAI5.COM .html
│ 点击进入 最新的海外英文教程分享网 - IMJMJ.COM .html
 | 
社交营销
103 人阅读
|
0 人回复
|
2024-05-20
