Hi Ahmed, Thanks for the response. Since your are new to Excel, we will start with the basics, cover intermediate excel and then cover some important topics of Advanced excel. The duration would be for 25 hrs and the fees would be 5000 /- only. Below are the topics that would be covered in your course : * Introduction * Formatting In Excel * Adv Formating * Conditional Formatting * Data Validation * Linking In Excel * Linking across Sheets * Linking across Workbooks * Making worksheets '' Error Free'' * Referencing * Cell Referencing In Excel * Relative Referencing * Absolute Referencing * Difference Between Relative & Absolute Cell Referencing * Functions In Excel * SUM,COUNT,AVERAGE,SUMIF,COUNTIF ETC * Sumproduct,subtotal,count,counta, * IF,AND,OR ETC * LOOKUP,VLOOKUP,HLOOKUP ETC * Days 360 (''mm/dd/yy'',''mm/dd/yy'') (Days - Functions) * LEN,UPPER,LOWER,PROPER ETC * PMT,RATE,PV,FV ETC * EOMONTH, TODAY(), WORKDAY(), * ISNUMBER, ISERROR, OR, AND, IF-THEN-ELSE * Financial Functions * Text Functions * Date & Time Functions * Working With Data Lists * Sorting * Form * Validation * Subtotals * Filtering * Pivot Tables * Creating Pivot Table Using Wizard * Modifying The Pivot Table * Creating a Pivot Table Report * Printing with Excel * Working with print Options * Setting Print Area/layout * customization of toolbar * Applying Protections * Worksheet protection and locking of cells * Workbook Protection * Excel Keyboard shortcuts. * Auditing Excel Sheet * Working and editing with Hyperlinks * Adding and Working On Custom views * Analysis tool * Working With Goal Seek * Creating Scenarios * Grouping the Columns and Rows * Importing the Text * RECAP and PRACTISE SESSIONS Regards, Sajjan

Asked by Naveen Paripally 05/09/2013 Last Modified   05/09/2013

Follow 0

Answer

Please enter your answer