This course is ideal for students and professionals who wish to familiarize themselves with the basics of Excel.
Course contents:
- Entering Data & Editing
- Insert & Delete Rows & Columns
- Insert, Rename, Delete Worksheet
- Save, Open & New Options
- Data Selection
- Cut, Copy, Paste & Fill
- Undo, Redo
- Format Painter
- Cell Referencing – Absolute, Relative & Mixed
- Formatting Options
- Cell Type
- Cell Range
- Excel Functions - Sum, Product, Power, Sqrt, Int, Ceiling,Floor, Round Roundup, Rounddown, Today, Now, Lower, Upper, Proper, Len
- If, And, Or Functions
- Sort & Filter functions
Number of classes : Five
This course is designed for beginners, whether students or professionals, who are new to Excel. By the end of the course, participants will be confident in using Excel and creating spreadsheets. Upon completion, students can progress to an advanced Excel course that focuses in-depth on data analysis. The course will be conducted as a group class over five days, with one-hour sessions each day.