Search Results

excellent help För alla dina Excel och kalkylarksbehov Här på Excellent Help anser vi att när Excel är optimerat till sitt ändamål så kan man spara tid, pengar och även ett och annat hårstrå + Lär dig mer om oss Våra Tjänster Våra Tjänster Vi erbjuder ett brett sortiment av Excel relaterade lösningar anpassade efter just era behov. Behöver ni ett nytt Excel kalkylark för ett nytt projekt? Eller kanske renovering av ett gammalt Excel ark? Då kan vi hjälpa er Saknar ni sista biten i ert företags Excel pussel. Vill ni ha tillgång till Excel support dagligen? Då kan vi hjälpa er Behöver ert företag en skräddarsydd Excel utbildning? Då kan vi hjälpa er Referenser REFERENSER “Marcus har byggt ett skräddarsytt Excel för projektuppföljning och resursplanering åt oss på AB 05. Marcus är lyhörd och extremt kunnig inom excel. Vi har dagligen stor hjälp av det smarta upplägg han skapat åt oss.” — Gisli Kristjansson, Arkitekt/ Grundare AB05 Contact

Skräddarsydda Excel- och kalkylarks- Utbildningar Excel är ett verktyg som används dagligen på många arbetsplatser, dock är kunskapsnivån inom Excel väldigt olika från arbetsplats till arbetsplats. Det enkla svaret är att utbilda personalen. Dom flesta utbildningar som finns är både dyra och lär ut lite om väldigt mycket. Det finns ingen garanti att utbildningen kommer gå på djupet där du behöver. Där kommer vi in. Vi skräddarsyr en utbildning som gör dina anställda till experter inom det dom behöver kunna för att kunna utföra sina uppgifter. FALLSTUDIER Under min tid på Beijer Byggmaterial så har jag ofta varit just denna Excel expert. Vid ett tillfälle genomförde jag en utbildning för säljstaben så att dom skulle bli effektivare och samtidigt öka samarbetsförmågan för dom och min avdelning. < Back

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 210401 210402 EXTENDED EXCELLENT EXCEL TIPS - April 2021 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. A pril 1 , 2021 - Did you know ... Welcome to a new great year of amazing #facts, #tipsand #tricks that will simply make you fall in love with #excel. Well maybe not love .. but at least learn to appreciate how great it Excel is and what an amazing tool it can be both at home and at work. Come here every weekday for the latest installment, starting tomorrow. #didyouknow #excellenthelp #goodtoknow#microsoft #tasuohoriuchi #excelartist #exceltips ps I've included one of my favorite works by renowned Excel artis Tatsuo Horiuchi. This piece, like all his work, is done using only the tools available in excel. ​ ​ ​ ​ ​ ​

OM OSS Begynnelsen EXCELLENT HELP startades 2020 och drivs av Marcus Öhman. Företaget har sin bas i Skåne, men ser hela Sverige som sin lekplats. Marcus har flera års erfarenhet från flertalet företag inom lager och logistik. Under dom åren skapade han och utvecklade flera unika lösningar inom företagens Excelbehov. Varför vi finns till Genom åren har vi sett hur vänner och kollegor klagar på allt jobb som dom måste göra med Excel, och vilken källa till frustration och vrede det kan vara. Då vi alltid har haft den motsatta reaktionen inför detta moment så såg vi ett område där vi kunde hjälpa till, samtidigt som vi får syssla med något som vi älskar. Vad kan vi göra för dig Vi kan hjälpa er att få ut mer ur Excel, eller erat valda kalkylarksprogram, och hjälpa er att spara både tid och pengar. Våran Excelkunskap är nästan uteslutande självlärd och de ger oss den fördel att vi inte är hämmade av några ramar. Vi kommer att använda alla våra unika idéer till att hjälpa er. Vad anser vi Här på Excellent Help anser vi att när Excel är optimerat till sitt ändamål så kan man spara tid, pengar och även ett och annat hårstrå.

