Back
  •      Time
  • Duration      :     2 Month
  • Class           :     1 Hrs Daily
  • Days            :     Mon-Sat

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
error: Content is protected !!