This video will help you to create Smilie Faces for values given in your reports / dashboards. They will be Green for Happy Face, Yellow for Neutral Face and Red for Unhappy Face. Excel file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvS7bd4uLFLchcsHE?e=jBxt0d
Category: Tips and Tricks
Tips & Tricks 186 – Multi Column VLOOKUP XLOOKUP
DOWNLOADS 27 – CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition. DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference Shortcut Action Ctrl+Shift Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Ctrl+Shift+A Insert argument…
Important – Content of this Website is 100% Copyright Free
I just want to convey that the content of this site is completely copyright free. You can use the content the way you want without seeking any permission. Whether you are using it commercially or non-commercially, personally or within your organization, it doesn't matter. There is no need to give any acknowledgement either that you…
DOWNLOADS 25 – CTRL+0 to 9 – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ 0 to 9 shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_0_9_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+0 Hide the selected columns CTRL+1 Open the Format Cells dialog CTRL+2 Apply or remove…
DOWNLOADS 24 – CTRL+F1 to F12 – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ F1 to F12 shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_F1_F12_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+F1 Displays or hides the ribbon CTRL+F2 Displays the print preview area on the Print…
DOWNLOADS 23 – CTRL+A to Z – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ A to Z shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_A_Z_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+A Select the entire worksheet CTRL+B Apply or remove Bold formatting to font CTRL+C Copy…
Convert Month Name to Month Number in Power Query – Tips & Tricks 12
In Query M language, there is no function which converts Month Name to Month Number so that if I give February or Feb, the result should be 2. You can use following formula to get the Month Number from Month Name = Date.Month(Date.FromText("1"&[Month Name]) If your data is using some other locale than whatever is…
Excel Trim Formula in Power Query – Tips & Tricks 11
Excel's TRIM function has a unique way to handle trimming unlike other programming languages / applications. It not only trims the leading and trailing blanks (spaces) but also all blanks in between other than single blank between two words. Official Excel documentation for TRIM says – "Removes all spaces from text except for single spaces…
Binary to Decimal (BIN2DEC) using List.Accumulate – Power Query – Tips & Tricks 10
The tip is originally published @ http://excel-inside.pro/blog/2016/06/06/bin2dec-in-power-query-implementations-of-list-accumulate-part-1/ My formula is a slight modification of this. You can use following formula to convert from Binary Decimal where [Binary Number] is the column which holds the binary number. List.Accumulate(Text.ToList([Binary Number]), 0, (s,c)=> s*2 + Number.From(c))