与常规的入门课程不同,
这个课程深入讲解了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.

  • 教程编号:0495318450
  • 教程语言:英语 / 无字幕
  • 安全扫描:无病毒无插件 / 云查杀 Virustotal Virscan
  • 培训机构:未知 / IMJMJ
  • 文件大小:2.77GB
  • 文件格式:视频 / 文档 / 图文
  • 压缩软件:7ZIP
  • 视频播放:完美解码

│  └─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


此处内容需要权限查看

您还没有获得查看权限包月包年终身可免费查看

升级VIP免费查看

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注