This course on "Data Analysis Using Excel" is a beginner level course in Excel that helps in dealing with large amount of data and drawing meaningful conclusions from the data.
The course begins with the use of functions and formulae so that you can transform the raw input into meaningful data. You learn how to visually represent data using different techniques like charts, pivot charts and sparklines. These techniques will let you choose the best method available as per your specific requirement. To slice and dice large data sets and to understand hierarchical relationships between data, you will learn the use of pivot tables. You will learn to give a professional touch to your reports by the use of header and footer. You will learn different tools which aid in decision making - like the goal seek or the scenario manager. You will learn how to let Excel solve complex optimization problems for you using he Solver add-in.
By the end of this course, you will be able to transform raw data into meaningful reports, identify trends, test scenarios, and make informed decisions. Whether you are a student, professional, or business user, this course will help you harness the full potential of Excel for smarter and faster data analysis.
