Cosultant & Trainer

Excel, Access based Project

At present, I am rendering my services as a Consultant to three companies one from each US, UK and Europe.

Application I have developed are from both IT, and Non-IT areas.

·         Trading Application, Including automation of Invoice, Client Management, Supplier Management, Expenses and Profit Report. Automating PDF creation, Forecast. Various Kind of Graphical Report

·         For Mid Level to High Management: Compliance Report, Factors Dependency on kind of media used, Penalty based on Failures based on Priority Based criteria

·         Customized Application for Renovating Home/Office Companies to name a few.

Developed Project are for US,UK and Europe Based companies.

If you are using MS-Excel, MS-Access for your Companies. And looking for some assistance irrespective of how small or big your project is. It may require an hour of consultation or project that require weeks of work from requirement phase to successful completion of project.
Your queries are always welcome. Contact me at techie.excel@gmail.com

OFFLINE AND ONLINE TRAININGS..

I am Consultant and Corporate Trainer. 

As a Consultant, I love taking challenge from my own field, and As a Trainer I keep updating myself. Once you stop learning, your start feeling stagnation.

Having trained 5000+ professionals from Sales/Marketing/Finance/Accounts fields, I started initiative of training professionals online.

I undertake training assignments in following. 

1. Basic Excel 
2. Functional Excel 
3. Advance Excel
4. Excel with VBA
5. MS-Word- Basic, Intermediate and Advance Excel
6. Complete Power Point

For all above course outlines Offline and Online both training are available. For online trainings I prefer using webex.

Contact for your Training Assignment at techie.excel@gmail.com

Advanced Excel 2007

2-day Crash Course in Advanced Excel 2007

Module 1:  Understanding The Excel Screen

Navigating in a spreadsheet   Understanding worksheets, columns, rows and cells   Saving, opening, and closing workbooks Formatting numbers ,Clearing formats Managing records, Recognizing and Correcting blank, errors, duplicates through navigation techniques. Applying borders to cells  Merging cells Using text files with Excel Compatible file formats with Excel Inserting other applications in Excel Hyperlinks and Bookmarks in Excel  Intersection operators in Excel Module 2: Formatting a Spreadsheet Changing column widths and row heights  Changing alignment of cells Undoing and redoing actions Formatting numbers Clearing formats Applying borders to cells  Merging cells   Module 3: Working with Ranges

Working with ranges, continuous, dis-continuous, Intersecting ranges    Module 4: Working with Large Worksheet Freezing and unfreezing panes  Splitting windows  Inserting page breaks for printing  Module 5: Named Ranges

.

       Module 11: Using Subtotals for Reporting Purpose

	Creating subtotals  Multiple-level subtotals Module 12 & 13:
	Reports Using Pivot Tables and Consolidation(2 Modules)
	Module 16: Practice Exercise based on All 15 modules.

--------------------------------------------------------------------------------------------------------

Workshop scheduled on :November 17 and November 18, 2012

Timing: 10:00- 18:30

Bangalore - 560064