We will cover a variety of topics, including exploring formulas, cleaning data, and identifying data attributes. This course starts off with the fundamentals, walking you through all you need to understand about spreadsheets, from layout to applications. Using the data analysis and visualization features that are native to Excel, this course will show you how to extract maximum value most efficiently from the information your organization collects. In this course, we will explore the key features of Microsoft Excel that make it such an essential tool for data analytics. **This course includes downloadable instructor files to work with and follow along.**One of the most rapidly developing areas in today's market is data analytics-it is also an area in which businesses are struggling to find qualified staff. This course is suitable for absolute beginners Microsoft Excel for Windows installed and ready to use on your computerīasic knowledge of Microsoft Excel is helpful but not required. Utilize rank and percentile options and generate histograms 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

Download microsoft excel