السعر: 1,638 درهم
- مدة الدورة التدريبية: Upto 8 Hours
- مواعيد الدورة: Part Time, Flexible
تفاصيل الدورة
Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX; will learn about data validation and database functions such as DSUM; will learn how to import and export data, and how to query external data bases.Course Outline
1 - Logical and statistical functions
Logical functions Math and statistical functions
2 - Financial and date functions
Financial functions Date and time functions Array formulas Displaying and printing formulas
3 - Lookups and data tables
Using lookup functions Using MATCH and INDEX Creating data tables
4 - Advanced data management
Validating cell entries Exploring database functions
5 - Exporting and importing
Exporting and importing text files Exporting and importing XML data Getting external data
6 - Analytical tools
Goal Seek and Solver The Analysis ToolPak Scenarios
7 - Macros and custom functions
Running and recording a macro Working with VBA code Creating functions تحديث بتاريخ 24 October, 2017
الموقع
نبذة عن معهد New Horizons Computer Learning Center-Dubai
New Horizons is the world’s largest training provider with a global footprint of more than 300 locations in over 70 countries.They have more combined global training experience than any other training provider in the world as an industry leading training provider. The institute has been awarded more times
by major vendors than any other training organisation in the world.Their customers have a dedicated account manager who provides advice and guidance regarding training solutions and manages the relationship end-to-end.
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office Essentials London Institute of Business & Management72 درهم
771 درهممدة الدورة التدريبية: Upto 67 Hours - Microsoft Excel Bundle Beginners to Advance One Education43 درهم
881 درهممدة الدورة التدريبية: Upto 1 Month
