Excel logo 3.JPG

MICROSOFT EXCEL ADVANCED

Currently no public class is available but private class can be arranged

Duration: 2 days

Upon completion of this program, participants should be able to:
• Create Subtotal Using the Subtotal Function
• Analyze data Using Pivot Tables
• Perform What If Analysis using:
o Goal Seek
o Solver
o Input Table
o Scenarios
• Use VLOOKUP function to extract data
• Nesting INDEX and MATCH Function
• Combining & Consolidating Data
• Summarizing & Analyzing with Pivot Table and Pivot Charts
• Record and Run a Macro