Information and Communications Microsoft MS Excel 2013, 2016, 2019 and 365 (Basic to Intermediate)

Understand the main functions of Excel Do simple to intermediate worksheets independently

4hrs Purpose of Excel Navigate and Select Cells in Worksheets Create a Basic Worksheet Inputting data Fixed-Width Fonts Inserting, Renaming, Deleting Rows and Columns Add Borders and Colours to Cells Change column width and row height Merge Cells and Wrap Text Apply Number Formatting Apply Font Properties Edit Worksheet Data Find and Replace Data Autofill Data Data Segregation using Text to Column Working with Lists – Sorting and Filtering (> versus >=, < versus <=, AND versus OR). Sort and Filter by Color Deleting Every Other Row 4hrs Create Formulas in a Worksheet Understand commonly used Functions like SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, ROUND, ROUNDUP, ROUNDDOWN. Insert Functions in a Worksheet Reuse Formulas Create Formulas using $ sign IF, SUMIF and COUNTIF Insert Text to Column Transposing Data Inserting Header and Footer Align Content in a Cell Apply Page Break, Split and Freeze Panes Creating 2D and 3D Charts >Showing Data Labels, Legend, Titles, Format Moving and copying Worksheet Inserting, Renaming, Deleting, Hiding Worksheet Save and Print a Worksheet