Use the Analysis ToolPak to calculate basic statistical concepts such as correlation and covarianceĬompute descriptive statistics and moving averages and apply exponential smoothing techniques Utilize database functions created specifically to work with large datasets ![]() Understand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions Sort data and apply filters, including advanced filtering techniquesĬreate problem statements to tackle complicated “OR” criteriaĬreate Pivot tables and charts and work with Excel charts, including clustered columns, line graphs, and waterfalls Identify data attributes and view, enter, and format data types in Excel ![]() Understand and apply Excel formulas and functions and apply techniques to recognize and avoid formula errors Learn the fundamentals of Excel spreadsheets, from their layout to the applications ![]() Explore the key features of Microsoft Excel that makes it such an essential tool for Data Analytics
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |