资源中心

“我是会计”之处女座会计教你刷报表—财务必备的Excel技能(1)

最近陈会计接手了一项审核客户内部报表的工作,看着客户那些五花八门的报表,让她非常抓狂,她罗列出了很多问题,比如格式不统一,相同的报表有好几个版本,数据都是纯手工录入。

陈会计是典型的处女座,她对财务报表的要求,一是格式完美,让报表的使用者一目了然;二是计算自动化完美,方便报表的编制者。

如何制作出一张完美的报表,让处女座的陈会计来教你一些实用的Excel小技巧吧。

1 格式刷的妙用
  • 双击格式刷,可以无限制的刷格式

Step 1: 选中标准格式后,双击格式刷

Step 2: 选中想要刷新的单元格,刷区域刷整表都可以,可以无限次点击,取消按”ESC”.

  • 双击格式刷,可以代替复制粘贴

Step 1: 选中需要复制的区域,双击格式刷。

Step 2: 选中需要粘贴单元格的位置,按”回车”即可将复制的内容粘贴。

  • 双击格式刷,为查找的单元格统一添加格式

Step 1: 选中需要格式刷的单元格,双击格式刷。

Step 2: Ctrl+F跳出查找框,查找框中自动显示了需要格式刷的文字,点击”查找全部”

Step 3: Ctrl+A 即能将相同文字刷成所需的格式了。


2 拆分合并单元格,填充数据到每行

每次将合并单元格拆分后,都要手动将空白的表格重新填充?下面这个小方法可以帮助你迅速解决这个问题。

Step 1: 选中合并的单元格,点击”取消合并单元格”

Step 2: Ctrl+G, 点击”定位”,选定”空值”,确定。

Step 3: =B3后,Ctrl+回车,即可实现所有拆分后的单元格填充。


3 快速核对两个表中数值不同的单元格

同样的报表有2个版本,不知道哪里的数据做了修改?用这个简单的“复制”、“粘贴”就可以迅速找到修改的金额!

Step 1: 选中左表中的数据部分,Ctrl+C复制

Step 2: 选中右边表格,点击“选择性粘贴” ,选择“减”,按“确定”,就能迅速得出两表中哪个数据不同了。



财务工作重复性高,恰当使用简介有效的方法,对提高工作效率、提升工作质量具有非常大的作用,希望此篇文章对各位财务人员有所帮助。

你是处女座吗?那来做会计吧,我们欣赏你的强迫症、挑剔、完美主义······

预告
下一期“我是会计”系列内容,将带来处女座会计教你刷报表—财务必备的Excel技能(2),我们会分享简单易用的函数公式,让财务工作更有效,欢迎持续关注。

如果还有其他疑问,记得联络我们▼

林晔女士
助理董事,会计服务
邮箱:jessielin@SBASF.com
电话:021- 6186 7618

中瀚石林将陆续为大家带来"我是会计” 原创系列,分享会计、财务等相关知识和技巧。内容出品自我们资深的专业团队,欢迎关注及探讨!如有任何意见及建议,请留言或发送邮件至info@sbasf.com

免责声明
本文容仅供参考,并不构成任何具体的业务建议。对于文中可能出现的错误或遗漏,以及由此引发的损失,中瀚石林不承担任何责任。在进行具体的业务决定之前,请咨询中瀚石林专业服务团队。中瀚石林拥有对此声明的最终解释权。

