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
