Professional Training &
100% Projects Based Training

Be Professionals From Professionals               Only Professionals can Make u Professional

  • Part Time
  • Duration      :     1 Month
  • Class           :     1.30 Hrs Daily
  • Days            :     Mon-Fri.
  • Half Time
  • Duration      :     2 Weeks
  • Class           :     3.00 Hrs Daily
  • Days            :     Mon-Fri.
  • Full Time
  • Duration      :     1 Week
  • Class           :     4.30 Hrs Daily
  • Days            :     Mon-Fri.

Module 1

WORKING WITH LISTS

  • Sorting Records in a List
  • Using AutoFilter in a List

Module 2

WORKING WITH CHARTS

  • Creating a Chart with the 2D or 3D
  • Create Column Chart
  • Create Pie Chart
  • Create Line Chart
  • Create Cylinder chart
  • Create Cone chart
  • Create Bar Chart
  • Moving a Chart
  • Resizing a Chart
  • Changing a Chart Type
  • Editing Chart Text
  • Modifying  Chart Options
  • Formatting Category & Value Axis Data
  • Formatting  a Data Series
  • Changing a Chart’s Source Data

Module 3

WORKING WITH GRAPHICS

  • Using the Drawing Toolbar
  • Formatting  Objects
  • Inserting  WordArt
  • Inserting an Smart Art
  • Modifying an Smart Art

Module 4

WORKGROUP COLLABORATION

  •  Web Page Preview
  •  Converting Worksheets into Web  Pages
  •  Inserting  Hyperlinks
  •  Viewing & Editing Comments

Module 5

IMPORTING & EXPORTING DATA

  •  Importing External Data into Excel
  •  Importing Text Data into Excel
  •  Importing Data from  a Database
  •  Exporting Data from Excel
  •  Publishing Worksheets & Workbooks  to the Web

Module 6

FORMATTING NUMBERS

  •   Using  Conditional Formatting
  •   Removing Conditional Formatting
  •   Format As table
  •   Create our Styles

Module 7

WORKING WITH RANGES

  •   Using the HLOOKUP Function
  •   Using the VLOOKUP Function

Module 8

CUSTOMIZING EXCEL

  •   Creating a Macro
  •   Running a Macro
  •   Editing a Macro
  •   Adding a menu to the Menu Bar
  •   Adding a Commands to a Menu
  •   Adding Buttons to a Toolbar

Module 9

DATA  ANALTSIS TOOLS

  •   Tracing Formula Precedents
  •   Tracing Cell Dependents
  •   Error Checking
  •   Creating a Pivot Table
  •   Rearranging a Pivot Table
  •   Filtering Pivot Table Data
  •   Creating a Pivot Chart

Module 10

SUMMARIZING DATA

  •   Adding Subtotals to a List
  •   Nesting  Subtotals
  •   Applying Advance Filters
  •   Adding  Group & Outline Criteria to   Ranges
  •   Using Data Validation
  •   Text to Column

Module 11

WHAT –IF DATA ANALYSIS

  • Using Goal Seek
  • Using Data Table
  • Creating  & Displaying Scenarios

Module 12

WORKGROUP COLLABORATIONS

  • Locking/Unlocking Cells in a worksheet
  • Protecting a Worksheet
  • Protecting a Workbook
  • Creating a Shared Workbook
  • Tracking Changes to a Workbook
  • Accepting & Rejecting Changes to a Workbook
  • Password Protecting a Workbook
  • Merging  Workbooks

Module 13

Format of cells

  • Number
  • Alignment
  • Border
  • Fills
  • Cell Size
  • Visibility
  • Organize Sheets
  • Protection

Module 14

Formula’s

  • Sum
  • Product
  • Average
  • IF
  • Days360
  • Date
  • Ceiling
  • Floor
  • Round
  • Round up
  • Round down
  • Power
  • Count
  • CountA
  • Count If
  • Sum if
  • Maximum
  • Minimum
  • Hlookup for single worksheet
  • Vlookup for single worksheet
  • Hlookup & Vlookup for multiple Sheet
  • Index
  • Show formula
  • Dmin
  • Dmax
  • Dcount
  • Dsum
  • Dget
  • Now
  • Today
  • Weekday
  • SQRT
  • Mod
  • Upper
  • Lower
  • Left
  • Right
  • Exact
  • Len
  • Match
  • Roman
  • Proper
  • Pmt
  • Concatenate
  • IF Function & Nested IF Statements
    And & Or Functions
  • Disc
  • Log
  • AverageA
  • Dollar
  • MaxA
  • MinA
  • Count Blank
  • Large
  • Iferror
  • And
  • Coupdays
  • Not
  • Mode.SNGL
  • Median
  • FV
  • PV
  • Round down
  • Round up
  • IPMT
  • Sumifs
  • Mode
  • Dateif
  • Countifs
  • Receive
  • PPMT
  • Rate
  • Networkdays
  • Coupnum

Module 15

Custom Views

  • Add, Delete, Show

Module 16

Print Settings

  • Page Break
  • Print Area
  • Print Titles
  • Background

 

  • Part Time
  • Duration      :     1.5 Months
  • Class           :     1.30 Hrs Daily
  • Days            :     Mon-Fri.
  • Half Time
  • Duration      :     3 Weeks
  • Class           :     3.00 Hrs Daily
  • Days            :     Mon-Fri.
  • Full Time
  • Duration      :     2 Weeks
  • Class           :     4.30 Hrs Daily
  • Days            :     Mon-Fri.

