Convert text to columnsObjective: Certification exercises: Split the content of cells into different Use practice 11 for Excel columns Approximate time: 10 minutes Preview Convert text to columns 1.- Data tab 2.-Data Tools group 3.-Text to columns 4.-Follow the wizard Home button : Press this button to return to the topic index. Preview box : You will find a quick visual guide about the topic to easily locate the exercise to be done. Certification exercises box : Sometimes you will find a link to a practical exercise with the data you need for reviewing what you know. Color box : It mentions the certification topics that are covered in thatObjective box : slide.It explains the required objective andemphasizes the learning of thecertification topics. Finally, there is a set of steps to graphically follow the use of the tool. Topics are developed with specific exercises in each slide. Methodology Each slide has a color box that corresponds to a topic to develop, focused on a particular objective. Content 31.View tab 32.Allow multiple users 33.Use Functions CountIf 34.Draw shapes 35.Formulas with absolute references 36.Show and print formulas 37.Use topics to give format to spreadsheets 38.Protect workbooks and sheets 39.Split screen
#Office excel 2007 tutorial series
Content 15.Apply the feature for compatibilityMethodology 16.Apply quick styles to tables (design) 17.Find data using a formula 18.Vlookup and Hlookup functions 1.Convert text to columns 19.Calculate subtotals 2.Apply quick styles to tables 20.Mark workbooks as final 3.Modify pictures 21.Save a book with enable macros 4.Use Count Function 22.Format painter 5.Copy a series 23.Select sources of data 6.Hide and show rows and columns 24.Use the document inspector 7.Use advanced formulas 25.Insert, modify and delete comments 8.Move and resize graphic objects 26.Sort data using criteria 9.Summarize data using functions (average) 27.Add and remove graphic elements 10.Rules for conditional formatting 28.Copy and move spreadsheets to another workbook 11.Custom format of the cell 29.Change the type of charts 12.Delete duplicated data within a table 30.Filter and sort data 13.Change the size of ranges 14.Restrict data using data validation And the Vlookup function will return the contents of column number 6. It will look for it in the cell range A3 to F9 (the dollar signs signify an absolute cell range). This function will look for whatever is entered into cell H4. Enter each one into the required field and click OkĪn example Vlookup function would look like below. * Range Lookup (Are you looking for an approximate or exact match?)Ĥ. * Col Index Num (The number of the column that holds the data you want to return.) * Table Array (Where can Excel find this Lookup Value?) * Lookup Value (What you are looking for?) These pieces of information are known as arguments. The Excel Vlookup function needs 4 pieces of information in order to work. Click on the Lookup and Reference button in the Function Library group Click on the Formulas tab on the ribbonĢ. To use the Vlookup function in Excel 2007:ġ. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel. Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table.
0 kommentar(er)
