EXCEL在财务中的运用实验报告.docx

1、EXCEL在财务中的运用实验报告EXCEL在财务中的运用实验报告实验报告 学院: 会计学院 专业: 会计学 班级: 成绩: 姓名: 学号: 组别: 组员: 实验地点:实验楼微机七室 实验日期: 指导教师签名: 实验 项目名称: Excel在会计和财务中的应用 一、实验目的和要求 实验要求:根据提供的“会计科目表.xls”和“会计凭证表.xls”建立“日记账”、“总分类账”“明细分类账”“科目汇总表”“科目余额表”“资产负债表”“利润表”，并且将“工资表”补充完整。 实验目的:通过用excel建立以上工作表，熟悉excel在会计上的运用，将会计知识和excel紧密结合起来，较熟练地利用excel

2、进行企业的完整日常的会计账务处理以及日常管理，对使用excel进行会计核算有更深入、更全面的认识，在实际工作中节省工作时间和成本。 二、实验内容及步骤(图片) 将会计凭证表的L3单元格签上自己的名字，并在M3设置“借贷不平衡” 1、 选中M3单元格，点击“插入”，然后点击“函数”，在“函数分类”列表框中选择“逻辑”类别函数，在“函数名”列表框中选择IF()函数。如图 2、 单击“确定”，并在IF()函数的LOGICAL_TEST、WALUE_IF_TRUE 、VALUE_IF_FLASE等自变量位置分别输入“SUM(J:J)=SUM(K:K)”、 “”、“借贷不平衡”(注意要用西文状态下的)然

3、后单击“确定如图 than ? 5mm; elevation deviation was less than ? 5mm work surface height difference is not more than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation process,

4、use tensioner to adjust the side rail. Side rail hole top center within the scope of the work is less than +2-1mm, scope of work at a 4-to-2; wrong tooth less than 1mm at the joint work surface flatness 2mm lateral curvature RADIUS is less than ? 5mm sealing plate surface distortion is less than 1mm

5、. Reinforcement process of adjustment is completed, in order to prevent tank deformation or displacement, welded tank side of the door, then welded reinforcing side, lap length is not less than 100mm. Door installation: the lintel the installation focuses on family Center sill plane distance h is le

6、ss than ? 3mm; work surface flatness of less than 2mm; combination of surface dislocation is less than 0.5mm surface distortion is less than 1.5mm. Mode with the side rail. Grid slot bi-directional gate leaf on a car lift and lower grille blade adjustment is completed with pin connection, then try c

7、onnecting rod. After you check the accessories complete the fastening, hanging out the bottom opening and closing test in still water as a whole. 8.2.3 tainter and hinge installation Setup: Pivot fixed bearing installation ? orbit stitching, alignment ? arm splicing, installation connected with the

8、headstock ? ? ? welding door leaf side connecting plates welded, water seal installation ? clean, and wipe off. 8.2.3.1 hinge installation and 3、 若输入的金额借方不等于贷方金额时，在M3单元就会出现“借贷不平衡”如图 4、 如借贷方输入正确的金额，则提示会自动消失，如图 than ? 5mm; elevation deviation was less than ? 5mm work surface height difference is not m

9、ore than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation process, use tensioner to adjust the side rail. Side rail hole top center within the scope of the work is les

10、s than +2-1mm, scope of work at a 4-to-2; wrong tooth less than 1mm at the joint work surface flatness 2mm lateral curvature RADIUS is less than ? 5mm sealing plate surface distortion is less than 1mm. Reinforcement process of adjustment is completed, in order to prevent tank deformation or displace

11、ment, welded tank side of the door, then welded reinforcing side, lap length is not less than 100mm. Door installation: the lintel the installation focuses on family Center sill plane distance h is less than ? 3mm; work surface flatness of less than 2mm; combination of surface dislocation is less th

12、an 0.5mm surface distortion is less than 1.5mm. Mode with the side rail. Grid slot bi-directional gate leaf on a car lift and lower grille blade adjustment is completed with pin connection, then try connecting rod. After you check the accessories complete the fastening, hanging out the bottom openin

13、g and closing test in still water as a whole. 8.2.3 tainter and hinge installation Setup: Pivot fixed bearing installation ? orbit stitching, alignment ? arm splicing, installation connected with the headstock ? ? ? welding door leaf side connecting plates welded, water seal installation ? clean, an

14、d wipe off. 8.2.3.1 hinge installation and 一、根据已建立好的会计凭证表建立日记账: 1、 打开“会计凭证表”，全选“会计凭证表”，复制黏贴到新工作表 2、重命名新工作表为“日记账”，将标题改为“北京维达股份有限公司日记账”并保存 、建立总分类帐 二1、打开“日记账”工作表，选择“数据”“数据透视表和图表报告”命令，在“数据透视表和数据透视图向导”对话框中选中“MICROSOFT EXCEL数据清单或数据库”和“数据透视表”单选按钮，然后单击下一步。如图 2、选中日记账的区域，然后单击下一步。如图 than ? 5mm; elevation devia

15、tion was less than ? 5mm work surface height difference is not more than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation process, use tensioner to adjust the side rai

16、l. Side rail hole top center within the scope of the work is less than +2-1mm, scope of work at a 4-to-2; wrong tooth less than 1mm at the joint work surface flatness 2mm lateral curvature RADIUS is less than ? 5mm sealing plate surface distortion is less than 1mm. Reinforcement process of adjustmen

