Microsoft Excel Advance Marcos training in pune

Optimal Microsoft Excel Advance Macros training in pune

Ideal Microsoft Excel Advance Marcos traning built for you

Advance Excel Training Syllabus
Introduction to MS Excel and Understanding BasicWorking with it
Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon,Worksheets and Toolbar Difference Between Excel 2003, 2007, 2010 and 2013Saving Excel File as CSV, Macro Enable Sheet, PDF and Older VersionsUsing Excel Shortcuts with Full List of Excel ShortcutsCopy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows,Columns and SheetsUsing Paste Special OptionsFormatting Cells, Rows, Columns and SheetsProtecting & Unprotecting Cells, Rows, Columns and Sheets with or without PasswordPage Layout, Themes, Background and Printer PropertiesInserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets
Working with Formulas/Functions
Lookup and Reference Functions:
VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
Logical Function:
IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
Database Functions:
DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
Date and Time Functions:
DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR,YEARFRAC, TIME, WEEKDAY, WORKDAY etc
Information Functions:
CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT,ISNUMBER, ISREF, ISTEXT, TYPE etc
Math and Trigonometry Functions:
RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
Statistical Functions:
AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST,MAX, MAXA,MIN, MINA, STDEVA etc
Text Functions:
LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE,TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
Conditional Formatting
Using Conditional FormattingUsing Conditional Formatting with Multiple Cell RulesUsing Color Scales and Icon Sets in Conditional FormattingCreating New Rules and Managing Existing Rules
Data Sorting and Filtering
Sorting Data by Values, Colors, etcUsing Filters to Sort Data Advance Filtering Options
Pivot Tables
Creating Pivot TablesUsing Pivot Table OptionsChanging and Updating Data RangeFormatting Pivot Table and Making Dynamic Pivot Tables
Pivot Charts
Creating Pivot ChartsTypes of Pivot Charts and Their UsageFormatting Pivot Charts and Making Dynamic Pivot Charts
VBA Macro
Introduction to VBA MacroRecording Macro & Understanding Code BehindEditing, Writing VBA Code and Saving as Macro or Add-In Adding Add-Ins in Excel
Fill the inquiry form above to join Basic Excel classes in Gurgaon

go to homepage