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

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

FEATURES

• 16 hours of business focused Excel  
  
• Taught through a trainer led class  Practice spreadsheets   
  

OUTLINES Section 1: Foundation

• Excel Introduction 
  
• The Excel Interface 
  
• Basic Navigation and Editing 
  
• Getting Going  
  

Section 2: Orientation and Efficiency

• Editing 
  
• Viewing 
  
• Spreadsheet Structure 
  
• Cell References
  
• Named Ranges
  
• Basic Macros
  
• Design  
  

Section 3: Administration

• Customizing Excel 
  
• Housekeeping 
  
• Connecting Workbooks
  
• Documentation 
  
• Protecting and Sharing 
  
• Google Docs 
  
• Excel Troubleshooting  
  

Section 4: Data Handling

• Sorting and Filtering 
  
• Controlling User Input 
  
• Working with Dates and Times 
  
• Working with Text 
  
• Lookup and Reference 
  
• Logical Functions  
  

Section 5: Data Analysis

• Working with Numbers 
  
• Summarizing Data 
  
• PivotTables 1 - Simple Summaries 
  
• PivotTables 2 - Manipulating Data 
  
• PivotTables 3 - Interpreting Data 
  
• PowerPivot: Handling Big Data 
  
• Formula Auditing 
  
• Advanced Macros and VBA 
  
• Modelling  
  

Section 6: Presentation

• Cell Formatting 
  
• Number Formatting 
  
• Conditional Formatting 
  
• Graphs and Charts 
  
• Page and Print Setup  
  

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