Advance Excle

Course Contents

• 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

• 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