The 2024 Excel to Alteryx Data Analyst Essentials Bundle

Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.

• Access 49 lectures & 5 hours of content 24/7
• Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, & XLOOKUP
• Use IF, IFS, IFERROR, SUMIF, & COUNTIF to apply logic to your analysis
• Split data using text functions SEARCH, LEFT, RIGHT, MID
• Standardize & clean data ready for analysis
• Use the PivotTable function to perform data analysis
• Use slicers to draw out information
• Display your analysis using Pivot Charts
• Learn about forecasting & using the Forecast Sheets
• Conduct a Linear Forecast & Forecast Smoothing
• Use Conditional Formatting to highlight areas of your data
• Learn all about Histograms & Regression
• Use Goal Seek, Scenario Manager, & Solver to fill data gaps

Note: Software NOT included.

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Certificate of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel