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

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

Course Curriculum:
Outline of Excel Environment
Usage of Shortcuts
Developments and Scenarios utilizing charts
Guidelines and Techniques to improve dashboard designing
Overview of VBA
Getting Started with PivotTables
User Defined Function
Error Handling
Slicers
Using Custom AutoFill Lists
DBMS – SQL (VIDEO-BASED)
SQL Fundamentals
Manage Macros
Comprehending RDBMS concept
Data Forms
Outlining and Grouping Data
Special Features for Filtered Lists
Splitting Windows
Analysis tool pack
Building your worksheet interactive by utilizing actions
Goal Seek and Data Tables
Visual Basic and Macros
Identifying Records Using Criteria

Course Overview:
You will be capable enough to break the complex applications down into basic steps.
Utilizing advanced graphs in minutes and complete the work as a substitute to killing hours to figure out.
Students will be able to improve interaction by automating spreadsheets.
You can easily answer difficult problems with superpower functions.
You will be able to turn raw data into decisions by leveraging PivotTables.

  تحديث بتاريخ 20 June, 2021