Basic Excel for administrator and Professional
30% Off for Laimoon Users! إحصل على هذا العرض
السعر: 245 USD
490 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 Basic
    1.    Setting up a workbook
    •  Creating Workbooks
      • Excel Terminology
      • Excel Environment
      • Customizing Quick Access Toolbar
      • Creating a New Workbook
      • Entering Data into Workbook
      • Saving a workbook
      • Open a workbook
      • Zoom
      • Insert a new worksheet
      • Renaming a new worksheet
      • Changing the tab colour of worksheet
      • Rearranging the order of worksheets
      • Move or Copy worksheet
      • Hide/Unhide Worksheet
      • Switch Windows
      • Modifying Workbooks and Worksheets 
    • Changing column widths and row heights
    • Insert Columns/Rows
    • Delete Columns/ Rows
    • Hide/Unhide columns or rows
    • Insert Cells
    • Moving Data by dragging
    • Customizing Excel
    • Arranging multiple workbook windows
    • Customizing the ribbon
    • Minimizing the ribbon
    • 2.  Working with Data and Excel Tables
    • Entering Data
    • Copy, Cut and Paste
    • Pick from drop down list
    • Find and Replace data
    • Spell Check
    • Thesaurus
    • Defining an Excel Table
    • Format as table
    • Table design
    • Basic Formulas
      • How to create a basic formula
      • Operators
      • Copy Formula down
      • Absolute cell reference
    • Basic Functions
    • What is the difference between formulas and functions
    • Insert a function
      • AutoSum, sum, min, max and average
    1. Changing Workbook Appearance
    • Format Cells
    • Changing Font, Font size and Font
    Colour
    • Borders
    • Bold, Italic and Underline o Fill Colour
    • Themes
    • Format Numbers as percentage, currency and general
    • Insert a Picture
    • Picture Styles, remove background, picture effects
    • Insert Background
    4.    Printing
    • Inserting Headers and Footers
    • Print Preview
    • Page Setup
    • Page break preview
    • Print active worksheets
    • Print entire workbook
    • Print Selection
    • Print titles
    • Set Print Area
    • Centre data on page
     

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

    المتطلبات

    Basic knowledge of computer and internet

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

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

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