Excel Quick Overview : Use of Excel, its boundaries & features

Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning

Conditional Formatting : Once defined, it will automatically change color of values e.g. up or down, high or low, pass or fail, profit or loss etc.

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.

Formula Writing & Fixing Errors : Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, 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 & it’s relevance.

Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc.

Hyper / Data Linking : Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.

Grouping - Ungrouping : Sometime data needs to be grouped for summarized results & crisp view. Grouping & ungrouping feature will help you do so.

Pivot Tables : Summarize your data as per your desire. You need to select data in a range & produce consolidated results in user defined formats.

Macros Recording, use, editing, linking : Record, edit & use Macros with no programming knowledge.

Security & Protection : It will help you protect your cells, worksheet or an excel file from misuse.

Data validation : prevent wrong data entry. Specify your own format and conditions for data entry so that right data should be entered & accepted by the Excel.

Course Fees: 5,000 INR
Course Duration: 10Hours
Address: G – 244, Basement, Vikas Puri, New Delhi 110018 Landmark: Behind PVR Cinemas
Telephone:011-45620832
Mobile: +91 9873388286
E-mail:info@clickprefect.com