17、t is completed, in order to prevent tank deformation or displacement, welded tank side of the door, then welded reinforcing side, lap length is not less than 100mm. Door installation: the lintel the installation focuses on family Center sill plane distance h is less than ? 3mm; work surface flatness

18、 of less than 2mm; combination of surface dislocation is less than 0.5mm surface distortion is less than 1.5mm. Mode with the side rail. Grid slot bi-directional gate leaf on a car lift and lower grille blade adjustment is completed with pin connection, then try connecting rod. After you check the a

19、ccessories complete the fastening, hanging out the bottom opening and closing test in still water as a whole. 8.2.3 tainter and hinge installation Setup: Pivot fixed bearing installation ? orbit stitching, alignment ? arm splicing, installation connected with the headstock ? ? ? welding door leaf si

20、de connecting plates welded, water seal installation ? clean, and wipe off. 8.2.3.1 hinge installation and 3、在“数据透视表和数据透视图向导”对话框中选择“新建工作表”，然后单击“布局”。如图 4、在“数据透视表和数据透视图向导”对话空中，将其布局设置如下图 5、双击“计数项:借方金额”，弹出“数字透视表字段”对话框，在“汇总方式”列表框中选择“求和”，“计数项:借方金额”改为“求和项:借方金额”。如图 than ? 5mm; elevation deviation was less t

21、han ? 5mm work surface height difference is not more than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation process, use tensioner to adjust the side rail. Side rail ho

22、le top center within the scope of the work is less than +2-1mm, scope of work at a 4-to-2; wrong tooth less than 1mm at the joint work surface flatness 2mm lateral curvature RADIUS is less than ? 5mm sealing plate surface distortion is less than 1mm. Reinforcement process of adjustment is completed,

23、 in order to prevent tank deformation or displacement, welded tank side of the door, then welded reinforcing side, lap length is not less than 100mm. Door installation: the lintel the installation focuses on family Center sill plane distance h is less than ? 3mm; work surface flatness of less than 2

24、mm; combination of surface dislocation is less than 0.5mm surface distortion is less than 1.5mm. Mode with the side rail. Grid slot bi-directional gate leaf on a car lift and lower grille blade adjustment is completed with pin connection, then try connecting rod. After you check the accessories comp

25、lete the fastening, hanging out the bottom opening and closing test in still water as a whole. 8.2.3 tainter and hinge installation Setup: Pivot fixed bearing installation ? orbit stitching, alignment ? arm splicing, installation connected with the headstock ? ? ? welding door leaf side connecting p

26、lates welded, water seal installation ? clean, and wipe off. 8.2.3.1 hinge installation and 5、 单击“数字”按钮，将单元格格式设置如下:如图 6、 在“数据透视表和数据透视图向导”对话框中将“贷方金额”按钮拖到“数据”区，按照设置“借方金额”的步骤重设“贷方金额”有关数据。 7、 返回“数据透视表和数据透视图向导”对话框，单击“完成”按钮，总分类帐已经建成，如图 than ? 5mm; elevation deviation was less than ? 5mm work surface heigh

27、t difference is not more than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation process, use tensioner to adjust the side rail. Side rail hole top center within the sco

28、pe of the work is less than +2-1mm, scope of work at a 4-to-2; wrong tooth less than 1mm at the joint work surface flatness 2mm lateral curvature RADIUS is less than ? 5mm sealing plate surface distortion is less than 1mm. Reinforcement process of adjustment is completed, in order to prevent tank de

29、formation or displacement, welded tank side of the door, then welded reinforcing side, lap length is not less than 100mm. Door installation: the lintel the installation focuses on family Center sill plane distance h is less than ? 3mm; work surface flatness of less than 2mm; combination of surface d

30、islocation is less than 0.5mm surface distortion is less than 1.5mm. Mode with the side rail. Grid slot bi-directional gate leaf on a car lift and lower grille blade adjustment is completed with pin connection, then try connecting rod. After you check the accessories complete the fastening, hanging

31、out the bottom opening and closing test in still water as a whole. 8.2.3 tainter and hinge installation Setup: Pivot fixed bearing installation ? orbit stitching, alignment ? arm splicing, installation connected with the headstock ? ? ? welding door leaf side connecting plates welded, water seal ins

32、tallation ? clean, and wipe off. 8.2.3.1 hinge installation and 8、选中第一行，右键“插入”按钮，选中A1、F1，单击“合并及居中”，并在A1单元格输入“北京维达股份有限公司总分类账”并居中加粗。 9、将“数据”标题字段处拖动“数据”到“汇总”字段处。总分类账的页面如图 10、选中“科目代码”中的任意一个单元格并单击鼠标右键，在弹出的快捷菜单中选中“字段设置”命令;打开“数据透视表字段”对话框的“分类汇总”选项中选中“无”，单击“高级”按钮，打开“数据透视表字段高级选项”对话框的“自动排序选项”，选中“升序”如图，然后按确定 如图 than ? 5mm; elevation deviation was less than ? 5mm work surface height difference is not more than 3mm on the one end to the other end; wrong tooth at the joint is less than 1mm. Side rail mounting: side rail installation take each side rail on two points. During the installation proce