Building elegant, informative and eye-catching dashboards in Excel is an indispensable skill. Learn how to build them in one afternoon.There are many small, simple skills that you need to know to build amazing dashboards. Most Excel users may know the skills but they do not know how to combine them correctly. This comprehensive lesson will take you from zero to dashboard master. You will learn all the basic skills and then how and why, you should combine them.Note, there is no programming involved here, simply some very clever tricks and tips to make Excel perform magic. This is not a dry, boring, technical Excel book. This is a real-life Excel lesson loaded with images and ample explanations in plain English. The material is written for every level of Excel user, from basic to advanced.The lesson includes a link to my website where you can download sample workbooks to follow along with the material. I am always available to answer any questions.This bundle contains the following lessons:
- Mastering Excel Formulas: SUM, SUMIF
- Mastering Excel Formulas: VLOOKUP
- Mastering Excel: Pivot Tables
- Mastering Excel:Mastering Excel: Named Ranges, OFFSET and Dynamic Charts
- Mastering Excel: Conditional Formatting
- Mastering Excel: User Forms
- Mastering Excel: Building Dashboards
This is a bundle of previously published eBook lessons. The Mastering Excel: Dashboard Bundle contains the following lessons: - Mastering Excel Formulas: SUM, SUMIF - Mastering Excel Formulas: VLOOKUP - Mastering Excel: Pivot Tables - Mastering Excel: Building Animated Charts - Mastering Excel: Conditional Formatting - Mastering Excel: User Forms - Mastering Excel: Building Dashboards To create effective, dynamic Excel dashboards there are several skills that you need to know. This bundle covers these skills. This is a long eBook, covering many topics. In the last lesson, you will take all the other topics and combine them together to create new Excel functionality that is not possible 'out of the box'. The eBook contains a link to my website where you can download a zip file with every follow along workbook for each lesson You will get the opportunity to work through each lesson on your own PC.