The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.
From Very Basic Excel to Advanced Excel step-by-step.
Real-time projects.
Theory and Practical Exams.
Interview practice.
At the end of the course, you will able to do anything in excel in the perspective of System Analyst role.
Right from Excel introdution, Excel window components, excel specifications, basic functions and formulas, commands, tables, reports, various commands, you will learn many more things.
Excel Sort and Filter.
Functions in Excel.
Conditional formatting.
Data Validation.
Pivot Tables and Charts.
Data Analysis in Excel.
Macros
Excel Dashboard.