Microsoft Excel Dashboards Crash Course for Advanced Users | Free Udemy Course
Learn to create interactive stunning visuals all from within Excel in this 2 hr crash course for Excel Dashboards! - Free Course | Free Udemy Course
new- 1.5 hours hours of on-demand video
- 3 article
- Full lifetime access
- Access on mobile and TV
- 1 additional resources
If you want those fancy dashboards, you see in Power BI, well guess what you can get them here in Microsoft Excel!Using enhanced Excel functions such as INDEX, MATCH, IFS and many more, I will guide you use a simple Data List feature and form controls to pull out the important data from your tables using advanced functions and combine it with interactive and modified charts all from within Excel.In this 2-hour crash course, we will cover:INDEX & MATCHIFS FunctionsLARGE vs SMALLCHOOSEUsing Bar Charts as a whole vs Pie ChartsAdding Dynamic Vertical Group Bars to ChartsMaking your Line Chart Dynamic to Date RangesCreating your very first Info GraphicsUsing Option ButtonsUsing List BoxUsing Scroll BarCreate your Dashboard masterpieceThis course is intense, it's fast, but it gets the job done. This course is designed for the Advanced Excel user who knows their way around functions and syntax and Excel in general. Although the manual you get with this course is eight chapters long, we only cover four of them in under 2 hours. So, you must know the first three chapters of the manual as well to be able to keep up with the content. You may have heard of the functions we mentioned enough but you may not of known how their use can lead to stunning visuals and a dashboard all within Excel with no need to jump into Power BI!Who this course is for:This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work.
Course Content:
Sections are minimized for better readability, click the section title to view the course content
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
JOIN WHATSAPPJOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON
JOIN TELEGRAMJOIN OUR FACEBOOK GROUP TO GET LATEST COUPON
JOIN FACEBOOKFree Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Try itURL Decoder
Input an encoded string of text or a URL and decode the entered string
Try itColor Contrast Checker (WCAG)
Calculate the color contrast ration for your website (WCAG)
Try itXML Formatter
Paste or upload an XML and have it formatted to a beautiful XML format
Try itURL Slug Generator
Convert any title or sentence into a variety of slugs for your pages URL
Try itE-Signature
Draw an e-signature or type a signature for your online signature
Try it