This will build on your current Excel skills. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our professional Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate's knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the ‘IF’ function, You’ll learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper MS Excel tools to create a unique solution. This training will also enable you to create, build and customise graphs. Existing MS Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel. We also have an Advanced MS Excel Training course. For people from companies, we provide Corporate Training on MS Excel.
Class |
Syllabus |
Training Details |
---|---|---|
Session - 1 | EXCEL BASIC OPTIONS |
|
Session - 2 | EXCEL FUNCTIONS |
Uses of Excel FormulasSUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR, COLUMN, COLUMNS, CONCATENATE, COUNT, COUNTA, COUNTBLANK, EXACT, HYPERLINK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT, OFFSET, PROPER, MAX, SEARCH, TIME, DATE, DAY, MONTH, YEAR, FIND, REPLACE, ROUND, ROW, ROWS, SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT, NETWORKDAYS, DATEDIF, MOD, NOW etc |
Session - 3 | ||
Session - 4 | EXCEL ADVANCE FUNCTIONS |
Various Methods and Uses of Advance Excel FormulasVLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT, GETPIVOTDATA, DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH etc |
Session - 5 | EXCEL OPTIONS |
|
Session - 6 | ACCESS DATABASE & RECORD MACRO |
|
Our session will not just stop with teaching you the above options, we go beyond to make you an expert in using the various options in real time scenario. |