This deal was published more than 2 weeks ago and may no longer be available.
Excel Formulas and Functions 2020 - Kindle Edition now Free @ Amazon
1401°

Excel Formulas and Functions 2020 - Kindle Edition now Free @ Amazon

FREE£0.01Amazon Deals
Expert (Beta)27
Expert (Beta)
Posted 6th Jun
A good book here to help you with excel.

Description
Microsoft Excel is an application that helps you save time and analyze data easily. It has multiple predefined functions you can use to perform complex calculations and analysis and make your job easy. A lot of people struggle to understand these functions for multiple reasons, and therefore, cannot use the application well.

Regardless of the industry you work in, you must understand the use of these functions so you can improve your analysis and understanding of the data. Use this book as your guide to understand different functions and formulae in Excel.

In this book, you will learn about:
●What Microsoft Excel is, and its benefits
●The Formula Tab in Excel
●Types of Referencing
●Different functions in Excel
●Some tips and shortcuts

To make it easy for you to learn these formulae, there are several screenshots to guide you and make the functions easy for you.

Hope it helps someone.
Community Updates

Groups

Top comments
Excel is probably the most underrated IT skill in business. Knowing your way around formulas and functions makes you more of an asset to a company than many people realise.
MrWang07/06/2020 13:03

Excel is probably the most underrated IT skill in business. Knowing your …Excel is probably the most underrated IT skill in business. Knowing your way around formulas and functions makes you more of an asset to a company than many people realise.


The company I work for's HR admins have been unable to work out my holiday entitlement for years. Turns out it's because not one of them understands excel (and basic maths in general) and so they had just downloaded a template from a university site as they thought 'if it's from a university it must be right?' Wrong. I might send them this book.
This maybe a 2020 edition but from what I could see it doesn't include any new 2020 Excel functions like for example XLOOKUP which is a much easier version of VLOOKUP. If anyone wants to know about these you can follow Leila on YouTube who runs through these in more detail
27 Comments
Might be useful, and its free, thank you.
Cheers Op
Exactly what I need - thanks!
Thanks for posting OP!
Nice Find OP
I know some people would find this useful, but isn’t it easier to look them up online?
Excel is probably the most underrated IT skill in business. Knowing your way around formulas and functions makes you more of an asset to a company than many people realise.
ikc031207/06/2020 13:00

I know some people would find this useful, but isn’t it easier to look t …I know some people would find this useful, but isn’t it easier to look them up online?


It is once you've got a base understanding of it all. I'm not in the position to need this but I can understand why those on the ground floor might want to start with this.
MrWang07/06/2020 13:03

Excel is probably the most underrated IT skill in business. Knowing your …Excel is probably the most underrated IT skill in business. Knowing your way around formulas and functions makes you more of an asset to a company than many people realise.


The company I work for's HR admins have been unable to work out my holiday entitlement for years. Turns out it's because not one of them understands excel (and basic maths in general) and so they had just downloaded a template from a university site as they thought 'if it's from a university it must be right?' Wrong. I might send them this book.
Thanks for taking the time to post this - useful book.
This maybe a 2020 edition but from what I could see it doesn't include any new 2020 Excel functions like for example XLOOKUP which is a much easier version of VLOOKUP. If anyone wants to know about these you can follow Leila on YouTube who runs through these in more detail
P.man07/06/2020 13:59

This maybe a 2020 edition but from what I could see it doesn't include any …This maybe a 2020 edition but from what I could see it doesn't include any new 2020 Excel functions like for example XLOOKUP which is a much easier version of VLOOKUP. If anyone wants to know about these you can follow Leila on YouTube who runs through these in more detail


Leila knows her Excel. Quite an enchanting personality too
Might be useful, thanks OP
makkax107/06/2020 13:21

The company I work for's HR admins have been unable to work out my holiday …The company I work for's HR admins have been unable to work out my holiday entitlement for years. Turns out it's because not one of them understands excel (and basic maths in general) and so they had just downloaded a template from a university site as they thought 'if it's from a university it must be right?' Wrong. I might send them this book.


Good luck with that, unless your company has a combined HR/Payroll department.
MrWang07/06/2020 13:03

Excel is probably the most underrated IT skill in business. Knowing your …Excel is probably the most underrated IT skill in business. Knowing your way around formulas and functions makes you more of an asset to a company than many people realise.


Disagree. At the end of the year, no senior manager says I must keep Joe Bloggs because he's good at excel.