Online support via Email Vill du ha tillgång till min expertis för mindre Excel bekymmer. Under arbetsdagen så finns vi tillgängliga vid våra datorer under hela dagen. Skicka mig ert dokument och en kort förklaring kring vad som är fel/inte funkar. Så fort problemet med dokumentet är åtgärdat så skickar vi tillbaka dokumentet till er . Vid större fel så skickas en offert. FALLSTUDIER Detta är en ny tjänst och har ännu inte utnyttjats av nån kund. < Back

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date 210201 210202 EXTENDED EXCELLENT EXCEL TIPS - Februari 2021 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. F ebruari 1 , 2021 - Did you know ... Did you know that in #excel you can use something called #sparklines to give you a quick visual graph that will show you how a value is changing over time. Like any graph, sparklines can be colored and adjusted in many different ways. In our example you will see 8 cities with a several data points. In order to create sparklines for each city do the following: 1. Highlight all the #datapoints in a row. 2. Select Sparklines from the #insert tab 3. Chose which cell you want the sparkline in. 4. Done ​ ​ ​ ​ ​ ​ F ebruari 2 , 2021 - Did you know ... Did you know that it is all right for me to come with a tip this late in the day. While it is my goal to get these out nice and early in the morning, that just does not happen every day. So here we are. Today's tip: Lets say that you are given a large list of items that you have found in your warehouse (or other place) and you want to filter it down to only unique items. In the #data tab you can find an icon called #removeduplicates. Simply highlight the range where the items are listed, click the remove duplicates button and then approve. #Excel will tell you how many duplicates it found while automatically removing them from the range. Quick, easy and done. ​ ​ ​ F ebruari 3 , 2021 - Did you know ... Did you know that there is a great way to quickly remove blank rows (or cells or columns) in #excel. Once again Excel comes to the rescue here. Lets say that you get a set of data, but you get it sent to you with a lot of blank rows that you don't want to be there when you start working with the data. 1. Simply press F5, and then click on #special. 2. Select Blanks, and press #Enter 3. You will get all your blank cells, in the region around your range, highlighted. 4. Right click to delete and thenselect which way you want your range to move. 5. Done ​ ​ ​ ​ ​ 210203 210204

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 201201 201202 201203 EXTENDED EXCELLENT EXCEL TIPS - December 2020 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. D ecember 1 , 2020 - Did you know .. Xmas Xcel edition ... Now aside from being the color of a christmas tree (at least the logo is) there is actually so much more to Excel that is, or can be made to be, Christmasy. For the 1:st of December I thought we all use a little tool to help us get into, or stay in, a Christmas state of mind. Here is an easy tutorial to creating your own Christmas tree, complete with presents and blinking lights. Step 1:Highlight all the cells you need to create the GREEN part of the Christmas tree. Do this by holding CONTROL (PC) or COMMAND(mac) Step2: Release the command/control button and enter "=RAND()". Finish by pressing command/control+ENTER. This enters the same formula in all highlighted cells. Step 3: Center in the cells, then fill the cells with the green color of your choosing. STEP 4:Go to CONDITIONAL FORMATTING and choose ICON sets. Step 5: Edit the rule to be "show ICON only". Step 6: Add a stump, and color it. Add presents, as many as you want. Change the width of all the columns to about 30 pixels. Add a seasons greetings ribbon somewhere. Step 7: Press and hold F9 to make the lights blink. ​ ​ ​ ​ ​ D ecember 2 , 2020 - Did you know ... Did you know that, as of today, there are 22 days left until Christmas. At least for those of us who celebrate on the 24th. Yesterday I showed you how to make a BLINKING CHRISTMAS TREE in EXCEL, and today I have made an ADVENT CALENDER to help keep you in that Christmas state of mind. The basics of the tree and the boxes is all just filling cells, and the star is 3 INSERTED SHAPES (a star) in different sizes stacked on top of each other. I have made sure to MERGE the cells in each red box. Then I entered this formula: =IF(DATE(2020,12,2)=TODAY(),"THERE ARE 22 DAYS LEFT TILL CHRISTMAS","2") In each red box, adjusting the DATE function and the TEXT so it is right for each day. What this formula does then is that when DATE function is equal to the TODAY function it will display text showing me how many days are left till Christmas, otherwise it will show me the date. You can adjust the text to whatever you want, and the size of the cells as well to make room for more text. As a bonus I have added a MACRO that changes the size of the cell font so that the date can be displayed as a larger font. ENJOY ​ ​ ​ ​ ​ D ecember 3 , 2020 - Did you know ... Did you know that THE TWELVE DAYS OF CHRISTMAS is a very long song? If you have ever heard it then you know it to be a very true story. And a hardship that comes with a very long song is remembering the lyrics. The easiest way would of course be to just jot them down and look and them, but that would not be as much fun as making an EXCEL flash card game to learn the lyrics. What I did what write each days lyrics into 12 separate boxes, then make a cell that would only let me enter a number from 1 to 12 and then some conditional formatting that would hide every other day than then one I wanted to look at. Nice and simple right. If you have any questions regarding how the inner workings functions, as a question in the comments. ​ ​ ​ ​ ​ D ecember 4 , 2020 - Did you know ... Sorry for the late posting today .. but then again it is Friday and I am allowed to be a bit lazy sometimes. Today's tip is more something for the years to come, as we already know what day of the week Christmas will fall on ... right. Well, let's say that we don't know .. or that we are planning our Christmas for next year and we want to know what day of the week the 25th of December and the 1st of January falls on so we know which days we get off from work and how many vacation days we would need to add to make our vacation last as long as possible. By using the date function: =DATE(2020,12,25) or =DATE(2021,1,1) You can substitute the date with a cell value if you have a column or row of years. But this will of course only display the date in the format of our choosing. This is where we get fancy. By CUSTOM FORMATTING the cells with "dddd" we get the formula to show us the day of the week. ​ ​ ​ ​ ​ D ecember 5 , 2020 - Did you know ... Did you know that EXCEL could make even Santa's job easier. Let's take Santas list as an example. I have constructed a quick list that consists of a number of names and a few requirements to remain on the "NICE" list. Step 1 is figuring out if the child in question has done all the things required on the NICE list. As it is important that they have a "YES" value in each cell, I have used an IF function with an AND function in it. This looks at every cell in the row and asks if has the value "YES". If it does then the child gets a gift, otherwise coal. Step 2, conditional formatting to find the children who get coal. Step 3, figuring out why the child gets goal. What I did here was use another IF function, with a text string for the "VALUE WHEN FALSE". For the VALUE WHEN TRUE I am using an INDEX, function with a nested MATCH function with a little concatenation sprinkled in for fun. Check it out and see what you think. ​ ​ ​ ​ ​ D ecember 6 , 2020 - Did you know ... Did you know that today is second advent. Now most people celebrate this by lighting the second of the four advent candles. Me being an EXCEL guy, I went another route. I have made my own advent candles in EXCEL. The basic shape of the candles is made by simply filling cells with color. I shaped out the flames by holding down CONTROL and clicking on all the boxes that I wanted to be in my candle flame. When the last box is clicked enter the function: =RAND() ... then press CONTROL+ENTER to enter the same formula in every chosen cell. Then I used CONDITIONAL FORMATTING and chose the ICON SET to add color to the changing values. I changed the GREEN color to YELLOW (could have been red, doesn't make any difference). Then I copy pasted a second candle with flame, and then copy pasted two more candles with no flame. The text inside the candles is for good measure. Once everything is in place, press and hold F9 to see your flames flicker. Man EXCEL is really great. ​ ​ ​ ​ ​ D ecember 7, 2020 - Did you know ... So this week I thought I would start out with a formula that might not seem as useful on the surface, but once you get in and start getting creative with it .. it really turns into something great. The INDEX function. Basically the index function works like this: =INDEX(array to search in, what row, what column) - return value And you would think that you could then just let your cell be equal to that other cell and be done with it. But what if you need to look around in different cells but you want the value always returned in the same cell. In my example I have a table of the 9 planets, their relative position, diameter and number of satellites. And I have set up two DATA VALIDATION LISTS to let me choose different variables. I am then using the INDEX function, with VLOOKUP to find my row number and HLOOKUP to find my column number. That formula looks like this: =INDEX(B3:E11,VLOOKUP(G7,B3:F11,5,0),HLOOKUP(H7,C2:E12,11,0)) Just imagine the possibilities with this set up. Endless amounts of fun. As always, if you have any questions just comment below. ​ ​ ​ ​ ​ D ecember 8, 2020 - Did you know ... Did you know that there is this amazing thing called FLASH FILL. It is a part of the sort AI aspect of EXCEL and it can do some seriously amazing things to help you out. In today's example I have acquired a list of 100 random emails that I would like to group by their providers. So what I need is a way to extract the provider from each email address and put that into its own column so that I can then order that in ascending order. What I don't want to do is sit and read of each address and type the provider name by hand. This is where FLASH FILL comes in handy. With the list placed in column A, I type the provider name from the first two email addresses into column B. I am basically taking the text written between the "@" and the first "." With two solid examples of what I am doing I can simply mark the next PROVIDER cell and press CONTROL+E (same for both MAC and PC), and EXCEL will fill in my entire column for me. Easy peasy and I've got a list that I can now work with. ​ ​ ​ ​ ​ D ecember 9 , 2020 - Did you know ... Did you know that you can use the FIND and/or REPLACE function within EXCEL in order to adjust massive amounts of text. In our first table we have several issues that are affecting the user friendliness of the text inside it: 1: The > and < surrounding the country names 2: The hyphen in the middle of the person names 3: The text "at a private company" in the last column is unnecessary. Begin by highlighting the area that you want to remove/replace. The > and < need to be removed in two steps, one symbol at a time. When removing the hyphen, you have to make sure that you add a SPACE (place cursor in the REPLACE WITH box and press the space bar once). For all steps enter the symbol or text string that you want to remove into the FIND WHAT box. ​ ​ ​ ​ ​ D ecember 10 , 2020 - Did you know ... Today's #didyouknow will be in the spirit of what we learned yesterday. More text manipulation. It is not uncommon, when importing massive amounts of data into #EXCEL, that information gets lumped together into one column. So what do you do. Now you can use Tuesday's tip and set up for a flash fill, but there is another way that goes a bit faster in this case. In picture one you can see a small sample set of ID, country, first and last name. After highlighting all the rows that we want to manipulate, we go to the #DATAtab and choose #texttocolumn; then using the #delimited setting we can press next; then we select that different delimiters that are separating our information; after making sure that preview is correct select finish and see the results. If you finish right away you will replace your old column with the newly divided information. But you can also go with next again and select another destination for your information. ​ ​ ​ ​ ​ D ecember 11 , 2020 - Did you know ... Did you know that you can use something called #hyperlink in #excel to allow you to quickly navigate between different tabs in a large document. It is pretty cool if you ask me. In my example I have set up a small table with with 3 cells that I want to couple together with their respective tabs. What you have to imagine here is that the front/start tab consists of hundreds-thousands of cells and that the information in the tabs is just far too big to have on the start tab. Simply right click on the first cell that you wish to assign a #hyperlink to and choose hyperlink from the bottom of the menu. Select the option "this document" and then select the tab from the menu. Once you are done your text will alter color and become underlined, signifying that you have hyperlinked it. Repeat for the other cells. Come back tomorrow and I will show you how to create the "BACK" button that allows you navigate as easily to the start tab. If you have a question, comment below. ​ ​ ​ ​ ​ D ecember 12 , 2020 - Did you know ... Did you know that yesterday I left you all with a bit of cliffhanger ... Maybe that is an overly dramatic way of putting it, but I did promise to tell you how to create a button that you can #hyperlink. Basically, this works more or less the same as it does when hyperlinking a cell. There is a bit of work that needs to be done first though. In the #insert tab, choose #shapes and there pick the shape you want. Move your cursor down to the document and click and drag to place the shape (also choosing what size you want, this can always be altered later). Then right click on the shape and edit text to put a text on the button. Once you've done right click on the shape again and choose hyperlink; then, select where you want it to link to. Once you've done that the button is an active hyperlink, so if you want to edit it in anyway you have to right click it. Look over the pictures posted to see the steps in real life. If you have any questions, comment below. Come back to tomorrow for the third advent. ​ ​ ​ ​ ​ D ecember 13 2020 - Did you know ... I bet a lot of you actually #didknow that today is the third advent. That means today we light the third of our four advent candles. In honor of that I am bringing back my little lovely #exceladvent candles. From last week, when only two candles were lit I have simply copy and pasted the candle light from candle 2 to candle 3. All the formatting comes along with it, so I did not need to add anything to it. The formula in each cell is simply =RAND(). Then, once you're done with all that and everything looks nice .. just press and hold F9 and your candle flames will flicker for you. Enjoy the holidays. ​ ​ ​ ​ ​ D ecember 14, 2020 - Did you know ... Today we are going into the future .. so to speak. I will show you how EXCEL can help you #predict/ #forecastthe future. There is a lovely #function called #forecast.linear that will look at the numbers that you have in a sequence and predict the coming number/numbers. In my example I have a table the is showing me the amber of customers, sales and returns that I have had for a number of years, and I want to see what I can expect to happen in the upcoming 3 years (assuming that my company continues to grow at the same rate) Here is the formula: =FORECAST.LINEAR($D21,$E16:$E20,$D$16:$D$20) for #of customers in 2020. ​ ​ ​ ​ ​ D ecember 15 , 2020 - Did you know ... Did you know that you can make an #excel document that links directly to webpages or email addresses. Some of you are reading this and going .. Marcus, of course we do. But then I add to this, did you also know that you don't have to have the link look like an email address or a webpage. Did I get your attention there. In today's example, I am showing you a made up example of a company staff list with their email addresses. Along with a direct link to the company website. Then I could include this in a send out to potential customers and they would have a click-a-ble link to me. Today we begin with linking the company name to the company website. We start by right clicking on the cell with the company name and choosing hyperlink. Then, on the website/file tab of hyperlinking I enter the website in the address slot. Making sure to enter in the text I want to display in the "text to display" slot. Then you can click on the cell and it takes you to my website. ​ ​ ​ ​ ​ D ecember 16, 2020 - Did you know ... Did you know that there is even more things that you can do with #hyperlinks in #excel. Yesterday I showed you how to take a cell and make it link to a homepage, taking a cell with only text and making that text a hyperlink. Well, when you enter an email address, Excel will always make that a hyperlink and sometimes you don't want that. So in today's example I will show you the simple way we remove a hyperlink. First step; I am highlighting all the cells that I don't want to hyperlink, right clicking and choosing "remove hyperlink". Easy as all that. Come back tomorrow for more hyperlink-madness. ​ ​ ​ ​ ​ D ecember 17, 2020 - Did you know ... Did you know that I was not yet done geeking out over #hyperlink on #excel. Well, if you didn't know before .. I assume that this comment certainly tells the whole story. So far I have shown you how to take text in a cell and turn it into a hyperlink to a website, how to remove the hyperlink from email addresses and I have also previously shown how to use the hyperlink function to allow you to travel from tab to tab within an excel #workbook. Today I will show you how to edit the TEXT TO DISPLAY and what a SCREEN TIP is. Getting access to both of these is done by right clicking on the cell/hyperlink and choosing EDIT LINK. The SCREEN TIP is a small message that will appear when you hover the mouse cursor over the hyperlink. In this case I have made mine read "send me a question". As for TEXT TO DISPLAY, I made mine say "send Marcus an email". This is a very aesthetic choice as I just find that this looks nicer than just having my email address showing. ​ ​ ​ ​ ​ D ecember 18 , 2020 - Did you know ... Now I'm sure that there are many of you out there that already know that there are plenty of great things you can do to spice up a party by using #excel. Things like #bingo. Well, maybe not a party .. but who doesn't love BINGO. In the coming days I will show you how to build an excel document that you can use for any type of bingo you like. Fill it in with your own facts/things, make the board as big as you want it to be or spice up the appearance however you like. Today we will look at making your sheet. You will want two tabs: 1. One for the #bingoboard, with as many copies as you like. 2. One for the list of items you want in the sheet. It is rather smart (necessary) to make the cells on sheet two(where you write your facts) and the cells in the #bingosheets (so that you can set fonts and sizes from the get go). You can see in my pictures how a plain and simple bingo sheet can look. Keep all your facts in a single column. And make sure you turn off AUTOMATIC FORMULA CALCULATION. You can turn it back on for other sheets, but for this one it needs to be set to manual. I will explain why later. ​ ​ ​ ​ ​ D ecember 19 , 2020 - Did you know ... Did you know that last night I left you with a blank #bingosheet. Today I will address that and give you the #formula to fill in the sheet with. One change from yesterday. I said that it was important to keep all the facts in one column, that turned out not to be necessary. Have as many columns there as you like .. so I've added a second to illustrate that. Now, to fix the #bingoboard .. we begin by highlighting all the cells in the board, then going to the formula field and enter this: =IFERROR(INDEX('Fact sheet'!$A:$B, RANDBETWEEN(2,51),RANDBETWEEN(1,2)),"") Press Command+Enter(MAC) or Ctrl+Enter for PC. #iferror is there in case something does not work and will return blank cell. Then we are using #index, which returns the value in the row number and column number indicated. For that we are using #randbetween. In the formula it returns a row from 2-51 and a column from 1-2 (A-B). After that you can copy the entire board and paste it into the other boards. Come back tomorrow to find out why some squares are red. ​ ​ ​ ​ ​ D ecember 20 , 2020 - Did you know ... Well, here we are on the #fourthadvent. This is the last one before #christmas. I know you were all expecting the continuation of my #bingo thread, but that will continue tomorrow. As for today. Reopen your #adventcandle file, which you have of course all made and saved since the first advent, and lets make some adjustments. Copy the flame from the third candle and paste it on top of candle number four. Then, something that I should have done from the beginning as well, adjust the heights of the candles so it looks as if they have been used. Then just press and hold F9 and enjoy the your advent candles, brought to you by #excel, #randbetween and some basic cell filling and fun. ​ ​ ​ ​ ​ D ecember 21, 2020 - Did you know ... Did you know that we are returning back to #bingo now. Today I will explain to you how #excel helps me make sure that I don't have any duplicates on any given sheet. If you remember the pictures from Saturday, there were some cells that were red with red text. So what I did was add a bit of #conditionalformatting to warn me about duplicates by coloring those cells. Using "format only unique or duplicate values" and choose #duplicatevalues. Now, to get a sheet with no duplicates, go to the #formulatab and click on #calculatenow as many times as needed until your sheet is devoid of duplicates. Here is also the reason that formula calculation is set to manual, because otherwise every change you make to the sheet will recalculate the cells. Which could be annoying if you've finally got a sheet with no red cells. Come back tomorrow for another step forward in #bingo evolution. ​ ​ ​ ​ ​ D ecember 22 , 2020 - Did you know ... Did you know that I have yet another level to #excel#bingo. So there is this great version of bingo called #minglebingo. At least that is how I know it. It is a great way to help/force people at a party to mingle. Basically, before the event, everyone sends you 1 or 2 (or more) strange/funny facts about themselves. Now, you can put that into the #bingosheet that I have already shown you. But you need to make sure that they get everything right. For this I created an answer board that looks at the fact on the board, and then using a double/nested #vlookupfunction to get the name of the person who submitted the fact. Here is that #formula: =IFERROR(VLOOKUP(B3,'Fact sheet'!$A$2:$D$166,4,0),VLOOKUP(B3&"",'Fact sheet'!$A$2:$D$166,5,0)) You can see on the fact sheet that I have 1 column for facts, 1 for first name, 1 for last name and lastly 1 column where the first and last names are combined so the full name shows up in the answer sheet. I did this cause I wanted to alphabetize by their first names. Remember that #calculationoptions must be set to #manual. This is to ensure that the board you print out and the answer sheet are a match. ​ ​ ​ ​ ​ D ecember 23 , 2020 - Did you know ... Today, or rather tonight, being the day before Christmas for those of us living in Sweden. I only have one tip. Have an EXCELlent evening and enjoy the holidays. ​ 201204 201205 201206 201207 201208 201209 201210 201211 201212 201213 201214 201215 201216 201217 201218 201219 201220 201221 201222 201223

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 210301 210302 EXTENDED EXCELLENT EXCEL TIPS - Mars 2021 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. M ars 1 , 2021 - Did you know ... Welcome to a new great year of amazing #facts, #tipsand #tricks that will simply make you fall in love with #excel. Well maybe not love .. but at least learn to appreciate how great it Excel is and what an amazing tool it can be both at home and at work. Come here every weekday for the latest installment, starting tomorrow. #didyouknow #excellenthelp #goodtoknow#microsoft #tasuohoriuchi #excelartist #exceltips ps I've included one of my favorite works by renowned Excel artis Tatsuo Horiuchi. This piece, like all his work, is done using only the tools available in excel. ​ ​ ​ ​ ​ ​

