Intermediate Excel for administrator and Professional
50% off through Laimoon! إحصل على هذا العرض
السعر: 191 USD
382 USD
100% ضمان استعادة الاموال
No questions asked refund With a goal of giving you a worry-free and secure enrollment experience, We offer a 24 hour money-back guarantee. Just send us a refund request via email within 24 hours after first class and we will refund 100% of your payment, no questions asked!
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
  • مدة الدورة التدريبية: 12 ساعة
  • مواعيد الدورة: Flexible

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

    Microsoft Excel Intermediate
     
    1.    Performing Calculations
    1. Naming groups of Data using Named Ranges
    2. Creating Formulas to Calculate Values
    3. Summarizing data meets specific condition
    4. using If function
    5. Formula Auditing
    • Adding a watch Window o Tracing Formula Errors
    o  Tracing Precedents and Dependent cells
    1. Changing workbook appearance
    • Defining Styles
    • Making Numbers easier to read
    • Transposing data
    • Changing Cell Orientation and Merging Cells
    • Change appearance of data based on its value
    • Focusing on specific data by using filters
    • Inserting Filters
    • Sort A to Z using Filters o Number Filters
    o  Clear Filters
     
    o Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden
     
    and filtered rows (subtotal and aggregate functions)
    • Data Validation 
    3.    Reordering and Summarizing Data
    • Sort Data
    • Custom Lists
    • Organizing data into levels using subtotals 
    • Creating an outline
    • Lookup Functions
    4.    Combining Data from Multiple Sources 
    • Using Excel’s Built-in Templates
    • Using workbooks as templates for other workbooks
    • Linking to data in other workbooks
    • Consolidating data
    • Saving workbooks as a workspace
    • Comments in cells and workbooks
      • Viewing Comments in a worksheet
      • Adding and Removing comments
      • Adding comments to a workbook
    • Protection 
    • Password protect a worksheet and workbook
    • Unlock cells and protecting part of a worksheet
    • Track Changes
    • Mark a workbook as final
     

     
     
     
     
     
      تحديث بتاريخ 12 May, 2020

    المتطلبات

    Basic knowladge of computer and internet

    استفسر عن هذه الدورة

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

    قيِم هذه الصفحة