Advance Excel

Advanced Excel skills are a high level of proficiency with the Microsoft Excel program. The basic users of Excel can use Excel to create spreadsheets, perform mathematical operations, and make simple tables and charts, advanced users can manage and analyse complex and large datasets, derive meaningful insights from them, and create persuasive data visualizations for presentations.

Advanced Excel users are also experts at using lesser-known capabilities of this program like lookup tables, pivot tables, and pivot charts, along with data validation and debugging features to ensure accuracy.

Content:

• Introduction & Usage of Advance Excel
• Gathering And Processing Data
• Data Validation
• Analyzing Data
• Work financial function
• Work with Date and Time function
• Work with Text function
• Vlookup / HLookup
• Index and Match
• Nested VLookup
• Reverse Lookup using Choose Function
• Worksheet linking using Indirect
• Visualizing data with charts
• Create a PivotTable
• Analyze PivotTable Data
• Creating Sparklines and Mapping Data
• What if Analysis
• Goal Seek
• Scenario Analysis
• Loading the data from the text file
• Loading the data from Internet
• Transferring data for presentation purpose
• Exporting data to the text file
• Exporting data to the web
• Sharing and Protecting Workbooks
• Recording a Macro
• Executing a Macro
• Deleting Macro
• Customizing the Macro
• Inserting & Removing Hyperlink
• Creating a Data form
• Preparing Tax Invoice
• Preparing Salary Slip
• Printing Workbooks