MS-OFFICE-Adv. EXCEL
February 17, 2022 2022-12-23 18:39MS-OFFICE-Adv. EXCEL
- Introduction to Excel Sheets
- Basic Excel (Home,insert,Layout,view,Review menu )
- Create Macros
- Create Payrolls, Tables
- Create student table Using Formula
- Graphs , Charts
Advanced Excel
- V Look up, H Look Up
- Sum If, Count If functions
- Index & Match Functions
- Pivot Tables Charts
- Filters. Adv. Filters
- Paste
- Paste Special
- Import Tables Excel To Notepad and
- word, Access
- Date Functions
- Logical Functions Name Define
- Financial Functions
- text Functions
- Conditional Formatting
- Sub Total Functions
- Goal seek
- What if analysis
- Data table
- Protect Book & Sheet
- Scenarios, number series
- Sheet Breaks
- Column charts
- Columns And Rows, Print Titles
- Smart Art, pivot charts
- Hyperlinks
- Consolidation
- Data validation
- Date and time function
- Text functions
- Statistical functions
- Financial Functions
- Employee pay slips in excel
- Hyperlink in excel
