Ultimate Microsoft Excel With Data Analysis & VBA Macros
Deal Score0
What you’ll 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
