Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats. We will use advanced functions to repackage data into more useful forms, such as correctly formatted addresses, using the CONCATENATE function to pull data together from two or more columns. From there, we will construct logical comparisons between given and expected values using IF.THEN.ELSE statements to make data more readable, locate information in a workbook, and avoid duplicate entries. We will also learn to use Data Validation criteria to keep data accurate and streamline input with dropdown lists. In this course, we will discover how to formulate smarter worksheets by understanding Excel's time format and using Date Calculations such as TODAY and YEAR. Microsoft Excel has hundreds of features, functions, formulas, and other things that can make managing your data easier.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |