getformula

Love It ❤️ Highlight the active row in a worksheet!!! Select the area to apply the conditional formatting rules: - CTRL + SHIFT + Down Arrow / Left Arrow Conditional Formatting rule setup: - Select: Use A formula to determine which cells to format - Formula: =ROW()=CELL(“row”) Add the following code in the worksheet: - Application.ScreenUpdating = True #accountant #corporate #easyexcel #excel #excelshortcuts #exceltips #exceltraining #exceltricks #exceltutorial #finance #geekinthesheet #learnexcel #microsoftambassador #microsoftexcel #microsoftoffice #productmanagement #projectmanagement #sheets #spreadsheets #tutorial #wfh #workfromhome #workhack #workhacks #conditionalformatting #excelformatting

Lovin’ it ❤️ Using =SUMPRODUCT() to calculate total sales per product line. =SUMPRODUCT(—(ARRAY1=VALUE),ARRAY2,ARRAY3) =SUMPRODUCT(—($A$4:$A$39=E4),$B$4:$B$39,$C$4:$C$39) Link in Bio #accountant #corporate #easyexcel #excel #excelshortcuts #exceltips #exceltraining #exceltricks #exceltutorial #finance #geekinthesheet #learnexcel #microsoftambassador #microsoftexcel #microsoftoffice #productmanagement #projectmanagement #sheets #spreadsheets #tutorial #wfh #workfromhome #workhack #workhacks

Love it ❤️ Using SumIfs is a very powerful formula. Use it to quickly calculate a value base on one or two variables The formula for one variable: =sumifs(sum_range, criteria _range1, criteria1) The formula for two variables: =sumifs(sum_range, criteria _range1, criteria1, criteria _range2, criteria2) Two variable formula used in the video: Link in BIO #exceltips #excel #help #shortcuts #excelshortcuts #easyway #easyexcel #corporate #finance #accountant #exceltutorial #workhack #tutorial #sheets #exceltips #spreadsheets #productmanagement #projectmanagement

Time Saver ❤️ Use the Split option to divide a window into different panes that can scroll separately. Location: View / Window / Split Link in BIO #exceltips #excel #help #shortcuts #excelshortcuts #easyway #easyexcel #corporate #finance #accountant #exceltutorial #workhack #tutorial #sheets #exceltips #spreadsheets #productmanagement #projectmanagement

Save it ❤️ Use Home / Styles / Conditional Formatting to identify duplicates quickly!! Very cool and very fast! Link in BIO #exceltips #excel #help #shortcuts #excelshortcuts #easyway #easyexcel #corporate #finance #accountant #exceltutorial #workhack #tutorial #sheets #exceltips #spreadsheets #productmanagement #projectmanagement #conditionalformatting

Use TEXTJOIN to generate an email send list in seconds!!!! In this video, you will learn how to select the target data range and use the TEXTJOIN formula to join an array of data together with a selected delimiter. For the email send list, the “;” as the delimiter will be used. =textjoin(“;”,,array) Like, Share, and Save for later!!! Link in BIO #excelpro #dataanalyst #analyst #spreadsheet #excel #financialmodeling #corporate #microsoftexcel #dataanalysis #microsoftexceltricks #excelforbeginners #workhack #projectmanagement #tutorial #exceltips #learnexcel #exceltipsandtricks #projectmanager #exceltipstricks #exceltricks #exceltutorial

Three ways to transpose a column to a row Share & save this post for future reference! #geekinthesheet #microsoftambassador #autoformat #excel #exceltips #exceltricks #spreadsheets #workhacks #finance #learnexcel #accounting #tutorial #corporate #exceltutorial #microsoftexcel #tutorials #data #microsoftoffice #sheets @getformula @getformula @getformula

Weighted Averages - quick formula calculations!!! #excellearning #msexceltraining #excelfunctions #excelskills #msexceltips #excelvideos #microsoftexceltraining #tutorialexcel #exceltipsandtricks #advancedexcel #excelshortcuts #financialmodeling #learnexcel #excelformulas #googlesheets #officeworks #spreadsheet #exceltraining #workhacks #exceltutorial

Dynamic Table in Word From Excel - Its Hot!!! 1) Select the table, right click and select copy 2) In an open word document, place the cursor where you want the table to be located 3) From the ribbon, select Paste and then Paste Special 4) From the Paste Special window, select Paste Link 5) In the window pain, select “Microsoft Excel Worksheet Object” 6) Select “OK” button on the Paste Special popup window You can now resize the image to how you want it to fit in the document. Changing the values in the Excel table will be reflected in the Word document!!! #employed #microsoftexcel #microsoftoffice #sheets #excellearning #daily #dailytips #excelshortcuts #excelformulas #employer

You can now calculate # of workdays in seconds!!!! Using the Excel =days() and =networkdays() formulas save so much time! Try using this formula to see how you can increase the visibility of your team's time.

LIKE and FOLLOW for more!!!! These text formulas TEXTBEFORE, TEXTAFTER are very powerful. They allow you to break apparat text strings using a delimiter. This reel tutorial highlights the formula’s usefulness. #excelsheets #excelshortcutskeys #excelformula #msexcelvideos #msexcelformulas #msexcelformula #excelfunctions #msexceltraining #excelskills #exceltraining #exceltutorial #officeworks #excelformulas #excelshortcuts #excelvideos #msexceltips #microsoftexceltraining #tutorialexcel #exceltipsandtricks #advancedexcel #financialmodeling #learnexcel #ittraining #exceltricks #msoffice #spreadsheets #spreadsheet #workhacks #microsoftoffice #exceltips