In: Other Topics

Submitted By ikaran

Words 6127

Pages 25

Words 6127

Pages 25

Karan shah (T.Y BBA) Roll no: - 25 Navrachana University Final thesis

ACKNOWLEDGEMENT

I would like to take the opportunity to thank all the people who have helped me in this project.

First of all, I would like to thank Mrs. Shefali Pillai Madam who has been very cooperative.

I am also very grateful to Mr. Amol Ranadive sir and Mr. Hitesh Bhatia sir for giving me guidance whenever I required completing this research project.

INTRODUCTION

Garnieris a mass market cosmetics brand ofL’Oreal that produces hair care and skin careproducts. The company started as Laboratoires Garnier in 1904, and was acquired by L’Oreal in the 1970s. Current product lines include Fructis shampoos and conditioners, and Nutrisse hair colour. Garnier is sold in numerous countries worldwide, with specific product lines targeted for different skin types and cultures. In 2011, Garnier partnered with TerraCycle to promote up cycling of product containers and the introduction of biodegradable products.

GARNIER VISION

For garnier, beauty is within us all. Every one possesses its own natural beauty and everyone has the power to make that beauty shine through.

For garnier the aim of beauty is happiness and felling at ease with other.

The Garnier Story

Garnier’s history of innovation began with its first product. In 1904, Alfred Garnier began marketing a hair tonic when most people of the time still used soap to wash their hair. In 1936, his company,…...

...1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or......

Words: 7496 - Pages: 30

...Excel Excel ShortCut Keys and Tips Enter data by using shortcut keys To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK) CTRL +......

Words: 3690 - Pages: 15

...ADVANCED EXCEL TRAINING Quality Management Objective To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced ® EXCEL Topics Working with Data Lists Naming Cells and Ranges Conditional Functions Lookup Functions Pivot Tables Data Validation Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box 1. Select the cell or range you want to name. 2. Click the Name box on the formula bar. 3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle. 4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

