OMX Helsinki — S&P 500 — DAX — NASDAQ 100 — STOXX 600 — EUR/USD — EUR/SEK — BTC/USD — ETH/USD — Euribor 3M — Euribor 12M —
Kenji Explains

Kenji Explains

Teknologi og KI 971,000 abonnenter

Build Awesome Excel Visuals to Grab Anyone’s Attention

08.12.2023
Publisert: 08.12.2023 Kategori: Teknologi og KI

Om episoden

Episodebeskrivelse

Create awesome excel excel charts and visuals to impress anyone! 👉 Get our Excel Course here: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/639c825e49ad46f529603a71 Learn to make advanced excel hearts and turn int into a nn awesome dashboard to impress anyone. First, we'll make a Gantt chart, which will act as the project roadmap. Then, we'll make a table, where we can see the trendiness (sparklines) and conditional formatting (for the growth rates). In step 3, we'll make gauge charts, which tell su the satisfaction scores for employees and customers. In step 4, we'll make a budget vs actuals chart where we assess our expenses. Lastly, we'll make a waterfall charts to visualise our employee headcount change in the past year. LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Intro 0:50​ - Gantt chart (Project Roadmap) 4:41​ - Table format & Sparklines 7:54​ - Gauge Chart 13:10​ - Budget vs. Actuals Chart 15:38​ - Waterfall Chart Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Åpne chatten med AI-assistenten. Chatten lastes først når du åpner den.