HOW TO BUILD EXCEL DASHBOARDS - Key Excel Skills for Consulting
Invest in yourself! Use my link and check out the first chapter of any course for FREE! https://bit.ly/3oztYLk
In this video, I show you how to build Excel dashboards. Based on my experience as an Ex-McKinsey consulting, I teach key Excel skills for consulting or corporate careers. Creating Microsoft Excel dashboards is a crucial skills for anybody working with data. Dashboards enable decision makers to regularly review data from crucial areas from their operations and make informed business decisions. Learn to build Excel dashboards and build key Excel skills for consulting in this video! I will teach how how to build interactive Excel dashboards. This is an absolute beginner's guide to Excel dashboards, it is an Excel tutorial for dashboards, based on dropdowns. Learn to build Excel dashboards for beginners with this Microsoft Excel tutorial. Learn data analysis in Excel today.
Chapters
00:00 Introduction
01:28 DataCamp
02:50 What we are going to build
04:00 Building the front end
09:01 Understanding the data inputs
10:30 Linking the data to the dashboard
22:10 Additional remarks
23:44 Wrap-up
This video was sponsored by DataCamp.
Download the Excel dashboard that we jointly create in this video to play around with it: https://link.firmlearning.com/dashboard
🎓 MY ONLINE COURSES*
Learn to make PowerPoint presentations like Top Management Consultants:
"CEO-level Presentation Skills - Slide Writing for Consulting"
https://link.firmlearning.com/slides
Learn to negotiate your salary and earn your worth:
"The Complete Salary Negotiation Master Class - ASK for more"
https://link.firmlearning.com/salarynegotiation
Everything you need to know about Blockchain and Cryptocurrency:
"The Complete Course on Blockchain and Bitcoin"
https://link.firmlearning.com/blockchain
📄 CV AND COVER LETTER TEMPLATE*
Get a CV and cover letter template based on my own documents. With earlier versions of this CV and cover letter, I successfully applied to McKinsey as consultant:
https://link.firmlearning.com/learning
👍 CHANNEL MEMBERSHIP
Become a member of Firm Learning to support my work and get access to perks:
https://link.firmlearning.com/join
📩 NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
https://link.firmlearning.com/e-mail
☑️ RECOMMENDATIONS*
Books that I loved (Management & Self-development): https://link.firmlearning.com/books
Travel like a consultant: https://link.firmlearning.com/travel
GMAT study material: https://link.firmlearning.com/gmatstudy
My video equipment: https://link.firmlearning.com/myequipment
Learn to code (with 50 USD discount): https://link.firmlearning.com/udacity
Skillshare - start taking courses with free trial: https://link.firmlearning.com/skillshare
📈 START INVESTING WITH ETFs*
Trade Republic (for Germans): https://link.firmlearning.com/traderepublic
WeBull (for U.S. citizens): https://link.firmlearning.com/webull
You receive a free stock valued up to 1,600 USD when joining WeBull via this link.
🎧 AUDIOBOOKS*
This is a link to the audiobook service Audible that I use every day. It helps me "read" 50+ books every year. The link gives you a free test month:
https://link.firmlearning.com/audible
💬 SOCIAL MEDIA
Instagram: https://link.firmlearning.com/instagram
LinkedIn: https://link.firmlearning.com/linkedin
Discord: https://link.firmlearning.com/discord
TikTok: https://link.firmlearning.com/tiktok
Facebook: https://link.firmlearning.com/facebook
* Links are Affiliate links. This means I receive a revenue share whenever a purchase is made via the link. The price for you stays the same. Please always do your own research when signing up with other services. I cannot be held liable for any misrepresentations or damages, except for gross negligence. Thank you for supporting my work at Firm Learning!
All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.
#consulting #excel #exceldashboards
Видео HOW TO BUILD EXCEL DASHBOARDS - Key Excel Skills for Consulting канала Firm Learning
In this video, I show you how to build Excel dashboards. Based on my experience as an Ex-McKinsey consulting, I teach key Excel skills for consulting or corporate careers. Creating Microsoft Excel dashboards is a crucial skills for anybody working with data. Dashboards enable decision makers to regularly review data from crucial areas from their operations and make informed business decisions. Learn to build Excel dashboards and build key Excel skills for consulting in this video! I will teach how how to build interactive Excel dashboards. This is an absolute beginner's guide to Excel dashboards, it is an Excel tutorial for dashboards, based on dropdowns. Learn to build Excel dashboards for beginners with this Microsoft Excel tutorial. Learn data analysis in Excel today.
Chapters
00:00 Introduction
01:28 DataCamp
02:50 What we are going to build
04:00 Building the front end
09:01 Understanding the data inputs
10:30 Linking the data to the dashboard
22:10 Additional remarks
23:44 Wrap-up
This video was sponsored by DataCamp.
Download the Excel dashboard that we jointly create in this video to play around with it: https://link.firmlearning.com/dashboard
🎓 MY ONLINE COURSES*
Learn to make PowerPoint presentations like Top Management Consultants:
"CEO-level Presentation Skills - Slide Writing for Consulting"
https://link.firmlearning.com/slides
Learn to negotiate your salary and earn your worth:
"The Complete Salary Negotiation Master Class - ASK for more"
https://link.firmlearning.com/salarynegotiation
Everything you need to know about Blockchain and Cryptocurrency:
"The Complete Course on Blockchain and Bitcoin"
https://link.firmlearning.com/blockchain
📄 CV AND COVER LETTER TEMPLATE*
Get a CV and cover letter template based on my own documents. With earlier versions of this CV and cover letter, I successfully applied to McKinsey as consultant:
https://link.firmlearning.com/learning
👍 CHANNEL MEMBERSHIP
Become a member of Firm Learning to support my work and get access to perks:
https://link.firmlearning.com/join
📩 NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
https://link.firmlearning.com/e-mail
☑️ RECOMMENDATIONS*
Books that I loved (Management & Self-development): https://link.firmlearning.com/books
Travel like a consultant: https://link.firmlearning.com/travel
GMAT study material: https://link.firmlearning.com/gmatstudy
My video equipment: https://link.firmlearning.com/myequipment
Learn to code (with 50 USD discount): https://link.firmlearning.com/udacity
Skillshare - start taking courses with free trial: https://link.firmlearning.com/skillshare
📈 START INVESTING WITH ETFs*
Trade Republic (for Germans): https://link.firmlearning.com/traderepublic
WeBull (for U.S. citizens): https://link.firmlearning.com/webull
You receive a free stock valued up to 1,600 USD when joining WeBull via this link.
🎧 AUDIOBOOKS*
This is a link to the audiobook service Audible that I use every day. It helps me "read" 50+ books every year. The link gives you a free test month:
https://link.firmlearning.com/audible
💬 SOCIAL MEDIA
Instagram: https://link.firmlearning.com/instagram
LinkedIn: https://link.firmlearning.com/linkedin
Discord: https://link.firmlearning.com/discord
TikTok: https://link.firmlearning.com/tiktok
Facebook: https://link.firmlearning.com/facebook
* Links are Affiliate links. This means I receive a revenue share whenever a purchase is made via the link. The price for you stays the same. Please always do your own research when signing up with other services. I cannot be held liable for any misrepresentations or damages, except for gross negligence. Thank you for supporting my work at Firm Learning!
All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.
#consulting #excel #exceldashboards
Видео HOW TO BUILD EXCEL DASHBOARDS - Key Excel Skills for Consulting канала Firm Learning
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Key Consulting Excel Skills - How to use Index Match in Excel for ConsultantsWhy Time Management does not work - and what to do insteadHow to Take Notes for Work - Note-taking Tutorial for ProfessionalsAVOID SMART ARTS IN POWERPOINT - Why you should not use SmartArt in PPT and what to do insteadEXCEL SKILLS - How to build Financial Model in Excel (liquidity forecast with SUMIFS formula)Bain Case Interview - Strategy consultant reacts to mock case interviewSTAY HEALTHY - How to stay healthy while working full-time (morning routines, exercise, food, sleep)How I Built 7 Income Streams in 2 YearsHOW TO SOLVE PROBLEMS - How do consulting firms work (hypothesis-based problem solving explained)COMMON FIRST JOB MISTAKES - What young graduates do wrong at work (with McKinsey storytime)Excel Formatting Tips for ConsultantsTalk like a Consultant - How to conduct Interviews with ClientsHOW TO GET PROMOTED AT WORK FAST - Importance of "Visibility" at work (fast track your promotion)How to Dress as a Consultant at Work (Men's Style Guide)Ex-McKinsey consultant creates a Slide Presentation with youHOW TO SET GOALS FOR 2021 | Using OKRs for personal goalsHOW TO SUCCEED IN MEETINGS - Tips to contribute and speak up in business meetingsProject Management Consulting Skills - How consultants manage projects and file structures