## Advanced Topics in Excel :

Excel over view

The Date in Excel

Excel Conditional Formatting

Excel VLOOKUP

Excel HLOOKUP

Using Excel’s Goal Seek Feature

Create Excel Pivot Tables

Microsoft Excel Sort Feature

Introduction to Using Macros in Microsoft Excel 2003

Protect Excel Sheet

Data base in excel

Copy, paste special function

Data showing thru Chart / graph

Working with share workbook

Data filter

Subtotal

Validation

Find & replace

## Microsoft Excel – Course outline

Are you want to learn MS Excel online? A free training session available for short time. What topic you want to learn? comments here

 Question Y/N Question Y/N Write basic formulas, eg = A1*A2 Write formulas using brackets where required, eg =(A1+A2)/A3 Write basic functions, eg SUM, AVERAGE,MAX, MIN Selecting ranges with cells together and separate Understand Absolute and Relative References in formulas, eg =B7 + \$A\$3 Create simple charts Create Logical functions, eg IF, AND, OR, NOT Create a nested IF function (multiple IF statements in the same function) Concatenate (join) text Trap errors using IFERROR Paste Values from formulas Change Calculation method, eg Manual or Automatic Create custom formats for numbers and dates Use Conditional Formatting Change the Page Layout, eg Margins, Headers, Footers, Background, Orientation, Paper Size Use Scale to a Percentage or to Fit when Printing Use different Views, eg Page Break Preview, Page Layout Insert and delete columns, rows and worksheets Hide and unhide worksheets Move and copy worksheets to the same or a different workbook Freeze row and/or column titles Use Find and Replace to change formulas Sort a list (including multiple sorts) Use Filtering – Compound filters, Multiple value filters, Custom filters Modify charts – adding titles, data tables, Trend lines, Error bars, text boxes Create a VLOOKUP function in both it’s forms and know the difference between them Create CHOOSE, INDEX, MATCH functions Create reference functions, e.g. ROW, COLUMN, ADDRESS, INDIRECT, OFFSET Modify charts – changing shape styles, colors, fills, shape effects, themes Create, use, modify and delete range names Create range names using text labels or a selection Create worksheet specific range names Using range names in formula Protecting cells, ranges, worksheets and workbooks Use automatic Subtotals (rather than manually creating them) Create and use Relative Names for Subtotals Linking between Worksheets and Workbooks Consolidate data from many workbooks into one workbook Create Pivot Tables Use Pivot Tables: Group, calculate, Slicer Create Pivot Charts Use the data analysis tools Goal Seek and Solver Use macro

These are basic level MS Excel training outline, if you interested to learn advance level formula and formatting, also write us / comments here

## IMO Offer !

Now enjoy Monthly 2GB IMO on Pakistan’s No. 1 Data Network.

Make IMO video & voice calls to any network at just Rs. 20

Simply dial *466# and enjoy all features of IMO anywhere and everywhere on Pakistan’s largest 4G network.

### Zong subscribers can enjoy all features of IMO at Rs. 20! Simply dial *466# once

All features of IMO are included in this offer, including:

Video & voice calls

Picture sharing

Text & voice messages

#### How to Subscribe

Dial *466# to subscribe

#### Data Usage Check:

Dial *102#

Charges 10 Paisa per inquiry

#### Terms and Conditions

• This offer is available for all Zong subscribers including Prepaid, Postpaid, MBB & Internet SIM
• This offer is auto-recursive
• Your SIM is your identity; only use SIMs issued through Biometric Verification – PTA
• Unwanted and unethical (unreasonable) messages can be reported by texting SENDER’s NUMBER (SPACE) message to 9000 –PTA

## WhatsApp Offer!

Now enjoy Monthly 4GB WhatsApp on Pakistan’s No. 1 Data Network.
Make WhatsApp video & voice calls to any network at just Rs. 20
Simply dial *247# and enjoy all features of WhatsApp anywhere and everywhere on Pakistan’s largest 4G network.

Zong subscribers can enjoy all features of WhatsApp at Rs. 20! Simply dial *247# once
All features of WhatsApp are included in this offer, including:

Video & voice calls
Picture sharing
Text & voice messages

