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 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |