Time Saver ❤️
Add a slicer to a pivot table!!!
Link in BIO
#accountant #corporate #easyexcel #excel #excelshortcuts #exceltips #exceltraining #exceltricks #exceltutorial #finance #geekinthesheet #learnexcel #microsoftambassador #microsoftexcel #microsoftoffice #productmanagement #projectmanagement #spreadsheets #spreadsheet #tutorial #workhack #workhacks #excelformatting #pivottable #pivottables
Save it 👍❤️👍
Pivot Table - Identify top 10 customers by sales volume!!!
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 #conditionalformatting #excelformatting #pivottable #pivottables
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
That’s Cool 😎
Use “Filter” and “Countif” together to determine which customer order numbers contained both products (Cars & Boats) !!!
=filter(array1,countif(array2,array1))
In the Reel example:
=filter(cars,countif(boats,cars))
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
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
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
Adding images to Excel FAST!!!
In this video, you will learn how to add an image from the web to an excel sheet using the new IMAGE function.
Helping you be more efficient in using formulas with your data set.
Like, Share, and Save for later!!!
#analyst #dataanalyst #exceltipstricks #microsoftexcel #corporate #excelforbeginners #spreadsheet #exceltutorial #learnexcel #workhack
Converting 12 hours to 24 hours!!
In this video, you will learn how to convert from 12 hour to 24 hour time FAST!!!
Helping you be more efficient in using formulas with your data set.
Like, Share, and Save for later!!!
#microsoftambassador #autoformat #excelfunctions #excel #exceltips #exceltricks #spreadsheets #workhacks #finance #learnexcel #accounting #tutorial #corporate #exceltutorial #microsoftexcel #tutorials #data #microsoftoffice #sheets #financialmodeling #reelsviral #dataentry #msexcel #msoffice #office365 #exceltraining #projectmanagement