Introduction to Data Analytics with Microsoft Excel
Explore the key features of Microsoft Excel that makes it such an essential tool for Data Analytics
4.29 (17 reviews)
88
students
4.5 hours
content
Feb 2023
last update
$64.99
regular price
What you will learn
Learn the fundamentals of Excel spreadsheets, from their layout to the applications
Understand and apply Excel formulas and functions and apply techniques to recognize and avoid formula errors
Identify data attributes and view, enter, and format data types in Excel
Sort data and apply filters, including advanced filtering techniques
Create problem statements to tackle complicated “OR” criteria
Create Pivot tables and charts and work with Excel charts, including clustered columns, line graphs, and waterfalls
Understand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions
Utilize database functions created specifically to work with large datasets
Use the Analysis ToolPak to calculate basic statistical concepts such as correlation and covariance
Compute descriptive statistics and moving averages and apply exponential smoothing techniques
Utilize rank and percentile options and generate histograms
Related Topics
5079642
udemy ID
1/12/2023
course created date
4/7/2023
course indexed date
Bot
course submited by