Ultimate Microsoft Excel With Data Analysis & VBA Macros
Excel Data Analysis - Learn Advanced Techniques for Cleaning, Organizing, Manipulating and Visualization Your Data.
4.27 (83 reviews)
9,660
students
4.5 hours
content
Jul 2024
last update
$19.99
regular price
What you will learn
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
Screenshots
6070613
udemy ID
7/12/2024
course created date
7/30/2024
course indexed date
Muhammad
course submited by