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

One Day Workshop on Advance Excel 2007 (July 22, 2012)

About the Course:

How to deal with numerical data, to convert data into Business Specific information. To get right result, one should know what can be done with the data.

Business person, Management  Professionals, Sales, Chartered Accountant,  we all deal with numerical data. To assist you with all of your data and provide you business solution MIS related needs there is beautiful application MS-Excel.

Let's explore the beauty of MS-Excel

Topics Covered:

Module 1: Overview of the Basics
Interacting with Excel(2007) screen

Difference between Excel 2003 and Excel 2007 Screen

Module 2: Cell Reference and its usage in formulas
Absolute and Relative and Mixed cells reference

Preferred References in Formula

Module 3 A: Working with Functions
Writing conditional expressions (using IF, NESTED IF)
Using logical functions (AND, OR, NOT, COMPOUND IF)

Other Functions:

Date and time functions

Text functions: Right, left, trim, Ltrim, Rtrim, Mid, instr, substr etc.

Database functions: Dsum, Daverage etc.

Mathematical Functions: Sum, Sumif Count, CountA, Count blank etc.

Difference Between Sum, Sumif  and count, CountA functions

Using lookup and reference functions (VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH)

Module 3 B: Evaluation of Formula

Understanding Formula Evaluation concept

Using "Evaluate Formula"

Module 4: Named Ranges

Named Ranges

Application of Named Ranges

Preferring Named Ranges over other

Module 5: Handling Errors

Types of Error

Ways of handling Errors

Module 6: Data Validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations

Setting Input and Error Messages

Module 7: Sorting
Sorting tables
Using multiple-level sorting
Using custom sorting

Module 8: Data filter

Filtering data for selected view (AutoFilter)
Using Advanced filter
Different option available for Filtering the data.

Module 9: Conditional Formatting

Setting new Rules

Editing and Clearing Rules

Using different Kind of Conditional Formatting

Managing the Rules

Module 10: Data Consolidation

Data Consolidation need

Types of Data Consolidation

Using Data Consolidation in real time environment

Module 11: Macro Basics

How to record a Macro

How to Save, Run Macro

Editing the existing Macro.

Who should attend:

Management Professionals dealing with Data
MIS personnel
Business person
Commerce field, C.A./Would be CA

Managers

What you need to bring:

Laptop-if you have one.(If you are looking for Computer facility, would like to be informed well in advance.)
USB

Key Takeaways:

Ability to manage your data.
Knowledge specific to Business Solution no matter which field you are in.

Opportunity to meet people from varied fields with same interest

Training Timing:

Timing: 9:30 AM- 6:00 PM

Seats: only 20

Venue: Koramangla, Bangalore

Date: July 22, 2012

For details mail me techie.excel@gmail.com

About Me: I am experienced and well qualified professional with 9.5Years of experience.

 I am MS-Information Technology and MS-BI. I have joined the IT industry as a Trainee Programmer and left the full time job of Technical Consultant in 2011. Since then, I am rendering my services as Technical Consultant(Business Solution & Analysis) & Trainer.

Training Assignment I undertake are as follows:
Expertise Area: MS-Excel, Excel with VBA(Macro), MS-Word, MS-Access, MS-Power Point
Level: Beginners, Mid and Expert Level

Thanks for your time.

Regards

Rashmi Sachdeva

MS-Information Technology, M.Sc(BI)

Freelance Technical Consultant (Business Solution & Analysis) & Trainer

techieexcel.blogspot.in

http://in.linkedin.com/pub/rashmi-sachdeva/51/252/888

Online training available.
For details mail me techie.excel@gmail.com

Format Row and Column headers - Excel 2007

  Format Row and Column headers - Excel 2007

It is feasible to format the Row Numbers and Column Heading in Excel 2007 and Earlier versions.

Here I am going to explain it in Excel 2007.
Go to Home tab, under the "Styles" group there is a drop down for Cell Styles. Click on the drop down.
The very first click-able option is "Normal" under Good, Bad and Neutral. 

Picture1.1 Cell Style

Picture 1.2 Modify

Picture 1.3 Style dialog Box

Right Click "Normal". "Normal" option shows the Font type, size, and other default behavioral value for Excel Row/column and Excel sheet in general.  In the shortcut menu, select "Modify". ( As shown in Picture 1.2 Modify)

Once you click over there. You will get "Style" dialog box with a "Normal" type of formatting. "Normal" type of format comprises of Font type "Calbri" font size 11, with no borders, no shading General Alignment for both. ( As shown in Picture 1.3)

Row and Column Header are formatted with Wingding font. ( As shown in Picture 1.4) 

Picture 1.4  Column and Rows with Wingding Font

Selecting Color in Fill Tab of Format will fill color in Excel sheet, and not in Row/Column headers. See the Row/Column Header font changed to "Lucida Handwriting". ( See picture 1.5 Fill option used)

Picture 1.5 Fill option used

Note: To see the enlarge view of pictures, click on the required picture.

My Blog..

My First blog 

I am newbie to this blog thing.Its my first attempt to write article online.

If you ask me, why I thought of writing blog? Why when we do have a number of articles written by professionals, and are easily available on the Internet?

Then my answer will be, something is missing.  As a professionals, we do have access to big data repository through Internet. However still we are not able to make best use of things. Reason is.. For all of us..Time is big constraint.

For guided journey in Technical field, a number of articles are there. However because time shortage, we are not able to reach the best solution. And we opt for something that's easy or not so professional or easy to implement however not foolproof.

So this blog is sincere attempt to be of help, to Technical community we all belong to..

**Excel Community**

Through this Blog I also want to thank to all who has constructive contribution toward what I am today..

Lets Excel in MS-Excel..

About me:

I am experienced professional with Total 9.5 Years of experience. I have joined IT industry as Trainee Programmer and left the full time job of Technical Consultant in 2011. 

Since then I am rendering my services as Freelance Technical Consultant
(Business Solution & Analysis domain) & as a Corporate Trainer.

Welcome to My blog..

Techieexcel.blogspot.in

For consultancy & training related queries, mail me at techie.excel@gmail.com .
Your queries will be answered within 24hours. Keeping in mind difference in time zones 24 hours window is required.