February 22, 2022
Microsoft Excel
Day-to-day Tools
7
video(s)
Microsoft Excel is a very popular and powerful tool for any kind of tabular data representation. It helps to capture data, format data and analyze data using charts. Excel can have powerful mathematical formulas as well.
Excel 1 - File, Worksheets basics - Need for tabular format, rows, columns, xlsx files, worksheets
Excel 2 - Text formatting - Font types, font size, bold, underline, italics, text color, fill color, cell border
Excel 3 - Filter and Sort - Auto filter, show rows based on filter, sort on one or more columns
Excel 4 - Cell formatting - Vertical align, horizontal align, wrap text, merge cells, change cell height and width
Excel 5 - Currency and Date formats - Format date values, format currency values, decimal places, calculate total
Excel 6 - Charts - Drag fill values, create 2d bar charts, create 3d bar charts, draw line charts, configure charts options
Excel 7 - Essential formulas - Apply banking interest formula, calculate sum, calculate the count based on conditions
