Scribd Logo
Upload

Welcome to Scribd!

  • 120 views

    Advanced Excel Sheet

    Uploaded by

    krackku k
    The document provides an overview of an advance Excel course, outlining 13 topics that will be covered: 1) The 10 most important Excel functions 2) Important shortcut keys 3) Mathematical expressions 4) The If function and pivot tables 5) Text and number cells, conditional formatting, and solving errors 6) The Solver function, developer tools, and visual basic 7) Importing data from Google and writing visual basic codes

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Advanced Excel Sheet

    Uploaded by

    krackku k
    120 views25 pages
    The document provides an overview of an advance Excel course, outlining 13 topics that will be covered: 1) The 10 most important Excel functions 2) Important shortcut keys 3) Mathematical expressions 4) The If function and pivot tables 5) Text and number cells, conditional formatting, and solving errors 6) The Solver function, developer tools, and visual basic 7) Importing data from Google and writing visual basic codes

    Original Title

    Advanced Excel sheet

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides an overview of an advance Excel course, outlining 13 topics that will be covered: 1) The 10 most important Excel functions 2) Important shortcut keys 3) Mathematical expressions 4) The If function and pivot tables 5) Text and number cells, conditional formatting, and solving errors 6) The Solver function, developer tools, and visual basic 7) Importing data from Google and writing visual basic codes

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    120 views25 pages

    Advanced Excel Sheet

    Uploaded by

    krackku k
    The document provides an overview of an advance Excel course, outlining 13 topics that will be covered: 1) The 10 most important Excel functions 2) Important shortcut keys 3) Mathematical expressions 4) The If function and pivot tables 5) Text and number cells, conditional formatting, and solving errors 6) The Solver function, developer tools, and visual basic 7) Importing data from Google and writing visual basic codes

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 25

    Advance Excel

    By :
    Mohammed Dwairi
    Course objectives
    1) Excel Meaning
    2) The most 10 important functions in excel
    3) Most important shortcut keys in excel
    4) Mathematical expressions in Excel
    5) If function
    6) Pivot table
    7) Text and number cell
    8) Conditional formatting in excel
    9) Solver meaning and used
    10) Errors in excel and how to solve them
    11) Developer function in excel
    12) Visual basic in deplorer and how to add
    data
    13) How to add data from google to excel
    Excel meaning

    is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present
    tables of values arranged in rows and columns that can be manipulated mathematically using both basic
    and complex arithmetic operations and functions.
    There is more than 700 functions in the excel and can be divided in to
    A- logical excel function
    B- statistical excel function
    C- lockup excel function
    D- text excel function
    E- data and time excel function
    The most 10 important functions in excel
    Sum
    Drop down list
    Sum if
    Average
    If
    Count if
    Lookup
    Match
    Concatenate
    IMAG LOOKUP
    EXAMPLE FOR THE 10
    IMPORTANT FUNCTION IN
    EXCEL
    Most important shortcut keys in excel

    Shortcut
    Ctrl+C means copykey means Shortcut key means

    Ctrl+D means fill down 


    Ctrl + A Select all Ctrl+ O open
    Ctrl+F fin 
    Ctrl+
     B bold Ctrl+ P print

    Ctrl+ D Copy Ctrl+V paste

    Ctrl+ F Find Ctrl+ W Close

    Ctrl+ G Go to Ctrl+ X Cut


    Ctrl+ H Replace Ctrl + shift+ ; Current time
    Mathematical expressions in Excel

    (+ ) this for adding A <> B A is not equal B

    (-) this for subtraction (/) this is for division

    (=) this for equal (%) for percentage

    A>= B this means that A is bigger or equal A )^( Integer Exponents

    A<= B this means that is less than B A> B means A is bigger than B
    If function
    The if function is one of the most important function in excel , because it allows to make logical
    comparisons between any valve and what you expect, the if can be divided into tow types
    A- single if
    B- multiple if
    TEXT AND NUMBER CELL
    Text Cell can be known in excel by the function
    =iStext() if it was text it will show True, if not shows false 

    =Isnumber( ) if it was number it will show True, if not shows false 

    Numbers such as: 12, 4^5, 0.55, 99


    Text : any text


    Pivot table
    What is using of pivot table
    A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends
    based on your information. Pivot tables are particularly useful if you have long rows or columns that hold
    values you need to track the sums of and easily compare to one another
    Conditional formatting in excel
    Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific
    formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight,
    emphasize, or differentiate among data and information stored in a spreadsheet
    Major Errors in excel
    Solver function in Excel
    Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal
    (maximum or minimum) value for a formula in one cell — called the objective cell — subject to
    constraints, or limits, on the values of other formula cells on a worksheet.
    What is the uses of solver
    the process of finding the correct input value when only the output is known
    How to bring data from google
    it can be by copy / paste

    Or by data , then data , then from web and write the link in the box
    As this box
    Developer in excel
    is a feature included in Microsoft Excel, and it is usually hidden by default. The tab allows users to create
    VBA applications, design forms, create macros, import and export XML data, etc
    How to get the developer in excel
    Different between the form control
    and the active X control
    Form control
    A- original tools
    B- works with all Microsoft excel versions
    C- cant work without the VBC codes
    D- there is not modify on the shape of the
    control

    active X controls
    A- adding codes on the VBC
    B- the setting can be modified
    C- don’t work with the Microsoft office
    MAC
    Marco in advance excel
    A macro is an action or a set of actions that you can run as many times as you
    want. You can create and then run a macro that quickly applies these formatting
    changes to the cells you select.
    Marco advantage:
    Macros hold the details of an operation in a module that can be used "as if" it were
    a single instruction.
    A frequently used sequence of instructions can be defined as a macro. ...
    Macros are used to build up complex operations out of simpler operations.
    Libraries of useful macros can be created.
    Visual Basic For Application
    What is VBA ?
    is an event-driven programming language implemented by Microsoft to develop Office
    applications. VBA helps to develop automation processes, Windows API, and user-defined
    functions. It also enables you to manipulate the user interface features of the host applications.
    Why VBA?
    VBA enables you to use English like statements to write instructions for creating various
    applications. VBA is easy to learn, and it has easy to use User Interface in which you just have to
    drag and drop the interface controls. It also allows you to enhance Excel functionality by making
    it behave the way you want.
    How to write codes in excel
    Items can be procedure into 2 ways
    A- sub- routine
    Like Sub Name( )
    End sub
    Example:
    Sub hi ( )
    Msgbox (“hi”)
    End sub
    B- function
    Function name ( )
    End Function
    The visual basic is depend on

    Object. property= valve


    Collection ( ). Property
    Object. Methods

    You might also like