ONLINE ADVANCE EXCEL TRAINING COURSE
Apply For Course
DURATION : 15 DAYS
FACULTY : MS. VIJAYALAKSHMI
Microsoft Excel
- Introduction to Excel Sheets
- Functional Formula
- Create Macros, Validation
- Create Payrolls, Tables
- Create Accounts Using Formula
- Graphs , Charts
Advanced Excel
- Lookup, H look up
- Sum if, Count if functions
- Index and Match Functions
- Pivot Tables Charts
- Filters Adv Filters
- PasteLinks,Paste Special
- Import Tables Excel To Word
- Custom List, Data Functions
- Logical Functions Name define
- Data Functions,text Functions
- Conditional Formatting
- Sub total Functions
- Goal seek,print Functions
- Protect book & Sheet
- Scenarios, number series
- Sheet Breaks,formula auditing
- Hide And Unhide Sheets,Objects
- Columns and Rows,print titles
- Smart Art,watch windows