Formula’s

  • Sum
  • Product
  • Average
  • IF
  • Days360
  • Date
  • Ceiling
  • Floor
  • Round
  • Round up
  • Round down
  • Power
  • Count
  • CountA
  • Count
  • Sum if
  • Maximum
  • Minimum
  • Hlookup for single worksheet
  • Vlookup for single worksheet
  • Hlookup & Vlookup for multiple Sheet
  • Index
  • Show formula
  • Or
  • Not
  • Iferror
  • Lookup
  • Rate
  • Ppmt
  • Ipmt
  • Networkdays
  • Roundup
  • Rounddown
  • Mode
  • Median
  • Received
  • Log
  • Dollar
  • AverageA
  • Averageif
  • Averageifs
  • Mina
  • Maxa
  • Sumifs
  • Large
  • Pv
  • Fv
  • Coupdays
  • Coupnum
  • Datedif
  • Daverage
  • Dproduct
  • Dmin
  • Dmax
  • Dcount
  • Dsum
  • Dget
  • Now
  • Today
  • Weekday
  • SQRT
  • Mod
  • Upper
  • Lower
  • Left
  • Right
  • Exact
  • Len
  • Match
  • Roman
  • Proper
  • Pmt
  • Concatenate
  • IF Function & Nested IF Statements And & Or Functions
  • Match and find record by VLOOKUP And HLOOKUP
  • ISPMT
  • SLN
  • Effect
  • CUMPRINC
  • CUMIPMT
  • EoMonth
  • EDATE
  • WORKDAYS
  • DDB
  • DB
  • Approximate Match with Vlookup
  • Exact match with Vlookup
  • Nesting Lookup Function
  • Choose Function
  • Rank & Rank Average
  • Rand & Rand Between
  • Mod with Conditional Formatting
  • Transpose
  • Find & mid
  • ISERR,
  • OFFSET
  • IIR
  • NPV
  • MONTH
  • HOURS
  • MINUTE
  • NETWORKDAYS.INSTL
  • Transpose with Vlookup
  • ISNUM
  • ISERROR
  • IFERROR
  • SUBSTITUTE
  • INDIRECT
  • SEARCH
  • TRIM
  • INDEX WITH SUM,COUNT,AVERAGE

Special Operation

  • Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
  • Find record by drop down list according To condition
  • Dash Board

Working with the Web and External Data

  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections

Create Statements According to Function

  • MIS Report
    • Profit & Loss a/c statement
    • Balance sheet
    • Worker contribution statement
    • Cash flow statement
    • Debtor’s & Creditors statement
    • Inventory statement
    • BRS Statement
    • Fixed Assets & fund statement
  • Payroll Report
  • P.F & E.S.I Report

WORKING WITH CHARTS

  • Creating a Chart with the 2D or 3D
  • Create Column Chart, Pie Chart
  • Create Pateros Charts
  • Create Speed- O-Meter Chart
  • Moving a Chart One to another Sheet
  • Resizing a Chart, Changing a Chart Type
  • Editing Chart Text, Modifying Chart Options
  • Formatting Category & Value Axis Data
  • Formatting a Data Series
  • Changing a Chart’s Source Data

Formats, Conditional Formatting & Sorting

  • Cell Format.
  • Data Bars, Color Scales & Icon Sets.
  • Conditional formatting with formulas
  • Conditional formatting with Form Controls.
  • Sorting basic.
  • Sorting based on Customized List.
  • Customized Sorting (Advanced).

FORMATTING NUMBERS

  • Using Conditional Formatting
  • Removing Conditional Formatting
  • Format As table
  • Create our Styles

Data Management

  • Data Validation and dealing with Invalid Data.
  • Group and Outline Data
  • Data
  • Data Consolidation.
  • Data text to column.
  • Custom Views

DATA ANALYSIS TOOLS

  • Tracing Formula Precedents
  • Tracing Cell Dependents
  • Error Checking
  • Creating a Pivot Table
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Creating a Pivot Chart

SUMMARIZING DATA

  • Adding Subtotals to a List
  • Nesting Subtotals
  • Applying Advance Filters
  • Adding Group & Outline Criteria to Ranges
  • Using Data Validation
  • Text to Column

WHAT –IF DATA ANALYSIS

  • Using Goal Seek
  • Using Data Table
  • Creating & Displaying Scenarios

WORKING WITH LISTS

  • Sorting Records in a List
  • Using AutoFilter in a List
  • Filter & Advance Filter

WORKGROUP COLLABORATIONS

  • Locking/Unlocking Cells in a worksheet
  • Protecting a Worksheet
  • Protecting a Workbook
  • Creating a Shared Workbook
  • Tracking Changes to a Workbook
  • Accepting & Rejecting Changes to a Workbook
  • Password Protecting a Workbook
  • Merging Workbooks

WORKGROUP COLLABORATION

  • Web Page Preview
  • Converting Worksheets into Web Pages
  • Inserting Hyperlinks
  • Viewing & Editing Comments

CUSTOMIZING EXCEL

  • Creating a Macro with Condition
  • Running a Macro, Editing a Macro
  • Adding a menu to the Menu Bar
  • Adding a Commands to a Menu
  • Adding Buttons to a Toolbar

Print Settings

  • Page Break
  • Print Area
  • Print Titles
  • Background

 

Professional Excel Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.

 

Copyright © Computec Professionals Group