Array
(
    [0] => D:\XAMPP\htdocs\index.php
    [1] => D:\XAMPP\htdocs\includes\defines.php
    [2] => D:\XAMPP\htdocs\includes\framework.php
    [3] => D:\XAMPP\htdocs\libraries\import.legacy.php
    [4] => D:\XAMPP\htdocs\libraries\platform.php
    [5] => D:\XAMPP\htdocs\libraries\loader.php
    [6] => D:\XAMPP\htdocs\libraries\legacy\error\error.php
    [7] => D:\XAMPP\htdocs\libraries\joomla\log\log.php
    [8] => D:\XAMPP\htdocs\libraries\joomla\log\entry.php
    [9] => D:\XAMPP\htdocs\libraries\joomla\date\date.php
    [10] => D:\XAMPP\htdocs\libraries\cms.php
    [11] => D:\XAMPP\htdocs\libraries\vendor\autoload.php
    [12] => D:\XAMPP\htdocs\libraries\vendor\composer\autoload_real.php
    [13] => D:\XAMPP\htdocs\libraries\vendor\composer\ClassLoader.php
    [14] => D:\XAMPP\htdocs\libraries\vendor\composer\autoload_namespaces.php
    [15] => D:\XAMPP\htdocs\libraries\vendor\composer\autoload_psr4.php
    [16] => D:\XAMPP\htdocs\libraries\vendor\composer\autoload_classmap.php
    [17] => D:\XAMPP\htdocs\libraries\vendor\composer\autoload_files.php
    [18] => D:\XAMPP\htdocs\libraries\vendor\ircmaxell\password-compat\lib\password.php
    [19] => D:\XAMPP\htdocs\libraries\cms\class\loader.php
    [20] => D:\XAMPP\htdocs\libraries\classmap.php
    [21] => D:\XAMPP\htdocs\libraries\fof\include.php
    [22] => D:\XAMPP\htdocs\libraries\fof\autoloader\fof.php
    [23] => D:\XAMPP\htdocs\libraries\cms\error\page.php
    [24] => D:\XAMPP\htdocs\libraries\cms\version\version.php
    [25] => D:\XAMPP\htdocs\configuration.php
    [26] => D:\XAMPP\htdocs\libraries\joomla\factory.php
    [27] => D:\XAMPP\htdocs\libraries\cms\application\cms.php
    [28] => D:\XAMPP\htdocs\libraries\joomla\application\web.php
    [29] => D:\XAMPP\htdocs\libraries\joomla\application\base.php
    [30] => D:\XAMPP\htdocs\libraries\vendor\joomla\application\src\AbstractApplication.php
    [31] => D:\XAMPP\htdocs\libraries\vendor\psr\log\Psr\Log\LoggerAwareInterface.php
    [32] => D:\XAMPP\htdocs\libraries\cms\application\site.php
    [33] => D:\XAMPP\htdocs\libraries\joomla\input\input.php
    [34] => D:\XAMPP\htdocs\libraries\joomla\filter\input.php
    [35] => D:\XAMPP\htdocs\libraries\vendor\joomla\registry\src\Registry.php
    [36] => D:\XAMPP\htdocs\libraries\joomla\application\web\client.php
    [37] => D:\XAMPP\htdocs\libraries\joomla\uri\uri.php
    [38] => D:\XAMPP\htdocs\libraries\vendor\joomla\uri\src\Uri.php
    [39] => D:\XAMPP\htdocs\libraries\vendor\joomla\uri\src\AbstractUri.php
    [40] => D:\XAMPP\htdocs\libraries\vendor\joomla\uri\src\UriInterface.php
    [41] => D:\XAMPP\htdocs\libraries\vendor\joomla\uri\src\UriHelper.php
    [42] => D:\XAMPP\htdocs\libraries\joomla\event\dispatcher.php
    [43] => D:\XAMPP\htdocs\libraries\joomla\object\object.php
    [44] => D:\XAMPP\htdocs\libraries\cms\application\helper.php
    [45] => D:\XAMPP\htdocs\libraries\joomla\session\session.php
    [46] => D:\XAMPP\htdocs\libraries\joomla\session\storage.php
    [47] => D:\XAMPP\htdocs\libraries\joomla\session\storage\database.php
    [48] => D:\XAMPP\htdocs\libraries\joomla\input\cookie.php
    [49] => D:\XAMPP\htdocs\libraries\joomla\database\driver.php
    [50] => D:\XAMPP\htdocs\libraries\joomla\database\database.php
    [51] => D:\XAMPP\htdocs\libraries\joomla\database\driver\mysqli.php
    [52] => D:\XAMPP\htdocs\libraries\joomla\database\query\mysqli.php
    [53] => D:\XAMPP\htdocs\libraries\joomla\database\query.php
    [54] => D:\XAMPP\htdocs\libraries\joomla\database\query\limitable.php
    [55] => D:\XAMPP\htdocs\libraries\vendor\joomla\registry\src\AbstractRegistryFormat.php
    [56] => D:\XAMPP\htdocs\libraries\vendor\joomla\registry\src\Format\Json.php
    [57] => D:\XAMPP\htdocs\libraries\vendor\joomla\registry\src\Format\Ini.php
    [58] => D:\XAMPP\htdocs\libraries\joomla\user\user.php
    [59] => D:\XAMPP\htdocs\libraries\joomla\user\wrapper\helper.php
    [60] => D:\XAMPP\htdocs\libraries\cms\component\helper.php
    [61] => D:\XAMPP\htdocs\libraries\joomla\cache\cache.php
    [62] => D:\XAMPP\htdocs\libraries\joomla\cache\controller.php
    [63] => D:\XAMPP\htdocs\libraries\joomla\filesystem\path.php
    [64] => D:\XAMPP\htdocs\libraries\joomla\cache\controller\callback.php
    [65] => D:\XAMPP\htdocs\libraries\joomla\cache\storage.php
    [66] => D:\XAMPP\htdocs\libraries\joomla\cache\storage\file.php
    [67] => D:\XAMPP\htdocs\libraries\cms\plugin\helper.php
    [68] => D:\XAMPP\htdocs\libraries\joomla\access\access.php
    [69] => D:\XAMPP\htdocs\libraries\joomla\utilities\arrayhelper.php
    [70] => D:\XAMPP\htdocs\libraries\joomla\language\language.php
    [71] => D:\XAMPP\htdocs\language\en-GB\en-GB.localise.php
    [72] => D:\XAMPP\htdocs\plugins\system\admintools\admintools.php
    [73] => D:\XAMPP\htdocs\libraries\f0f\include.php
    [74] => D:\XAMPP\htdocs\libraries\f0f\autoloader\fof.php
    [75] => D:\XAMPP\htdocs\libraries\f0f\less\less.php
    [76] => D:\XAMPP\htdocs\libraries\joomla\filesystem\file.php
    [77] => D:\XAMPP\htdocs\libraries\joomla\filesystem\wrapper\path.php
    [78] => D:\XAMPP\htdocs\plugins\system\admintools\admintools\main.php
    [79] => D:\XAMPP\htdocs\libraries\cms\plugin\plugin.php
    [80] => D:\XAMPP\htdocs\libraries\joomla\event\event.php
    [81] => D:\XAMPP\htdocs\plugins\system\admintools\admintools\core.php
    [82] => D:\XAMPP\htdocs\administrator\components\com_admintools\models\storage.php
    [83] => D:\XAMPP\htdocs\libraries\joomla\model\model.php
    [84] => D:\XAMPP\htdocs\libraries\legacy\model\legacy.php
    [85] => D:\XAMPP\htdocs\plugins\system\admintools\admintools\pro.php
    [86] => D:\XAMPP\htdocs\administrator\components\com_admintools\helpers\ip.php
    [87] => D:\XAMPP\htdocs\plugins\system\modulesanywhere\modulesanywhere.php
    [88] => D:\XAMPP\htdocs\plugins\system\jux_megamenu\jux_megamenu.php
    [89] => D:\XAMPP\htdocs\plugins\system\regacymailing\regacymailing.php
    [90] => D:\XAMPP\htdocs\plugins\system\jce\jce.php
    [91] => D:\XAMPP\htdocs\plugins\system\rsform\rsform.php
    [92] => D:\XAMPP\htdocs\plugins\system\directalias\directalias.php
    [93] => D:\XAMPP\htdocs\plugins\system\rsfprecaptchav2\rsfprecaptchav2.php
    [94] => D:\XAMPP\htdocs\plugins\system\nnframework\nnframework.php
    [95] => D:\XAMPP\htdocs\plugins\system\logout\logout.php
    [96] => D:\XAMPP\htdocs\plugins\system\debug\debug.php
    [97] => D:\XAMPP\htdocs\plugins\system\log\log.php
    [98] => D:\XAMPP\htdocs\plugins\system\remember\remember.php
    [99] => D:\XAMPP\htdocs\plugins\system\highlight\highlight.php
    [100] => D:\XAMPP\htdocs\plugins\system\sef\sef.php
    [101] => D:\XAMPP\htdocs\libraries\cms\menu\menu.php
    [102] => D:\XAMPP\htdocs\libraries\cms\menu\site.php
    [103] => D:\XAMPP\htdocs\libraries\joomla\user\helper.php
    [104] => D:\XAMPP\htdocs\libraries\cms\router\router.php
    [105] => D:\XAMPP\htdocs\libraries\cms\router\site.php
    [106] => D:\XAMPP\htdocs\libraries\joomla\string\string.php
    [107] => D:\XAMPP\htdocs\libraries\vendor\joomla\string\src\String.php
    [108] => D:\XAMPP\htdocs\libraries\vendor\joomla\string\src\phputf8\utf8.php
    [109] => D:\XAMPP\htdocs\libraries\vendor\joomla\string\src\phputf8\mbstring\core.php
    [110] => D:\XAMPP\htdocs\libraries\vendor\joomla\string\src\phputf8\substr_replace.php
    [111] => D:\XAMPP\htdocs\libraries\vendor\joomla\string\src\phputf8\strcasecmp.php
    [112] => D:\XAMPP\htdocs\components\com_content\router.php
    [113] => D:\XAMPP\htdocs\libraries\cms\component\router\base.php
    [114] => D:\XAMPP\htdocs\libraries\cms\component\router\interface.php
    [115] => D:\XAMPP\htdocs\libraries\legacy\categories\categories.php
    [116] => D:\XAMPP\htdocs\components\com_content\helpers\category.php
    [117] => D:\XAMPP\htdocs\libraries\cms\language\multilang.php
    [118] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\protect.php
    [119] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\cache.php
    [120] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\helper.php
    [121] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\parameters.php
    [122] => D:\XAMPP\htdocs\plugins\system\modulesanywhere\helper.php
    [123] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\functions.php
    [124] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\tags.php
    [125] => D:\XAMPP\htdocs\plugins\system\nnframework\helpers\text.php
    [126] => D:\XAMPP\htdocs\libraries\cms\library\helper.php
    [127] => D:\XAMPP\htdocs\libraries\joomla\document\document.php
    [128] => D:\XAMPP\htdocs\libraries\joomla\document\html\html.php
    [129] => D:\XAMPP\htdocs\libraries\joomla\application\route.php
    [130] => D:\XAMPP\htdocs\libraries\joomla\language\helper.php
    [131] => D:\XAMPP\htdocs\components\com_content\content.php
    [132] => D:\XAMPP\htdocs\components\com_content\helpers\route.php
    [133] => D:\XAMPP\htdocs\components\com_content\helpers\query.php
    [134] => D:\XAMPP\htdocs\libraries\legacy\controller\legacy.php
    [135] => D:\XAMPP\htdocs\components\com_content\controller.php
    [136] => D:\XAMPP\htdocs\components\com_content\views\article\view.html.php
    [137] => D:\XAMPP\htdocs\libraries\legacy\view\legacy.php
    [138] => D:\XAMPP\htdocs\components\com_content\models\article.php
    [139] => D:\XAMPP\htdocs\libraries\legacy\model\item.php
    [140] => D:\XAMPP\htdocs\libraries\joomla\table\table.php
    [141] => D:\XAMPP\htdocs\libraries\joomla\observable\interface.php
    [142] => D:\XAMPP\htdocs\libraries\joomla\table\interface.php
    [143] => D:\XAMPP\htdocs\libraries\joomla\access\rules.php
    [144] => D:\XAMPP\htdocs\libraries\joomla\access\rule.php
    [145] => D:\XAMPP\htdocs\libraries\cms\layout\file.php
    [146] => D:\XAMPP\htdocs\libraries\cms\layout\base.php
    [147] => D:\XAMPP\htdocs\libraries\cms\layout\layout.php
    [148] => D:\XAMPP\htdocs\libraries\legacy\application\application.php
    [149] => D:\XAMPP\htdocs\libraries\cms\helper\tags.php
    [150] => D:\XAMPP\htdocs\libraries\cms\helper\helper.php
    [151] => D:\XAMPP\htdocs\plugins\content\loadmodule\loadmodule.php
    [152] => D:\XAMPP\htdocs\plugins\content\joomla\joomla.php
    [153] => D:\XAMPP\htdocs\plugins\content\rsform\rsform.php
    [154] => D:\XAMPP\htdocs\plugins\content\contact\contact.php
    [155] => D:\XAMPP\htdocs\plugins\content\pagebreak\pagebreak.php
    [156] => D:\XAMPP\htdocs\plugins\content\pagenavigation\pagenavigation.php
    [157] => D:\XAMPP\htdocs\plugins\content\vote\vote.php
    [158] => D:\XAMPP\htdocs\administrator\components\com_rsform\helpers\rsform.php
    [159] => D:\XAMPP\htdocs\administrator\components\com_rsform\helpers\config.php
    [160] => D:\XAMPP\htdocs\administrator\components\com_rsform\helpers\version.php
    [161] => D:\XAMPP\htdocs\libraries\legacy\table\content.php
    [162] => D:\XAMPP\htdocs\libraries\joomla\observer\updater.php
    [163] => D:\XAMPP\htdocs\libraries\joomla\observer\updater\interface.php
    [164] => D:\XAMPP\htdocs\libraries\joomla\observer\mapper.php
    [165] => D:\XAMPP\htdocs\libraries\joomla\table\observer\tags.php
    [166] => D:\XAMPP\htdocs\libraries\joomla\table\observer.php
    [167] => D:\XAMPP\htdocs\libraries\joomla\observer\interface.php
    [168] => D:\XAMPP\htdocs\libraries\joomla\table\observer\contenthistory.php
    [169] => D:\XAMPP\htdocs\libraries\cms\helper\contenthistory.php
    [170] => D:\XAMPP\htdocs\libraries\cms\pathway\pathway.php
    [171] => D:\XAMPP\htdocs\libraries\cms\pathway\site.php
    [172] => D:\XAMPP\htdocs\templates\accountstaff\html\com_content\article\news.php
    [173] => D:\XAMPP\htdocs\libraries\cms\html\html.php
    [174] => D:\XAMPP\htdocs\templates\accountstaff\index.php
    [175] => D:\XAMPP\htdocs\libraries\cms\html\bootstrap.php
    [176] => D:\XAMPP\htdocs\libraries\cms\html\jquery.php
    [177] => D:\XAMPP\htdocs\libraries\legacy\request\request.php
    [178] => D:\XAMPP\htdocs\libraries\joomla\utilities\utility.php
    [179] => D:\XAMPP\htdocs\libraries\joomla\document\html\renderer\modules.php
    [180] => D:\XAMPP\htdocs\libraries\joomla\document\renderer.php
    [181] => D:\XAMPP\htdocs\libraries\joomla\document\html\renderer\module.php
    [182] => D:\XAMPP\htdocs\libraries\cms\module\helper.php
    [183] => D:\XAMPP\htdocs\modules\mod_menu\mod_menu.php
    [184] => D:\XAMPP\htdocs\modules\mod_menu\helper.php
    [185] => D:\XAMPP\htdocs\templates\accountstaff\html\mod_menu\footerlinks.php
    [186] => D:\XAMPP\htdocs\templates\accountstaff\html\mod_menu\default_component.php
    [187] => D:\XAMPP\htdocs\templates\system\html\modules.php
    [188] => D:\XAMPP\htdocs\templates\accountstaff\html\modules.php
    [189] => D:\XAMPP\htdocs\modules\mod_custom\mod_custom.php
    [190] => D:\XAMPP\htdocs\templates\accountstaff\html\mod_custom\default.php
    [191] => D:\XAMPP\htdocs\libraries\cms\html\content.php
    [192] => D:\XAMPP\htdocs\templates\accountstaff\html\mod_menu\footerblock.php
    [193] => D:\XAMPP\htdocs\templates\accountstaff\html\mod_menu\default_url.php
    [194] => D:\XAMPP\htdocs\libraries\joomla\filter\output.php
    [195] => D:\XAMPP\htdocs\libraries\joomla\language\text.php
    [196] => D:\XAMPP\htdocs\modules\mod_accountstaff_banners\mod_accountstaff_banners.php
    [197] => D:\XAMPP\htdocs\modules\mod_accountstaff_banners\tmpl\default.php
    [198] => D:\XAMPP\htdocs\modules\mod_jux_megamenu\mod_jux_megamenu.php
    [199] => D:\XAMPP\htdocs\modules\mod_jux_megamenu\helper.php
    [200] => D:\XAMPP\htdocs\components\com_contact\router.php
    [201] => D:\XAMPP\htdocs\modules\mod_jux_megamenu\tmpl\default.php
    [202] => D:\XAMPP\htdocs\libraries\joomla\document\html\renderer\head.php
    [203] => D:\XAMPP\htdocs\libraries\vendor\joomla\utilities\src\ArrayHelper.php
    [204] => D:\XAMPP\htdocs\libraries\joomla\document\html\renderer\message.php
    [205] => D:\XAMPP\htdocs\libraries\cms\layout\helper.php
    [206] => D:\XAMPP\htdocs\templates\accountstaff\html\layouts\joomla\system\message.php
    [207] => D:\XAMPP\htdocs\libraries\legacy\response\response.php
    [208] => D:\XAMPP\htdocs\administrator\components\com_acymailing\helpers\helper.php
    [209] => D:\XAMPP\htdocs\administrator\components\com_acymailing\compat\compat3.php
    [210] => D:\XAMPP\htdocs\administrator\components\com_acymailing\classes\cpanel.php
    [211] => D:\XAMPP\htdocs\libraries\cms\html\select.php
)