# 培训视频
1、数据库连接
文件夹连接 (opens new window) SqlServer连接 (opens new window) MySQL连接 (opens new window) Oracle连接 (opens new window)
2、查看表
2.1 查看整体表
表筛选 (opens new window) 查看所有表 (opens new window) 排序规则 (opens new window)
2.2 查看表内信息
查看前1000行 (opens new window) 查看所有行 (opens new window) 查看行数 (opens new window) 查看表结构 (opens new window) 查看唯一值 (opens new window) 查看部分字段 (opens new window)
2.3 数据透视
2.4 筛选
2.5 自助查询
2.6 SQL语句
3、修改表
编辑表_folder (opens new window) 编辑表_sql (opens new window) 排序 (opens new window) 修改表名 (opens new window) 修改记录 (opens new window) 修改字段_folder (opens new window) 修改字段_sql (opens new window) 字符替换 (opens new window)
4、向库增加表
创建新表_folder (opens new window) 创建新表_sql (opens new window) 导入数据_sql (opens new window) 复制表结构_folder (opens new window) 复制表结构_sql (opens new window) 选取记录 (opens new window) 选取字段 (opens new window)
5、向表增加数据
插入记录 (opens new window) 复制字段 (opens new window) 添加字段_folder (opens new window) 添加字段_sql (opens new window) 字段分列 (opens new window) 字段合并 (opens new window) 字段计算 (opens new window) 字段截取 (opens new window)
6、复制表
同库复制 (opens new window) 跨库复制 (opens new window) 跨服务器 (opens new window) 跨数据源 (opens new window)
7、跨表操作
字段匹配 (opens new window) 表合并 (opens new window) 表连接 (opens new window)
8、删除数据
批量删表 (opens new window) 删除记录 (opens new window) 删除重复项_folder (opens new window) 删除重复项_sql (opens new window) 删除字段 (opens new window)
9、导出表
10、外部数据
数据转换 (opens new window) 拆分文件 (opens new window) 读入文本 (opens new window) 网页爬虫_基本功能 (opens new window)
11、SqlCel函数
数据集函数 (opens new window) 数据库函数 (opens new window) 爬虫函数 (opens new window) 正则函数 (opens new window) 自定义函数 (opens new window)
--------------------我是SqlCel和SqlCelINN的分割线---------------------
12、统计分析
工作表查询 (opens new window) 快速统计 (opens new window) 顺序统计 (opens new window) vlookup+ (opens new window) 描述数据 (opens new window)
13、字符处理
字符提取 (opens new window) 字符过滤 (opens new window) 字符转换 (opens new window) 填充选区 (opens new window) 字符截取 (opens new window) 加上 (opens new window) 减去 (opens new window) 乘以 (opens new window) 除以 (opens new window) unix时间戳 (opens new window) 数字转日期 (opens new window) 工作休息日 (opens new window) 获取星期 (opens new window) 录入日期 (opens new window) 级联菜单 (opens new window) 分列 (opens new window)
14、单元格
查找定位 (opens new window) 新增插入 (opens new window) 批量删除 (opens new window) 合并单元格 (opens new window)
15、跨表操作
邮件合并 (opens new window) 插入目录 (opens new window) 表合并 (opens new window)
16、实用工具
环境显示 (opens new window) 快递查询 (opens new window) 翻译 (opens new window) 身份证 (opens new window) 手机号 (opens new window) IP归属地 (opens new window) 地区匹配 (opens new window) 加密选区 (opens new window) 破解密码 (opens new window)
17、二维码工具
18、其它
SqlCel培训视频是一个独立的安装包。安装后可在本地观看，亦可在SqlCel中调用观看相应的视频。
如果本地已安装SqlCel和SqlCel培训视频，打开Excel/WPS后按住Ctrl键同时用鼠标点击SqlCel的按钮即可调出该按钮对应的培训视频。如果本地没有安装培训视频安装包，亦可通过相同的方法在线播放。
对于工作面板（DBOPT表）里面的功能可通过双击单元格调出对应的培训视频。
点击以下链接可下载完整的SqlCel培训视频安装包：