Porto

Smart Excel

Smart Excel

  • Duration 70 Hrs
  • 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 Fundamentals
  • Selecting Cells & Ranges
  • Formatting Cell & Worksheet
  • Conditional Formatting
  • Insert Tab In Excel 2010
  • Create Custom Tables
  • Sorting Data
  • Advance Filter
  • Creating Charts & Graphics
  • Chart Types
  • Sparkline
  • Pivot Table & Pivot Chart
  • Insert Slicer
  • Graphics & Designing In Excel
  • Working With Picture, Clipart & Shapes
  • Smart Art Objects
  • Hyperlinks
  • Printing Your Work
  • Page Layout Option
  • Analyzing Data with Excel
  • Get External Data From Various Sources
  • Data Validation
  • Performing Spreadsheet What-If-Analysis
  • Scenario Goal seek & 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, Date value, 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 Function - Dsum, Dmax, Dproduct, Dvar etc...
  • Statistical Functions - Counta, Countblank, Count if, Forecast
  • 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
  • SKILL

    CCA Educations Pvt.Ltd. Pune is very proud to be associated with Globsyn Skill Development Pvt.Ltd. Kolkata which is National Skill Development Corporation.....

  • COLLEGE

    Besides franchisees, in the year 2013 requirements came in from university colleges to provide a short term courses to their students in their own premise.....

  • FRANCHISE

    COLLEGE OF COMPUTER ACCOUNTANTS (Pune) is a major Accounts education, service and research Institute.....

  • INSTITUTE

    With the Great success of our institution, A thought of why not start up with Franchisee’s clicked us.....