Excel Advanced Course Content • Module-1 | Introduction to Excel• Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options • Module-2 | Understanding Cell References and Range Name• References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series • Module-3 | Working with Formulas and Functions• Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET • Module-4 | Lookup and References Functions• Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func • Module-5 | Data Validation and Protection• Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates • Module-6 | Sorting and Filtering Data• Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter • Module-7 | What if-Analysis Tools• Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario • Module-8 | Formatting Features• Table Format, Conditional Format, using formulae & vlookup • Module-9 | Importing Data• Importing Text files, Importing data from database • Module-10 | Macro & Custom Functions• Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. Basic Course: Rs. 1500/- Advanced Course: Rs. 2800/- Keywords: MS Excel, Microsoft, Excel, Basic, Advanced, Spreadsheet, Computer, Weekend, expert, economic, cost

Topics Covered

.Excel Advanced Course Content • Module-1 | Introduction to Excel• Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options • Module-2 | Understanding Cell References and Range Name• References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series • Module-3 | Working with Formulas and Functions• Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET • Module-4 | Lookup and References Functions• Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func • Module-5 | Data Validation and Protection• Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates • Module-6 | Sorting and Filtering Data• Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter • Module-7 | What if-Analysis Tools• Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario • Module-8 | Formatting Features• Table Format, Conditional Format, using formulae & vlookup • Module-9 | Importing Data• Importing Text files, Importing data from database • Module-10 | Macro & Custom Functions• Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. Basic Course: Rs. 1500/- Advanced Course: Rs. 2800/- Keywords: MS Excel, Microsoft, Excel, Basic, Advanced, Spreadsheet, Computer, Weekend, expert, economic, cost

Who should attend

.Excel Advanced Course Content • Module-1 | Introduction to Excel• Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options • Module-2 | Understanding Cell References and Range Name• References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series • Module-3 | Working with Formulas and Functions• Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET • Module-4 | Lookup and References Functions• Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func • Module-5 | Data Validation and Protection• Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates • Module-6 | Sorting and Filtering Data• Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter • Module-7 | What if-Analysis Tools• Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario • Module-8 | Formatting Features• Table Format, Conditional Format, using formulae & vlookup • Module-9 | Importing Data• Importing Text files, Importing data from database • Module-10 | Macro & Custom Functions• Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. Basic Course: Rs. 1500/- Advanced Course: Rs. 2800/- Keywords: MS Excel, Microsoft, Excel, Basic, Advanced, Spreadsheet, Computer, Weekend, expert, economic, cost

Pre-requisites

Basic Excel

What you need to bring

.Excel Advanced Course Content • Module-1 | Introduction to Excel• Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options • Module-2 | Understanding Cell References and Range Name• References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series • Module-3 | Working with Formulas and Functions• Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET • Module-4 | Lookup and References Functions• Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func • Module-5 | Data Validation and Protection• Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates • Module-6 | Sorting and Filtering Data• Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter • Module-7 | What if-Analysis Tools• Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario • Module-8 | Formatting Features• Table Format, Conditional Format, using formulae & vlookup • Module-9 | Importing Data• Importing Text files, Importing data from database • Module-10 | Macro & Custom Functions• Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. Basic Course: Rs. 1500/- Advanced Course: Rs. 2800/- Keywords: MS Excel, Microsoft, Excel, Basic, Advanced, Spreadsheet, Computer, Weekend, expert, economic, cost

Key Takeaways

.Excel Advanced Course Content • Module-1 | Introduction to Excel• Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options • Module-2 | Understanding Cell References and Range Name• References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series • Module-3 | Working with Formulas and Functions• Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET • Module-4 | Lookup and References Functions• Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func • Module-5 | Data Validation and Protection• Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates • Module-6 | Sorting and Filtering Data• Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter • Module-7 | What if-Analysis Tools• Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario • Module-8 | Formatting Features• Table Format, Conditional Format, using formulae & vlookup • Module-9 | Importing Data• Importing Text files, Importing data from database • Module-10 | Macro & Custom Functions• Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. Basic Course: Rs. 1500/- Advanced Course: Rs. 2800/- Keywords: MS Excel, Microsoft, Excel, Basic, Advanced, Spreadsheet, Computer, Weekend, expert, economic, cost