This course is ideal for students and professionals who wish to familiarize themselves with the basics of Excel.
Course contents:
1. Excel Basics - Navigating through the excel
2. Data Manipulation - Working with rows & columns, using Auto Fill & Fill options, using data validation, sort & filter
3. Formatting & Conditional Formatting - Applying formatting styles & themes, usng conditional formatting
4. Formulas & Functions - Understanding Cell References (Absolute & Relative), Working with common functions (IF, Nested IF, And, OR, Not), Vlookup, HLookup & XLookup, Using Text & Date Formulas
5. Data Analysis - Creating & Analyzing the data using Pivot tables & Graphs.
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.