Certified Advance Excel Professional Training ProgrammeMS Excel is the most common software used for spreadsheet, the Workshop on MS Excel has been designed to provide hands-on experience. The workshop aims to impart the basic and advanced techniques of Excel to acquaint users with the latest technology as well as lessen their work load. We, at i4best, believe in practical oriented training methodology, and thus we conduct a hands on workshop to enrich the existing knowledge in professionals and help them explore unimaginable possibilities and secure your job for data entry operator mis executive.
Who Should Attend This Training Programme? Why?This Course on MS Excel is a common platform for all to learn the nitty-grittys of spreadsheet application. It is for Executives, who are familiar with the basic functionality of spreadsheets, yet are unaware of its advanced techniques. It is for students of professional courses, who use spreadsheet at on elementary level and will have to graduate to advanced features during their academic and career pursuits.
Course ContentThis course is specifically designed for professionals and graduate students who need to learn about the advanced ways of using spreadsheets for complex issues. This knowledge packed workshop starts with an introduction to MS Excel. Tentative list of topics which are covered in the courses.
- Essential Shortcuts
- Absolute & Relative Referencing ($)
- ROUND (), SUMPRODUCT (), etc.
- Using SUBTOTAL() with Filtered data
- SUMIF, COUNTIF
- Computations %, Sum, Max, Min, Average, Count, etc.
- Generate Multiple Reports
- VLOOKUP() & HLOOKUP()
- VLOOKUP() with MATCH(), INDEX() & MATCH()
- INDIRECT() with Cell Range Naming
- IF(), Nested IFs(), AND(), OR(), IFERROR()
- ISNUMBER(), ISTEXT(), ISBLANK()
Working with Dates Data Cleaning
- LEFT(), RIGHT(), MID()
- LEN(),TRIM(), SUBSTITUTE(), VALUE()
- UPPER(), LOWER(), PROPER()
- Using “&” for concatenating or joining strings / cell values
- Find & Replace (Using wildcard character – Asterisk *)
- Go To (Special) with Ctrl+Enter trick
- Text to Columns with advanced tricks
- Remove Duplicates
- Data Consolidation
- Automatic Row Wise Sub-Total
- Conditional Formatting – Blanks, Duplicates, Cell Values, Formula based, etc)
- File Password & Cell Protection
- Data Validation (List)
- Cell Range Naming, Grouping
What IF Analysis
- Data Tables
- Macros Recorder, Record & Run
OTHER DETAILSTraining Pre-Requisites
- The candidate should have working knowledge of Basic Excel. He is expected to know the following: Paste Special | Basic Formulas: SUM(), MAX(), MIN(), AVG() | Hide-Unhide Rows & Columns | Freeze-Unfreeze Panes | Basic Sort & Filter