Nytt och Optimerat Excel-kalkylark Vet ni att behöver använda Excel men vet inte var ni ska börja. Låt oss hjälpa er då. När målet med dokumentet har diskuterats fram via ett möte så skräddarsyr vi ett dokument som gör det ni vill att det ska göra. FALLSTUDIER Marcus har vid flertalet tillfällen under min tid på Beijerbygg Material AB skapad nya Excel dokument för diverse olika mål och uppgifter på lagret. < Back

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 201016 201020 201021 EXTENDED EXCELLENT EXCEL TIPS - Oktober 2020 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. October 20, 2020 - Did you know ... Did you know that Excel can tell you what day it is. There are some simple formulas that you can type into a cell and it will tell you the day, what time it is or all of the above. =NOW() - mm/dd/yy hh:mm =TODAY() - mm/dd/yy =HOUR(NOW()) - hh =YEAR(NOW()) -same as- =YEAR(TODAY()) - yyyy October 21, 2020 - Did you know ... Today's did you know is more of a "have you heard". So, have you heard about a brilliant thing called Flash Fill in Excel. It is another leap forward in Excel's AI. Lets say that you have gotten a list of names where first and last names are in separate columns and you want to bring them together. You simply fill in the first cell in the "Full name" column and then the magic happens. On a PC flash fill can be set to automatically happen, while on MAC you need to press "control+E" to invoke Flash Fill. You can see the three steps of the process in the attached images. ​ ​ ​ ​ ​ ​ October 22, 2020 - Did you know ... Did you know that there is more to excel than simply "=". You can make "greater than", "less than" and "not equal to" comparisons as well. I have attached an image that shows the simple formulas you can use and how it acts. I also added a simple Conditional Formatting to tell me when the formula is TRUE. Let me know if you want to know more about Conditional Formatting and I will talk about that tomorrow. ​ ​ ​ ​ ​ ​ October 23 , 2020 - Did you know ... I don't know if the rest of you love Conditional Formatting as much as me, but I will tell you one great use for it. Have you ever had to enter so much information into a document that you kind of lost track of what you enter in. And then you are not sure if you have entered something twice. Well there are some simple ways to find and eliminate those duplicates. Now, I know that Excel has a "Remove Duplicates", but that just removes it the duplicates without allowing you to analyze them. By Using Conditional Formatting you can highlight the duplicates so you can find them, analyze them and then change them. I once made a Bingo Sheet template and I had to be certain that I had no duplicates. Check the attached pictures for a bit of a step by step .. and if you have any questions feel free to contact me. ​ ​ ​ ​ ​ ​ October 26, 2020 - Did you know ... Today's little lesson will deal with a nice formula called DATEDIF. What this excellent gem can do for you is calculate time between dates. What you need is to have two cells with separate dates, then in a third cell you enter the following: =DATEDIF(CELL1, CELL2, "XX") CELL 1 - the starting date CELL 2 - the end date XX - y(years), m(months), ym(the months left after calculating years), d(days), md(the days left after calculating months) See attached images below for the formula in action. ​ ​ ​ ​ ​ October 27, 2020 - Did you know ... Today we will look at a situation where you want to just sum up your top or bottom results out of a range. As with everything EXCEL has the answer for this too. And that answer is combining SUMPRODUCT with either LARGE or SMALL. The generic formula would looks like this: =SUMPRODUCT(LARGE(range,{1,2,3})) for top 3 =SUMPRODUCT(SMALL(range,{1,2,3})) for bottom 3 As always I have attached some pictures that will show you the formula in action. Enjoy. ​ ​ ​ ​ ​ October 28, 2020 - Did you know ... Today we will have a look at something to expedite a task like grading results. In the example in the attached images we are looking at this from a school teacher's perspective. We are using an IF formula to quickly tell us if the student in question has PASSED or FAILED the class. The formula in the cells is as follows: =IF(cell>60, "PASS", "FAIL") We have chosen a result of 60% correct or better to be a passing grade. Come back tomorrow to see what we do if the class is not pass/fail. ​ ​ ​ ​ ​ October 30, 2020 - Did you know ... As promised yesterday, I am back today with another step within the IF formula world of EXCEL. Yesterday we created a formula that graded each student as PASS or FAIL based on a numerical test result. Today we will grade them on a scale from A to F. If you are like me and not using Office 365, then you will have to utilize a NESTED IF FORMULA. Here comes the formula I am using in the pictured example: =IF(C5<60,"F",IF(C5<70,"D",IF(C5<80,"C",IF(C5<90,"B",IF(C5>=90,"A",""))))) You can see the grade levels in the formula above and the results of it in the attached images. The nesting basically makes EXCEL check the cell value against criteria from left to right. If you have OFFICE 365 you can use the following formula as well: =IFS(C5<60,"F",C5<70,"D",C5<80,"C",C5<90,"B",C5>=90,"A") ​ ​ ​ ​ ​ 201022 201023 201026 201027 201028 201030

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 201102 201103 201104 EXTENDED EXCELLENT EXCEL TIPS - November 2020 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. N ovember 2 , 2020 - Did you know ... Did you know that CONCATENATE is a word in the world? It is derived from the Latin word directly concatenare, which in turn is formed from con- (meaning "together") and catena( meaning "chain"). But that is not the best thing about it, the best thing is what it does as an EXCEL formula. It can be used to smoothly combine a list of first and last names (or any text strings from cells) in a new column. As always there are pictures attached showing how it is used. The formula being used is this: =CONCATENATE(cell1&" "&cell2) cell 1 = First names cell 2 = Last names " " = quotes with a space to create a space between the first and last name. ​ ​ ​ ​ ​ N ovember 3, 2020 - Did you know ... Did you know that there is even more we can do with CONCATENATE. Working off of the same list from yesterday we are now looking to create an email list for all the employees at our fictitious company. In this company everyones email address is : firstname.lastname@department.company.com So, by using CONCATENATE again we can achieve this by using the formula thusly: =CONCATENATE(A33&"."&B33&"@"&D33&".company.com") Look at the pictures below to see how this works. ​ ​ ​ ​ ​ N ovember 4 , 2020 - Did you know ... Did you know that when countries print/create regular license plates there are certain letter combinations that are not allowed to appear. Since the License plates are randomly generated there needs to be a way to check to make sure that nothing inappropriate makes it onto a plate. In todays example I am using a 4 formulas, nested to help me make sure that a range of text strings never appear anywhere in my cell. Here is my formula: =IF(SUMPRODUCT(--ISNUMBER(SEARCH($A$67:$A$70,C67)))>0,"REJECT","APPROVE") Boy that is a doozy. The IF formula is what helps me return REJECT vs APPROVE in my cell. SEARCH does the actual looking while ISNUMBER coupled with SUMPRODUCT (and the "--", double negative) makes everything into an array that allows me look for every word in the BAD WORDS list. Pictures, as always, attached below. ​ ​ ​ ​ ​ ​ N ovember 5 , 2020 - Did you know ... Well hello there everyone. We are going to revisit some pictures you've seen before (sort of) and address another common problem. Looking for blank cells and/or getting an accurate count on the number of blank cells. Seen from the perspective of a teacher grading assignments this can be a way to see who has not turned in their assignment or that they have missed to enter their grades. I am going to show you two ways to do this. CONDITIONAL FORMATTING to highlight the blank cells, which would work on its own for a smaller sample set. Then coupled with a COUNTIF formula to count the number of blank cells which would be helpful when dealing with larger sample sets. The CONDITIONAL FORMATTING you can see the steps in the pictures and for COUNTIF, the formula is: =COUNTIF(range,"") ​ ​ ​ ​ ​ ​ N ovember 6 , 2020 - Did you know ... Have you ever heard of a little EXCEL gem called SUBTOTALS. SUBTOTALs will essentially do what it sounds like it does. It will allow you to have a SUBTOTAL rows in the middle of a column while still having a total at the bottom that will not count the SUBTOTALS. You can use this formula when calculating SUM, AVERAGE, MAX or MIN value to name a few. Here is the formula in basic form: =SUBTOTAL(1,C2:C4) 1 - is the FUNCTION NUMBER (see first picture) C2:C4 - is the first range to be SUBTOTALed ​ ​ ​ ​ ​ ​ N ovember 9 , 2020 - Did you know ... This week we will begin with the DID YOU KNOW with a VBA code. Something I don't use too often, but that can be super useful. There are plenty of cases where we may not want people to be able to see what formulas we have in certain cells. By using a simple little program, you can password protect any numer of cells from showing their imbedded formulas. The results will still be visible, but no one will ever be able to see how you did it. STEP 1: open VIRTUAL BASIC on the DEVELOPER tab and add a module to the entire worksheet. Enter the programming language shown in one of the pictures. STEP 2: select the cells you want to hide the formulas of. Select MACRO from the DEVELOPER tab and select the MACRO and run it. The formulas are now hidden. STEP 3: to unhide the formulas, go to the REVIEW tab and select PROTECT SHEET, enter the password you entered in the MACRO (pass in this example) and the formulas can once again be seen. As always, pictures that follow will show you everything. ​ ​ ​ ​ ​ ​ N ovember 10, 2020 - Did you know ... Have you ever decided to make a graph only to get frustrated by the automated choice of color that EXCEL decides to give you. Never does this become more poignant than when you are dealing with category titles that are colors. You might just go to chart design and choose from the CHOOSE COLOR button, but all that lets you do is pick from some pre-programmed color schemes. And you want to color every stack personally. For the longest time I thought this required some serious work-arounds. But that is far from the truth. The truth is that coloring your stacks (or pie slices) is as easy as filling in a cell. If you CLICK on one stack, you will select all the stacks (see the blue dots in the corners of the stack in the pictures). When you then click on another stack you will have selected only that one (again, see small blue dots). Then all you do is select the CELL COLOR FILL button on the HOME tab and select your color. Repeat as many times as needed to get the result you want. As always, pictures attached will show you each step I have written about. If you have any other questions about this, respond here and I will respond in kind. ​ ​ ​ ​ ​ ​ N ovember 11 , 2020 - Did you know ... Excel has, among so many other great things, something called a SLICER. Now, what are SLICERS I hear you asking .. or at least I assume some of you may be asking this. So what do they do, well ... simply put they are a quicker and more visual way to work with filters in a TABLE. STEP 1: Make your RANGE into a TABLE from the HOME tab. STEP 2: In the TABLE tab you can select INSERT SLICER. STEP 3: Select the Columns you want SLICERS for. STEP 4: Resize and place your SLICERS where you want them. STEP 5: Click your SLICER and see what happens. Have fun with it. Look over the attached pictures, and if you have any questions about this function respond to the post and I will answer. ​ ​ ​ ​ ​ ​ N ovember 12 , 2020 - Did you know ... Here comes a simple, but useful EXCEL factoid. As many of you know, when working with EXCEL you might see things like #NUM! or #N/A! , and that means that something is not right. Your sheet will not work and you need to figure out why. Well, one thing that will help you is a little overview of the different ERROR MESSAGES you will see and what they mean. This way you will know where to begin looking. ​ ​ ​ ​ ​ ​ N ovember 13 , 2020 - Did you know ... Have you heard of a nifty little function called CELL. I know that it sounds rather generic, but what it can do for you is anything but. For the purpose of this little demonstration we will be using 3 out of the 13 versions of the CELL formula. And with it we will track any changes made to your documents. With the following formulas entered into cells (any cells really): =cell("address") =cell("contents") =cell("filename") Excel will tell you which cell was changed, what the new content of the cell is, and the path to the sheet where the change took place. For WINDOWS (PC) users you can enter these cells into a WATCH WINDOW (located in the FORMULA tab) and that will allow you to have a small floating window that will allow you to keep an eye on your changes. For MAC users we would have to create a separate EXCEL where we have these formulas entered and adjust the size of the window so it can be "free floating" ​ ​ ​ ​ ​ ​ N ovember 16 , 2020 - Did you know ... Welcome to Monday everyone, time to start a new week with some new EXCEL tips. This whole week I will be talking about DATA VALIDATION; how to use, when to use it and why to use it. In today's first example we will look at a section of a table of information where we have a column that will only ever consist of one or four words. We use DATA VALIDATION here in order for us not to have to write in our option every time. Now, I know that once you have entered every option at least once EXCEL will automatically create a sort of drop menu for you to choose from, but with DATA VALIDATION you will be able to have gaps in the table and still get at your options. DATA VALIDATION is basically sort of like CONDITIONAL FORMATTING in that you must FORMAT every cell where you want to have access to your options. STEP 1: Choose DATA VALIDATION from the DATA tab STEP 2: Choose LIST and enter your options/variables, separated by commas. STEP 3: Use the "DOWN ARROW" now visible in the table to enter the correct option for your row. ​ ​ ​ ​ ​ ​ N ovember 17 , 2020 - Did you now ... Hello, hello, hello. Day 2 of DATA VALIDATION is upon us. And here comes a small be very useful reason to use DATA VALIDATION in large/complex tables or ranges. If you visited my comment yesterday, you should recognize the tables in the pictures that I am using today. And what I will show with my pictures is the simple fact that DATA VALIDATION makes it impossible to enter a something into the column you have formatted that you have not preset to be allowed to be entered. In this example we are attempting to enter "book" into the column, even though it is not one of our accepted options. This factor is particularly useful when you have formulas set up to use that particular column. Enjoy this fact and see you tomorrow for even more DATA VALIDATION craziness. ​ ​ ​ ​ ​ ​ N ovember 18 , 2020 - Did you know ... Moving on with our week of DATA VALIDATION, today we will discuss how we create a larger sample range for our potential drop-down menu. This is something that you would do if you had several different variables. And this range of variables can be placed on a separate SHEET, thereby keeping it out of view for everyday use. The difference here is that instead of entering the different variables you want in you menu, you enter the range where they are written down. Just like I showed you yesterday, you are still guarded from entering a variable that should not be in your table. Come back tomorrow to see how you make a dynamic range where you need to constantly add or remove variables. ​ ​ ​ ​ ​ N ovember 19 , 2020 - Did you know ... Yesterday I wrote about how you can use an entire range to a drop down menu via DATA VALIDATION. Well, what do you do if you are constantly adding to or removing things from that RANGE. You would want your drop down menu to automatically update itself without you having to go in and fiddling with it. Today we will discuss one of the ways you can do that. What you want to do is change your range to a TABLE, using the FORMAT AS TABLE function on the HOME tab in EXCEL. Then you will want to NAME that table via INSERT (menu), NAME and DEFINE NAME. Enter that NAME into the DATA VALIDATION range. With that done, as you add new items to the end of your range, they will automatically appear in your drop down menu the next time you open it. Come back tomorrow to see a way to make a dynamic DATA VALIDATION drop down menu without having to create a TABLE. ​ ​ ​ ​ ​ ​ N ovember 20 , 2020 - Did you know ... Here we are, day 5 of DATA VALIDATION week. And in my opinion I have saved one of the best for last. Here is the formula that you will want to know if you are working with lists/ranges that are prone to changing often. Using this formula: =OFFSET(first cell of the table,1,0,COUNTA(range of the table)) As your DATA VALIDATION source will allow you to add or take away items from the RANGE and it will automatically resize and adjust your drop down menu. Here comes a step by step of the pictures below. STEP 1: Here is our table with a prepared cell for our DROP DOWN MENU. STEP 2: Open DATA VALIDATION under the DATA tab and choose LIST. STEP 3: Enter the formula. STEP 4: Check to make sure your DROP DOWN MENU contains all our factors. STEP 5: We add two new words (cartoon, flyer) and check to see that our update works. If you have any questions about this just write them in the comment and I will get back to you. Come back on Monday for a new themed week. ​ ​ ​ ​ ​ N ovember 23 , 2020 - Did you know ... If, if, if, if .. look forward to a whole week of IF. The amazing range of uses for IF is nearly limitless, and this week I will show you 5 of those uses. They might not be the flashiest things out there, but they are super useful. In this first example we will be working with a range of material that we are selling (see picture). A few basic cell arithmetic formulas are being used to figure out the values in some of the columns, but in column F (Discount or not) we need our first IF function to see if we indeed will be offering a discount and what that discount will be. In that column we are using this formula: =IF(no. sold>=100, cost * 0.1, "NO DISCOUNT") =IF(logical test, IF TRUE, IF FALSE) What the formula is saying is as follows: If the number of units sold is GREATER THAN or EQUAL to 100 take the COST and MULTIPLY it by 0.1 (10%), and if that units sold is less than 100 display NO DISCOUNT. As you can see in the pictures, there are plenty of lovely error messages as well. Come back tomorrow and I will show you how we remove them. ​ ​ ​ ​ ​ N ovember 24 , 2020 - Did you know ... A merry tuesday to you all. Yesterday we left off with a table that a fair number of #VALUE! errors. Why did this happen and what are we going to do to fix it .. simple. More IF functions. Today we will be implementing IFERROR to deal with our error. You can see where we left off in the first picture. The reason we are getting a #VALUE! error is because there is no number in certain places in column F (the places where no discount takes place) Now we could have simply let yesterdays formula return a 0.00 in that column, but that is not as much fun. So now we have a simple subtraction formula that involves text, and the returns an error. Here is the solution. =IFERROR(COST-DISCOUNT;COST) =IFERROR(VALUE; VALUE IF ERROR) This does a lovely job of removing all the #VALUE! errors, but we get a few new #DIV/0! errors in column H. Come back tomorrow for the solution to that beauty. ​ ​ ​ ​ ​ N ovember 25 , 2020 - Did you know ... Welcome back for day three, Wednesday, of our IF function week. Yesterday we left our range with a column that contained a few #DIV/0! error messages, and I said that today we will remove them. Now, we do have one other issue that we will need to address with our choice of formula, and that is the fact that we don't want anything to be calculated here if there is no discount. We only want a figure to be displayed when there is a discount to be counted. If we were simply going to remove the #DIV/0!, then "=IFERROR" would be sufficient. But here we are nesting the IFERROR inside a simple IF to eliminate both issues. Our formula looks like this: =IF(discount?="no discount", "NO DISCOUNT", IFERROR(end price/unit price, unit price)) So basically if we are not giving a discount then we we will display no discount, but if we are discounting the price then we want to be able to see what our new unit price is, and we are guarding against errors by using the IFERROR function there. Tomorrow we will move on to something different. See you then. ​ ​ ​ ​ ​ N ovember 26 , 2020 - Did you know ... Welcome to Thursday, and another great day to think about IF functions. Yesterday we left our range with no errors and looking sharp. Well .. I can't leave it like that. Today I decided to add three new columns. One to determine whether or not the material bought should be delivered or picked up, one to determine whether or not I need to adda surcharge for delivery to the total price and the last one simply giving me the final price due for the purchase. Now, on the surface this would be a simple case of throwing in an IF function asking whether or not column I's cells include the word "delivery" or "pickup". But this can create a problem if the person entering the data accidentally enters a space in the cell. So what to do ... Nesting the TRIM function in the IF function cuts out the spaces and leaves only the actual text in the cell alone, saving us $75 per possible mistake. Here is the formula in the cell so you can copy/paste it for your own use: =IF(TRIM(I2)="delivery",75,0) Come back tomorrow for the weeks final IF. ​ ​ ​ ​ ​ N ovember 27 , 2020 - Did you know ... And here we are now. We have made it to the end of another week and I thought what else to do on a Friday then celebrate with the Cure and an #IF function. So how does that work? I have set up a range that includes the 7 days of the week and 3 rows for the 3 different verses of the song. Then I set up a #datavalidation #dropdownmenu to allow me to select the different days of the week along with a lovely little, albeit long, IF statement with some added spice to tell me what happens on the given day I select. I will share the formula in a comment as it is too long to include here. This might not seem like the most super useful thing, but it is a good example of yet another way to use IF in excel. Feel free to comment to question, and have a great weekend. ​ =IF(C10="Monday","On a Monday I can be "&RIGHT(B3,4)&" or be "&RIGHT(B4,5)&" or "&B5, IF(C10="Tuesday","On a Tuesday I can be "&RIGHT(C3,4)&" or have a "&C4&" or "&C5, IF(C10="Wednesday","On a Wednesday I can be grey "&RIGHT(D3,3)&" or have a "&D4&" or "&D5, IF(C10="Thursday","On a Thursday "&E3&" or I will be "&E4&" or I can "&E5, IF(C10="Friday","On a Friday "&F3&" or "&F4&" or "&F5, IF(C10="saturday","On a Saturday I will have to "&G3&" or "&G4&" or "&G5, IF(C10="sunday","And of course a Sunday "&H3&" or it "&H4&" or it "&H5, IF(C10="", "PICK A DAY","")))))))) ​ ​ ​ ​ ​ N ovember 30 , 2020 - Did you know ... That in the US Thanksgiving was celebrated on the Thursday preceding this weekend. Meanwhile Canada celebrated Thanksgiving much earlier in the previous month. That is because Canada celebrates Thanksgiving on the 2:nd Monday of October and the US on the 4:th Thursday of November. Now, what does that have to do with Excel. Well, instead of mucking about with a calendar when trying to find the date for the upcoming Thanksgivings. We can simply let EXCEL do all the heavy lifting. For Canadians: =DATE(A2,10,15)-WEEKDAY(DATE(A2,10,6)) For Americans: =DATE(A2,11,29)-WEEKDAY(DATE(A2,11,24)) Where A2 is the a cell in a column that denotes the year that we are looking into. Now with Thanksgiving over with, and tomorrow being the 1st of December it is time to get into the Holiday spirit. Starting tomorrow I will start a 24 day countdown to Christmas with a new fun fact everyday, including weekends. ​ ​ ​ ​ ​ ​ 201105 201106 201109 201110 201111 201112 201113 201116 201117 201118 201119 201120 201123 201124 201125 201126 201127 201130

