X

Excel Formulas & Functions - Find Answers in Your Excel Data (Updated)

English Tutorials and Courses

 
  • Filter
  • Time
  • Show
Clear All
new posts

    Excel Formulas & Functions - Find Answers in Your Excel Data (Updated)

    Duration: 1.5 hour | Size: 367 MB



    Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016

    What you'll learn

    Identify formulas and functions and know the difference between the two.
    Locate and use any of the functions in Excel using various methods, such as the Formula Tab.
    Use the 7 most important Excel functions in common spreadsheet computations.
    Understand the important difference between Absolute and Relative cell references to increase your computing power.
    Identify the various parts of an Excel formula so you can create or modify formulas to fit your needs.
    Use the SUM function in Excel
    Use AVERAGE and AVERAGEA functions in Excel
    Use COUNT and COUNTA functions in Excel
    Use IF functions in Excel
    Use SUMIF and SUMIFS functions in Excel
    Use COUNTIF and COUNTIFS functions in Excel
    Use VLOOKUP in Excel
    Use LEFT, RIGHT and MID functions in Excel

    What's included in the course?

    What is a formula? What is a function?

    The anatomy of a formula and how to create one.

    How to use the SUM function.

    How to use the AVERAGE and AVERAGEA functions.

    How to use the COUNT and COUNTA functions.

    How to use the IF function.

    How to use the SUMIF and SUMIFS functions.

    How to use the COUNT and COUNTIFS functions.

    How to use the popular VLOOKUP function.

    How to use RIGHT, LEFT and MID to sort data easily.

    A complete demonstration of how to use each function and what to use if for.

    *

    #2
    تحياتي من القدس الشريف

    بارك الله فيكم وزادكم من علمه
    Comment

      #3
      Originally posted by raedms
      شكرا لك أخي الكريم
      جزاك الله خيرا واحسن اليك
      Comment

        #4
        Originally posted by فلسطيني حتى النخاع View Post
        تحياتي من القدس الشريف

        بارك الله فيكم وزادكم من علمه
        جزاك الله خيرا واحسن اليك
        Comment

          #5
          Originally posted by faristorrent
          جزاك الله كل خير
          شكرا لك يأ خي و جزاك لله خيرا
          Comment

            #6
            وافر الشكر والتقدير
            Comment

              #7
              Originally posted by alawadly View Post
              وافر الشكر والتقدير
              شكرا لك يأ خي و جزاك لله خيرا
              Comment

                #8
                Originally posted by كمال بدر
                جزاكَ الله خيراً أخي الكريم عن هذا الطرح القيم والنافع والمفيد ... تقبل تحياتي.



                شكرا لك يأ خي و جزاك لله خيرا
                Comment
                Working...
                X