| 標(biāo)題 |
習(xí)題素材 |
日期 |
觀看 |
 MONTH函數(shù)提取日期的月份 |
|
2020-03-27 |
3115 |
| NETWORKDAYS函數(shù)計(jì)算上班天數(shù) |
|
2020-03-27 |
2962 |
| NETWORKDAYS.INTL函數(shù)計(jì)算六天制的工作天數(shù) |
|
2020-03-27 |
3705 |
| NOW函數(shù)插入自動(dòng)更新的日期和時(shí)間 |
|
2020-03-27 |
3541 |
| TIMEVALUE函數(shù)計(jì)算員工加班時(shí)間 |
|
2020-03-27 |
3271 |
| TIME函數(shù)生成年月日的日期 |
|
2020-03-27 |
3276 |
| Today函數(shù)提取當(dāng)天的日期 |
|
2020-03-27 |
2700 |
| WEEKDAY函數(shù)判斷日期是星期幾 |
|
2020-03-27 |
3296 |
| WEEKNUM函數(shù)計(jì)算日期是第幾周 |
|
2020-03-27 |
3268 |
| WORKDAY函數(shù)計(jì)算員工離崗到期日 |
|
2020-03-27 |
3881 |
| YEARFRAC函數(shù)計(jì)算日期占全年天數(shù)的百分比例 |
|
2020-03-27 |
3346 |
| YEAR函數(shù)提取日期的年份 |
|
2020-03-27 |
3582 |
| 第五章：查找與引用函數(shù)的使用介紹篇 |
習(xí)題下載 |
2020-03-27 |
3002 |
| ADDRESS函數(shù)可以轉(zhuǎn)化絕對(duì)引用 |
|
2020-03-28 |
3673 |
| AREAS函數(shù)計(jì)算區(qū)域個(gè)數(shù) |
|
2020-03-28 |
3005 |
| CHOOSE函數(shù)用于篩選數(shù)據(jù) |
|
2020-03-28 |
3634 |
| COLUMN函數(shù)獲取單元格列號(hào) |
|
2020-03-28 |
3297 |
| COLUMNS函數(shù)統(tǒng)計(jì)項(xiàng)目列數(shù) |
|
2020-03-28 |
3860 |
| Index函數(shù)通過(guò)行號(hào)與列號(hào)快速查找數(shù)據(jù) |
|
2020-03-29 |
3777 |
| HYPERLINK函數(shù)設(shè)置跳轉(zhuǎn)指定鏈接或位置 |
|
2020-03-29 |
4651 |
| HLOOKUP函數(shù)從橫向查找數(shù)據(jù)內(nèi)容 |
|
2020-03-29 |
3760 |
| GETPIVOTDATA函數(shù)可以查找商名的單格 |
|
2020-03-29 |
3478 |
| EVALUATE函數(shù)以計(jì)算器方式計(jì)算結(jié)果 |
|
2020-03-29 |
3418 |
| INDIRECT函數(shù)引用單元格內(nèi)容 |
|
2020-03-29 |
3249 |
| LOOKUP函數(shù)快速查找數(shù)據(jù)內(nèi)容 |
|
2020-03-29 |
3273 |
| Match函數(shù)快速匹配序號(hào) |
|
2020-03-29 |
4287 |
| Offset函數(shù)快速查找數(shù)據(jù)目標(biāo) |
|
2020-03-29 |
3310 |
| ROWS函數(shù)快速統(tǒng)計(jì)考試人數(shù) |
|
2020-03-29 |
3942 |
| ROW函數(shù)快速標(biāo)注序列號(hào) |
|
2020-03-29 |
3877 |
| vlookup怎么用詳細(xì)步驟 |
|
2020-03-29 |
4324 |
|
|
|
贛公網(wǎng)安備 36082102000008號(hào)