Excel For Everyone: Data Analysis Fundamentals
About Course
- This advanced Excel course builds on the teachings of Course 1: Core Foundations and Course 2: Data Management. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.
- Whether you need to process numbers for personal projects or for organizational purposes like sales, inventory, human resources, or IT, knowing how to make sense of data is critical. You will develop in-demand skills to gain a competitive edge and value to your organization, including how to extract actionable organizational intelligence from raw data, and present it in a visual format to help drive organizational decision-making Learn how to get Excel to do the hard work for you with sophisticated automation, spreadsheet design and powerful dashboards.
What I will learn?
- Advanced Formulas and conditional logic
- Analyze and report data
- Automating complex & repetitive tasks
- Advanced-Data Analysis
- Workbook Collaboration
- Automate workbook functionality
- Protecting Workbooks
- Formula Audits and Data Validation
- Macros and Visual Basics
- Advanced Charting Techniques
- Professional Dashboards.