Excel Basic Functions and Formulas
About This Course
This course provides a practical introduction to Microsoft Excel formulas and functions. It focuses on building a strong foundation in essential tools used for data entry, text handling, calculations, statistics, dates, and logical operations.
Learners will gain hands-on experience using real-life examples similar to workplace tasks such as splitting names, calculating ages, working with dates, counting data, and applying logical tests.
Learning Objectives
Understand and use essential Excel formulas with confidence
Calculate percentages, increases, decreases, and original values
Split and combine text using key text functions
Analyze data using COUNT, COUNTA, COUNTBLANK, and COUNTIF
Work with dates: calculate age, convert text to dates, and use date functions
Use shortcuts like AutoSum and show-all-formulas to work faster
Clean, organize, and prepare data for reporting and analysis
Material Includes
- Learners will receive:
- ✔ 22 Excel lesson videos
- ✔ Practice Excel files (datasets for exercises)
- ✔ A full course PDF/Word handbook (if you want, I can generate it)
- ✔ Slide presentations for each lesson
- ✔ Step-by-step instructions and formulas
- ✔ Final assessment (optional)
- ✔ Certificate of completion
Requirements
- A laptop or computer
- Microsoft Excel (2016, 2019, 2021, or Office 365)
- Basic computer literacy (open, save, type, navigate windows)
- Internet connection (for watching lessons)
Target Audience
- This course is suitable for:
- Beginners with little or no Excel experience
- Students and job seekers needing Excel skills
- Office, admin, NGO, humanitarian, and data-entry staff
- Finance and reporting officers
- Anyone who wants to work faster and smarter with Excel
- No prior technical skills required — just basic computer use.
Curriculum
22 Lessons
Lesson 01: Split Forename & Surname
Learn how to separate a full name into first name and surname using text functions such as LEFT, RIGHT, MID, and FIND. This lesson is essential for cleaning imported datasets and sorting names properly.
Split Forename & Surname18:02
Lesson 02: Percentage Increase
Understand how to calculate percentage increases in Excel using simple formulas. This lesson includes salary change, profit growth, and budget increment examples.
Lesson 03: Percentage (General Basics)
Explore how percentages work, how to convert numbers into percentages, and how to correctly apply formatting to avoid common errors.
Lesson 04: Percentage – Budget Calculation
Learn how to calculate budget allocations, remaining percentages, and distribution of funds using percentage formulas.
Lesson 05: Percentage – Finding Original Value
Understand reverse percentage calculations — for example, finding the original price before a discount or tax.
Lesson 06: Brackets in Formulas (Order of Operations)
Learn how Excel prioritizes calculations using PEMDAS/BODMAS. Understand when and why to use brackets to control complex formulas.
Lesson 07: Show All Formulas (Ctrl + `)
Master the Excel shortcut to instantly display all formulas in your sheet. This lesson helps in auditing worksheets and fixing errors.
Lesson 08: Age Calculation (Using DATEDIF)
Learn how to calculate age in years, months, or days based on a date of birth using the hidden DATEDIF function.
Lesson 09: AutoSum Shortcut Key (Alt + =)
Save time by learning the quickest way to sum entire columns or rows. Great for financial records, totals, and quick summaries.
Lesson 10: AND Function
Understand how the AND function tests multiple conditions and how it is used inside IF statements for logical decision-making.
Lesson 11: AVERAGE Function
Learn to calculate the average of a dataset while understanding how Excel handles blank cells, text cells, and zeros.
Lesson 12: CONCATENATE / Text Join
Learn how to combine text from multiple cells into one using CONCATENATE, TEXTJOIN, and the & operator. Useful for names, messages, and reports.
Lesson 13: COUNT Function
Understand how to count numeric values in a dataset and when to use COUNT instead of other counting functions.
Lesson 14: COUNTA Function
Learn how COUNTA counts all non-blank cells (text + numbers) and when it is used for inventory, attendance, or general data checks.
Lesson 15: COUNTBLANK Function
Explore how to count blank cells in a range. Very useful for data validation, missing data checks, and reporting.
Lesson 16: COUNTIF Function
Learn how to count values that meet a condition (e.g., "How many passed?", "How many are Male/Female?", "How many > 50?").
Lesson 17: DATEDIF Function – Advanced Examples
Deepen your understanding of DATEDIF by calculating months, weeks, days, and differences between any two dates.
Lesson 18: DATEVALUE Function
Learn how to convert text-formatted dates into true Excel dates so they can be sorted, filtered, and used in formulas.
Lesson 19: DAY Function
Understand how to extract the day (1–31) from any date. Useful for scheduling, payroll cycles, and time-based analysis.
Lesson 20: DAYS360 Function
Learn the 360-day year calculation method used in accounting systems and how to calculate the number of days between two dates.
Lesson 21: EDATE Function
Understand how to add or subtract months from a given date — important for loan schedules, expiration dates, and planning.
Lesson 22: EOMONTH Function
Learn how to find the last day of any month, including future or past months — useful for month-end reports and finance tasks.
Your Instructors
micraaj2026@gmail.com
See more
$11.00
Material Includes
- Learners will receive:
- ✔ 22 Excel lesson videos
- ✔ Practice Excel files (datasets for exercises)
- ✔ A full course PDF/Word handbook (if you want, I can generate it)
- ✔ Slide presentations for each lesson
- ✔ Step-by-step instructions and formulas
- ✔ Final assessment (optional)
- ✔ Certificate of completion