Training

Beginner to ADVANCED EXCEL

Basic Excel Course Syllabus

Introduction to Excel and it's version, Font formatting, Number formatting, Table formatting, Conditional formatting, Hide / Unhide, Sort / filter, Paste special, Find and select, Insert Illustrations, Charts,

Basic Functions

Sum / Average / Count / Max / Min, Basic Text / date / time / lookup / information functions, Name manager, Formula Auditing.

Data

Import from web, Import from text, Text to columns, Remove duplicates, Grouping and ungrouping,

Review

Proofing, Comments, Protection,

Views

Types of views, Zoom, Windows.

Developer

Enable developer, Using checkbox / option buttons, 2010, 2013, 2016 Quick Overview.

Basic Formula

Formulae that Add / Subtract / Multiply / Divide, BODMAS / Formula Error Checking, The Sum Function, Absolute Referencing, Problems with Absolute / Relative Cell Referencing, Creating Absolute / Mixed References.

LOOKUP Functions

The VLOOKUP/ HLOOKUP Functions

Reporting in Excel

PivotTables

Creating, Formatting Simple PivotTables, Page Field in a PivotTable, Formatting a PivotTable, Creating / Modifying a PivotChart.

Functions in Excel

Logical Functions

IFs and Nested IF Functions, Using AND / OR / NOT Functions.

Statistical Functions

Using The SUMIF / COUNTIF Functions, Using The AVERAGE / COUNT / LARGER / SMALLER Functions.

LOOKUP Functions – Advance

MATCH with VLOOKUP Functions, INDEX & MATCH Functions, OFFSET / INDIRECT functions,

Logical Functions – Advance

If Loop and Nested IF Loop Functions, Using IF / ISERROR Functions.

Chart Data Techniques

The Chart Wizard, Chart Types, Adding Title / Legends / Lables, Printing Charts, Adding Data to a Chart, Formatting / Renaming / Deleting Data Series, Changing the Order of Data Series, Date / Time Functions, Using The Today, Now & Date Functions, Using The Datedif / Networkdays / Eomonth Functions, Using The Weeknum Functions, Using The Edate / Networkdays. Intl / Weekdays.Intl Functions.

Text Functions

The Mid / Search / Left / Right Functions, Using The Trim / Clean / Upper/ Lower Functions, Using The Substitute / Text Functions, Using The Trim / Clean / Proper / Dollar Function.

Validations

Whole Number Validation,Decimal Numbeer Validation,List Validation,Date Time Validation,Text Length Valdation,Custom Validation, Input Messages / Error Alerts.

Conditional Formatting

For Blank Cells,For Non Blank Cells,For specific Range etc..

Advanced Filters

Extracting Records with Advanced Filter, Using Formulas in Criteria.

Advanced Sorting

Sorting by Top to Bottom / Left to Right, Creating / Deleting Custom List, Sort by using Custom List, Hyper / Data Linking, Hyper linking data, within sheet / workbook, Linking & Updating links between workbooks & application.

Math & Trigonometry Functions

Using SUMPRODUCT Functions, Using FLOOR / CEILING/ MROUND / MOD / QUOTIENT Functions,

Summarizing Data

Creating Subtotals / Nested Subtotals, SUBTOTALS Formula.

Outlining

Creating / Working with an Automatic / Manual Outline, Grouping / Ungrouping.

Consolidation

Consolidating Data with Identical / Different Layout.

Using Auditing Tools

Displaying / Removing Dependent & Precedent Arrows, Evaluate Formula – Step IN / Step Out.

Custom Views

Creating Custom Views, Displaying Custom Views, Deleting Custom Views.

Importing & Exporting Data

Importing Data from Database / Text Files / Web, Exporting Data.

Visual Basic for Application

Creating Form in VBA,Login ,signup and Forgotton Paasword Form,Add VBA Controls like Label,Textbox,Command button,Combobox,Listbox,Frame and Mulypage etc..