![]() ![]() When I did them, it felt a bit "unnecessary" as I already knew these bits. For instance, when learning about how to format sheets in excell, the lesson also explained how this can be used in large data sets, which put this into perspective how one tool is useful to solve more complex problems.As I had previous experience, especially the first 3 lessons were rather easy. ![]() This made the first lessons fairly easy as I am familiar with the program, but I also learnt something new in most of the first lessons. to handle large data sets for assignments in various courses (mainly industrial economics, material handling and international distribution). As the Excel program is built with multiple tools, the basics course was structured appropriately by going through the tools one by one with a subsequent quiz to test the knowledge.Previously I have used Excell throughout my studies, with some basic application such as creating functions, using pivot tables etc. The quizes also includes applying the lesson learnt to a pre-set excel sheet, which made it easy to quickly learn the tool as I got to apply it directly. Each module in the course has a few video lessons of a couple of minutes long and ends with a quiz about the lesson. It introduces topics such as functions and formulas, navigation through the program, hotkeys, IF-formulas and much more. Online course: Excell Bas (basics)Great introduction to Excell and its tools!This is, I believe, one of the first and most basic courses that Learnesy offers. In the next post, we will start looking at reporting and how to easily build visual and informative reports in a simple way in Excel.įeel free to connect with me on LinkedIn and visit Learnesy’s website for more information. We have now looked at replacing different formats where punctuation, commas or spaces are making the amounts non-numeric formats. In this variant of the function, we can add several arrows if needed to divide more complicated combinations of numbers, characters and text. We click four notches on the ruler to get an arrow/line.įinally, we click on the next to get a preview or alternatively finish. We can then use the function With fixed width as below The second variant is when we see text right next to a numeric value. You see here that there are several automatic choices but that you can also select “Other” and enter which character should apply.Īfter clicking on finish, we get the end result above. We uncheck the default choice Tab and select Space. In our first case, it works with Delimited fields as we have spaces between the numeric values and the text “SEK”. Here there are two different choices, either using delimited fields or with a fixed width. We go to the function “Convert text to column” under the data menu. See below two examples where we see a space in the first example and that in the second example the number and text are together. Text to column is useful when you have different types of information in one and the same cell that you need to separate to be able to use the data for analysis or reporting. See below:Īfter removing the space, we replace the punctuation with a comma like in the previous example. We search on space and replace with… nothing. In the same way, we can replace blank spaces after a number. In this process, you need to replace the incorrect comma first, at thousands, adding a comma instead of the punctuation in step two. Then you do the same thing with punctuation but choose comma instead of a blank: This variant can be solved relatively quickly according to the steps below.Ĭtrl + F for “Find and replace”… choose comma first and replace with a blank They also often use punctuation where we use commas for decimals. Normally you can adjust the custom format quite easily.īut sometimes it’s a little bit trickier and formatting does not work. Punctuation instead of comma or comma at thousandsĪmerican companies like to place a dollar sign in front of their numbers and to use commas at thousands. It is therefore important to keep your eyes open and do some testing before using the numbers. As these amounts have different formatting, it is not easy to reformat them, but they need to be processed in another way before they can be reformatted to numeric value.īelow you see examples of how certain amounts can look as if they are numerical even though they are of text format and vice versa. Other formatsįormats that I often get when I work for companies with American owners are shown below. The easiest way is to mark the cells with the data and see if they get a sum in the status bar.īy customising the status bar to display the number of numeric numbers, you can also quickly see if the number of cells that are selected is the same as the number of numeric numbers. There are several ways to determine if the amounts are in non-numeric format which we looked at in the previous post.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |