About this Course
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.
What you will learn
- Understand how to to Enter to create formulas and functions
- Understand formatting and adjusting layouts
- Understand data management
- Understand how to create table and charts
- Pivot table
Duration
3 days
Fee
799/-
Syllabus
- Introduction to Excel
- Navigation around the Excel Interface
- Arithmetic operations
- Charts and Tables
- Use of Advanced Formulas
- Data Management
- Data Analysis Basics
- Pivot Table in Excel
