Advanced Microsoft Excel هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

FEATURES 

• 16 hours of business focused Excel 
  
• Using advanced graphs and presentation techniques to maximize impact
  
• How macros and VBA automate your spreadsheets and increase interactivity 
  
• How superpower functions can solve complex problems 
  
• Using PivotTables and PowerPivot to turn raw data into clear information that supports key decisions.

OUTLINES Section 1: Efficiency and Risk

• Templates 
  
• Increasing Efficiency and Reducing Risk 
  
• Data Validation 
  

• Functions with Superpowers 
  
• Array Formula
  
• Tables 
  
• Advanced Range Names 
  
• What If Analysis 
  
• Problem Solving  
  

Section 3: Excel Interactivity

• Form Controls 
  
• Visual Basic and Macros  
  

Section 4: Spreadsheet Impact

• Conditional Formatting 
  
• Charts that Inspire 
  
• Sparklines 
  
• Graphics Tricks and Techniques  
  

Section 5: Turning Data into Decisions

• Working with External Data 
  
• Advanced Uses of PivotTables 
  
• PowerPivot 
  
• Reporting with PowerPivot 
  
• Course Plenary  
  

Section 6: Course Plenary

Certificate: Log In Certificate of Completion will be provided to delegates who attend and complete the course.