...1.) According to Miller (2014) “there is generally a direct relationship between price and quantity supplied; as the price rises, the quantity supplied rises”(p. 58). How this concept affects me and my family is that we are victims of the market place. My family and myself cannot rely on prices remaining constant so we may end up having to pay more at times because of the laws of supply and which way that pendulum may be swinging at any given time. In short, because there has been more of a demand for something and therefore more is being supplied, I may even have to do without it because I choose not to buy it due to a price increase. 2.) According to Miller (2014) “another factor is ceteris paribus, conditions of supply; they include the prices of resources (inputs) used to produce the product, technology and productivity, taxes and subsidies, producers’ price expectations, and the number of firms in the industry” (p. 62. How this affects me and my family is let’s say that I was going to buy a refrigerator, the cost of products to produce refrigerators has risen, this will increase the cost of the refrigerator in the long run, at that point it would be best to wait it out and buy when the price evens out again. Another way that this theory affects the economy and my family is that if timber were to increase in price, it would raise the price of resources used to produce homes which in turn increases the price...

Words: 1447 - Pages: 6

...Function keys editing in a cell is turned off SHIFT+F2 adds or edits a cell comment. in excel ALT+F1 creates a chart of the data in the current range ALT+SHIFT insert a new worksheet Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when CTRL+F2 displays the Print Preview window When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. CTRL+F4 closes the selected workbook window Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. CTRL+F6 switches to the next workbook window when more than one workbook window is open. Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL+F9 minimizes a workbook window to an icon. Creates a chart of the data in the current range. SHIFT+F11 inserts a new......

Words: 274 - Pages: 2

...Microsoft Excel 2010 Formulas & Functions Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

...↑ up Arrow ফা ↓ down Arrow তত রিক করয অনায ড়ায ু রফধা নু ারয স্ক্রর স্পীড রিক করয রনন। Microsoft Excel রে একরি Spreadsheet তরাগ্রাভ। আা Microsoft Office এয একরি ং। এরি একরি Worksheet Analysis তরাগ্রাভ। ভূ রতঃ এরেররয াারমে ডািা এরি এফং োনারাআর উবয় ু রফধা ায়া মায়। অভারদয যীক্ষায Marksheet এয ারথ অভযা ফাআ রযরচত। Spreadsheet রে ভাককীরিয ভত এক ধযরণয ছক। Microsoft Word খুররর তমভন কাকয একরি াদা াতা ায়া মায় এফং কী-তফাডক তথরক ররখরত শুরু কযরর াদা াতায় তরখা শুরু য়। ততভরন Excel খুররর াদা াতায রযফরতক তিরফররয ভত একরি ছক ায়া মায় এফং ররতরি ঘরয করয়করি ক্ষয তরখা মায়। এছাড়া এরি ভাককীরিয ভত করাভ (Column) এফং ারযরত (Row) রফবক্ত থারক। A, B, C, D এবারফ করারভয নাভকযণ কযা থারক এফং 1, 2, 3, 4 এবারফ ারযয নাভকযণ কযা থারক। এআ ভস্ত ঘরয ফরিত গারণরতক ংখোরক উয, রনচ, ডান ফা ফাভ, তম তকান রদক তথরক তমাগ, রফরয়াগ, গুণ, বাগ আতোরদ কযা মায়। াধাযণত তমাগ, রফরয়াগ, গুণ, বাগ আতোরদ জরির গারণরতক ভোয ভাধান, ডািায উয রবরি করয রফরবন্ন ধযরণয গ্রাপ ততযী, ডািারক াজারনা রফরবন্ন ধযরণয ডািা ভোরনজরভন্ট, রযংখোরনয রফরবন্ন কাজ Excel রদরয় কযা য়। োকাা্ন্টরয রফরবন্ন কাজ, তমভন- তরজায, রাব ক্ষরত রাফ, Balance Sheet আতোরদ কাজ Excel রদরয় কযা রয় থারক। এজনে Microsoft Excel তক Accounting Package ProgramI ফরা য়। facebook /gmail/skype: - http://tanbircox.blogspot.com Want more Updates http://facebook.com/tanbir.ebooks রনরচয উদাযণ রক্ষে করুন। Excel ফেফায করয একরি ডািারফজ এফং ংরিষ্ট চািক তদয়া অরছ। জবারফ তফাঝারনায জনে একরি ররতষ্ঠারনয PC, Disk এফং......

Words: 4815 - Pages: 20

...Vietnam 0 Phiên bản thử nghiệm – Lưu hành nội bộ - Microsoft Vietnam Mục lục Excel 2010 I. Những điểm mới trong Microsoft Excel 2010 .................................................................................. 7 Thêm tính năng Sparkline ........................................................................................................................ 8 Tính năng Slicers...................................................................................................................................... 9 Định dạng dữ liệu có điều kiện .............................................................................................................. 10 PivotTables và PivotCharts..................................................................................................................... 11 Share Workbook.................................................................................................................................... 12 I. Nội dung chính .............................................................................................................................. 12 Chương 1: Làm Quen Với Microsoft Excel ...................................................................................... 12 1.1 Giới thiệu Excel ...................................................................................................................... 12 Excel là gì:......

Words: 43133 - Pages: 173

...P rate and y = T P rate. Possible values range from (0, 0) to (1, 1). The “classiﬁcation” that assigns “Test Negative” to every score has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classiﬁcation” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Deﬁnitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability:......

Words: 4475 - Pages: 18

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

...Exam Case PRACTICE Exam From the Pivot Info sheet: a) Create a Pivot Table on a new worksheet that Averages the Sales amount by Specialist (row label) and Date (column label). b) Use the Group Field property to display the Date field by month (p. EX 289). Click on one of the dates, click the Group Field button in the Group group then click Months c) Format the values as Currency with two decimals Hint: You should see four columns: Jul, Aug, Sep and Grand Totals. The Grand Total should be $477.42. The Aug Total should be $700.00 d) Rename the sheet with the Pivot Table. Use the name PivotTable (space removed). e) Add a Slicer to Filter by Type of Customization and apply it to show only Pin Striping. Your Grand Total should be $3,930 On the January sheet: a) Group (p. EX 304) the January, February and March sheets together: b) Calculate the difference between each product group: Actual-Forecast. c) Calculate the % change for each product group: Difference/Forecast d) Calculate the total revenue for the Forecast, Actual, and Difference columns, and then calculate the total %Change e) Ungroup the sheets f) Make a copy of the March sheet and name it Summary. Place the Summary sheet right after the March sheet. Delete B5:C9 from the Summary sheet. You will create 3-D cell reference formulas (also known as drilling formulas) to total data across the months. g) On the Summary sheet in cell B5, create a 3-D cell reference......

Words: 1218 - Pages: 5

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2

...Using Microsoft Excel Getting Started Using Microsoft Excel About Excel What is a Spreadsheet? Microsoft Excel is a program that’s used for creating spreadsheets. So what is a spreadsheet? Before personal computers were common, “spreadsheet” referred to large sheets of lined paper, which were used by people in various businesses to record facts and figures in rows and columns, and then make calculations based on the information. When personal computers first began appearing, one of the first applications was a program released in 1979 called VisiCalc. It was used as a tool for performing spreadsheet style calculations that would have been to difficult to do on a calculator. The program quickly became so popular that people began buying personal computers for their businesses just so they could use VisiCalc. VisiCalc Since then, many other spreadsheet programs have been popular over the years, such as Quattro Pro and Lotus 123. Microsoft Excel was first released in 1985 with newer versions being released every couple of years. The most recent version is Excel 2003 (version 11). © Stephen O’Neil 2005 Page 1 Of 17 www.oneil.com.au/pc Using Microsoft Excel Getting Started How Do Spreadsheets Work? Computer spreadsheets are based on their old paper formats. A spreadsheet on a computer uses rows and columns to record information such as text and numbers, such as the example below. Graduates from University 1996 1997 1998 1999 2000 2001......

Words: 4397 - Pages: 18