Wishing you all a very Merry Christmas! ☃️ 🎄 #excelwithdave #merrychristmas

=LARGE - a somewhat lesser known function that returns the k-th largest value in a data set. #excelwithdave #excel #learnexcel

Want to remove duplicates from a dataset to get a condensed, simplified, easy to use and useful list then use Excel’s brilliant ‘remove duplications’ button - it’s easier than you think, give it a go! 😀👍 Learn more: bit.ly/2QypMMl #excelwithdave #excel #learnexcel

=REPT repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. Example: =REPT("x",10) will return xxxxxxxxxx Try it out. #excelwithdave #excel #learnexcel

Take your VLOOKUP skills to the next level with the latest =XLOOKUP function. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on. #excelwithdave #excel #learnexcel

Sometimes when extracting certain elements of data what looks like a number isn’t always recognised by excel as a number, to quickly and easily convert your data into a number you can use the =VALUE() function. #excelwithdave #excel #learnexcel

Use =RAND to generate random numbers between 0 and 1, or between whatever values you specify using =RAND()*(b-a)+a. Learn more here: msft.it/6018Ti49k #excelwithdave #excel #learnexcel

To find the source of a circular reference error, click the Formulas tab, click the arrow next to Error Checking, point to Circular References, and then click the first cell listed in the submenu. Learn more: bit.ly/2zYqa2i #excelwithdave #excel #learnexcel

Use the =SUMIFS function to test multiple conditions & return a value based on those conditions. For example, use it to sum the number of products sold by a certain salesperson. Learn more: bit.ly/3dLo3gW #excelwithdave #excel #learnexcel

A quick keyboard shortcut for you, simply press Ctrl+N to quickly create a new workbook - then get to work creating your new masterpiece. #excelwithdave #excel #learnexcel

The IFS function checks whether one or more conditions are met, & returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements. Learn more: bit.ly/3fYYxX4 #excelwithdave #excel #learnexcel

The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it positive. If cell A1 = -4 (minus 4) then =ABS(A1) would return 4 #excelwithdave #excel #learnexcel

One of the most basic keyboard shortcuts which can really be a lifesaver; pressing Ctrl+S saves the current open worksheet. It only takes a second but can save a lot of rework! #excelwithdave #excel #learnexcel

The NOW function is useful when you need to display the current date & time on a worksheet or calculate a value based on the current date & time, & have that value updated each time you open the worksheet. Learn more: bit.ly/2L06X27 #excelwithdave #excel #learnexcel

The =YEAR function returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999. For example if cell A1 = 04/05/2020 then =YEAR(A1) would retun 2020 B7 = 01/02/2007 then =YEAR(B7) would return 2007 #excelwithdave #excel #learnexcel

Excel's Quick Analysis button lets you instantly create different types of charts, including line and column charts, or add miniature graphs called sparklines. Learn more: msft.it/6010TVCuy #excelwithdave #excel #learnexcel

The =ISODD function returns TRUE if number is odd, or FALSE if number is even. Learn more: bit.ly/3f6eaeC #excelwithdave #excel #learnexcel

Use conditional formatting to help you visually explore & analyse data, detect critical issues, and identify patterns and trends - quickly and easily! To learn more about conditional formatting: msft.it/6016TnIm0 #excelwithdave #excel #learnexcel

The SWITCH function evaluates one value against a list of values & returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. Learn more: bit.ly/2zxVIeN #excelwithdave #excel #learnexcel

Sometimes a ‘hidden’ issue can be additional spaces in your data that you don’t always notice - to help clean up your data you can make use of the =TRIM function which removes all spaces from text except for single spaces between words. #excelwithdave #excel #learnexcel