Are you a Ms Excel user looking for ways to take your spreadsheets to the next level? Then you’ve come to the right place! In this course, we will explore many features and capabilities of Ms Excel that can help you work smarter, faster, and more efficiently. From creating formulas to analyzing data, you’ll learn how to make the most of your spreadsheets and get the results you need.
Our course covers Excel’s functions, formulas, and tools that can be used to analyze business data. To help you better understand how to use Excel, we take you on a no-nonsense journey. Our first step is to prepare raw data for analysis and look at how to use it. We will then look at a number of tools and functions that can be used to conduct analysis, such as Pivot Tables. Then we’ll see how charts, pivot charts, slicers, and so on can be used to display data in a way that is most meaningful.
This course also includes practice exercises so you can immediately use the new data analysis techniques that you learn in the course. This course concludes with some advanced techniques designed to assist forecasting and using existing data to predict future trends.
Syllabus
- Excel Basics
- Data Fundamentals
- Descriptive Statistics
- Formatting and Validating Data
- Advanced Functions
- Pivot Table and Data Visualization
- Data Analysis
Duration
10 Days
Fee
1450/-
