Loading...
Loading...
    My Cart 0

    Advanced Excel

    Course Content

    Total learning: 50 lessons Time: 40 hours

    • Overview of MS Excel  0/4

      • Lecture1.1
        MS-Excel Fundamentals
      • Lecture1.2
        Customizing common options in Excel
      • Lecture1.3
        Absolute and relative cells
      • Lecture1.4
        Protecting and un-protecting worksheets and cells

    • Working with Functions  0/5

      • Lecture2.1
        Writing conditional expressions (using IF)
      • Lecture2.2
        Using logical functions (AND, OR, NOT)
      • Lecture2.3
        Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
      • Lecture2.4
        VlookUP with Exact Match
      • Lecture2.5
        VlookUP with Tables, Dynamic Ranges

    • Data Validations  0/3

      • Lecture3.1
        Specifying a valid range of values for a cell
      • Lecture3.2
        Specifying a list of valid values for a cell
      • Lecture3.3
        Specifying custom validations based on formula for a cell

    • Working with Templates  0/2

      • Lecture4.1
        Designing the structure of a template
      • Lecture4.2
        Using templates for standardization of worksheets

    • Sorting and Filtering Data  0/5

      • Lecture5.1
        Sorting tables
      • Lecture5.2
        Using multiple-level sorting
      • Lecture5.3
        Using custom sorting
      • Lecture5.4
        Filtering data for selected view (AutoFilter)
      • Lecture5.5
        Using advanced filter options

    • Working with Reports  0/9

      • Lecture6.1
        Creating subtotals
      • Lecture6.2
        Multiple-level subtotals
      • Lecture6.3
        Creating Pivot tables
      • Lecture6.4
        Formatting and customizing Pivot tables
      • Lecture6.5
        Using advanced options of Pivot tables
      • Lecture6.6
        Pivot charts
      • Lecture6.7
        Consolidating data from multiple sheets and files using Pivot tables
      • Lecture6.8
        Viewing Subtotal under Pivot
      • Lecture6.9
        Creating Slicers

    • More Functions  0/4

      • Lecture7.1
        Date and time functions
      • Lecture7.2
        Text functions
      • Lecture7.3
        Database functions
      • Lecture7.4
        Power Functions (CountIf, CountIFS, SumIF, SumIfS)

    • Formatting  0/2

      • Lecture8.1
        Using auto formatting option for worksheets
      • Lecture8.2
        Using conditional formatting option for rows, columns and cells

    • Macros  0/2

      • Lecture9.1
        Relative & Absolute Macros
      • Lecture9.2
        Editing Macro’s

    • WhatIf Analysis  0/4

      • Lecture10.1
        Goal Seek
      • Lecture10.2
        Data Tables
      • Lecture10.3
        Scenario Manager
      • Lecture10.4

    • Charts  0/5

      • Lecture11.1
        Using Charts
      • Lecture11.2
        Formatting Charts
      • Lecture11.3
        Using 3D Graphs
      • Lecture11.4
        Using Bar and Line Chart together
      • Lecture11.5
        Sharing Charts with PowerPoint / MS Word, Dynamically

    • New Features Of Excel  0/2

      • Lecture12.1
        Sparklines, Inline Charts, data Charts
      • Lecture12.2
        Overview of all the new features

    • MIS  0/2

      • Lecture13.1
        What is MIS ?
      • Lecture13.2
        Learn to use excel for the application of analytics in MIS

    • More Applications  0/1

      • Lecture14.1
        Creating Balance Sheet, GST Sheets, Medical Tables, etc.
    This content is protected, please login and enroll course to view this content!

    Leave a Reply