Excel Data Analysis - Learn Advanced Techniques for Cleaning, Organizing, Manipulating and Visualization Your Data.
Sub Category
- Microsoft
{inAds}
Objectives
- Overview of Excel Interface and Navigation
- Merging and Splitting Cells
- Absolute and Relative Cell References
- Using AutoSum and AutoFill for Efficiency
- Performing Text Manipulation with Functions (CONCATENATE, LEFT, RIGHT, MID)
- Using Data Validation to Control Input
- Removing Duplicates and Cleaning Data
- Adding Titles, Labels, and Legends to Charts
- Understanding PivotTables and Pivot Charts
- Creating Dynamic Reports with PivotCharts
- Performing Statistical Analysis with Functions (COUNTIF, SUMIF, AVERAGEIF)
- Adding Trendlines and Error Bars to Charts
- Designing Interactive Dashboards Using Excel Features
- Linking Data Between Multiple Sheets and Workbooks
- Editing and Debugging Macros Using the Visual Basic Editor
- Best Practices for Creating Effective Dashboards
Pre Requisites
- No Prior Excel Knowledge is Needed.
- Beginners and Experts Will Learn a Lot From This Course.
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)