Saturday 20 June 2015

NESTLE (Mineral Water brand) innovative advertising

[WATCH VIDEO]




CONTREX is a brand of mineral water owned since 1992 by NESTLE waters.
It was discovered in French department of Vorges by Dr. Bagard.

IKEA innovative advertising

PEPSI innovative advertisement

COCA-COLA innovative advertisement



                    

Tuesday 2 June 2015

WHY EXCEL FOR M.B.A ?

1.Audit tool bar.The audit tool bar traces graphically which cells are included in a mathematical formula for a given cell—a real lifesaver to catch embarrassing errors that inevitably happen.
2. Quickly sum up numbers.This is the most common mathematical function used in Excel. Simply highlight the cell where the result is to appear and press ALT plus +.
3. Auto fill series.Spreadsheets are traditionally about some type of series. Save a lot of time in the typing of months or any series by using auto fill and that way you don't skip anyone item in that series as well.
4. Freezing highlighted panes.This is helpful in any spreadsheet so cells remain visible while data is entered further down the page. It can be especially useful when comparing facts and figures throughout the sheet.
5. Conditional formatting.This allows users to automatically change the appearance of cells to meet any specifically defined criteria. This conditional formatting technique identifies important data that is critical to many analyses.
6. Pivot Tables.They allow users to take raw data in any form and organize it in a myriad of different ways for sorting data into tables. It can be used to look at revenue data by client, by type of offering, by month booked, or by whatever descriptive fields are captured.
7. Change the name of the "Sheet" page.Just right click on Sheet 1, and rename it. This is especially helpful when using multi-pages within one document.
8. Keyboard shortcuts Like (F7 for Spell Check) are incredibly useful. (As are many others.)
9. The new Sparkline feature, or sometimes called "micro charts," Illustrates trends within tables. It gives the reader a quick view of the trend and overall direction.
10. Text to columns. This feature helps parse data into columns. It can be used to cut and paste tables from the Internet into an Excel spreadsheet and split this data into columns, which can then be used as tables. It is particularly useful when pasting from a PDF document.

NOW ROBOTS TO KILL CORONA VIRUS

Schools closed, colleges closed. Malls empty , flights grounded and even international borders closed. But hospitals are still open , docto...