Overview
This course introduces you to the world of Excel. You will understand what MS Excel is and how and where it is being used in the professional spheres with its amazing data analysis capabilities. You will be taken through a journey right from the very basics like how data is entered and manipulated in worksheets for creating tables, protecting your work from unauthorized access, creating and working with Excel series, Filtering data and many more. At the end of this course you will be able to appreciate its data crunching abilities and its real life application in daily professional environment.
What you'll learn in Ms-Excel Basic.
In this course you will lerarn about the basics of Ms-Excel. In this course we let the student understand what is Excel,
appreciate its data crunching abilities and its real life application in daily professional environment.
Key Features:-
- Introduction to excel
- what and where is this used?
- Connection between Data and Excel
- Data gyan and table understanding
- Excel data types
- Deep understanding on Excel workbook, worksheets and cell
- Saving Excel Documents with password protection
- Comman Excel shortcut Keys
- Basic use of Userforms for data entry
- Name definition
- Learning some handy data-entry techniques
- Series
- Paste Special
- Filter
- Functionâ??s basic understanding
- Page Setup and taking printouts
- Ms-Excel fundamental tests