Advance Excel

Advance Excel course is offered by Anil Computers. Anil Computers is a premier education institute. Anil Computers is a pioneer in providing career-orientated courses to aspiring professionals since 1997. For more than 20 years Anil Computers has provided training programs to more than 15,000 Students.

Outline:

• Basic Excel
• - Introduction of MS Excel
• - Auto Fill
• - Insert row and column
• - Change row height and column
• - Delete row and column
• - Hide and unhide row column
• - Merge and center
• - Wrap text
• - Sheet option
• - Arrange window
• - Use cut copy paste
• - How to use format painter
• - Excel font: changing font, font style, bold, Italic, underline
• - Text alignment
• - How to use undo and redo option
• - Custom short part 1
• - Spelling and grammar
• - Protect cell
• - Protect sheet
• - Comment
• - Advanced printing method
• - How to insert watermark
• - Hyperlink
• - Remove page break
• - Grouping column
• - Bullet mark
• - Header and footer
• - Chart part 1
• - Chat part 2
• - Password protection
• - Advance page setup
• - Lock cell
• -Text rotation
• - Number block
• - Auto sum
• - Product
• - Blank formula
• - Change case
• - Freeze panes
• - Quick access
• - Change currency
• - Average formula
• - Fact formula
• - And formula
• - Or formula
• - Round
• - Sqrt
• - Count
• - Today
• - Now
• - Mod
• - Min and max
• - Discount
• - Even or odd
• - Percentage
• - Mini toolbar
• - Select blank cell
• - Find and replace
• - How to create border
• - Convert excel file to PDF
• Advance Excel
• - Absolute cell reference
• - Char function 
• - Clear function 
• - Code function 
• - Dollar function 
• - Left and right function 
• - Right function 
• - Mid function 
• - Replace function 
• - Repeat function 
• - Search function 
• - Trim function 
• - Abs function 
• - Int function 
• - Roman function 
• - Round, roundup or round down function
• - PMT function 
• - Rate function 
• - NPER function 
• - Future value function 
• - Due and advance amount 
• - Scenario manager 
• - Data table 
• - Remove if zero 
• -  Pivot table 
• - Subtotal 
• - Attendance sheet 
• - Insert a new tab 
• - Paste special 
• - Age calculates 
• - Concatenate 
• - Spark line 
• - Text to column 
• - Format is table 
• - Fill blank cell in excel 
• - Count if 
• - VLOOKUP 
• - Hlookup 
• - Pass or fail formula 
• - Goal seek
• - Excel error 
• - Find formula 
• - Rand and rand between 
• - Substitute 
• - Mix cell reference 
• - Marksheet 
• - Nested if 
• - Cube root 
• - Exact 
• - Istext and isnontext 
• - Comma style
• - Sumif formula
•  
• Industrial Excel 
• - MIS report 
• - Indirect function 
• - Index with match 
• - Sum product 
• - Array 
• - Create new templates 
• - Forecast formula 
• - Simple interest 
• - Pivot chart 
• - Index function 
• - Data validation 
• - Dget formula 
• - E date 
• - Lookup formula 
• - Small formula 
• - Consolidate multiple sheet 
• - How to use even or odd with if formula 
• - Is even or odd formula 
• - Macros 
• - Db formula (depreciation) 
• - Frequency formula 
• - Large formula 
• - Formula auditing 
• - GCD formula 
• - Lcm formula 
• - Calculation option 
• - Conditional formatting 
• - Condition formatting part 2
• - Conditional formatting part 3
• - Dmax and Dmin 
• - Average if  
• - Daverage 
• - Dcount 
• - Floor and ceiling
• - If error 
• - How to convert number to word 
• - How to split name or surname 
• - Full screen 
• - Best tricks in excel from subtotal 
• - Excel master tricks 
• - Excel magic tricks 
• - Important setting part 1 
• - Important setting part 2 
• - Important setting part 3 
• - How to create bill format 
• - Create salary slip