CrispEXCEL Training & Consulting's banner
CrispEXCEL Training & Consulting's profile picture

CrispEXCEL Training & Consulting

@Crisp_EXCEL • 36,401 subscribers

⭐We are the best Excel Trainers in East & Central Africa.

Videos

LIVE
1.2k

Anya Rossi

sweetdream.ai

SweetDream.aiSponsored•Livecam
Streaming Now

Watch Anya Live

Anya is streaming live right now! Join her private show and enjoy exclusive content.

HD live stream
Exclusive private shows
1.2k viewers online

Free preview available • Premium content

Can VLOOKUP Return Multiple Columns? 🤔 By default, NO! 😢 But with a very small tweak...YES!!! Just put the column numbers in curly braces =VLOOKUP(G2,B2:E24,{3,4},FALSE) #exceltips #exceltricks #CheatSheet #programming #spreadsheets
0:25
Crisp_EXCEL's profile picture

Can VLOOKUP Return Multiple Columns? 🤔 By default, NO! 😢 But with a very small tweak...YES!!! Just put the column numbers in curly braces =VLOOKUP(G2,B2:E24,{3,4},FALSE) #exceltips #exceltricks #CheatSheet #programming #spreadsheets

CrispEXCEL Training & Consulting

143,215 просмотров • 3 лет назад

How to you fill series to autofill Dates 👇 Save time...Increase productivity #Excel #cheatsheets #programming
0:35
Crisp_EXCEL's profile picture

How to you fill series to autofill Dates 👇 Save time...Increase productivity #Excel #cheatsheets #programming

CrispEXCEL Training & Consulting

74,833 просмотров • 3 лет назад

How to Get Multiple Months End of Month dates Data By Defult EOMONTH function does not accept a range of #data. Force it by adding a Zero to the range. =FILTER(tblSales[Items], EOMONTH(tblSales[Date]+0,0)=tblSales[Date]) #Excel #programming #DataAnalytics #CheatSheet
1:06
Crisp_EXCEL's profile picture

How to Get Multiple Months End of Month dates Data By Defult EOMONTH function does not accept a range of #data. Force it by adding a Zero to the range. =FILTER(tblSales[Items], EOMONTH(tblSales[Date]+0,0)=tblSales[Date]) #Excel #programming #DataAnalytics #CheatSheet

CrispEXCEL Training & Consulting

46,421 просмотров • 3 лет назад

Two ways to separate text & numbers What's your favourite? ⭐WRAPROWS + TOROWS ⭐Multiple FILTER functions Article inspired by @exceleducations 😎 #excel #exceltips #acccounting #programming
1:08
Crisp_EXCEL's profile picture

Two ways to separate text & numbers What's your favourite? ⭐WRAPROWS + TOROWS ⭐Multiple FILTER functions Article inspired by @exceleducations 😎 #excel #exceltips #acccounting #programming

CrispEXCEL Training & Consulting

40,467 просмотров • 3 лет назад

How to Lookup multiple tables using VLOOKUP #excel #ExcelTips ........... Follow for more tips
0:54
Crisp_EXCEL's profile picture

How to Lookup multiple tables using VLOOKUP #excel #ExcelTips ........... Follow for more tips

CrispEXCEL Training & Consulting

24,680 просмотров • 2 лет назад

Больше нет контента для загрузки