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

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


    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.....


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


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