Microsoft Excel Advanced

Course details

2 days Course Outline
Module 1: Advanced functions and formulas
• Logical functions
• Conditional functions
• Financial functions
• Text functions
• Date and time functions
• Array formulas
• Calculation options
 
Module 2: Lookups and data tables
• Using lookup functions
• Creating data tables
 
Module 3: Advanced data management
• Validating cell entries
• Advanced filtering
 
Module 4: Advanced charting
• Chart formatting options
• Combination charts
• Graphical objects
 
Module 5: Pivot Tables and Pivot Charts
• Working with PivotTables
• Modifying Pivot Table data
• Formatting PivotTables
• Using Pivot Charts
• PowerPivot
 
Module 6: Streamling Workflow: Macros
• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings
 
Module 7: Collaborating with Others
• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
 
Module 8: Auditing Worksheets
• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline
 
Module 9: Analyzing Data
• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak
• Create Sparklines
 
Module 10: Working with Multiple Workbooks
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links  
 
Module 11: Importing and Exporting Data
• Export Excel Data
• Import a Delimited Text File Updated on 11 May, 2020