Warning: include(header-excel.php): failed to open stream: No such file or directory in /home/alantiai/public_html/sap-abap.php on line 3

Warning: include(header-excel.php): failed to open stream: No such file or directory in /home/alantiai/public_html/sap-abap.php on line 3

Warning: include(): Failed opening 'header-excel.php' for inclusion (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/alantiai/public_html/sap-abap.php on line 3
  • Introduction
  • Evolution of ERP
  • ASAP (Accelerated SAP)
  • Project preparation
  • Business Blue Print
  • Realization
  • Final preparation
  • Go-Live and Support
  • Centralized architecture
  • Distributed architecture
  • 2-tier architecture
  • 2-tier architecture
  • 3-tier architecture
  • Overview of Software Development
  • Overview of SAP Landscape
  • Landscape types
  • Lifecycle Implementation concepts
  • Introduction to ABAP
  • Getting Started
  • SAP Logon Details
  • Row
  • column
  • Sheet
  • Row
  • column
  • Sheet
  • Applying Formats
  • General, Date, time, text, numbers
  • Sorting
  • Find & Replace
  • Pivots
  • Charts
  • Slicer
  • Diagram
  • Screenshot & Editing screenshot
  • Logical
  • Text
  • Date & Time
  • Lookup & Reference
  • Name Manager
  • Graphically representing data: Charts & Graphs
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Formatting worksheets, Securing & Protecting spreadsheets
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
  • Nested functions, Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references: >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function, Date and time functions, Annotating formulas
  • Sort
  • Filter's
  • Advanced Filter
  • Text To Columns
  • Remove Duplicates
  • Data Validation
  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Linking Between Word/Excel/Ppt
  • Functions: - LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK
  • Absolute Cell References
  • Name Manager
  • Creating and defining names
  • Making a name list
  • Advanced technique of using names in formulas
  • Using Name Manager
  • Using Name Manager
  • Excel Pivot Tables
  • Data Forms in Excel 2007/2010
  • Data Forms in Excel 2007/2010
  • Add your own Error Messages
  • Excel and Web Integration
  • Hyperlinks in Excel
  • Object Linking and Embedding
  • Spell check
  • Insert command
  • Protect Sheet
  • Protect Workbook
  • Protect Share Workbook
  • Track Changes
  • Gridlines
  • Freeze Panes
  • The database components
  • Using Excel Form feature
  • Inputting data
  • Deleting data
  • Finding records
  • Using menu commands to find records
  • Multi-level sorting
  • Restoring data to original order after performing sorting
  • Sort by icons
  • Sort by colors
  • Multi-level subtotal
  • Consolidating and combining several spreadsheets using the operation addition, subtraction
  • Synchronizing the consolidated table with the source data
  • Lookup ()
  • VLOOKUP ()
  • HLOOKUP ()
  • Application of exact match and approximate match
  • Creating an order form using VLOOKUP function
  • Files protection
  • Protecting cells/documents
  • Unprotecting documents
  • Paste link
  • Defining single and multiple criteria
  • Combining search criteria
  • Deleting criteria
  • Extracting records
  • Steps to create a pivot table
  • Creating pivot table from Excel
  • Consolidating data from multiple ranges into a pivot table
  • Highlighting data using cell colours, font colours
  • Highlighting data using icons
  • Define the data input type
  • Define the warning message
  • Define the error message
  • Circle invalid data
  • Defining your own scenario
  • Preview the result of scenario
  • Editing a scenario
  • How to apply What-If Analysis
  • Creating a hyperlink
  • Editing a hyperlink
  • Creating a menu system using hyperlink

Latest News

We ,AIIT is a privileged of Tally.ERP9 with GST, SAP & Advance Excel Training. We focus on the needs of the Tally & SAP ERP community. We AIIT provide the ideal platform to meet the demands of the constantly evolving Present job market.
msme registration

Quick Contact

+91-9735596611
+91-8001281345
alantiainstitute@gmail.com
info@alantiainstitute.in

Skype : alantiaiit16


Register Address: Satgachia Manashatala, Satgachia, Memari, Burdwan-713422 Training Center Address: Bhairab nath tala, J.B Mitra Lane, Burdwan-713104
Copyright ©2017 - 2021 AIIT . All Rights Reserved
Follow us on: