Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells.Ĩ. If you work with PivotTables a lot, you know that they put information out the way users want to read it, but you can't use it to drive another PivotTable.ħ. Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data). Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table.ĥ. Learn to sort data in Excel by a single column or by multiple columns. Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.Ĥ. Learn about working with absolute and relative cell referencing, and techniques for copying formulas.ģ. Recognize the main terms used to describe Excel’s work canvas.Ģ. Identify the terminology and elements of the Ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |