Avadi : 8695577620 Ambattur : 9361402101 Tambaram : 9361202101 Kelambakkam : 9362077655
Avadi : 8695577620 Ambattur : 9361402101 Tambaram : 9361202101 Kelambakkam : 9362077655
MIS
Microsoft Advance Excel. FIIT the best Advanced Excel Training Centre in Chennai. We offer Basic, Intermediate, Advance Excel Training and VBA Macro Training for Corporate & Individuals. FIIT Advanced Excel Training course is an interactive hands-on training program.
We train participants step by step, from basic to advanced level function of Microsoft Excel. Our training methodology is simple and easy to understand. Our training courses will show you how to use Excel better, faster and more efficiently.
For more INFO contact
Essential Level Excel Training
Overview: Our most popular course. You will learn how to create templates for commonly used worksheets. Learn how to apply filters and sort data into key elements. Getting Excel to make decisions using the If function, Pivot Table and conditional formatting,.
Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.
Excel Ribbon
Tabs, Contextual Tabs
Quick Access Tool bar
Overview of 2003, 2007, 2010, 2013
Various ways of Entering Data into Excel
Cell, Rows, Columns, Range, Name Box
Entering Formulas in Excel BODMAS Rule
Alignment, Merge Cell, Wrap Text
Text, Number Formatting
Entering Data in Next Line within single cell
Insert, Delete, Move, Copy, Group Sheetsbr
Insert, Delete Rows/Columns
Freeze Headings
Various ways of selecting Data
Selecting Non Continuous Range
Shortcuts & Techniques
Using sample formulas
Using AutoSum, Average, Min and Max
Introduction to AutoFill
Various ways to apply Fill Series
Number Fill Series Based on Stop Value
Inbuilt Fill Series for Text
Custom based Text Fill Series
Core concept of Excel Cell Addressing Absolute Referencing Relative Referencing
Auto Filter - Shortcut
Text Filter Begins With, Contains, Ends With
Number Filter Top 10, Above Average
Sorting Custom Sort
Sort Based on Color, Multilevel Sorting
UPPER, LOWER, PROPER, TRIM, CLEAN
LEFT, RIGHT, MID
Text to Columns
DATE, YEAR, MONTH, DAY, TEXT
TIME, HOUR, MINUTE, SECOND
VLOOKUP Exact, Approximate Match
Restrict Values based on Number Drop-Down List for Text Restriction
Creating Pivot Table
Sum, Average, Count Function in Pivot
Hide/View Subtotal
Report Filter
Better way of representing Data in Pivot Table
Inserting Chart Column Chart, Pie Chart
Adding/Deleting Data in Chart
Charting Option Legend, Axis, Layout, Styles
Multiple Charting
Savings in different Formats
Saving with Password Protection
Saving in different Formats
Saving with Password Protection
Repeat the Rows/Columns in Multiple Pages
Page Orientation
Header/Footer
View/Hide Grid Lines
Excel VBA Macro Training
This 2 day Excel VBA course is suitable for advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to automate routine activities in Excel based on their requirements. Prerequisites Good proficiency in Microsoft Excel is required, or completion of our 2 day Advanced MS Excel course. Benefits At the end of the course the delegate will have ability to automate their Excel based Work in Macros.
What is a Macro
Recording a Macro
Relative References
Running a Macro
Running a Macro From The Macros Dialog Box
Editing a Macro with Visual Basic
Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar
Creating A Short-Cut Key To Run A Macro
The Visual Basic Editor
The Project Explorer
The Code Window
Procedures
Inserting Comments
Printing a Visual Basic Module
The Cells Property
The Range Property
Activating a Workbook/Sheet
This Work Book
Running Code
Excel Constants
Variable Constants
Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object
Objects, Properties & Methods
Getting & Setting Properties
VARIABLES
Using Variables In Routines
Inputbox Function & Msgbox Function
Using A Set Statement
CONTROL STRUCTURES
If Then Decision Structures
Logical Operators
For Loops & Do Loops
Select Case
Creating and using a user-defined function
Creating another function
Passing multiple arguments
VBA Editing & Debugging
Auto Macros
Error Handling
User-Defined Forms
Adding Form Controls
Form Control Properties
Control and Dialogue Box Events
Displaying and Dismissing a User Form
Handling Form Controls
Types of Training
