Unlock the full potential of Microsoft Excel with our comprehensive Advanced Excel course at SVM TECHNO LABS. Designed to enhance your Excel skills and empower you to tackle complex data analysis and reporting tasks, our course offers hands-on training in the advanced functionalities of Excel..
Apply NowINSERT SHEET ROW,SHEET
COLUMN,FORMAT OPTIONS, CONDITIONAL,
FORMATING, FILL OPTIONS,
LINEAR, GROWTH, DATE, AUTOFILL,
CLEAR OPTIONS,
SORT AND FILTER, FIND OPTIONS
Insert Menu Option In Excel
How to use the Pivot Tables & Pivot Table With Pivot Charts in Excel
Using the Table Options, Picture, Clip Art, Shapes
Using the Columnar Chart, Bar Chart, Pi Chart, Doughnut
Using the Smart Art, Hyperlink, Text Boxes
Using the Word Art, Header & Footer, Object, Symbol options
Working with page layout menu
Margins, Orientation, Size, Set Print Area,
Remove print area, page break, back ground,
Print Titles, Grid Lines, Heading.
Formula Menu
Mathematical functions
Sum, sumif, sumifs, count, countif, countifs,
Mod, sqrt, round, roman, counta, averageif
Character functions
Upper, lower, proper, concatenate,
Left, right, length
Date functions
Today(), now(), edate(), eomonth(), networkdays(), datedif()
Boolean functions
And, or if condition,
Compound if statements trace precedencts,
Trace dependents,
Watch window,
Formula auditing,
Error checking,
Define name, name manager
Data menu
Subtotal, group, ungroup,
Scenario manager
Goal seek,data table,
Consolidate
Data validation,
Remove duplicates,
Text to columns,
Advanced filter,
Sort, get external data
Review menu
Comment,
Protect workbook,
Allows user to edit ranges.
View
Normal, page layout, custom view, full screen,
Show hide, zoom,
New window,
Freeze panes,
Save work space
Other functions
Vlookup
Hlookup
Match
Index
Indirect
Isna
Control flow structures
Linear
Sequential
Iteratives
How to write range print using linear programming
How to use exit sub
How to use message box and inputbox
How to declare variables and using variables how to take print on
Excel sheet and message box
If statements
Goto statements in if condition
If else statements
Do loop (entry conditional loop)
Do while loop (exit conditional loop)
Do until loop
For loop
Single dimentional array
Two dimentional array
switch case programming
Event driven programming
how to create command buttons
How to write linear, sequential, iteratives using command buttons
Assigning macros to shapes
Creating user forms
How to create pay slip using forms
How to take print on excel sheet using forms
How to write vlookup using form
How to create menu items using multitab, tabs on form
How to use check box and option buttons on forms
How to call user defined functions in forms
User defined functions
How to convert formulas into user defined functions
How to write if else statements using functions
How to call user defined functions on excel sheets
How to call user defined functions in macros and forms
Classes and objects
How to create class functions and
Creating object and
Calling function in forms
Apply NowAt SVM TECHNO LABS, we understand the importance of successful SAP implementation projects for businesses seeking to optimize their operations and maximize efficiency. Our experienced team of SAP consultants and project managers is equipped to guide you through every step of the implementation process, ensuring a seamless transition to SAP technology.
Apply NowAt SVM TECHNO LABS, we are committed to not only providing top-notch training but also assisting our students in their career growth. Our placement assistance program is designed to support and guide you in securing exciting job opportunities in the SAP ecosystem.
Apply Now