MIME-version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0076_01C29953.BE473C30"; type="text/html" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 This is a multi-part message in MIME format. ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: text/html; Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.TMP.html

从数据分析到工作汇报—EXCEL基础篇

基本信息
  2021/9/7 0:00:00~2021/9/7 0:00:00

  上海市 上海市

  

市场价2880.00

会员价2880.00 

 

课程介绍

培训对象

希望短时间大幅提升办公效率的业务精英
希望有效展示科研实力和水平的科技人员
希望系统的学习微软核心技术的OFFICE爱好者
需提升OFFICE应用水平,通过岗位考核的企业职员

课程目的

帮助学员树立一种正确高效使用OFFICE软件的基本理念和思路
为学员提供一套实用高效的OFFICE运用技能和方法
让EXCEL学习不会令人望而生畏,帮你快速搞定复杂的数据和图表,EXCEL高效武器会成为你的职场上的得力助手

课程大纲

理解EXCEL表格,确保数据准确性,高效分析数据
EXCEL是高效数据处理工具,经过处理后的数据用于决策依据。确保表格结构正确和基础数据准确是数据处理的关键
应用彩色的数据表,轻松洞察数据背后的信息
EXCEL数据透视表从浩瀚的数字中找出规律,挖掘您所希望了解的信息,用于决策依据


十分钟会用400个EXCEL函数
理解数学计算四步,成功推导计算方案
掌握公式中的引用,突破80%的计算瓶颈
F4/F5的妙用;选择性粘贴中的计算能力
理解函数通用格式,应用函数推导,一举会用400个函数
高频率函数组合应用:IF/VLOOKUP
 

看透图表,报告型图表随心所得
图表实为数据的表现形式,制作图表可以不用表格,但不能没有数据
无表格制图技术助您DIY图表,直观的报告型图表随心所得
双轴图表的制作技巧:预算与实际执行情况的差异分析图

 
报表保护与输出技巧
控制单元格编辑权限,共享表
打印报表中遇到的问题(标题,大表格等)

 

讲师简介 ()

 

汇款信息

公司名称:北京中人网信息咨询股份有限公司

  行:招商银行北京分行大屯路支行

    号:866180508610001

    号:976

 

联系我们

客服热线:010-52725400-800

客服传真:010-52725273

客服邮箱:exposerv@chinahrd.net

------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222142.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp145990999245478922215.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222164.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222204.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222286.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30--