This Course is designed for professionals who are willing to learn Advanced Excel and one who are interested to learn various useful formulas. This is an instructor led Program paced at 2 hours a day for 6 Days.
Post Learning you participants will be able to use formulas like Vlookup,Hlookup and many more
Training Contents Include:
| Introduction to Excel |
| A overview of the screen, navigation and basic spreadsheet concepts |
| Understanding workbooks, worksheets, rows, columns, cells |
| Various selection techniques |
| Entering Data |
| Entering, Editing and Deleting Text, Numbers, Dates |
| Using Auto Lists |
| Moving and Copying data |
| Using navigation techniques |
| Managing & Navigating through workbooks |
| Using Workbook Views |
| Selecting and Switching Between Worksheets |
| Understanding & working rows, columns and worksheets |
| Formatting & Proofing |
| Formatting Cells with Number formats, Font formats, Alignment, Borders, etc |
| Basic conditional formatting |
| Working with Styles |
| Manage data cells and ranges |
| Insert data in cells and ranges |
| Format cells and ranges |
| Summarise and organise data |
| Using different filtering techniques |
| Functions& Formulas |
| Logical functions |
| Math functions |
| Lookup functions |
| Date & Time functions |
| Text Functions |
| Data Sorting & Filtering |
| Sort by Columns |
| Sort by Rows |
| Sort by custom list & Advanced Filtering techniques |
| Data Validation |
| List Validation |
| Value Validation |
| Advanced Validation Techniques |
| Pivot Tables |
Post Learning:
> Will be able to Manage and Maintain MIS Reports
> Develop Template for Daily Reports (like Efficiency Report,Ticket Status Reports..Etc)
> Handle Data in more Efficient way
View this Course
Certified
You have 
