Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

Everyone is gatekeeping Control+ E aka Flash Fill in Excel and it makes me sick. It is the best excel tip imo because you don't have to even gogole a formula or use AI. All you need to do, is type one example, hit Ctrl+E, and Excel fills out...

codingfortherestofus's profile picture

brooke | learn coding + ai

35,400 subscribers

83,900 görüntüleme • 6 ay önce •via TikTok

EğitimFinansBilim & Teknoloji#excel#exceltips#dataanalyst#interviewtips
LIVE

Anya Rossi• Live Now

Private livecam show

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

How to extract and automatically update subsets of data in Excel 📊 Download my FREE Excel Shortcut Guide 👉🏼 #excel #exceltips #dynamicarrays
0:31

How to extract and automatically update subsets of data in Excel 📊 Download my FREE Excel Shortcut Guide 👉🏼 #excel #exceltips #dynamicarrays

Excel Dictionary

14,493 görüntüleme • 3 ay önce

a super quick advanced excel tutorial for beginners 📊🤓 a calculated field lets you do math between two columns directly inside your pivot table - no extra formulas needed. how to add one: click into your pivot table click pivot table analyze click fields, items and sets click calculated field name your field "total revenue" double click PRICE, hit multiply, double click UNITS SOLD hit add, then ok total revenue is now in your pivot table save this before your next interview. free excel and sql interview cheat sheet in my bio. #excel #exceltips #dataanalyst #interviewtips
0:26

a super quick advanced excel tutorial for beginners 📊🤓 a calculated field lets you do math between two columns directly inside your pivot table - no extra formulas needed. how to add one: click into your pivot table click pivot table analyze click fields, items and sets click calculated field name your field "total revenue" double click PRICE, hit multiply, double click UNITS SOLD hit add, then ok total revenue is now in your pivot table save this before your next interview. free excel and sql interview cheat sheet in my bio. #excel #exceltips #dataanalyst #interviewtips

brooke | learn coding + ai

22,900 görüntüleme • 6 ay önce

This Excel function predicts the future 😳 Type =FORECAST, add your future date, select your existing values and time periods, press enter, and Excel instantly calculates a data-driven prediction based on your historical trend. Link in bio for my free cheatsheet with 26 Excel functions you need to know ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks
0:44

This Excel function predicts the future 😳 Type =FORECAST, add your future date, select your existing values and time periods, press enter, and Excel instantly calculates a data-driven prediction based on your historical trend. Link in bio for my free cheatsheet with 26 Excel functions you need to know ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks

Grant - Excel Tips

19,700 görüntüleme • 12 gün önce

Only 1% know how to do this in Excel 🤯 Follow Miss Excel for more Excel & AI tips 💚 #excel #exceltips #corporate #workhacks
1:30

Only 1% know how to do this in Excel 🤯 Follow Miss Excel for more Excel & AI tips 💚 #excel #exceltips #corporate #workhacks

Miss Excel

16,276 görüntüleme • 10 ay önce

3 Excel hacks every beginner needs to know 😎 Flash Fill. Auto Format. Auto Fit. Three shortcuts that eliminate the most annoying manual work in Excel instantly. DM me the word "EXCEL" and I'll send you my free Excel and AI class ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks
0:56

3 Excel hacks every beginner needs to know 😎 Flash Fill. Auto Format. Auto Fit. Three shortcuts that eliminate the most annoying manual work in Excel instantly. DM me the word "EXCEL" and I'll send you my free Excel and AI class ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks

Grant - Excel Tips

54,300 görüntüleme • 6 ay önce

Stop using VLOOKUP in Excel 🚫 XLOOKUP returns every column you need in one single formula that never breaks. Link in bio for 26 Excel functions that save you hours every week ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks
0:59

Stop using VLOOKUP in Excel 🚫 XLOOKUP returns every column you need in one single formula that never breaks. Link in bio for 26 Excel functions that save you hours every week ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks

Grant - Excel Tips

78,200 görüntüleme • 1 ay önce

Build a dynamic search bar in Excel that filters data instantly as you type. This tutorial shows how to use FILTER, SEARCH, and ISNUMBER to create a searchable table and find data faster. (Save and share this video). #Excel #ExcelTutorial #ExcelTips #SpreadsheetTips #MicrosoftExcel
0:42

