Porto

Master in Excel

Master in Excel

  • Duration: 156Hrs
  • Module: 4 Mod
  • Exam: 4 Online Exam
  • Cash Job Card

A complete professional course- Microsoft Excel helps companies maximize the value of their data, helping to control costs more effectively and obtain business information. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Mastering MS Excel lets you get home on time

  • Excel makes calculations of complex formulas easy
  • Excel works great as a basic reporting tool
  • Excel is used extensively by just about everyone at work.

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,
    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,
  • 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

Advanced Functions and Formulas in Excel 2010

  • Advanced Charts
  • Advanced Pivot Tables
  • Logical Functions
  • Test Functions
  • Date & Time Functions
  • Data Validations
  • Conditional Formatting
  • Financial Functions
  • Lookup & Reference Functions
  • Mathematical Functions
  • HyperLinks,Linking & Embedding
  • Import Data
  • Trignometry Functions
  • DataBase functions
  • Statistical Functions
  • Sorting & Filtering Data
  • Tracking & Reviewing Changes
  • Scenarion,Goal Seek
  • Solver & Data Table
  • Information Function
  • Engineering Function
  • Other Functions
  • Macros
  • Practical Projects & Reports
  • MIS In Excel
  • Lookup Project

Macros & VBA Programming in Excel 2010

  • Creating A Macro
  • Running A Macro
  • Editing A Macro
  • Additing A Menu To Menu Bar
  • Additing A Commands To Menu
  • Additing Button To Toolbar
  • Data Handling,MIS,EXCEL,and Access
  • Macro Generation and Application Design
  • VBA in Excel 2010
  • VBA Programming
  • Macros & The VB Editor
  • Modifying The Recorded Code
  • Projects & Reports
  • Various Examples