It's an overused application that is poorly implemented. Often there are better solutions that are more powerful and don't create single points of failure (Tableau, Power BI, Alteryx and many other off the shelf solutions).

Not to mention automation.
Edited by: "bman" 7th Jun
schnide07/06/2020 13:17

It is once you've got a base understanding of it all. I'm not in the …It is once you've got a base understanding of it all. I'm not in the position to need this but I can understand why those on the ground floor might want to start with this.


Each to their own but, I disagree with you a little there. I think it’s always nice to have an up to date book specific for the release. Some functions change in excel from version to version or just improve. For example if to ifs in 2016 comes to readily to mind, together with a few VBA improvements that I might never have got whiff of if it wasn’t for reference books.
Ooh, blast and tarnation OP, you have just cost me £6 bar a few pence LOL I am super hopeless with Excel so I “purchased” this and then went and had a look at my Wish List. 6 mysteries reduced to 99p so I got them as well.
Awesome!! Thanks for that!!! Looking to improve my excel skills!!!
bman07/06/2020 16:31

Disagree. At the end of the year, no senior manager says I must keep Joe …Disagree. At the end of the year, no senior manager says I must keep Joe Bloggs because he's good at excel. It's an overused application that is poorly implemented. Often there are better solutions that are more powerful and don't create single points of failure (Tableau, Power BI, Alteryx and many other off the shelf solutions). Not to mention automation.


Agree that Excel is showing it's age, but the average user wanting to get useful data out of a csv file would likely still use Excel rather than learn Power BI, for now at least anyway
taffyjock107/06/2020 16:22

Good luck with that, unless your company has a combined HR/Payroll …Good luck with that, unless your company has a combined HR/Payroll department.


HR work out my holidays, payroll send me my pay. Maybe that's not how it is where you work but it is at mine. Sorry if it bothers you.
makkax107/06/2020 19:51

HR work out my holidays, payroll send me my pay. Maybe that's not how it …HR work out my holidays, payroll send me my pay. Maybe that's not how it is where you work but it is at mine. Sorry if it bothers you.


Why would it bother me, the point is HR folk with zero finance background would never understand excel.
taffyjock107/06/2020 20:45

Why would it bother me, the point is HR folk with zero finance background …Why would it bother me, the point is HR folk with zero finance background would never understand excel.


Ah ok, I wasn't sure what u were getting at. 😄
makkax107/06/2020 13:21

The company I work for's HR admins have been unable to work out my holiday …The company I work for's HR admins have been unable to work out my holiday entitlement for years. Turns out it's because not one of them understands excel (and basic maths in general) and so they had just downloaded a template from a university site as they thought 'if it's from a university it must be right?' Wrong. I might send them this book.


As long as they work it out the right side wrong
bman07/06/2020 16:31

Disagree. At the end of the year, no senior manager says I must keep Joe …Disagree. At the end of the year, no senior manager says I must keep Joe Bloggs because he's good at excel. It's an overused application that is poorly implemented. Often there are better solutions that are more powerful and don't create single points of failure (Tableau, Power BI, Alteryx and many other off the shelf solutions). Not to mention automation.


If senior managers aren't recognising the value of Excel skills in their team, then surely that proves @MrWang point - it is a highly underrated skill.

Also, the software may by overrated, but that doesn't mean skills using it can't be underrated. The fact is, most companies use Excel extensively and don't use other programs like Power BI. Knowing these Excel skills is therefore of greater value in most workplaces than knowing Tableau is technically better than Excel.
NotAnonymous08/06/2020 10:18

If senior managers aren't recognising the value of Excel skills in their …If senior managers aren't recognising the value of Excel skills in their team, then surely that proves @MrWang point - it is a highly underrated skill.Also, the software may by overrated, but that doesn't mean skills using it can't be underrated. The fact is, most companies use Excel extensively and don't use other programs like Power BI. Knowing these Excel skills is therefore of greater value in most workplaces than knowing Tableau is technically better than Excel.


Don't disagree. Being good at excel though does not differentiate you where it really matters (eg promotion, salary, greater scope in role). It's like spending your time to be really good at something technical and difficult, but the rewards aren't there. It's in the "high effort, low reward" category. Nobody is fighting over excel experts in the market. Be more strategic.

I would learn the basics in Excel (few hours) which give you 60% of what you need. And move on. Unless your role specifically demands it, spend your time on something more productive.
Everyone with a computer should know basic Excel... even kids are learning it now as part of their syllabus,
Post a comment
Avatar
@
    Text