Excel Macro course Beginner level by XLStime MIS Traning Center

Paste Special
Go to Special
Fill Series
Basic of Custom format
Data Validation
Name Range
Basic Excel Keys
Basic of Conditional Formatting
Format Cell
Format as Table
Cell Styles
Insert/Delete - Cell / Row / Column
Height/Width - Row / Column
Protection - Cell / Sheet/ Workbook
Pivot Table
Pivot Table Filter - Slicer / Timeline
Charts
Shapes
Sparklines
Object
Basic of Print - Print Area / Print Titles
Basic formulas and Formulas with Dynamic range and values
Go To Special -Precedents, Dependents
Calculation Options
3D Range
Basic formulas with Dynamic range and values
Get External Data
Sort & Filters
Data Tools (Text to Column, Remove Duplicate)
Data Validation
What-If Analysis
Outline
Freeze Panes
Formulas:-
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
Linking Multiple Sheets
Sheet Referencing
Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
Character Functions
Date Functions
Age Calculations
Array formulas
Conditional formatting with formula
Data Validation with formula
Pivot table with formula (Dynamic range)
Charts with formula (Dynamic range)
Reporting & Dashboard
Conditional formatting with formula
Data Validation with formula
Pivot table with formula (Dynamic range)
Charts with formula (Dynamic range)
Reporting & Dashboard
Macro and Basic of VBA:-
Definition and use , Record a macro
Assign a macro , Run a macro
Store a macro, Introduction to VBA Prog.
PowerPoint Presentation
Charting
Shapes
Animations
Slide Show
Word
Mail merge