Alantia Institute of Information Technology (AIIT)

"Apprise Education, Reprise Innovation"
An ISO 9001: 2015 Certified Institute


+91-9735596611
+91-8001281345
alantiainstitute@gmail.com
OUR BLOG | ENQUIRE NOW
partner_logo
Alantia Institute of Information Technology (AIIT)
  • Basic Excel Course
  • Advance Excel Course
  • VBA Course
certificate

Welcome to a short, easy-to-master, web based course on basic computer skills. Our goal is to give you a solid foundation. Once you have understood these basics, you will have a clear understanding on which to build your future knowledge of and skill with computers.

To become acquainted with your computer there are certain basic skills to be mastered. While these skills might seem obvious at first, the fact is that many people never take the time to learn these very important basics. By studying them now, you will both save time later and also improve your daily computer productivity.

Course Contents are as follows:

Basic Level

In Basic Level It covers basics functionality on all the Tabs

Course Duration, Fees

Advanced Excel

This Excel 2013 advanced training course, follows up from the Beginners Excel 2013 course by delving even deeper into the features and functions of this powerful spreadsheet software. Microsoft Excel 2013 is much more than a quick way to add up numbers. In this our offline & online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Spark lines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros. This advanced Excel course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2013, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the faculty trains you with.

Course Content are as follows:
  • In Advanced Excel Training it Cover’s all the Tabs & Functions File Tab
  • Home Tab
  • Spreadsheet basics
  • Inserting
  • Deleting
  • Formats
  • Insert Tab
  • Formula's Tab
  • Working with functions & formulae
  • Formulas & Macros Formulas:
  • Data Tab
  • DATA Analysis:
  • Naming cells and ranges
  • Excel Pivot Tables
  • Review Tab
  • View Tab
  • Advanced data sorting and subtotal
  • Consolidation with several worksheets
  • Lookup table
  • Document protection
  • File linking
  • Filter and advanced filter
  • Pivot table
  • Conditional format
  • Data validation
  • More...
  • How to recover a file
  • Creating Add-ins
  • Opening or Viewing the Recent files (Which we have worked)
Conditional Formatting - All Function's Applying Conditions for Highlighting in Using Formula's in Conditional Formatting
  • Text
  • Numbers
  • Date
  • Duplicate Values
  • Formatting the Table
  • Creating a Table
  • Using Created Table in Pivot Table
  • Creating
  • editing
  • saving
  • printing spreadsheets
  • 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

Course Duration, Fees

VBA Macro Training Content

Basics

• Understanding Loops & Writing VBA Code
• Variables & More
• Dealing with Cells & Ranges
• Workbooks, Worksheets & Databases
• Working with Charts & Shapes
• Working with Pivots
• User Forms & Databases
• More User Forms & Example Application
• Integrating with Word & PowerPoint
• Additional VBA Techniques
• Using Do While Loop & IF Statement in VBA
• DO WHILE Loop Explained
• Using FOR NEXT Loop in Excel
• Using SELECT CASE Statement in VBA & Working with User
• Defined Functions (UDF)
• Deep Dive in to VBA: Theory on Variables, Scoping etc.
• How to Save and Reuse your Macros
• Dealing with Cells & Ranges Workbooks, Worksheets & Databases
• Working with Charts & Shapes
• Displaying Message Boxes using VBA
• Understanding & Using Cells Object
• File Handling: Opening, Reading & Writing to Files from VBA
• Wrapping a Set of Formulas with IFERROR
• ODBC Connectivity to SQL Database and Query Handling
• Files and Folder Handling (FSO Method)
• Interacting with other MS - Office applications (word, PowerPoint and MS-Access)
• Interacting with Outlook Applications
• Running the SQL Queries within Excel Environment
• Interacting with Internet Explorer
• Interacting with Client Application
• Interacting with SAP Environment by Excel
• Interacting with MAINFRAME by Excel
• Send keys
• Excel to Excel
• Excel to MS Office Applications (Excel, outlook, Access, word, notepad..etc)
• Excel to Database by using SQL
• Excel to Internet Explorer
• Excel to Mainframe
• Excel to SAP
• Excel to Client Application (All kind of applications by identifying API)
• Using Worksheets, Workbook Objects in
• VBA: Example on how to save a copy of workbook
• Consolidate Multiple Workbooks in to one using VBA
• Delete Blank Cells & Sort a List using VBA
• Generating Multiple PDF Reports using VBA
• Creating Spark-line Chart in Excel using VBA
• Cleaning up multiple charts using VBA
• Interactive Excel Charts using VBA
• Animating Excel Charts with VBA
• Building an Application using User Forms & VBA
• Integrating with Word & PowerPoint
• Generate MS Word Reports from Excel
• Create a PPT Slide Deck from Excel
• Running a Macro when user selects a cell
• Showing & Hiding information using VBA
• Text Processing & Analysis using VBA
• Using Arrays in VBA
• Building a Workbook Change Tracker App using VBA
• Debugging & Error Handling in VBA

In the age of information technology every person should be aware of the latest innovations. Modern programs, languages of programming and so on are constantly appearing. Nearly everybody knows Microsoft office and use it every day. But everybody wants to know how to work with it more efficient and quicker. Do you want to find out how to make your work with MS Office, even more, better? You’ll learn it from this course teaching you VBA (Visual Basic for Application). This programming language will automate your work with MS Office and makes it easier.


After this Visual Basic course will able to customize MS office for your needs. You’ll able to:

• To write your formulas and functions in Excel, output pre-programmed messages etc…
• To record macros
• To create custom applications in such programs as Outlook, Excel, PowerPoint, and Access
• It’s only a part of the information, you’ll learn

What this course will cover?

This course will provide you with a lot of information given below:
• You will be able to understand how to work with Visual Basic
• You will find out how to record macros
• You’ll learn how to use loops and functions
• You’ll be taught to create code in Visual Basic Editor
• You’ll get information on debugging, and securing your code
• You will be explained how to make dialogue boxes, input boxes
• You’ll be efficient to XML-based files

Who is this course useful for?

• If you want to work more effectively and efficiently using programs of packaging in Microsoft office.
• Individuals working for IT-industry.
• If you’re a freelancer and want to work efficiently
• Who want to be aware of the latest programming languages? This is for you!
• Application developers
• For people who are in business. The ability to use VBA will meet your business needs
• People who prefer working in Microsoft Office Products

What are your benefits?

To say that Word, Excel, PowerPoint, Outlook, and Access are very popular programs is to say nothing. Daily Creation of documents and presentations and, of course, everybody use outlook to stay in touch with clients. And in common, it gets a lot of time. Everyone wants to reduce the time spending on working with these programs and optimize your working process. It is important to learn how to use such. And this educational course will help you.

The benefits are:

• VBA programming is easy to learn and simple to use
• Gets you work done quicker
• Gives you an opportunity to create your own applications
• To run database more effectively
• To improve work with Excel and Word

Course Duration, Fees

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.


Quick Contact

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

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