goodrich-topline-image

Courses We Offered

Syllabus for EXCEL


Excel Basic Level : Duration 5 hours,

About Excel Window
  • Introduction to Excel, Explanation about Interface Elements, basic spreadsheet concepts
  • Differences between cell, row, column, sheet and workbook
  • various selection techniques
Data Entry
  • Data entry with different formats (Data Entry Techniques).
  • Creating and Working with Auto Lists
  • Different ways of copying and moving data
  • Different methods of Inserting, Deleting, Moving and Copying Sheets
  • Various navigation techniques
Customizing UI
  • Customizing the Ribbon, Quick Access Toolbar
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Creating a Custom Number Format
Working with Large Data Base
  • Creating a Template
  • Arranging Windows
  • Selecting and Switching Between Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hiding Rows, Columns, Worksheets, and Windows
  • Working with Multiple Workbook Windows
Working with Formulae
  • Creating Formulae, Editing Formulae
  • Copying Formulae
  • Sum, Average, Max, Min, Count, Counta
  • Applying Absolute (Fixed) Referencing
Cell Referencing Techniques in Formulae
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
Formatting and Proofing
  • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  • Basic conditional formatting
  • Copying and Clearing Formats
  • Working with Styles
  • Spell Check, Find & Replace

EXCEL INTERMEDIATE LEVEL : Duration 5 hours


Defining Names to Ranges
  • Concept and Purpose of defining names
  • Naming individual or range cells
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae
Logical, Conditional, Date & Some Other Formulae
  • If Statements , Nested If
  • And, Or, Not
  • Combining If, And, Or, Not
  • Sumif , Countif
  • Conditional Formatting
  • Entering Dates and Times and auto update
  • Different date/time formats
  • How dates are stored
  • Calculating Number of days between dates
Formulae Auditing
  • Formula Auditing Tools
  • Revealing Formulae
  • Tracing Precedents/Dependents
  • Goto Special
Worksheet Management & Linking
  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Viewing different sheets at once
  • Data consolidation
Data Management
  • Sorting Data
  • Adding Subtotals
  • Autofilter
  • Freeze Panes
  • Group and Outline
  • Data Form
Excel Charts
  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type
Working with Dash Boards
  • Creating a Dash Board
  • Dash Board Do’s and Don’ts

ADVANCE EXCEL:  Duration 5 hours

Lookup & Information Functions
  • Vertical Lookup (VLOOKUP)
  • Horizontal Lookup (HLOOKUP)
  • Match and Index
  • IsText, IsNumber, IsDate , IsNull , IsErr, IsError, IsNa
Advanced List Management
  • Advanced Filters
  • Using List Features
  • Dynamic Lists
Pivot Tables
  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart
What If Analysis
  • Scenarios
  • Goal Seek
  • Solver
Protecting & Sharing Files
  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

EXCEL VBA PROGRAMMING :  25 hours

Creating & Record Macros
  • Recording, Running a Macro
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic
VB Editor Overview
  • Objects
  • Methods
  • Properties
  • Programming Tools
Working with Constants
  • Excel Constants
  • Variable Constants
Excel Objects
  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects
Visual Basic Functions
  • InputBox Function
  • MsgBox Function
  • Using a Set Statement
Building Formulae Control Structures
  • Control Statements & Loops
  • Logical Operators
  • Branching Statement
  • Comparison Operators with Select Case Structure
Running Program
  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application
The Properties Window
  • Changing a Property
Variables
  • Dimensioning a variable
  • Scope and life of a Variable
  • Using variables in routines
  • Object Variables
User Forms
  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • User form Properties Methods & Events
Advanced VBA Programming
  • Developing Excel Utilities with VBA
  • Exception Handling
  • Using In-Built Excel Features in VBA
  • Working with Pivot Tables
  • Working with Charts
  • Understanding Excel's Events
  • Interacting with Other Applications
  • Creating and Using Add-Ins
Event Handling
  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling
DAO / ADO Objects
  • Connect to MS Access , SQL Server
  • Access Database & Retrieve Data from MS Access
  • Create Table & Query Data Filter DB using Query
  • Update and Modify DB
  • Create Single and Multiple Mapping Tables
  • Filter DB using Query
  • Query data grouping
  • Retrieve Data using Logical Access Query
  • Connect Excel to Outlook
    • Connect to Outlook using VBA
    • Query to retrieve Mail From, to and CC address
    • Retrieve Mail Subject and Time
    • Retrieve Mail Attachment
    Live Project

    We Offered

    • Workshops
    • Live Projects
    • Digital Marketing
    • Online Training
    • Application Development
    • Website Development
    • Placement Assistance
    • Off-Campus Seminars

    Recent News

    • Demo on every Saturday @ 10am

    Get in Touch

    Goodrich IT Solutions,
    2nd Floor, Maruthi Complex,
    Opp. R.S. Brothers, KPHB,
    Hyderabad - 500 072

    Mobile No. :+91 9885811057
    Land Line: +91 4065889933
    Email:sathesh@goodrichitsolutions.com