Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;
VLOOKUP() Function for Looking up Information
INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
TEXT() Function for Formatting
CHOOSE() for Ultimate Flexibility in Presenting Data
Advanced Filtering
Summarizing Data with PivotTables and Pivot Charts
Interactive Features to Create User Friendly Reports
VBA Magic to Create Dynamic Content
and more...
What's Included in the Course:
30+ Video Lectures to Follow Along and Practice the Concepts of Excel Data Analysis and Dashboard Reporting
Downloadable Exercise Files
Instructor Support through the QA Section Found within the Course - Ask Your Questions!
Build a Real World Excel Dashboard
30 Day Money Back Guarantee
Join me in this course and take your Microsoft Excel skills to new heights. The skills you learn will help streamline your efforts in managing and presenting Microsoft Excel data.
See you in the course!
Understand and Identify the principles of data analysis
Effectively summarize and present data clearly
Use effective design principles when creating and presenting data
4 Lectures
6 Lectures
6 Lectures
6 Lectures
9 Lectures
4 Lectures
1 Lectures
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 1.8 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into...
Here to support your progress through courses provided by Office Newb, LLC.
This course was incredibly helpful! It was well-organized and easy to follow, starting with the basics and progressing to advanced features like pivot tables and data analysis and building dashboard in excel. The instructor was clear and engaging. I feel much more confident using Excel now. Highly recommend it for anyone looking to improve their skills
Helpful
yes, exactly what I was looking for
Reassuring intro
Learning a lot, instructor explains very clearly and is easy to understand
AMAZING
Record macro steps --> VBA projects (Alt + f11 to open)
subtotal functions, to not count hidden values
Love this course and it is so easy to understand and follow.
Good
Your email address will not be published. Required fields are marked *
Roni T.
got new knowledge