ADVANCE EXCEL AND VBA

  1. Advance Excel and VBA Syllabus

      Advanced Worksheet Functions

    • Names
      1. Defining Names
      2. Creating Names Automatically
      3. Managing Names
    • Using Names
      1. Go To
      2. Names In Formulae
      3. Applying Names
    • Conditional & Logical Functions

      1. If Statements
      2. Logical Test
      3. Value If True/False
      4. Nested If
      5. Statistical If Statements
    • AND,OR,NOT
      1. And
      2. Or
      3. Not
    • Lookup Functions
      1. Lookup
      2. Vector Lookup
      3. Hlookup
      4. Vlookup
      5. Nested Lookups
    • Other Useful Functions
      1. ISERROR
      2. IFERROR
      3. COUNTIF
      4. AVERAGEIF
      5. AVERAGEIFS
      6. SUMIFS
      7. COUNTIFS
    • Data Consolidation
    • Views, Scenarios, Goalseek And Solver

    • Goal Seeking And Solving
      1. Goal Seek
      2. Solver
      3. Solver Parameters
      4. Constraints
      5. Solver and Scenario Manager
      6. Opening Scenario Manager
      7. Saving Solver Solutions
      8. Reports
    • Views & Scenarios
      1. Custom Views
      2. Typical Custom View Model
      3. Defining A View
      4. Showing A View
      5. Scenario Manager
      6. Load The Scenario Manager
      7. Showing A Scenario
      8. Editing A Scenario
      9. Deleting A Scenario
    • Using Excel To Manage Lists

    • Excel Lists And List Terminology
      1. Row And Column Content
      2. Column Labels
      3. List Size And Location
      4. Miscellaneous
    • Sorting data
      1. Custom Sorting Options
      2. Creating A Custom Sort Order
    • Adding subtotals to a list
      1. Examining Subtotals
    • Filtering A List
      1. Custom Criteria
      2. Wildcards
      3. Turning Off Auto filter
      4. Advanced Filtering
      5. Set Criteria
      6. Entering Search Criteria
      7. Wildcards With Text Criteria
      8. Multiple Criteria
      9. Checking The Criteria Range
      10. Calculated Criteria
      11. Calculated Criteria Using Functions
      12. Copying Filtered Data
      13. Unique Records
    • List Statistics
      1. Database Functions
    • Pivot Tables
      1. To Create A PivotChart Report From An Existing PivotTable Report
      2. Create A Static Chart From The Data In A Pivot Table Report
      3. Delete A PivotTable Or PivotChart Report
      4. Create Layout For PivotTables
      5. Modifying A PivotTable
    • Managing Pivot Tables
      1. Using Another PivotTable Report
      2. Changing An Existing Report's Source Data
      3. Automatically Refresh Data When A Workbook Is Opened
      4. Automatically Refresh Data At Regular Time Intervals
      5. Require A Password To Refresh An External Data Range
      6. Grouping PivotTable Items
      7. Formatting A PivotTable
    • Charts

    • Introduction To Charting
      1. Terminology
      2. Embedded Charts
      3. Separate Chart Pages
      4. Three Methods To Create Charts Moving And Resizing Embedded Charts
      5. Data Layout
      6. Chart Types
      7. Shortcut Menu (Right Click)
      8. Default Chart Type
    • Formatting Charts
      1. Design Ribbon
      2. Switch Rows And Columns
      3. Changing The Chart Layout
      4. Chart Styles
      5. Moving Chart Location
      6. Layout Ribbon
      7. Formatting Chart Elements
      8. Resetting Custom Formats Adding Removing And Formatting Labels
      9. Axes
      10. Gridlines
      11. Unattached Text
      12. Format Dialog
      13. Add A Series Manually
      14. The Series Function
      15. Charting With Blocks Of Data
    • Templates

    • Introduction To Templates
      1. Standard Templates
      2. Custom Templates
      3. AutoTemplates
      4. Opening And Editing Templates
      5. Template Properties
    • Auditing

    • Auditing Features
      1. Tracers
      2. Comments
    • Other Formatting

    • Formatting cells
      1. Themes
      2. Customizing A Theme
      3. Styles
      4. Conditional Formatting
    • Other Excel Features

    • Inserting, Formatting And Deleting Objects
      1. Inserting A Drawing Object
      2. Smart Art
      3. WordArt
      4. Formatting Shapes
      5. Quick Styles
      6. Manual Formatting
    • Reviewing
      1. Protecting
      2. Use A Shared Workbook To Collaborate
      3. Share A Workbook
    • Proofing Tools
      1. Spelling And Grammar
      2. Thesaurus
      3. Translation
      4. Show Or Hide Screen Tips
    • VBA

    • Introducing VBA
      1. What Is VBA?
      2. Introduction to Macro Recordings, IDÉ
    • How VBA Works with Excel
      1. Working In the Visual Basic Editor
      2. Introducing the Excel Object Model
      3. VBA Sub and Function Procedures
      4. Using the Excel Macro Recorder
    • Programming Concepts
      1. Essential VBA Language Elements
      2. Working with Range Objects
      3. Using VBA and Worksheet Functions
      4. Controlling Program Flow and Making Decisions
      5. Automatic Procedures and Events
      6. Error-Handling Techniques
      7. Bug Extermination Techniques
      8. VBA Programming Examples
    • Communicating with Your Users
      1. Simple Dialog Boxes
      2. UserForm Basics
      3. Using UserForm Controls
      4. UserForm Techniques and Tricks
      5. Accessing Your Macros through the User Interface
    • Putting It All Together
      1. Creating Worksheet Functions and Living to Tell about It
      2. Creating Excel Add-Ins
    • The Part of Tens
      1. Ten VBA Questions (And Answers)
      2. (Almost) Ten Excel Resources.

Benefits of Adexecl

      1. students will be getting government authorized certificate and will be valid worldwide
      2. Sharp Mind Info Train provides excellent coaching for the students who are looking to build high career goals.

      3. Sharp Mind not only provides professional teachers but also the necessary material required for the students and takes them to the next level of knowledge.

      4. The institute helps to gain fresh perspectives on your personal challenges and opportunities.

      5. In the era of cut-throat competition, there is huge competition in all the fields. Our institute makes the way for you easy by teaching all the new technologies to be a good competitor and ease your way to reach your goals.

      6. We provide competitive environment to you to make you more and more stable technically with all the best skills.

      7. We have company environment.

      8. All the courses available here are cost effective. The institute also provides 100% career assistance.

  • <