حالت شب

اکسل: ردیابی داده ها به راحتی و کارآمد

Efficient data tracking in Excel
00:50

Introducing tables
05:34
Key features of an effective data tracker
06:40

Thinking about input, storage, and output
06:27
Incorporating charts into your tracker
08:13
Adding helper columns
03:21
Using Slicers to filter for details
04:06
Summary pages and dashboards
04:51
Ad hoc vs. at-a-glance needs
04:32

Protecting cells and sheets
06:37
Hidden sheets
03:23
Hidden columns and rows
04:58

Using dropdown lists for accuracy and consistency
09:19
Applying formula triggers to prevent inaccurate results
04:10
Using cross-footing as a check for data quality
05:03
Data validation for reasonable values
04:33
Times: Checking data quality
02:29

Challenge: Building a data tracker for event details
02:04
Solution: Building a data tracker for event details
06:14

Dynamic Arrays: One formula, many results
06:14
Dynamic Arrays: FILTER, UNIQUE, SORT
08:51
Dynamic Arrays: TOCOL, dropdowns, and conditional formatting
07:27

VLOOKUP
04:34
Categorizing bonuses with VLOOKUP
03:45
Merging data with XLOOKUP
05:08
Categorizing bonuses with XLOOKUP
04:01

What is a PivotTable?
09:16
Preparing and connecting a PivotTable to your data
06:54
Building and using a PivotTable
07:11

Power Query overview
10:47
Splitting columns
06:42
Append in Power Query
08:39
Unpivot and fill-down
09:39

Data bars for easy visual comparison
02:21
Connecting a value to a shape
05:33
Hiding zeroes
02:42
Conditional formatting to warn of deadlines
06:51

Challenge: Building a tracker 1
01:21
Solution: Building a tracker 1
04:54
Challenge: Building a tracker 2
02:44
Solution: Building a tracker 2
11:56

Continue your data tracking journey in Excel
01:02

00:00

00:00

Hello, world! This is a toast message.

درصورتیکه بیش از 70% یک محتوا را مشاهده نمایید، به صورت تمام شده در نظر گرفته می شود.