Course Contents of Advanced Excel Training Program without Excel VBA:
Excel Quick Overview: Use of Excel, its
boundaries & features
Data Formatting & Custom settings: Number, Text, Date,
Currency, Custom settings.
Data validation: prevent wrong data entry in your specified format.
Getting data into an Excel worksheet – manual entry or from other
programs like Notepad and databases.
Conditional Formatting: Once defined, it will automatically change
color of values e.g. up or down, high or low, pass or fail, profit or
Filters, Queries & Data Sorting: Drill down your
data to your desired level. Sort data based on your choice e.g. like
North, East, West, South rather than alphabetically.
Writing & Fixing Errors: Financial, Logical, Text, Day and
Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum,
Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today,
Even, Exact, Exp, Find, Int, Is Blank, Left, Len, Lower, Upper, Proper,
Now, Power, Rank, Right, Round, Trim etc.
If-Then-Else & Nested If commands: Produce different set of
results based on slabs, conditions.
Vlookup / Hlookup: You have large amount of data placed at different
locations & you want to merge it based on common values
Graphs & Charts: You will learn how to create,
modify & update graphs / charts like Column, Line, Pie, Bar,
Scatter, 3D etc.
Hyper / Data Linking: Hyper & data linking,
within or outside Worksheet / Excel File are important features that
help update data automatically.
Grouping - Ungrouping: Sometimes data needs to be grouped for
summarized results & crisp view.
Pivot Tables: Summarize your data as per your desire. You need to
select data in a range & produce consolidated results in user
defined reporting formats.
Macro recording, use, editing,
linking: Record, edit & use Macros with little or no
knowledge. Macros are useful for automating tasks in Excel.
Creating custom functions for calculating, for example, compound
Security & Protection: It will help you protect your cells,
worksheet or an Excel file from unauthorized use.
Question and Answers for 'very specific' queries
Course in Excel Visual Basic for Applications (Excel VBA)
1 Create a Macro
2 Excel Macro Recorder
1 Macro Security
2 Visual Basic Editor
3 Macro Comments
5 Macro Errors
6 Debug Macros
7 Objects, Properties and Methods
8 Workbook and Worksheet objects
9 Application Object
2 String Manipulations
4 If Then Statement
7 Logical Operators
8 Range object
11 Functions and Sub
5 Option Buttons
7 Dates and Time
Place of training:
S-203, Greater Kailash-2
Training style: Mostly individual or in small batches of maximum 5 people
period: One month each (1.5 hours on alternate days, for example: Mon, Wed
and Friday) or two full days Saturday & Sunday (10 a. m. to 6 p. m.)
Timings: Can be decided mutually
Trainer: Dinesh K Takyar (Ph. D.)
Online training via Skype possibe: Rs. 750 per hour or $15 per hour: Skype ID - dktakyar