搜索
浅析excel在会计中的应用摘要:自2002年起随着计算机技术的不断得到普及和发展。计算机开始应用到各个领域。与此同时会计的信息化也已逐渐成为社会发展必不可少的条件，而excel作为会计工作中常用电子表格的软件。它所具备的很多功能除了例如数据图表的处理、自动管理、编辑、分析等多种功能。对于会计工作excel是可以准确方便地处理会计信息工作，是目前会计管理工作中常用软件。在日常会计工作会计人员会经常的需要提供各种各样的会计分析数据。而excel的电子表格可以有效地通过表格来解决会计工作中的各种问题，它也可以利用编程的数据等处理一些问题，使数据结果可以一目了然，简单快捷，可以大大的提高会计工作的管理信息。因此excel在会计工作中的应用是十分普遍广泛的。关键词：Excel会计应用Abstract：Since2002,withcomputertechnologycontinuestogainpopularityanddevelopment.Itbeginsappliedtovariousfields.Atthesametimeaccountinginformationtechnologyhasgraduallybecomeanindispensableconditionofsocialdevelopment,accountingandexcelasacommonspreadsheetsoftware.Ithasmanyfeaturesinadditiontoavarietyoffunctionssuchasdataprocessing,automaticmanagementofthechart,editing,analysis,etc.Foraccountingexcelcaneasilyhandleaccuratejobaccountinginformation,managementaccountingiscommonlyusedsoftware.Dailyaccountingaccountingstaffwilloftenneedtoprovideavarietyofaccountingdataanalysis.Theexcelspreadsheetcanbesoeffectiveintheactualaccountingworktosolveproblemsinavarietyofformsthroughwhichyoucanalsousetheprogramdataandtheliketodealwithsomeissues,sothatthedataresultscanbeclear,simpleandquick,cangreatlyimproveaccountingmanagementinformation.Thereforeexcelapplicationintheaccountingworkisverycommonextensive.Keywords:Excel、accounting、application目录摘要..................................................................................................................................................1引言：..............................................................................................................................................3一、研究背景...................................................................................................................................3（一）Excel的定义................................................................................................................3（二）Excel平台的特点..........................................................................................................3（三）Excel平台的功能..........................................................................................................4二、Excel在会计中的发展现况......................................................................................................4（一）我国信息化的发展背景...............................................................................................4（二）当前会计信息系统存在的缺陷...................................................................................51、会计信息系统难以完善.............................................................................................52、会计信息管理尚不完整.............................................................................................53、企业的信息管理不易维护.........................................................................................5（三）Excel在会计工作中所应用到的功能.........................................................................51、对数据表格的处理.....................................................................................................52、对表格数据进行分析.................................................................................................63、可以对照数据制定相应的图表.................................................................................6三、Excel在会计中的应用............................................................................................................6（一）Excel财务会计中的运用..............................................................................................71、用Excel编制会计报表...............................................................................................72、用Excel填制记账凭证.............................................................................................83、用Excel检索记账凭证.............................................................................................8（二）Excel在管理会计中的运用..........................................................................................8（三）Excel在会计数据中的运用..........................................................................................91、保护数据.....................................................................................................................92、共享数据...................................................................................................................10（四）Excel库存管理中的应用............................................................................................10（五）Excel在函数运算中的应用........................................................................................11（六）Excel的图表应用.......................................................................................................11四、Excel在会计应用中存在的问题..........................................................................................11（一）财务处理模型不健全,降低了Excel使用效率..........................................................11（二）部分财务人员业务素质过低，Excel合理应用受到局限.......................................12（三）自身功能较少解决不了较多的会计问题.................................................................12五、如何解决Excel在我国会计工作中存在的问题................................................................13（一）建立财务处理Excel模型................................................