- Championship manager 01/02 keyboard shortcuts how to#
- Championship manager 01/02 keyboard shortcuts pro#
- Championship manager 01/02 keyboard shortcuts series#
By sorting the data by Name and Round number, we can make our next job (copying and pasting of data) easier.
Following the question requirements, we’ll add columns for Country, Age, and the 3 rounds of scores.
Championship manager 01/02 keyboard shortcuts how to#
Don’t know how to sort data? Search Sort in “Tell Me” In the next steps you will see why sorting by name will be helpful. The question asks us to sort by Result Time, but we can do that later. Sort Table 1 (02:18) – To keep ourselves organized as we collect the data, let’s sort the competitors by their name.Filter the Original Data Table 1 (01:49) – For this question we are only concerned with Round 3 competitors, so let’s do a quick filtering of the results to get my list of Round 3 competitors.Again, we’ll get a chance to see how much easier modern Excel can make our lives in later rounds. This is not the best practice for tackling a similar problem if you encounter it in the real world…better to follow methods that will adjust dynamically if your data changes. This approach will be a little slow and a bit tedious, but it’s starting point for playing with data in Excel. I’ll also avoid the use of any formulas in this solution, so that we stick to just manipulating the data. This is one reason why I love Get & Transform (and we will explore this in a later round).įor now, we’ll approach this question as having a table of data that we need to quickly manipulate once to get to an answer and not worry about needing to repeat the steps in the future if the data changes. The question COULD be solved using Get & Transform (Power Query) tools to produce a query that easily updates results if your data changes. The intent of the question was to introduce tables. In some of the videos that follow I will share some cases where you could use Tell Me.
Championship manager 01/02 keyboard shortcuts pro#
This can be helpful even if you are an Excel pro and just can’t remember where to find a command, like the “Sort” button for example. Search words related to the task you want to accomplish and Tell Me provides some options, including the ability to click directly into an option and start using the feature – in other words you don’t have to navigate the ribbon to find the feature. “Tell Me” was added to Office 2016 applications as simplified approach to help. I've also attached a copy of the solution workbook below ( link), so you can inspect methods in detail.
I try to give as detailed an explanataion as i can so that a person with little Excel experience can follow along. Sorry, I know i talk a lot in the videos. When I write a time at the end of a step, the step is demonstrated at approximately that time of the video. Where possible I include videos that walk through the steps outlined in each solution, so you can see how to accomplish the tasks in Excel. There has been a lot of fantastic work shared on the community site, and I encourage you to explore those posts. Personal tastes can have a strong influence in this space. I’ll share some thoughts on the data and point to some of the charts posted to the community, but I will not spend a lot of time discussing the visualization challenges. I am in no way trying to say that my way is the only way to get the job done. I’ll share an approach to completing each challenge of each test that hopefully teaches you something new or at least gives you something to think about. There are many ways to solve a problem in the real world, and Excel is no different.In 2017, these country champs will compete for the world champ title!īefore I go any further I want to stress a few points for this post and all posts to follow.
Championship manager 01/02 keyboard shortcuts series#
In short, from October 2016-November 2016 we ran a series of Excel challenges in many countries to find local Excel Champions. Hello Excel Fans! I’m excited to kick off the first in a series of posts reviewing the tests of the #ExcelWorldChamp competition!įor those of you that have not seen any information on the competition, you can learn more here. Link to Test 1 Workbook - WITHOUT answers