Spread Sheets are one of the simple and widely used applications where information is gathered, analysed and exchanged. In our day to day life, we spend a lot of time processing the information in spreadsheets. Microsoft Excel is one of the powerful tools which has various inbuilt Features and Functions which helps in analysing the data on a real time. The Understanding and usage of these capabilities will help a user to comprehend the information and report information quickly and take advantage of the advanced capabilities provided in the Tool.
The below trainings will help you get acquainted with various features in the tool and help you use the tool to the best and save a lot of time! The Trainings will cover a lot of Scenarios which will help user expertise in using the various functions and find out various different ways we can think to get a solution and choose the best solution. Trainings will cover both Excel 2003 and Excel 2007 Versions.
The Course if useful for somebody who has no or very little knowledge on MS Excel, We start the training explaining about spreadsheets, Various version of Excel, Different tools and features, A start of Formulas, Building basic formulas and other various other things.
» Click here to get the contents of Excel Basic Course
In this course, We cover all the tools and features of Excel at an advanced level, We cover Advanced Filter, Conditional formatting, Data validation, How to control entry of duplicate values, Extensive time is given to build formulas, How to build complex formulas, Usage of Pivot Reports etc…
» Click here to get the contents of Excel Advanced Course
Want to automate the daily repetitive tasks you are performing in Excel and save time? Want to create your own formula in excel? Want to design and implement an automation system in your process or team? Want a Macro which can prepare a report in Excel in seconds, Present the same in PowerPoint and forward via Email? And all this thru a click of a button. This is all possible. Excel can be programmed to meet our needs.
This training will help you get there ,.The Course starts with getting expertise in Recording macros successfully, how to edit the codes and how to build the VBA codes to carry out an automation process. Trainings will cover sessions on How to build a successful Automation project and showcasing of various projects and case studies.