Save Adult Formula with airSlate SignNow

Save adult formula

hi Excel fans day Bruns here from Excel jet so welcome to this second video in our series on excel formulas today I want to share with you some tips for how you can work faster and more efficiently with formulas in Excel but first I've got a question for you about productivity have you ever thought about how many hours are wasted in companies all around the world every week as people struggle to use formulas to solve basic problems it's a big number right every day intelligent people are trying to use formulas to solve problems like how can I combine the data in this table with the data in this table or how can I extract the first name from this list of 10,000 names or how can I count the number of cells that contain just this one product code in this huge list of 20,000 orders or how can I adjust these 500 dates so that they all end on the last day of the month these are just ordinary normal problems but they aren't that easy to solve in Excel and the reason is pretty clear right nobody gets solid training and Excel formulas and functions just doesn't happen people learn Excel on the job and for pretty basic things they do pretty well but when the problems get more complex they struggle because Excel is a piece of an application with over 400 built-in functions so just being aware of the 50 or so functions you might use that are useful to you is a major challenge but if you use Excel at least a few hours a week and unless you're already an Excel guru then it's also a big opportunity when you take time to strengthen your skills with Excel formulas not only can you do your own work faster and more accurately but you become a more valuable asset to any company when you're good with Excel people will seek you out for help and you'll automatically have conversations with people that you might not talk to you otherwise also you'll be recognized as somebody who contributes to productivity and every good manager loves and will go out of their way to protect productivity the bottom line is it investing in yourself to get better with excels formulas and functions and pay you back again and again okay so now let's do some Excel training next I'm going to run you through a great list of formula tips that you can use to save time and Excel today okay so here we are in Excel and now I'm going to take you through more than 20 tips to help you save time and work faster with Excel formulas we cover all these topics in more detail in our course on Excel formulas so I'm going to move rapid-fire through these tips and trust that you can rewind the video if you need to so when you're entering a formula you can use autocomplete and tab to enter the formula to Center an equals sign and start typing and then you can use the arrow keys to select the function you need and press tab notice that you don't need to enter parentheses you can also use a feature called search function there's a button next to the formula bar or you can use the shortcut Shift f3 you and you can use the same feature to get back to the function arguments either with a button or with the shortcut shift f3 once you have a function entered in Excel you can use the function screen tip window to select the different arguments if you find this tip window is blocking something you want to see you can just move it anywhere you want you can also ask Excel to insert function arguments for you using the shortcut ctrl shift date then you can select the arguments and replace them with the values you need when you're entering functions that require multiple references on the worksheet you don't need to use a comma if you hold down the ctrl key on Windows or the command key on the Mac there's several ways you can enter formulas in the table and copy them down quickly first you can select all the cells enter the formula and then use ctrl enter or you can enter the formula and double click the fill handle or you can enter the formula select the formula and the cells below and use the shortcut fill down which is control D you can also convert a tape Excel table using ctrl T and once you have a table when you enter a formula Excel will automatically copy that formula down you can use a shortcut for autosum to quickly enter some functions for multiple rows multiple columns or for an entire table when you're working with a complicated formula that has a syntax problem Excel may not let you enter that formula as a workaround you can temporarily convert the formula to text with a single quote and then come back later when you have more time and fix the problem you can quickly see all the formulas in a worksheet using the keyboard shortcut control + Grave you can use a shortcut to toggle all formulas on and all formulas off you can also use go to special and formulas this will select every formula in the worksheet on Windows use the keyboard shortcut f4 to toggle through absolute and relative references and on the Mac use a shortcut command T when you want to move formulas about changing relative references you can use cut and paste or you can use drag-and-drop when you want to copy formulas that contain relative references you can temporarily convert them to text I'll search for the equal sign and replace with a hash character then I'll copy and paste the formulas and then I'll reverse the search and replace looking for a hash character and replacing with the equal sign now all formula references are unchanged you'll often want to convert formulas to values a simple way to do this is to use paste special with the values option select the formulas copy bring-up paste special and choose values then you can delete columns that you no longer need you can also use paste special to convert values in place without any formulas at all in this case I'll move all of these dates forward by 14 days or 2 weeks just copy the value bring up paste special choose values and a math operation in this case we want to add now all dates are shifted forward by 14 days I can use the same approach to increase prices by 15% this time I want to choose values and the multiply operation you can use named ranges to make your formulas easier to read and understand in this case I'll name the cell that contains hourly rate and then update the formulas if I undo that you can also apply names using the apply names feature on the formulas tab of the ribbon to understand a more complicated function you can use f9 manually or you can use the evaluate formula feature to use f9 work from the inside out here we'll use f9 to evaluate today then we'll evaluate the Year frac function and finally we'll use f9 to see the result of the in function evaluate formula is on the formulas tab of the ribbon each time you click evaluate Excel will solve one step of the formula working from the inside out ok so that's 20 tips to help you work a little faster with Excel formulas give these tips a try and save a little bit of time in Excel today alright so I hope you enjoyed that training make sure you download the worksheet that I use from the video which is attached below and give those tips a try I'll be back in a couple of days with the third and final video in this series on Excel formulas so watch for an email and in the meantime we'd love to hear from you about your experiences with Excel formulas or anything in this video so use a common area below to leave your thoughts I'll see you soon in the next video