Excel Macro Online for freshers by Mentormindz

Advance excel
If-else, Average, Averagea, AverageIf, AverageIfs
Min/Max, Count/ CountA/ CountBlank/ CountIf/ CountIfs
Sum/Sumif/Sumifs/Subtotal/Round/RoundDown/Roundup
Relative/Absolute reference/Row/Rows/Column/Columns
Operators Arithmetic (+,-,*,/) /Logical (AND,OR,NOT,>,<.>=,<=,<>) RIGHT/LEFT
Vlookup/Hlookup/Match/Index/MID/FIND/REPLACE/Concatenate/LEN
Indirect, Date & Time function, Database function, INT/CHAR
What if analysis (Goal seek), Charts & graph chart properties
Filtering data, Pivot tables, calculated fields in pivot, Slicer, data validation, Text-to-column, Remove duplicate
Working with range/range name/password protection
Setting data validation, Create Input message, Create error alert, data validation using formulas

VBA macros
Topic 1 : Introduction to excel VBA
Topic 2 : Getting started with a simple program
Topic 3 : Working with variables in VBA
Topic 4 : Introduction to excel VBA subroutines
Topic 5 : Using Message box and Input box in Excel VBA
Topic 6 : Using If.Then.Else in Excel VBA
Topic 7 : For/Next Loop and Do/Loop
Topic 8 : Select Case/End Select
Topic 9 : Excel VBA Objects Part 1An Introduction
Topic 10 : Excel VBA Objects Part 2 The Workbook Object
Topic 11 : Excel VBA Objects Part 3 The Worksheet Object
Topic 12 : Excel VBA Objects Part 4The Range Object
Topic 13 : Working with Excel VBA Controls/Active x & Form controls
Topic 14 : VBA Procedures Part 1-Functions
Topic 15 : VBA Procedures Part 2-Sub Procedures
Topic 16 : String Handling Functions
Topic 17 : Date and Time Functions
Topic 18 : Sample Excel VBA Programs
Topic 19 : VBA Programs discussions
Topic 20 : Test cases