Top of Page October 2020 November 2020 December 2020 January 2021 February 2021 EXCELLENT EXCEL TIPS Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. O ktober 16, 2020 - Did you know att det finns en Copy/Paste funktion för Vilkorsstyrd Formattering O ktober 20, 2020 - Did you know att Excel kan berätta vilket datum det är O ktober 21, 2020 - Did you know att Excel har en funktion som heter Flash Fill O ktober 22, 2020 - Did you know att Excel har mer än bara "lika med" (=) O ktober 23 , 2020 - Did you know att du kan använda Vilkorsstyrd Formattering för att hitta dubbletter O ktober 26, 2020 - Did you know att Excel har en Datedif formel O ktober 27, 2020 - Did you know att Excel kan summera topp/botten 3 värden ur ett dataset O ktober 28, 2020 - Did you know att Excel skilja på värden med IF formeln O ktober 30, 2020 - Did you know att Excel även tillåter dig att nästa en IF i en annan IF formel N ovember 2 , 2020 - Did you know att Excel har en formel som heter Concatenate N ovember 3, 2020 - Did you know att Excel formeln Concatenate kan göra även mer N ovember 4, 2020 - Did you know att Excel kan hjälpa dig att utvärdera bitar av text N ovember 5, 2020 - Did you know att Excel kan visa upp blanka celler med Vilkorsstyrd Formatering N ovember 6, 2020 - Did you know att Excel har en fantastisk funktion som heter Subtotal N ovember 9, 2020 - Did you know att Excel VBA kan tillåta dig att gömma formler från syn N ovember 10, 2020 - Did you know att Excel låter dig färga dina Diagram hur du vill N ovember 11, 2020 - Did you know att Excel har nånting som kallas Utsnitt N ovember 12, 2020 - Did you know att Excel har 7 vanliga felmeddeladande, här är dom N ovember 13, 2020 - Did you know att Excel formeln Cell kan ge dig mycket bra information N ovember 16, 2020 - Did you know att Excel Dataverifiering låter dig skapa menyer N ovember 17, 2020 - Did you know att Excel Dataverifiering kan göra stora urvalsgrupper för menyer N ovember 18, 2020 - Did you know att Excel Dataverifiering kan göra ännu mera N ovember 19, 2020 - Did you know att Excel här ger mig en fjärde post om Dataverifiering N ovember 20, 2020 - Did you know att Excel kan så mycket att jag även skapade en femte post om Dataverifiering N ovember 23, 2020 - Did you know att Excel här kommer med post 1 av 5 gällande Om formeln N ovember 24, 2020 - Did you know att Excel här kommer med post 2 av 5 gällande Om formeln N ovember 25, 2020 - Did you know att Excel här kommer med post 3 av 5 gällande Om formeln N ovember 26, 2020 - Did you know att Excel här kommer med post 4 av 5 gällande Om formeln N ovember 27, 2020 - Did you know att Excel här kommer med post 5 av 5 gällande Om formeln N ovember 30, 2020 - Did you know att Excel kan hjälpa dig identifiera när högtider sker D ecember 1, 2020 - Did you know att detta är dag 1 i årets Excel adventskalender D ecember 2 , 2020 - Did you know att detta är dag 2 i årets Excel adventskalender D ecember 3 , 2020 - Did you know att detta är dag 3 i årets Excel adventskalender D ecember 4 , 2020 - Did you know att detta är dag 4 i årets Excel adventskalender D ecember 5 , 2020 - Did you know att detta är dag 5 i årets Excel adventskalender D ecember 6 , 2020 - Did you know att detta är dag 6 i årets Excel adventskalender D ecember 7 , 2020 - Did you know att detta är dag 7 i årets Excel adventskalender D ecember 8 , 2020 - Did you know att detta är dag 8 i årets Excel adventskalender D ecember 9, 2020 - Did you know att detta är dag 9 i årets Excel adventskalender D ecember 10 , 2020 - Did you know att detta är dag 10 i årets Excel adventskalender D ecember 11 , 2020 - Did you know att detta är dag 11 i årets Excel adventskalender D ecember 12 , 2020 - Did you know att detta är dag 12 i årets Excel adventskalender D ecember 13 , 2020 - Did you know att detta är dag 13 i årets Excel adventskalender D ecember 14 , 2020 - Did you know att detta är dag 14 i årets Excel adventskalender D ecember 15 , 2020 - Did you know att detta är dag 15 i årets Excel adventskalender D ecember 16 , 2020 - Did you know att detta är dag 16 i årets Excel adventskalender D ecember 17 , 2020 - Did you know att detta är dag 17 i årets Excel adventskalender D ecember 18 , 2020 - Did you know att detta är dag 18 i årets Excel adventskalender D ecember 19 , 2020 - Did you know att detta är dag 19 i årets Excel adventskalender D ecember 20 , 2020 - Did you know att detta är dag 20 i årets Excel adventskalender D ecember 21 , 2020 - Did you know att detta är dag 21 i årets Excel adventskalender D ecember 22 , 2020 - Did you know att detta är dag 22 i årets Excel adventskalender D ecember 23, 2020 - Did you know att detta är dag 23 i årets Excel adventskalender J anuari 12, 2021 - Did you know att det finns en Excel artist som heter Tatsuo Horiuchi J anuari 13, 2021 - Did you know att Excel låter dig automatiskt anpassa bredden på flera kolumner J anuari 14, 2021 - Did you know att Excel låter dig ställa samma bredd på flera kolumner samtidigt J anuari 15, 2021 - Did you know att Excel rader kan manipuleras på samma sätt som sina kolumner J anuari 18, 2021 - Did you know att Excel låter dig slå in samma formel i flertalet celler samtidigt J anuari 19, 2021 - Did you know att Excel har en knapp som visar dig alla formler på bladet J anuari 20, 2021 - Did you know att Excel har nått som kallas för Absoluta Referenser J anuari 21, 2021 - Did you know att Excel och estetik går hand i hand J anuari 22, 2021 - Did you know att Excel låter dig frysa den översta raden J anuari 25, 2021 - Did you know att Excel låter dig frysa ännu mer än bara översta raden J anuari 26, 2021 - Did you know att Excel håller dina titel celler längst upp i en Tabell J anuari 27, 2021 - Did you know att Excel har massa bra verktyg för att filtrera en Tabell J anuari 28, 2021 - Did you know att Excel låter dig kopiera din skärm och kopiera det i andra Microsoft dokument J anuari 29, 2021 - Did you know att Excel har flertalet speciella sätt att klistra in saker F ebruari 1, 2021 - Did you know att Excel har SPARKLINES F ebruari 2, 2021 - Did you know att Excel enkelt kan ta bort dina Dubletter F ebruari 3 , 2021 - Did you know att Excel kan plocka bort dina blanka rader F ebruari 4, 2021 - Did you know att det finns en Excel F ebruari 5, 2021 - Did you know att det finns en Excel October 2020 November 2020 December 2020 January 2021 February 2021