Porto

Master in Excel

Master in Excel

  • Duration: 156 Hrs
  • 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 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

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
  • Trigonometry Functions
  • Database functions
  • Statistical Functions
  • Sorting & Filtering Data
  • Tracking & Reviewing Changes
  • Scenario & 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
  • Adding a Menu to the Menu Bar
  • Adding a Commands to a Menu
  • Adding Button to a 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
  • 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.....