MS EXCEL FOUNDATION
Our MS Office foundation is a starter programme targeted at fresh and entry level staff of organisations. This programme is highly recommended for the training schools of all companies where entry-level staff are thought the rudiments of the operations of …
Overview
Our MS Office foundation is a starter programme targeted at fresh and entry level staff of organisations.
This programme is highly recommended for the training schools of all companies where entry-level staff are thought the rudiments of the operations of the organisation.
Curriculum
Curriculum
- 3 Sections
- 26 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- INTRODUCTION TO EXCEL11
- 1.1Overview of the Excel Foundation6 Minutes
- 1.2Overview of the Excel Workbook6 Minutes
- 1.3Introduction to Excel Ribbon6 Minutes
- 1.4Basic Arithmetic5 Minutes
- 1.5Data Copy, Move and Delete7 Minutes
- 1.6Numbers, Cells and Range Formatting9 Minutes
- 1.7Basic Sheet Linking5 Minutes
- 1.8File and sheet restriction using password 16 Minutes
- 1.9Sheets Creation and Management6 Minutes
- 1.10Rows and Columns Adjustment10 Minutes
- 1.11Rows and Columns Adjustment – 28 Minutes
- WORKING WITH LISTS AND VISUALIZING DATA WITH CHARTS7
- INTRODUCTION TO EXCEL FUNCTIONS9
- 3.1Overview of Excel Functions7 Minutes
- 3.2Absolute cell reference6 Minutes
- 3.3SUM, AVERAGE and SUMIF8 Minutes
- 3.4MAX, MIN, LARGE and SMALL5 Minutes
- 3.5LEN, UPPER, LOWER AND PROPER6 Minutes
- 3.6IFS and RANK8 Minutes
- 3.7VLOOKUP Function10 Minutes
- 3.8MS EXCEL FOUNDATION – ASSESSMENT EXERCISES10 Questions
- 3.9Data Presentation and Reporting Quiz