How to Subscribe
Dial *247# to subscribe

Data Usage Check:
Dial *102#
Charges 10 Paisa per inquiry

Terms and Conditions
This offer is available for all Zong subscribers including Prepaid, Postpaid, MBB & Internet SIM
This offer is auto-recursive
Your SIM is your identity; only use SIMs issued through Biometric Verification – PTA
Unwanted and unethical (unreasonable) messages can be reported by texting SENDER’s NUMBER (SPACE) message to 9000 –PTA

## Tips To Earn Extra Money & Income Online

Tips To Earn Extra Money & Income Online!

There are many tips to earn extra money online these days because we all live on this Internet world. The electronic world has helped us to make money online easily by promoting big companies. They make money and we make money. We do not earn as much as them but enough to cover our lifestyle. On average, you spend about two hours a day online, you can earn probably \$1000 in the first month, \$5000 a month one year later, and \$10,000 a month five years later. Some people make more than that amount because they are smarter or work harder than you. We just point out the number so you can estimate how much you make to earn extra cash in your free time, instead of watching TV shows, you make money online.

You do not need to be a webmaster or web developer who must know how to create a website. You can create a blog using WordPress or Blogger without knowing web skills. You should know how to write an article to advertise your blog. This is one of the best method to get traffic for your web site. You write articles and submit them to social bookmarking sites, article directories, and any other places. If you article gets 1000 readers, they go to your website, you can think how much you earn for just \$.50 per click. You can get \$500 easily a day if you get 1000 clicks. You can think about it thouroughly and when you understand it, you will become a millionaire. It is just about working hard to gain experience from it.

When working online, you must investigate which method to use. The best online money making method is Google AdSense affiliate profile that they pay you for each unique click from your website. The more traffic you have, then the more clicks you earn. You can make a lot of money online for free using this way because you do not cost anything. So, starting creating a blog and write some articles that you are good at. You post these articles on your blog and submit them to social bookmarking services. You keep doing like this for about one month, you will see that the best possible results. The longer you do, the more customers accumulated on your website so the more money you make online. Read these free tips to earn extra income is the start.

## Earn Money Online By Working for Google

### Earn Money Online By Working for Google

Earn money online by working for Google is simple and easy because you do not invest any money at all. You will get a free job to work on your flexible time and day. All you work will be done from home so you do not worry about traveling anywhere else. Working from home has been popular in the last few years when the Internet market booming in Western countries as well as Asian countries. Consumers buy thing on the Internet instead of going to the stores because of its convenience and ease. So, your job is to promote these stores and earn money from valid clicks that consumers click from your websites. You will earn up to \$10.00 or more per valid click so you can make thousands of dollars a month easily.

Thousands of webmasters quit their daytime jobs to work full time only when they earn enough money online. They prefer to work for themselves instead of working for somebody else, and have their boss look on their back all the time. Working on the Internet has been famous in America and other countries. You can read our resources and other articles to learn more about making money on line. You do not need to be expert in web design or development to work from home. All you need is the patience and diligent mind of work to continue work while learn. The more you work online is the better and more you will learn from your failure. You will succeed if you try hard enough by working for Google.

Does not require you to have a diploma or any certificates or degree. You can work on Google at anytime and any place you like. You will never loose anything when working online, except your time. There is no fee to start your job. There are many millionaires on the Internet who started out as you. They have not have any experience as you now. What they had is the patience to work for low extra monthly income, then move up with big money. What they had is to learn from their failure and work to learn. They work hard and they work smart to earn what they have right now. You can work and learn as them and you may be more successful than them. You can be a billionaire by working on net.

How to make money online is the question that all of us want to know. There is no secret for making online money. You will get free tips of how to earn online money. Some webmasters sell out their secrets for some money. You can buy these tips to learn of making Internet income. I have not bought any books but I spend my time in searching for good tips and apply them myself. I think the webmasters combine their knowledge and other resources to create a book and sell it out. So, their labor can charge money when they sell their books out. Anyway, you should take an action now by working online for Google and start making money in your free time. You should not wait any longer. Your opportunity is awaited.

Below are the steps you need to do: