Advance Excel

by Anil Computers Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Anil Computers Logo

img Duration

1 Month

Course Details

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
  • Udaipur Branch

    6, Prem Kutir, Univestiy Road, Udaipur

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy