Free Drupal Themes by Unlimited Hosting and Free Joomla Templates

Advance Excle

  • Introduction Ms Excel 2010
  • Working With Formulas And Function Library
  • Advanced Charts
  • Creating A Macro
  • Working With Ribbon & Quick Access Toolbar
  • Text Functions Search, Mid,Exact, Substitute,Replace
    Find, Proper, Fixed, Trim, Clean, Text
  • Logical Functions
  • Editing A Macro
  • Selecting Cells And Ranges
  • Date And Time Functions Date,Today, Weekday,
    Date Value,Time, Hour, Now, Days 360,
    Edate, Emonth, Networkdays.etc.
  • Date & Time Functions
  • Adding A Commands To A Menu
  • Conditional Formatting
  • Lookup & Reference Function Match,

    Vlookup,
    Hlookup, Lookup, Inder, Offset
  • Conditional Formatting
  • Data Handling, Mis, Excel And Access
  • Create Custom Tables
  • Trigonmetry Functions Degree,

    radians, Cos, Sin, Tan Etc....
  • Lookup & Reference Functions
  • Vba In Excel 2010
  • Advance Filter
  • Statistical Functions Counta,

    Countblank, Count If, Forecast.
  • Hyperlinks, linking & Embedding
  • Macros & The Vb Editor
  • Chart Type
  • Enginnering Function Convert,

    Delta Gestep,Imreal, Dec2hex Functions
  • Trignometry Functions
  • Projects & Reports
  • Pivot Table And Pivot Chart
  • Insert Slicer
  • Statistical Functions
  • Hyperlinks
  • Tracking And Reviewing Changes
  • Printing Your Work
  • Page Layout Option
  • Solver
  • Engineering Function
  • Macro
  • Developer Tab
  • Information Functions
  • Scenario, Goalseek, Data Table
  • Other Functions



  • Click to Enquiry

  • Starting Ms-excel2010 Application
  • Logical Functions And, If, Or, Not, True
    & False Functions
  • Advanced Pivot Tables
  • Running A Macro
  • Worksheet Fundamentals
  • Concatenate & Functions.
  • Text Functions
  • Adding A Menu To The Menu Bar
  • Formatting Cell And Worksheet
  • Financial Functions Fv,

    Pmt, Pv, Rate, Nper, Sin, Db, Syd....etc...
  • Data Validations
  • Adding Buttons To A Toolbar
  • Insert Tab in Excel 2010
  • Mathematical Functions Sign,

    God, Lom, Product,
    Sumproduct, Sumif,

    Ceiling, Fact, Mmult, Combin Etc....
  • Financial Functions
  • Macro Generation And Application Design
  • Sorting Data
  • Database Function Dsum,

    Dmax, Dproduct, Dvar Etc...
  • Mathematical Functions
  • Vba Programming
  • Creating Charts And Graphics
  • Frequency, Information Function

    Is Blank. Is Logical, Info, Cell Ls Ref Etc.
  • Import Data
  • Modyfying The Recorded Code
  • Sparkline
  • Using Names To Work With Ranges Auditing
  • Database Functions
  • Various Examples
  • Graphics & Designing In Excel
  • Working With Pictures,
    Clipart & Shapes
  • Sorting & Filtering Data
  • Smart Art Objects
  • Scenario, Goal Seek
  • Analysing Data With Excel
  • Get external Data From Various Sourses
  • Solver & Data Table
  • Data Validation
  • Performing Spreadsheet

    What - If analysis
  • Macros
  • Practical Project & Reports
  • MIS In Excel
  • Lookup Project