楼主: igs816
3542 39

[其他] Microsoft Excel Practical Formulae: From basic data analysis to advanced formula [推广有奖]

泰斗

5%

还不是VIP/贵宾

-

威望
9
论坛币
2694466 个
通用积分
18516.8461
学术水平
2744 点
热心指数
3467 点
信用等级
2560 点
经验
484578 点
帖子
5415
精华
52
在线时间
3589 小时
注册时间
2007-8-6
最后登录
2024-4-26

高级学术勋章 特级学术勋章 高级信用勋章 特级信用勋章 高级热心勋章 特级热心勋章

楼主
igs816 在职认证  发表于 2016-1-30 22:28:56 |只看作者 |坛友微信交流群|倒序 |AI写论文
相似文件 换一批

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
fXJae7N4SdQkGRtyd6tIdWnLzP2fnHzC.jpeg
Microsoft Excel Practical Formulae: From basic data analysis to advanced formulae manipulation by Diane Griffiths
English | January 3, 2016 | ASIN: B01A6468SW | 142 Pages | MOBI/EPUB/PDF (conv) | 13.69 MB                                                

This book covers basic through to advanced formulae. It doesn’t cover all functions within Excel, but gives you what I consider to be the most practical functions and how to use them. As always, this will only be the tip of the Iceberg with Excel, but will give you a great set of tools which you will be able to apply in many different situations.

The book is split into 4 sections:

1 - Basic Formulae covering SUM, COUNT/COUNTA, IF, AND/OR and AVG/MAX/MIN.

The essentials to get you started with basic data analysis. We learn about using functions in your formulas, a useful Excel feature which is designed to make your life easier. It will give you the starting blocks that you need in order to present and make sense of a spreadsheet in a quick, easy and confidence-boosting way.

2 - Intermediate Formulae covering VLOOKUP/HLOOKUP, LEN, LEFT/RIGHT/MID, SEARCH/FIND, First Name and Last Name formulae, CONCATENATE, LOWER/PROPER/UPPER, TRIM, CLEAN/SUBSTITUTE/CHAR and IFERROR.

Now we start digging a bit deeper. Beginning with some criteria-based analysis and how to pull out data. The second half of this section looks at removing elements which may impede analysis or affect the quality of any data analysis results. We need to ensure the most effective prep to allow the most reliable and meaningful analysis. For example; have you ever created a formula that you know was correct but it didn’t work properly for some reason, this has happened to me so many times. Often it’s because the original data was inconsistent. I’ve got some handy functions for you to help with getting rid of unwanted characters, spaces and inconsistencies – as I always like to say ‘don’t get errors, get answers!’

3 - Advanced Formulae which talks about absolute references and covers COUNTIF/SUMIF, INDEX/MATCH, COUNTIFS/SUMIFS and how to do a two-way lookup.

Data analysis is the process of developing answers from data and it’s in this section where we can really manipulate the data in order to start understanding the messages contained within. This exploration might require additional data cleaning or requests for data, but that's ok; the process of collecting, cleansing, analysing, interpreting and presenting data is often an iterative process. To be successful in carrying out this process it does not necessarily mean providing the right answer first time, but being able to understand and give insight as to why that answer is what it is. A fluid process which allows you to revisit the data again and again is the key.

So how do we do this? Well Excel will facilitate this analysis, but it won't do it for you. You need to decide what you want to get from the data and I'll give you some tools in this book to query data within Excel and summarise it into top level information in order to present it like a pro and give your career a boost.

4 - Dynamic Formulae which really starts to show you the power of Excel. We cover OFFSET, OFFSET validation, INDIRECT, ROW, COLUMN, ADDRESS, INDIRECT/ADDRESS, SUM/INDIRECT/ROW.

A word of warning with this section, it will open up a world of possibilities and really expand how you think about Excel. However please remember, simple is usually better – so if you can do something in a more straight-forward way, and that might mean restructuring how your spreadsheet works or using other Excel functionality, then I would do that. Failing that option – you can probably use a bespoke formula and I will start to show you how!

There is a lot of information in here, so I wouldn’t try to read this all at once. Pull out the sections that are most relevant to you, and if you’re unsure, then start at the beginning, this book will take you on a journey through the Excel functions.

本帖隐藏的内容

Microsoft Excel Practical Formulae From basic data analysis to advanced formulae.rar (10.69 MB, 需要: 5 个论坛币) 本附件包括:
  • Microsoft Excel Practical Formulae From basic data analysis to advanced formulae manipulation.pdf
  • Microsoft Excel Practical Formulae From basic data analysis to advanced formulae manipulation.epub
  • Microsoft Excel Practical Formulae From basic data analysis to advanced formulae manipulation.mobi



二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Microsoft Practical Formulae Analysis Advanced Microsoft Excel

本帖被以下文库推荐

沙发
nonoyes233 发表于 2016-1-31 02:03:53 |只看作者 |坛友微信交流群
thanks...............................

使用道具

藤椅
smartlife 在职认证  发表于 2016-1-31 03:09:38 |只看作者 |坛友微信交流群

使用道具

板凳
oink-oink 发表于 2016-1-31 07:50:35 |只看作者 |坛友微信交流群

使用道具

报纸
kzpan 发表于 2016-1-31 09:30:06 |只看作者 |坛友微信交流群

使用道具

地板
aggiewe 发表于 2016-1-31 11:55:50 |只看作者 |坛友微信交流群
see.......................

使用道具

7
wusetu 发表于 2016-1-31 15:31:10 |只看作者 |坛友微信交流群
Microsoft Excel Practical Formulae: From basic data analysis to advanced formulae manipulation

使用道具

8
luojscd 发表于 2016-1-31 20:00:49 |只看作者 |坛友微信交流群
回帖看看!!

使用道具

9
kuayueriguang 发表于 2016-1-31 20:11:44 |只看作者 |坛友微信交流群
谢谢。。。。。。。。。。。。。。。。。。。。。。

使用道具

10
云游天外 发表于 2016-1-31 22:16:46 |只看作者 |坛友微信交流群
感谢分享!

使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jr
拉您进交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-4-27 06:56