Porto

Smart Excel

Smart Excel

  • Duration 70Hrs
  • Module 2 Modules
  • Exam 2 Online Exam
  • Certificate

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows, Mac OS, and iOS. It is an invaluable tool for portfolio managers, traders and accountants.

Complete Microsoft Excel 2010

  • Introduction MS excel 2010
  • starting MS excel 2010 Application
  • Working With Ribbon & Quick Access Toolbar
  • Worksheet Fundamental
  • Selecting Sales & Ranges
  • Formatting Cell & worksheet
  • Conditional Formatting
  • Insert Tab In Excel 2010
  • Craete Custom Tables
  • Sorting Data
  • Advance Filter
  • Creating Charts & Graphics
  • Chart Type
  • Sparkline
  • Pivot Table & Pivot Chart
  • Insert Slicer
  • Graphics & Designing In Excel
  • Working With Picture,Clipchart & Shapes
  • Smart Art Object
  • Hyperlinks
  • Printing Your Work
  • Page Layout Option
  • Anayizing Data With Excel
  • Get External Data From Various Sources
  • Data Validation
  • Performing Spreadsheet What if Analusis
  • Scenario Goalseek, Data Table
  • Solver
  • Macro
  • Developer Tab

Basic Functions and Formulas in Excel 2010

  • Working With Formulas and Functions Function Library
  • Logical Functions- AND,IF,OR,NOT,TRUE & FALSE Functions
  • Text Functions - Search,Mid,Exact,Substitute,Replace,Find,Proper
    Fixed,Trim,Clean,Text
  • Concatenate & T Functions
  • Date & Time Functions - Date,Today,Weekday,Datevalue,Time,Hour,Now
    Days360,Edate,Eomonth,Networkdays..etc
  • Financial Functions -Fv,Pmt,Pv,Rate,Nper,Sln,Db,Syd...etc
  • LOOKUP & Reference Function- Match,Vlookup,Hlookup,Lookup,Index,Offset
  • Mathematical Functions -Sign,God,Lcm,Product,SumProduct,Sumif,Ceiling,
    Fact,Mmult,Combin...etc
  • Trigonometry Functions - Degrees,Radians,Cos,Sin,Tan etc...
  • Database Functions -Dsum,Dmax,Dproduct,Dvar etc...
  • Statistical Functions -Counta,Countblank,Count if,Foreast
  • Frequency, Information Functions -Is Blank,Is Logical,Info,Cell,Is Ref etc...
  • Engineering Function -Convert,Delta,Gestep,Imreal,Dec2hex functions etc...
  • Using Names to Work with Ranges Auditing