![]() The course is Excel 2010, 2013, 2016, 2019 and Microsoft 365 compliant (previously known as Office 365). Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Excel Ninja! Learn more about how a GoSkills Excel certification can boost your career. In 25 engaging lessons you will learn how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. In the Order list, select the order that you want to apply to the sort operation - alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).įor more information about how to sort data, see Sort data in a range or table .New to Excel or need a refresher? This online course is designed to give you a solid foundation in the basics of Excel. In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. In the Sort by list, select the first column on which you want to sort. ![]() On the Data tab, in the Sort & Filter group, choose Sort. Select a single cell anywhere in the range that you want to sort. Select a single cell in the column on which you want to sort.Ĭlick to perform an ascending sort (A to Z or smallest number to largest).Ĭlick to perform a descending sort (Z to A or largest number to smallest). The range can include titles that you created to identify columns or rows. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |