Professional Excel

Mathamatical & Statical Function's

• Sum
• Product
• Average
• Ceiling
• Floor
• Round
• Round Up
• Round Down
• Power
• Count
• Counta
• Maximum
• Minimum
• Mode
• Median
• Log
• Dollar
• Averagea
• Mina
• Maxa
• Large
• Sqrt
• Mod
• Roman
• Rank
• Rank Average
• Rand
• Rand Between

Logical Function

• If
• Nested if
• SumIf
• Sumifs
• Averageif
• Averageifs
• Countif
• Countifs
• Or
• Not
• And
• Iferror
• If Function & Nested If Statements And & Or Functions
• Maxifs
• Minifs

Text Function's

• Upper
• Lower
• Left
• Right
• Exact
• Len
• Mid
• Concatenate
• Proper
• Trim
• Substitute
• Search
• Find

Date & Time Function's

• Days360
• Date
• Networkdays
• Now
• Today
• Weekday
• Effect
• Eomonth
• Edate
• Workdays
• Datedif

Lookup &Reference Function's

• Index
• Match
• Lookup
• Choose
• Offset
• Offset with Match
• Xlookup
• Transpose
• Hlookup For Single Worksheet
• Vlookup For Single Worksheet
• Hlookup & Vlookup For Multiple Sheet
• Match And Find Record By Vlookup And Hlookup
• Approximate Match With Vlookup
• Exact Match With Vlookup
• Nesting Lookup Function
• Show Formula
• Choose Function with Vlookup
• Indirect

Financial Functions

• Pmt
• Rate
• Ppmt
• Ipmt
• Fv
• Pv
• Coupdays
• Coupnum
• Ispmt
• Sln
• Cumprinc
• Cumipmt
• Ddb
• Db
• Received

Lookup &Reference Function's

• Index
• Match
• Lookup
• Choose
• Offset
• Offset with Match
• Xlookup
• Transpose
• Hlookup For Single Worksheet
• Vlookup For Single Worksheet
• Hlookup & Vlookup For Multiple Sheet
• Match And Find Record By Vlookup And Hlookup
• Approximate Match With Vlookup
• Exact Match With Vlookup
• Nesting Lookup Function
• Show Formula
• Choose Function with Vlookup
• Indirect

Database Function’s

• Daverage
• Dproduct
• Dmin
• Dmax
• Dcount
• Dsum
• Dget

Working With Charts

• Creating a Chart with the 2D or 3D
• Create Column Chart
• Create Pie Chart
• Create Pateros Charts
• Create Speed- O-Meter Chart
• Moving a Chart One to another Sheet
• Resizing a Chart
• Changing a Chart Type
• Editing Chart Text
• Modifying Chart Options
• Formatting Category & Value Axis Data
• Formatting a Data Series
• Changing a Chart’s Source Data

Formats Cell

• Cell Format.
• Data Bars, Color Scales & Icon Sets.
• Sorting basic.
• Sorting based on Customized List.
• Customized Sorting (Advanced).
• Conditional Formatting with Rules & Color Scale

Using Conditional Formatting

• Removing Conditional Formatting
• Format As table
• Create our Styles
• Conditional formatting with formulas
• Conditional formatting with Form Controls.

Data Management with Data Validation

• Data Validation and dealing with Invalid Data.
• Group and Outline Data
• Data Consolidation.
• Data text to column.
• Custom Views

DATA ANALYSIS

• Tracing Formula Precedents
• Tracing Cell Dependents
• Error Checking
• Summarizing Data by Subtotal With grouping

Adding Subtotals to a List

• Nesting Subtotals
• Adding Group & Outline Criteria to Ranges
• Using Data Validation
• Text to Column

What –If Data Analysis

• Using Goal Seek
• Using Data Table
• Creating & Displaying Scenarios

Sorting & Filtering

• Sorting Records in a List
• Using AutoFilter in a List
• Filter & Advance Filter
• Applying Advance Filters

Protecting Excel Workbook & Sheet

• Locking/Unlocking Cells in a worksheet
• Protecting a Worksheet
• Protecting a Workbook
• Creating a Shared Workbook
• Tracking Changes to a Workbook
• Accepting & Rejecting Changes to a Workbook
• Password Protecting a Workbook
• Merging Workbooks

Workgroup Collaboration

• Web Page Preview
• Converting Worksheets into Web Pages
• Inserting Hyperlinks
• Viewing & Editing Comments

Customizing Macro By Action Button

• Creating a Macro with Condition
• Running a Macro, Editing a Macro
• Adding a menu to the Menu Bar
• Adding a Commands to a Menu
• Adding Buttons to a Toolbar

Working with Pivot Table & Pivot Chart

• Creating a Pivot Table
• Rearranging a Pivot Table
• Filtering Pivot Table Data
• Creating a Pivot Chart

Reprting With Payroll Statement

• MIS Report
• Profit & Loss a/c statement
• Balance sheet
• Worker contribution statement
• Cash flow statement
• Debtor’s & Creditors statement
• Inventory statement
• BRS Statement
• Fixed Assets & fund statement
• Payroll Report
• P.F & E.S.I Report

Advance Paste Special Techniques

• Paste Formula’s,Paste Formats
• Paste Validations
• Transpose Tables
• Paste data

Special Operation

• Find record by drop down list according To condition
• Dash Board
• Working with the Web and External Data
• Inserting a Hyperlink
• Importing Data from an Access Database or Text File
• Importing Data from the Web and Other Sources
• Working with Existing Data Connections
• Speed o Meter

Print Settings

• Page Break
• Print Area
• Print Titles
• Background

Professional Excel Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.