Complete Guide To Excel For Football Traders
Complete Guide To Excel For Football Traders
This video, taken from our Excel (VBA) For Football Traders learning community, deals with tricky and important questions for any Excel user: What tool should I be using in Excel? Do I need to know everything in Excel? Do I need to learn Excel VBA? Where should I direct my Excel learning efforts for maximum impact …?
With these questions in mind, I explain the four usages of Excel, arguing the key to Excel proficiency is to understand which usage you’re engaged with at any one time. If you’re not trying to automate a manual process in Excel, for example, you probably won’t need Excel VBA. If you’re building a model, pivot tables won’t help …
The overarching aim is to provide a roadmap for your Excel learning, whether you’re working with football data or something else in Excel. Welcome to the Complete Guide To Excel For Football Traders!
It’s true – you’ll only ever do four things in Excel, regardless of whether you’re football trading, or doing something else. I argue if you can grasp this idea, it could have career-changing effect.
Question: where in your house is your kitchen? It’s not at the bottom of the garden, is it? The way you structure your spreadsheet files suggests it might be! I explain all in this section: helpful structure and layout really is the key to Excel success in football trading and other applications of Excel.
READ MORE ABOUT EXCEL (VBA) FOR FOOTBALL TRADERS
07:10 Usage 1/4: Key Concepts In Data Input In Excel
07:10 Usage 1/4: Key Concepts In Data Input In Excel
What’s Excel mainly used for? Logging data. ‘Chris, I know that!’ Ok, so why aren’t you focusing on it more in your practice? Poorly inputted data is at the root of most Excel problems. Let’s start by understanding some key concepts about data input in Excel, with some examples from the world of football trading.
You might be familiar with dropdown menus and how to build them, but what other forms of data validation might be useful for football traders and professionals working with Excel more generally? I point out some useful data input tools and techniques in this section.
The need to understand datasets drives the second usage of Excel. How can we quickly and effectively interpret large datasets? Football traders are trying to do this all the time. We start by building a conceptual foundation in which I offer my simple definition of ‘analysis’: it should turn data into information in a way that helps people like you.
25:50 Excel Tools And Techniques To Support Data Analysis
25:50 Excel Tools And Techniques To Support Data Analysis
Been avoiding pivot tables so far in your Excel career? You could be missing out! In this section, I identify tools and techniques to support data analysis in Excel, including my favoured approach: using Excel’s powerful database formulae such as DSUM. That beautiful dashboard to support your football trading or other activity could be closer than you think …
‘Modelling’ is one of many misunderstood terms in Excel. ‘Send me the Excel model!’ Your boss may have asked you. But, in truth, relatively few Excel files are actually ‘models’. A model refers specifically to an Excel file that expresses real-world relationships using formulae and the concept of ‘input-process-output’. Odds compilation is one example football traders will be familiar with.
If you’re a formula demon, you’ll love Excel modelling! That’s because Excel formulae, and particularly the ‘big 5’ formulae I’ve identified through my career, are integral to any functional Excel model. In this section, I share what the ‘big 5’ formulae are, and point out other useful Excel tools to help get you modelling like a pro.
Finally, the reason you probably subscribed to the Tiger mailing list: Excel automation using the magic of VBA. In this section, we explore key concepts around ‘automation’, so you can understand the specific tasks with which VBA might help. My argument that many tasks are best done with other tools in Excel may surprise you …
This section is the simplest of the lot: the only tool you need is … VBA! But, in terms of sophistication, VBA is on a higher order of magnitude compared with other facilities in Excel. That’s because VBA is a programming language. Like any human language, it’s complex and takes some time to learn, but is also supremely flexible and powerful.