$ 14.99

Lifetime access

Abshir Mohamed Abdirahman

The course starts on TODAYOctober 10, 2025

Course will end on December 09, 2025

5 Weeks (1-3 hours per week)

Last update on October 06, 2025

Advanced Excel for Business and Finance

somX

Master advanced Excel functions and real-world financial applications to streamline accounting, reporting, payroll, and data analysis for business and finance.

Somali

Self Paced

Verified certificate

ABOUT THIS COURSE

The Advanced Excel for Business and Finance course is designed for professionals, students, and entrepreneurs who want to use Excel as a powerful accounting and financial management tool. This hands-o

What you'll learn

1. Essential & Advanced Excel Functions

2. Practical Financial Applications.

3. Accounting Cycle in Excel.

4. Payroll & Expense Management.

5. Data Analysis & Reporting.

Course content

Workshop 1: Fundamental Excel Functions

Lesson 1: Introduction to Advanced Excel

1 lectures

Lesson 2: SUM Function

1 lectures

Lesson 3: SUMIF Function

1 lectures

Lesson 4: Multiplication Table

1 lectures

Lesson 5: SUMIFS Function

1 lectures

Lesson 6: SUMPRODUCT Function

1 lectures

Lesson 7: COUNT Functions

1 lectures

Lesson 8: COUNTIF Function

1 lectures

Lesson 9: LOOKUP Function

1 lectures

Lesson 10: Indicators in Excel

1 lectures

Lesson 11: VLOOKUP

1 lectures

Lesson 12: IF Function – Part 1

1 lectures

Lesson 12: IF Function – Part 2

1 lectures

Lesson 14: Mean, Median, Mode

1 lectures

Lesson 15: AVERAGE Function

1 lectures

Lesson 16: MAX and MIN

1 lectures

Lesson 17: SMALL and LARGE

1 lectures

Lesson 18: Excel Tips & Tricks – Part 1

1 lectures

Lesson 19: Excel Tips & Tricks – Part 2

1 lectures

Lesson 20: Excel Tips & Tricks – Part 3

1 lectures

Workshop 2: Practical Applications in Excel

Lesson 1: Inventory Valuation

1 lectures

Lesson 2: Calculating Murabaha & Financing

1 lectures

Lesson 3: Gross Margin

1 lectures

Lesson 4: Depreciation Expense

1 lectures

Lesson 5: Price Reduction

1 lectures

Lesson 6: Item Discounts

1 lectures

Lesson 7: Break-Even Point Formula – Part 1

1 lectures

Lesson 8: Break-Even Point Chart Method – Part 2

1 lectures

Workshop 3: The Accounting Cycle

Lesson 1: Introduction to the Accounting Cycle

1 lectures

Lesson 2: Connecting Journal and Ledger Accounts

1 lectures

Lesson 3: Trial Balance to Income Statement – Part 1

1 lectures

Lesson 4: Trial Balance to Income Statement – Part 2

1 lectures

Lesson 5: Income Statement Report

1 lectures

Lesson 6: Balance Sheet Report

1 lectures

Lesson 7: Owner’s Equity Statement

1 lectures

Workshop 4: Payroll Management

Lesson 1: Payroll – Part 1

1 lectures

Lesson 2: Payroll Processing – Part 2

1 lectures

Lesson 3: Overtime Pay

1 lectures

Lesson 4: Petty Cash Management

1 lectures

Lesson 5: Employee Salary Deductions

1 lectures

Workshop 5: Data Analysis & Reporting

Lesson 1: Introduction to Data Analysis

1 lectures

Lesson 2: Data Entry – Student Registration

1 lectures

Lesson 3: Exam Calculation Formula

1 lectures

Lesson 4: Pivot Table & Chart – Part 1

1 lectures

Lesson 5: Pivot Table Charts & Slicers

1 lectures

Lesson 6: Income Statement Comparison Analysis

1 lectures

Lesson 7: Creating an Excel Dashboard

1 lectures

Instructors

Abshir Mohamed Abdirahman

14 Learners

3 Course