Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The training has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.

Prerequisites

• The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel

Target Audience

• This training has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

Content

• Introduction
• Data Analysis Process
• Working with Range Names
• Tables
• Cleaning Data with Text Functions.
• Cleaning Data Containing Date Values
• Working with Time Values
• Conditional Formatting
• Sorting, Filtering
• Subtotals with Ranges
• Quick Analysis
• Lookup Functions
• PivotTables
• Data Visualization
• Data Validation
• Financial Analysis
• Working with Multiple Sheets
• Formula Auditing
• inquire
• Step Chart
• Box and Whisker Chart
• Histogram
• Pareto chart
• organization chart