MS EXCEL TRAINING (Basic & Intermediate)

Overview:

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	An overview of the Screen, Navigation and Basic Spreadsheet concepts Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells Various Selection techniques Various ways to Enter, Edit and Delete information (Text, Numbers, Dates) Methods to Move, Copy & Paste data All the Options in Paste Special and Go To Insert, Delete and Hiding Rows & Columns Inserting and Deleting ranges Insert, Delete and Move Cells Various Navigation techniques Sheet tab formatting and Renaming Copy and Clear Formats and Merge Cells Find, Replace and AutoCorrect Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns Uses Conditional Formatting and Auto Formatting All Formate Cells Options Uses of Toolbars and Formula Bar Viewing, Adding, Editing and Deleting Comments Auditing features and Tracing Formula errors Protecting and Sharing Workbook, Worksheet and Cell ranges Using Freeze Panes Worksheets and Workbooks Calculation method Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks Methods to Move and Copy sheets Uses of Hyperlinks and Define Name
Session - 2	EXCEL FUNCTIONS	Uses of Excel Formulas SUM, 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	EXCEL FUNCTIONS
Session - 4	EXCEL ADVANCE FUNCTIONS	Various Methods and Uses of Advance Excel Formulas VLOOKUP, 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	Various Methods and Options of Pivot Table Various Methods of Filter and Advance Filter options Creating and Updating Subtotals Various Methods of Text to Column options Uses of Data Grouping and Consolidation options Uses of Goal Seek and Scenarios Manager Various Method of Sorting Data Creating, Formatting and Modifying Chart Data Validation, Creating drop down lists using different data sources Linking Workbooks and Uses of Edit Link options Excel Options, Customizing the Quick Access Tool Bar Formula Auditing features and Trace formula error
Session - 6	ACCESS DATABASE & RECORD MACRO	Create a New Table and Database in MS Access Load the Data into Access Database Create a Query in Access Database Create Single and Multiple Mapping Tables Filter Single and Multiple criteria using Access Query Create Query for Data Grouping Create Query to Select required Columns Retrive specific data using Logical Access Query Create Access Query to Update, Change and Delete the Information in Access Recording, Viewing and Editing Macro VBA code
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.

MS EXCEL TRAINING (Basic & Intermediate)

Overview:

Class

Syllabus

Training Details

EXCEL BASIC OPTIONS

EXCEL FUNCTIONS

Uses of Excel Formulas

EXCEL ADVANCE FUNCTIONS

Various Methods and Uses of Advance Excel Formulas

EXCEL OPTIONS

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.