Tools - Microsoft Excel

Microsoft Excel 1 - File, Worksheets basics

Need for tabular format, rows, columns, xlsx files, worksheets

Microsoft Excel 2 - Text formatting

Font types, font size, bold, underline, italics, text color, fill color, cell border

Microsoft Excel 3 - Filter and Sort

Auto filter, show rows based on filter, sort on one or more columns

Microsoft Excel 4 - Cell formatting

Vertical align, horizontal align, wrap text, merge cells, change cell height and width

Microsoft Excel 5 - Currency and Date formats

Format date values, format currency values, decimal places, calculate total

Microsoft Excel 6 - Charts

Drag fill values, create 2d bar charts, create 3d bar charts, draw line charts, configure charts options

Microsoft Excel 7 - Essential formulas

Apply banking interest formula, calculate sum, calculate the count based on conditions