Build a dynamic search bar in Excel that filters data instantly as you type. This tutorial shows how to use FILTER, SEARCH, and ISNUMBER to create a searchable table and find data faster. (Save and share this video). #Excel #ExcelTutorial #ExcelTips #SpreadsheetTips #MicrosoftExcel

Tips Excel | AI Productivity

14,036 görüntüleme • 4 ay önce

How to look up data from another sheet in Excel with AI 🔍 Download my FREE AI for Excel Guide 👉🏼 #excel #chatgpt
0:47

How to look up data from another sheet in Excel with AI 🔍 Download my FREE AI for Excel Guide 👉🏼 #excel #chatgpt

Excel Dictionary

13,637 görüntüleme • 1 ay önce

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips
0:26

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips

brooke | learn coding + ai

139,100 görüntüleme • 6 ay önce

Excel has a secret camera feature nobody talks about 🤯 Set it up once and paste live updating pictures of your data anywhere in your workbook or even in Word and PowerPoint. Link in bio for my free guide with 26 Excel shortcuts ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks
0:46

Excel has a secret camera feature nobody talks about 🤯 Set it up once and paste live updating pictures of your data anywhere in your workbook or even in Word and PowerPoint. Link in bio for my free guide with 26 Excel shortcuts ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks

Grant - Excel Tips

82,400 görüntüleme • 17 gün önce

Python in Excel! Microsoft has announced Python and Excel integration today. Python in Excel brings the power of Python analytics into Excel. Use it to process data in Excel with Python code. More details 🧵👇
1:30

Python in Excel! Microsoft has announced Python and Excel integration today. Python in Excel brings the power of Python analytics into Excel. Use it to process data in Excel with Python code. More details 🧵👇

Afiz ⚡️

1,671,581 görüntüleme • 3 yıl önce

10-second Excel tip that'll save you hours. 🤯 Download my FREE Excel Shortcut Guide 👉🏼 #excel #exceltips #conditionalformatting #attendancetracker #tutorial
0:21

10-second Excel tip that'll save you hours. 🤯 Download my FREE Excel Shortcut Guide 👉🏼 #excel #exceltips #conditionalformatting #attendancetracker #tutorial

Excel Dictionary

10,363 görüntüleme • 6 ay önce

How to automatically fill dates and weekdays in Excel. 🗓️ Download my FREE Excel Functions Guide Vault 👉🏼 #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial #sheets
0:28

How to automatically fill dates and weekdays in Excel. 🗓️ Download my FREE Excel Functions Guide Vault 👉🏼 #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial #sheets

Excel Dictionary

10,815 görüntüleme • 8 ay önce

Stop manually creating tables in Excel 😭 Type =AI.Table, add your prompt in quotes, press enter, and Excel generates your entire table instantly. Link in bio to master the formulas and functions that save you 12+ hours every week ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks
0:52

Stop manually creating tables in Excel 😭 Type =AI.Table, add your prompt in quotes, press enter, and Excel generates your entire table instantly. Link in bio to master the formulas and functions that save you 12+ hours every week ⚡ #excel #exceltips #careertok #worksmarternotharder #exceltricks

Grant - Excel Tips

58,400 görüntüleme • 28 gün önce

How to use the INDEX + MATCH functions to search for data in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel
0:53

How to use the INDEX + MATCH functions to search for data in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel

CheatSheets

27,835 görüntüleme • 2 yıl önce

Let me help you take your Excel Data Validation game to the next level 🔥 In this video I’ll show you how to create dynamic and dependent drop downs and how to force unique values in a column #excel #microsoft #5MinutePlus
5:04

Let me help you take your Excel Data Validation game to the next level 🔥 In this video I’ll show you how to create dynamic and dependent drop downs and how to force unique values in a column #excel #microsoft #5MinutePlus

Metric Maven

67,800 görüntüleme • 1 gün önce

How to Get Data from Web in Excel! #excel #exceltips #exceltutorial
0:31

How to Get Data from Web in Excel! #excel #exceltips #exceltutorial

CheatSheets

77,935 görüntüleme • 3 yıl önce

TOCOL in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet
0:27

TOCOL in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet

CheatSheets

13,200 görüntüleme • 11 ay önce

VSTACK in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet
0:36

VSTACK in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet

CheatSheets

11,068 görüntüleme • 11 ay önce

Spelling out Numbers in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet
0:37

Spelling out Numbers in Excel! ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet

CheatSheets

22,033 görüntüleme • 1 yıl önce