Advance Excel

Advance Excel

Advance Excel

 

 

 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


Duration: 1 Months
Reviewed by 150+ Students
(12 Reviews)
Admission Query