Om kanalen
Kenji Explains gjør Excel til utgangspunkt for praktiske undervisningsvideoer om regneark, analyse og automatisering. Stoffet er særlig relevant for dem som bruker regneark til å organisere…
Kenji Explains gjør Excel til utgangspunkt for praktiske undervisningsvideoer om regneark, analyse og automatisering. Stoffet er særlig relevant for dem som bruker regneark til å organisere informasjon eller presentere tall, og som vil utvide repertoaret sitt. Flere videoer tar for seg en avgrenset funksjon, mens andre følger oppbyggingen av en mer sammensatt løsning. Eksemplene spenner fra beskyttelse av ark til interaktive oversikter og statistiske beregninger.
En gjennomgang viser hvordan man lager et søkefelt inspirert av en søkemotor, og en annen handler om en automatisert oversikt over oppmøte. Et mer omfattende undervisningsinnslag bygger et interaktivt instrumentbord fra bunnen av. Disse prosjektene retter oppmerksomheten mot hva regnearket skal gjøre for brukeren, ikke bare hvordan en enkelt formel skrives. De gir konkrete bruksområder som seeren kan knytte til egne administrative oppgaver eller behov for oversikt.
På funksjonsnivå behandles blant annet korrelasjonsanalyse, statistikk, krøllparenteser og tredimensjonale referanser. Andre videoer utfordrer bruken av velkjente oppslagsfunksjoner og pivottabeller ved å presentere alternativer. Nye cellefunksjoner og en video om COPILOT viser også at endringer i verktøyet er en del av emnevalget. Titlene er engelske og ofte formulert som tydelige oppfordringer til å prøve en annen fremgangsmåte.
Kanalens pedagogiske profil ligger i vekslingen mellom små grep og hele arbeidsprosesser. Den som trenger hjelp med én oppgave, kan velge en smal forklaring, mens den som vil forstå hvordan flere funksjoner virker sammen, kan følge et større prosjekt. Utvalget gir dermed både innganger til grunnleggende regnearkarbeid og temaer for brukere som vil utforske mer avanserte løsninger.
Nyeste episode
10 Financial Modeling Tricks I Wish I Knew Sooner
👉 Get Tracelight Pro at https://tracelight.link/kenjipro
Use code KENJI at checkout for 50% off your first month of Pro.
10 financial modeling tricks in Excel every analyst should know!
Check out…
👉 Get Tracelight Pro at https://tracelight.link/kenjipro
Use code KENJI at checkout for 50% off your first month of Pro.
10 financial modeling tricks in Excel every analyst should know!
Check out Tracelight's Youtube Channel here: https://www.youtube.com/@TracelightAI
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/cmp8lbqwxw
This video covers 10 financial modeling tricks in Excel that make financial models faster to build, easier to navigate, and less prone to errors. Use Watch Window to track net profit and closing cash while changing inputs on another sheet. Save a workbook template with your go-to colors and number formats, freeze panes to keep labels visible as you scroll, and group rows or columns to collapse details you don’t need.
Build in checks that flag negative cash balances and catch an unbalanced balance sheet. Link your model dates to a single input and use dropdowns to prevent scenario name typos. Finally, use Goal Seek to find the price per kilo needed to hit $100,000 in profit, then build a two-variable sensitivity table to see how different combinations of price and monthly growth affect annual profit.
LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥 AI for Business & Finance: https://www.careerprinciples.com/courses/ai-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Watch Window
1:37 - Format Guide
3:17 - Views
4:30 - Workspace
6:00 - Grouping
7:03 - Warnings
8:00 - Dates
9:49 - Lists
10:28 - Optimization
11:47 - Sensitize
YouTube Shorts
☎️ Excel Interview Tests
Uploads
✅ From Beginner to Pro in Excel
🤖 AI Tools to 10X Your Productivity
🤖 Automate Excel with VBA & Macros
💼 Careers in Business & Finance
📈 Excel for Business & Finance
💸 Finance Explained
💰 Financial Analysis in Excel
🏦 Investment Banking
📊 Make Professional Charts & Visuals in Excel
🚀 Power BI for Business Analytics
Flere episoder fra denne kanalen
Make an Automated Stock Inventory Tracker in Excel
12.11.2026
Make a stock in out balance tracker in Excel in 18 minutes. 👉 Get the free financial modeling webinar recording and files here: https://clickhubspot.com/548b5d 🆓 DOWNLOAD the Free Excel file for this video: https://careerprinciples.myflodesk.com/tl8yvyq9b3...
10 New Excel Features You Should Know About!
4.11.2026
From dashboards to new functions, here's 10 New Excel Features you probably didn't know. Get Started with GlideOS here: https://glide.s.gy/MyNF9G Glide's YouTube Channel: @glideapps This video goes over 10 of the newest Excel updates....
The Colon Trick That Makes Excel Formulas Smarter
1.11.2026
Send and receive faxes online without a fax machine. Explore eFax and choose the plan that works for you: https://www.efax.com/kenji-explains Use the underrated colon operator to make Excel formulas smarter! 🆓 DOWNLOAD Free Excel...
Excel's NEW Dashboard Mode is Insane!
16.10.2026
New interactive canvas feature in Excel currently available in Microsoft Insiders. 🚀 Check out all our courses here: https://www.careerprinciples.com/all-courses 🆓 DOWNLOAD Free Datasets for this video: https://careerprinciples.myflodesk.com/gdum4v5v5g Excel’s new interactive canvas lets users create...
Send WhatsApp Messages From Excel Automatically
11.10.2026
👉 Try Granola in your next meeting: https://go.granola.ai/kenji-farre How to send WhatsApp messages and attachments directly from Excel automatically. 🆓 DOWNLOAD the Excel file & Bas Files for this video: https://careerprinciples.myflodesk.com/gpv108xfae Learn how to...
Automate an Actuals vs Budget Report in Excel
4.10.2026
Automate your budget vs actuals variance analysis in Excel. 🚀 Get the FREE 50 Excel Hacks Template I made with HubSpot: https://clickhubspot.com/f0d9bf 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/wa69m9u8lr The video shows...
This NEW Excel Feature Changes Everything About Cells
30.9.2026
🚀 Check out all our courses here: https://www.careerprinciples.com/all-courses Note: These new features are still rolling out to Excel Beta channel users, so you may not have them yet. Microsoft changed one of Excel’s most...
Create a Google-Like Search Bar in Excel
27.9.2026
👉 Try Gamma now and see your presentations come to life! Click the link: https://bit.ly/4AflXQR Make a dynamic search bar in Excel to find anything! 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/wzeq205f37...
Make an Automated Attendance Tracker in Excel + Free Template
20.9.2026
👉 Try Granola in your next meeting: https://go.granola.ai/kenji-farre Make an automated employee attendance tracker in Excel. 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/rsa8uykigr This video shows how to build a dynamic attendance...
Make an Interactive Excel Dashboard From Scratch (Full Tutorial)
13.9.2026
Make an interactive Excel Dashboard using Pivot Tables from scratch. 🚀 Get 20% OFF our Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/bzsj26qt0h In this video, you’ll learn how...
I Rarely Use Pivot Tables Anymore…I Use This Instead
6.9.2026
Instead of using Pivot Tables, try these two new functions! 🚀 Get the FREE 50 Excel Hacks Template I made with HubSpot: https://clickhubspot.com/4323b6 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/lx8d8oxzgn Excel's new...
Learn Statistics in Excel in 14 Minutes
30.8.2026
Learn statistics in Excel in just 14 minutes! 👉 Take our Data Analyst Program here: https://www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD the Excel Dataset for this video: https://careerprinciples.myflodesk.com/e27j9bqpju This video teaches how to perform statistical analysis in...
Stop Using XLOOKUP & VLOOKUP. Try This Instead
23.8.2026
Stop using XLOOKUP and VLOOKUP. Try these two methods instead. 🚀 Get 25% OFF InstaHeadshots here: https://go.instaheadshots.com/kenjiexplains 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/glvjjgko9e The tutorial goes over the limitations of lookup...
How to Forecast Revenue in Excel (5 Main Methods)
16.8.2026
How to forecast revenue in Excel using the 5 main methods. 👉 Take the Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🆓 DOWNLOAD the financial models in Excel used for this video: https://careerprinciples.myflodesk.com/i8ww3pgy1d The video...
10 NEW Excel Copilot Features You Need to Know
9.8.2026
Learn the best Copilot in Excel Features for analysts in 2026. 🚀Get my FREE AI Stack from Hubspot: https://clickhubspot.com/91c4a0 🆓 DOWNLOAD Free Excel Dataset for this video: https://careerprinciples.myflodesk.com/enuese1dgh In this video, we go over...
10 Genius Excel Tricks I Wish I Knew Sooner
2.8.2026
👉 Try Granola in your next meeting: https://go.granola.ai/kenji-farre In this video, you'll learn 10 mind blowing Excel tricks I wish I knew sooner. 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/u5bsq7bjhe In this...
Master Data Analysis with AI in Just 11 Minutes
19.7.2026
👉Try CoreSignal for Free: https://coresignal.com/?utm_source=youtube&utm_medium=social&utm_campaign=kenji+explains&utm_content=data+search Learn how to analyse any dataset using Claude in 6 simple steps using the World Cup dataset. 🆓 DOWNLOAD the Datasets & Prompts for this video: https://careerprinciples.myflodesk.com/u7ka4xrjdk Most office...
NEW Custom Skills in Excel Automate 90% of Your Work
15.7.2026
Use Custom Skills with Excel Copilot to automate repetitive tasks! 🚀 Check out all our courses, bundles, and programs here: https://www.careerprinciples.com/all-courses 🆓 DOWNLOAD Free Datasets & Prompts for this video: https://careerprinciples.myflodesk.com/uqzgo0ox7y In this video,...
Split Excel Sheets Into Separate Files Automatically
12.7.2026
How to split Excel worksheets into separate Excel files automatically. 🚀 Get the FREE 50 Excel Hacks Template I made with HubSpot: https://clickhubspot.com/a67b1a 🆓 DOWNLOAD the Code for this video: https://careerprinciples.myflodesk.com/cbblyc68yx In this video...
Turn an Excel Table Into a Website (Auto-Updates)
5.7.2026
Learn how to turn any Excel dataset into a live website in minutes. 👉 Take our AI for Business and Finance course: https://www.careerprinciples.com/courses/ai-for-business-finance 🆓 DOWNLOAD the Excel File & Prompts for this video: https://careerprinciples.myflodesk.com/rhif3rxyvj...
Innohub TV
Se dette innholdet også på Innohub TV
Vi har plukket ut klipp fra Innohub TV som fortsetter samme tema.
