This class is basically a wonderful for those who have to work on reports, charts, Analysis on daily basis. It is an excellent for anyone who wish to learn it even at personal level.

Topics Covered

1. Basic Excel structure (Cells, Rows, Columns) 2. Basic Excel Functions (Sum, Min, Max, Average, Count) 3. Conditional Formatting 4. Sorting and Filtering Data 5. Inserting Shapes, Charts (Bar, Column, Pie, Line, Area, Scatter), Picture, Clip Arts, Smart Arts) 6. Inserting Hyperlinks (Internal and External) 7. Inserting Word Arts, Headers and Footers 8. Adding Digital Signatures to the Document 9. Lookup and References (HLOOKUP and VLOOKUP) 10. Page Setup (Margins, Page Size, Print Area) 11. Importing and Exporting Data in various formats (PDF, Text, Web) 12. Data Validation 13. What-If Analysis (Goal Seek) 14. Text-To-Columns 15. Protect Worksheet and Workbook 16. Sharing Workbook 17. Freeze Panes 18. Work Spaces 19. TEXT Functions (LEN, UPPER, LOWER, CONCATENATE, CHAR, CODE, LEFT, RIGHT, REPLACE, PROPER, EXACT) 20. DATE Functions (NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND) 21. Mathematical Functions (ABS, MOD, CEIL, FLOOR, POWER, RAND, RANDBETWEEN, SQRT, SUMIF, COUNTIF, AVERAGEIF) 22. Formula Auditing (Error Checking, Trace Precedent, Trace Dependent, Watch Window, Show/Hide Formula) 23. Working with Macros 24. Mail Merge

Who should attend

1. Students pursuing courses in Commerce, Economics, BFA (Bachelor of Finance and Accounts), Management, CS 2. Chartered Accountants (CA) 3. Data Analysts 4. Employers, Human Resource 5. Clerks, Back office staff 6. Working Professionals 7. Data Entry Operators

Pre-requisites

Basic knowledge of computers that's it. Rest leave it to me.

What you need to bring

Pen and notebook, Pen drive (for e-books)

Key Takeaways

1. Excellent knowledge in Microsoft Excel 2. Support for Microsoft International Certification (MOS - Microsoft Office Specialist)