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

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

Unlock the secrets of Excel and master spreadsheets.

Hone your skills in one of the most important, universal areas in the modern knowledge workers day to day job, and become indispensable.

However, we know Excel can be mystifying and intimidating to many people.

This bundle is perfect for beginners all the way through to data and financial analysts interested in solving complex business problems. We've established ourselves as the Excel experts in the last 9 years, and you won't find better, or more thorough content anywhere else.

What you get with this Ultimate Microsoft Excel Bootcamp package:

• 4 business focused Excel courses
  
• 280 modules of training, covering the most business-relevant areas of Microsoft Excel.
  
• 190+ videos and over 130 downloadable exercises.
  
• Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
  
• Multiple videos, practice exercises and test questions to aid your learning.
  
• Knowledge to understand the data that drives your business.
  

Microsoft Excel:

• How Excel works, how to navigate and design a spreadsheet
  
• The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  
• To use PivotTables, Pivot Charts and Basic Macros
  
• To create beautiful looking graphs and charts
  
• Formatting, including; conditional, cell and number formatting
  
• How to print what you want
  

• Use advanced graphs in minutes instead of wasting hours trying to figure them out
  
• Increase interactivity by automating your spreadsheets with macros and VBA
  
• Solve complex problems with superpower functions 
  
• Turn raw data into  must make decisions using PivotTables and PowerPivots.
  
• And more!
  

• The primary uses of pivot tables
  
• How to identify the best and worst data sets
  
• To filter, sort and group PivotTable"! data to maximise its usefulness
  
• How to present your data clearly using PivotCharts and Conditional Formatting
  

• How to turn buckets of data into sound business decisions
  
• Financial modelling theory
  
• Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
  
• How to effectively and clearly present your findings to relevant stakeholders
  
• Different forecasting techniques, including Moving Averages and Regression