MS Office - Advanced MS Excel
السعر: 1,500 درهم
3,746 درهم
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
  • كتيب الدورة: تحميل
  • مدة الدورة التدريبية: 300 ساعة
  • مواعيد الدورة: استفسار

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

    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.

     
    Content / Syllabus

    Course Syllabus:

    1. Introduction to Excel:

    • Overview of the Excel Interface
      • Familiarize yourself with the Ribbon, Workbook, and Worksheet.
      • Navigate worksheets and workbooks effortlessly.
      • Learn how to create and save a new workbook.
    • Basic Excel Terminology
      • Understand essential terms like cell, range, and formula.

    2. Entering and Formatting Data:

    • Entering Data
      • Input text, numbers, and dates accurately.
    • Data Formatting
      • Apply basic formatting such as font, color, and alignment.
      • Utilize the Format Painter to copy formatting.
    • Sorting and Filtering Data
      • Organize your data effectively using sorting and filtering tools.
    • Introduction to Data Validation
      • Learn the basics of data validation for error-free data entry.

    3. Working with Formulas and Functions:

    • Understanding Formulas
      • Master the syntax and operators used in Excel formulas.
      • Perform basic arithmetic operations.
      • Differentiate between relative and absolute cell references.
    • Common Formulas
      • Learn to use essential formulas like SUM, AVERAGE, MIN, and MAX.

    4. Functions in Excel:

    • Introduction to Functions
      • Get familiar with built-in functions to simplify complex calculations.
    • Using Common Functions
      • Apply functions like IF, COUNTIF, and VLOOKUP.
    • Nesting Functions
      • Combine multiple functions for more advanced formulas.
    • Error Handling
      • Use functions like IFERROR to manage errors in your calculations.

    5. Data Visualization:

    • Introduction to Data Visualization
      • Understand the basics of representing data visually.
    • Creating Charts
      • Build various chart types such as bar, line, and pie charts.
    • Customizing Charts
      • Adjust chart elements like titles, labels, and colors.
    • Using Sparklines
      • Add mini-charts to quickly visualize trends within a cell.

    6. Conditional Formatting:

    • Introduction to Conditional Formatting
      • Learn how to apply formatting rules based on cell values.
    • Highlighting Cells
      • Use conditional formatting to make your data stand out.
    • Data Bars, Color Scales, and Icon Sets
      • Explore different ways to visualize data using conditional formatting.
    • Practical Applications
      • Apply conditional formatting techniques to real-world examples.

    7. Advanced Features and Final Project:

    • Introduction to PivotTables
      • Learn how to summarize large data sets using PivotTables.
    • Creating and Modifying PivotTables
      • Master PivotTable customization for in-depth analysis.
    • Using Slicers and Filters
      • Enhance your PivotTables with slicers and filters.
    • Basic Data Analysis Tools
      • Get an introduction to Excel’s data analysis tools like What-If Analysis and Goal Seek.

    تحديث بتاريخ 27 November, 2024

    المتطلبات

    Basic MS Excel Knowledge: Familiarity with fundamental Excel functions and features.Intermediate Skills: Some experience with Excel formulas, charts, and data management.Professional Experience: Ideal for those with experience in data handling or office management.Interest in Advanced Techniques: Willingness to learn advanced Excel functionalities, including VBA and SQL.

    وظائف مناسبة لهذه الدورة

    secretary , office manager , document controller

    يمكنك إضافة المزيد من الدورات التدريبية هنا.
    سيتم حفظ القائمة.