初学者java读excel_初学者的最佳Excel技巧

初学者java读excel

On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the content ready, but wanted ideas from other people who have taught similar courses. What are your top Excel tips for beginners?

大卫·纳波利(David Napoli)在本周的Twitter上问我们–您将在课堂上教给Excel哪些技巧？ David正在计划一个Excel班，并且大部分内容都已准备好，但他希望从其他教过类似课程的人那里得到一些想法。 对于初学者，您最擅长的Excel技巧是什么？

大卫的推文 (David's Tweet)

If you're on Twitter, you can find David's account here. He's a Data Viz consultant and instructor, recovering rocket scientist, and loves cycling near his home in Colorado.

如果您在Twitter上，则可以在此处找到David的帐户 。 他是Data Viz的顾问和讲师，正在康复的火箭科学家，并且喜欢在他科罗拉多州的家附近骑自行车。

Here is the tweet that David posted, asking for suggestions on Excel tips and topics.

这是David发布的推文，征求有关Excel技巧和主题的建议。

I will be teaching an Excel workshop in a few days. Class content is essentially set, but in pursuit of continuous improvement…

我将在几天内教一个Excel工作坊。 课程内容基本上是确定的，但为了不断改进……

What would be the top #Excel tip / trick I should cover?@ddalgleish @jschwabish @Jon_Peltier @wisevis @AnnKEmery @kpuls

我应该讲的最重要的#Excel技巧/窍门是什么？ @ddalgleish @jschwabish @Jon_Peltier @wisevis @AnnKEmery @kpuls

— David Napoli (@Biff_Bruise) June 26, 2019

-David Napoli(@Biff_Bruise) 2019年6月26日

我的最佳Excel技巧 (My Top Excel Tips)

In my reply to David, I listed 2 tips:

在对David的回复中，我列出了2个技巧：

1. Format lists as named Excel Tables

   将列表格式化为命名的Excel表

2. Save early and save often
   尽早保存并经常保存

See the end of this blog post for the macro that I use to make a quick backup copy, while working on an Excel file.

有关在处理Excel文件时用来制作快速备份副本的宏，请参见此博客文章的结尾。

1. Format lists as named Excel tables 2. Save early and save often

1.将列表格式化为命名的Excel表2.尽早保存并经常保存

— Debra Dalgleish (@ddalgleish) June 26, 2019

-Debra Dalgleish(@ddalgleish) 2019年6月26日

合理的格式和名称 (Sensible Formats and Names)

John MacKintosh had a few great tips in his tweet, including sensible date formats and column names. Those can save you lots of pain and trouble.

John MacKintosh在其推文中提供了一些很棒的技巧，包括合理的日期格式和列名。 这些可以为您节省很多痛苦和麻烦。

Keeping data on a single sheet is important too – don't create a different sheet for each month or department or whatever!

将数据保存在一张纸上也很重要–请勿为每个月或部门或其他内容创建不同的纸！

After named tables, consistent / sensible date formats and column names. Not splitting data over worksheets when it should be in a single table (e.g. a sheet for each month) Then, and only then, vlookup() 🙂

在命名表之后，使用一致/合理的日期格式和列名。 当数据应该放在一个表中时，不要在工作表上拆分数据(例如每个月一个工作表)然后，只有那时，vlookup()🙂

— John MacKintosh (@_johnmackintosh) June 26, 2019

-John MacKintosh(@_johnmackintosh) 2019年6月26日

个性化主题 (Personalize the Topics)

Ann K. Emery had a great tip – personalize your topics, such as "Here's a thing I wish I knew sooner…" How many times have you finally learned a quicker way to do something that you've been doing for years?

安·埃默里(Ann K. Emery)有个很好的秘诀–个性化您的主题，例如“我希望我早点知道……”，您终于学会了更快的方法来做几年来一直在做的事情？

Whatever topics you cover, just personalize them -- "Here's the thing I wish I knew sooner..." or "This is the technique that would've saved me so much time..." or "I see a lot of people do this the long way, and here's a great shortcut..."

无论您涉及什么主题，只需对其进行个性化设置即可：“这是我希望我早点知道的东西...”或“这可以为我节省很多时间的技术……”或“我看到很多人从长远来看，这是一个很棒的捷径...”

— Ann K. Emery (@AnnKEmery) June 26, 2019

-Ann K.Emery(@AnnKEmery) 2019年6月26日

格式和布局 (Formats and Layout)

Jovan Lekovic suggested that David show Themes, from the Page Layout tab, and Copy/Paste Special…Formats with charts.

Jovan Lekovic建议David在“页面布局”选项卡中显示主题，并使用图表复制/粘贴特殊…格式。

Cell Styles are an overlooked feature too, that can make it quicker and easier to format a workbook.

单元格样式也是一个被忽略的功能，它可以使格式化工作簿更快，更轻松。

Oooh! Fun one! I always get great reactions for "Copy/Paste Special... -> Formats" used on graphs. Also "Page Layout -> Themes/Colours/Fonts" is a good quick hack to get away from Excel defaults...

哦！ 好玩的一个！ 对于图上使用的“复制/粘贴特殊...->格式”，我总是会收到很好的React。 同样，“页面布局->主题/颜色/字体”是摆脱Excel默认设置的好方法。

— Jovan Lekovic (@lekovicj) June 26, 2019

-Jovan Lekovic(@lekovicj) 2019年6月26日

功率查询与否？ (Power Query or Not?)

The big debate though, was whether or not David should show Power Query (Get and Transform) to Excel beginners. Which side are you on?

但是，最大的争论是David是否应该向Excel初学者展示Power Query(获取和转换)。 你支持哪一边？

Ken Puls and Greg Frazier both suggested Power Query, before David said it was a beginner class.

在David表示这是初级班之前，Ken Puls和Greg Frazier都建议使用Power Query。

Very much depends on the course outline. For em I try to get some Power Query in everywhere as that is by far the best way to save time.

在很大程度上取决于课程大纲。 对于em，我尝试在任何地方都可以使用Power Query，因为到目前为止这是节省时间的最佳方法。

— Ken Puls, FCPA, FCMA (@kpuls) June 26, 2019

-Ken Puls，FCPA，FCMA(@kpuls) ，2019年6月26日

翻译自: https://contexturesblog.com/archives/2019/06/27/your-top-excel-tips-for-beginners/

初学者java读excel